# In preparation for writing your report to senior management next

In preparation for writing your report to senior management next week, 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?

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Operations and Digital Business A1 Portfolio Assessment

Learning week 6: 28th February 2019 Learning outcomes addressed –1,3,4,5,6 & 7 1. Understand and justify how organizations secure and deploy their resources both in

### Being able to interview a client and create a case

Being able to interview a client and create a case plan for them is essential for any case manager. In this assignment, you will apply

### Project plans outline the intended course of events; however, things

Project plans outline the intended course of events; however, things don’t always happen as intended. Organizations need to consider risks and develop a contingency

### Manchester United Soccer Club  Nicolette Larson was loading the dishwasher with

Manchester United Soccer Club  Nicolette Larson was loading the dishwasher with her husband, Kevin, and telling him about the first meeting of the Manchester United

### Competencies In this project, you will demonstrate your mastery of

Competencies In this project, you will demonstrate your mastery of the following competencies: Determine how an organization gains a competitive advantage Determine organizational risk and

In the world of marketing, two specific environments exist: business-to-business (B2B) and business-to-consumer (B2C). What are the two primary differences in these environments? Give an

### What are the ethical issues around using persuasive techniques that are intended to make recipients feel uncomfortable but for beneficial

What are the ethical issues around using persuasive techniques that are intended to make recipients feel uncomfortable but for beneficial reasons? That is one of

### Competency Summarize cloud application scalability concepts. Evaluate cloud application benchmarking

Competency Summarize cloud application scalability concepts. Evaluate cloud application benchmarking and tuning procedures. Assess cloud-based implementation strategies. Select a deployment platform using appropriate criteria. Describe

### Using one case study from ‘Michael Sandel’s Justice: What’s the Right

Using one case study from ‘Michael Sandel’s Justice: What’s the Right Thing to Do?’ , compare the strengths and weaknesses of utilitarianism and deontology.

### When a business competes locally, it primarily needs to consider

When a business competes locally, it primarily needs to consider the factors that affect the local community. As it expands, so do the factors

### Summary- Women’s work and Chicano Families.

Patricia Zavella. 1987. Women’s work and Chicano Families. Cornell University Press. P xi-17, 69-71, 130-161. • Stone, Pamela. Opting out?: Why women really quit careers

### Reply to: The test-retest reliability is when a person takes

Reply to:   The test-retest reliability is when a person takes a test and after a period retakes the test. The reliable measures should reproduce

New questions