Apply: Statistics Analysis

profilesfcbrown2006

 

Assignment Content

  1. Resource: Pastas R Us, Inc. Database


    Review the Wk 2 - Apply: Statistical Report assignment. 


    In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel®. Answer the questions below in your Excel sheet or in a separate 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?
  • Posted: 4 months ago
  • Due: 
  • Budget: $25
Answers 1
  • Done
    Answer rating:5Stars out of1ratings

Purchase the answer to view it

blurred-text
  • Purpose

    This assignment is intended to help you learn how to apply statistical methods when analyzing operational data, evaluating the performance of current marketing strategies, and …

  • Rated 1 times

    statistics

    Assignment Content

    1. Resources: & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment


      Purpose
      This assignment is intended to help you learn how to apply …


    1. Resources: & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment


      Purpose
      This assignment is intended to help you learn how to apply statistical methods …

  • Assignment Content

    1. Resources: & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment


      Purpose
      This assignment is intended to help you learn how to apply …

  • Resources: & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment

    Purpose

    This assignment is intended to help you learn how to apply statistical methods when analyzing …

  • Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. Since its inception, the business development team has favored opening new restaurants in …