Calculate the mean-standard deviation

Assignment Help Basic Computer Science

Reference no: EM133139982

In preparation for writing your report to senior management, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet or in a separate Microsoft® Word document:

Insert a new column in the database that corresponds to "Annual Sales." Annual Sales is the result of multiplying a restaurant's "SqFt." by "Sales/SqFt."

Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.

Create a box-plot for the "Annual Sales" variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable's dispersion? Why?

Create a histogram for the "Sales/SqFt" variable. 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?

Attachment:- Pastas RUs.rar

Reference no: EM133139982

Questions Cloud

Importance of coding standard and code quality : In the article "Importance of Coding Standard and Code Quality in Software Development", the author discusses the challenges of setting coding standards

Organization contingency plan : Give suggestions on what might be added to the organization's contingency plan to mitigate those unexpected challenges.

Protection of customer information : Discuss the issues organization's face with regards to the protection of its customer information.

Emphasis on electronically stored information : What likely effect will its emphasis on electronically stored information (ESI) have on an organization's need for a digital forensic capability?

Calculate the mean-standard deviation : Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.

Layer OSI model incorporates security measures : Each layer of the 7-layer OSI model incorporates security measures. Discuss briefly security measures at each of the 7 layers

What is meant by the Break-even point for an activity : What is meant by the Break-even point (BEP) for an activity? How is it calculated? Explain why MDG Ltd should know the BEP

Calculate the cost to service each of the two customers : The annual fee charged to each customer is $3,800. Calculate the cost to service each of the two customers highlighted by the company president

Make a vertical analysis for Ambrose for balance sheet : The accounting office has given you the? company's income statement and balance? sheet, Make a vertical analysis for Ambrose for balance sheet

User Account

All Pages