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?

Table of Contents

Calculate your order
Pages (275 words)
Standard price: $0.00

Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

Ethical dilemma paper

 Ethical Dilemma paper (MO 1-3) Instructions: Choose and examine an Ethical dilemma that may be faced in nursing care , PRO-LIFE CHOICE)? Compare Christian and

SOC101 Assignment Sheet Interview

Goals and Skills: Students are asked to discuss specific concepts, theories and research findings that they learned in readings to life experiences. This allows students

New questions

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!