Write My Paper Button

WhatsApp Widget
Skip to content
Home » on Microsoft Excel. Answer the questions in the spreadsheet Can add additional page to the excel sheet I attached !!!! Calculate the following: • mean • standard deviation • skew • 5-number summary •

on Microsoft Excel. Answer the questions in the spreadsheet Can add additional page to the excel sheet I attached !!!! Calculate the following: • mean • standard deviation • skew • 5-number summary •

  • by

on Microsoft Excel.

Answer the questions in the spreadsheet Can add additional page to the excel sheet I attached !!!!

Calculate the following:

• mean

• standard deviation

• skew

• 5-number summary

• interquartile range (IQR) for each of the variables

Create a box-plot for the AnnualSales variable and answer the following questions:

• Does it look symmetric?

• Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why or why not?

Create a histogram for the Sales/SqFt variable and answer the following questions:

• Is the distribution symmetric? If not, what is the skew?

• 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?

• What measure of central tendency is more appropriate to describe Sales/SqFt? Why?