Apply: Statistics Analysis
sfcbrown2006
Assignment Content
- 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?
3 years ago
25
Purchase the answer to view it
PastasRUs.xlsx- StatisticalReportAssignment.docx
- StatisticalReport.docx
Purchase the answer to view it
- DAT565_v3_Wk1__Wk2_Assignment_Solution.docx
- DAT565_v3_Wk1__Wk2_Solution_EXCEL_Calculations.xlsx
Purchase the answer to view it
- PastasRUsInc.StatisticalReport.docx
Purchase the answer to view it
- StatisticalReportassignment.xlsx
- StatisticalReportassignment.docx
- Differentiate the Major Regulatory Restrictions on NP Practice.
- FINAL PROJECT
- Assignment 5: Cellular Respiration
- PICO ANALYSIS
- An Interpretive Claim
- Jake is always careful to arrive on time for work. He knows that his boss will dock his pay for any missed hours. Jake’s boss holds what kind of power over him?
- 04/10/2017 Community Policing
- Research
- quantitative bus week 4
- read the instructions plz..
Pastas R Us, Inc. Database & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment
Assignment Content
3 years agoMicrosoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment
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 …
2 years agoDAT/565: WEEK1- Apply: Statistics Analysis
Assignment Content
- Review the Wk 2 - Apply: Statistical Report assignment.
In preparation for writing your report to senior management next week, conduct the following descriptive …
a year ago- Review the Wk 2 - Apply: Statistical Report assignment.
Statistical Report
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 …
10 months agoCorey hm wk2
Resources: & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment
Purpose
This assignment is intended to help you learn how to apply statistical methods …
9 months agoStatistical Report
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 …
8 months ago
