high on Essays logo

Our Services

Get 15% Discount on your First Order

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

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit
Reviews

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Overview The thesis will explore the transformative role of Information and Communication Technology (ICT) in healthcare delivery, with a focus on health

Overview The thesis will explore the transformative role of Information and Communication Technology (ICT) in healthcare delivery, with a focus on health informatics and telemedicine. It will investigate how big data analytics in health informatics can enhance patient care and outcomes, and how the expansion of telemedicine services can improve