Question
Purpose This week is in preparation for writing your report to senior management in Week 2. Complete the following descriptive statistics analyses with Excel. Instructions
Purpose
This week is in preparation for writing your report to senior management in Week 2. Complete the following descriptive statistics analyses with Excel.
Instructions. Use the Week 1 Pasta's R Us (find below) with the following columns:
SqftSquare Feet
Sales/CustomerPer Customer Average Spending
Sales Growth%Sales Growth Over Previous Year (%)
Loyalty Card%Loyalty Card % of Net Sales
Sales/SqftAnnual Sales Per Sqft
Med IncomeMedian HH Income
Med AgeMedian Age
Bach Deg%% w/Bachelor's Degree
Steps
A. Insert a new column, Annual Sales ($/1000). Annual sales result from multiplying a restaurant's Sqft * Sales/Sqft with one decimal: If the current Sqft is 2000 and Sales/Sqft is 700, calculate the Annual Sales ($/1000) as 2000*700/1000 = 1400.0.
B. Calculate the mean, population standard deviation, skew, five-number summary, and the interquartile range (IQR) for each variable. Show how you made the calculations.
C. Use Insert > Insert Statistic Chart > Box and Whisker for the Annual Sales variable. Finish the chart with a y-axis label.
Does it look symmetric? Would you prefer the IQR instead of the population standard deviation to describe this variable's dispersion? Explain? Answer these questions in your Excel sheet.
D. Use Insert > Insert Histogram for the Sales/Sqft variable.
Is the distribution symmetric? If not, what is the skew (negative, positive)? Are there any outliers? If so, which one(s)? What is the Sqft area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation? Answer the questions in your Excel sheet.
E. What measure of central tendency (mean, median) is more appropriate to describe Sales/Sqft? Explain? Answer the questions in your Excel sheet.
Submit your Excel document.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started