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?
2 years ago
25
Answer(4)![blurred-text]()
![blurred-text]()
![blurred-text]()
![blurred-text]()
Purchase the answer to view it
Done5350
PastasRUs.xlsx- StatisticalReportAssignment.docx
- StatisticalReport.docx
Purchase the answer to view it
Detailed Solution - Paper & EXCEL Spreadsheet5150
- DAT565_v3_Wk1__Wk2_Assignment_Solution.docx
- DAT565_v3_Wk1__Wk2_Solution_EXCEL_Calculations.xlsx
Purchase the answer to view it
Pastas R Us, Inc. Statistical Report*****It has been used*****Use it as a Guide Paper*****0.75250
- PastasRUsInc.StatisticalReport.docx
Purchase the answer to view it
NOT RATED
- StatisticalReportassignment.xlsx
- StatisticalReportassignment.docx
other Questions(10)
- 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..
Write a 750-word statistical report with scope and descriptive statistics, Analysis, and recommendations.
Please Review Attached Documents
a year agoPastas R Us, Inc. Database & Microsoft Excel®, Wk 1: Descriptive Statistics Analysis Assignment
Assignment Content
2 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 …
a year 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 …
9 months 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 …
4 months ago- Review the Wk 2 - Apply: Statistical Report assignment.
