Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment Deliverable Complete the following on the Data tab of the Pastas R Us data file: Calculate Annual Sales for each restaurant. Annual Sales is

Assignment Deliverable

Complete the following on the Data tab of the Pastas R Us data file:

  • Calculate "Annual Sales" for each restaurant. Annual Sales is the result of multiplying a restaurant's "SqFt." by "Sales/SqFt." The first value has been provided for you.
  • Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables. The formulas and the first results have been provided for you.
  • Create a boxplot (sometimes referred to as a box and whisker chart) for the "Annual Sales" variable.
  • Create a histogram for the "Sales/SqFt" variable.

Respond to the following questions on the Questions tab of the Pastas R Us data file:

  • Does the annual sales boxplot look symmetric?
  • Would you prefer the IQR instead of the standard deviation to describe the dispersion of the annual sales variable? If so, why?
  • Does the histogram show that the sales per square foot distribution is symmetric?
  • If the sales per square foot distribution is not symmetric, what is the skew?
  • If there are any outliers, 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 data? What can you conclude from this observation?
  • What measure of central tendency may be more appropriate to describe "Sales/SqFt"? Why?

Download thePastas R Us datafile.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of Financial Derivatives

Authors: Ali Hirsa, Salih N. Neftci

3rd edition

012384682X, 978-0123846822

More Books

Students also viewed these Mathematics questions