• interquartile range (IQR) for each of the variables
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? WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEF