Wk 1 Statistics Analysis: Pastas R Us Data

Discipline: Business Finance - Management
Preparation

Review the Wk 2 Summative Assessment: Pastas R Us Statistical Report assessment. 

Download the Pastas R Us data file. 

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? 

Assignment Support
  • Review “Create a Histogram” from Microsoft 365 Support to learn how to create a histogram in Microsoft Excel. 
  • Review “Create a Box and Whisker Chart” from Microsoft 365 Support to learn how to create a box plot in Microsoft Excel.
  • Watch the selections from “Mastering Basic Charts and Graphs” from LinkedIn Learning in this week’s learning activities to see how to create histograms and box and whisker charts in Excel.
  • Watch “Excel Quick Tips” from LinkedIn Learning in this week’s learning activities to get answers to common questions about working with data in Excel. 

NEED A CUSTOMIZED PAPER ON THE ABOVE DETAILS?

Submit your order now!