1. Calculate “Annual Sales” for each restaurant. Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt”. the first value has been done ( in yellow)
2. Calculate the mean, standard deviation, skew, 5-number summary, and interquartlie range (IQR) for each of the variables. The formulas and the first results have been provided for you( in Yellow)
3. Create a box plot ( sometimes referred to as a box and whisker chart) for the “Annual Sales” variable.
4. Create a histogram for the “Sales/SqFt” variable
Respond to the following questions on the questions tab in the excel assignment
1. Does the annual sales boxplot look symmetric?
2. Would you prefer the IQR instead of the standard deviation to describe the dispersion of the annual sales variable? If so , why?
3. Does the histogram show that the sales per square foot distribution is symmetric?
4. If the sales per square foot distribution is not symmetric, what is the skew?
5. If there are any outliers, which one(s)? What is the “Sq/Ft” area of the outlier(s)?