Description
- AS Description:
The purpose of this assignment is to calculate key numerical measures from the Datafile of Pelican Stores using Microsoft Excel functions.
AS Instructions:
- Open the DataFile of PelicanStores (attached)
- Get descriptive statistics (mean, median, standard deviation, range, skewness) on net sales and net sales by various classifications of customers (married, single, regular, promotion).
- Interpret and comment on the distribution by customer type focusing on the descriptive statistics.
2.The purpose of this assignment is to learn to compute key numerical measures for descriptive statistics.
AS2 Instructions:
- The following data set is about the number of times a sample of 20 families dined out last week: 6 1 5 3 7 3 0 3 1 3 4 1 2 4 1 0 5 6 3 1
- Compute the mean and median.
- Compute the first and third quartiles.
- Compute the variance and standard deviation.
- Compute Z score for each number.
- Do the data contain outliers?