DAT/565: Data Analysis And Business Analytics Wk 1 – Apply: Statistics Analysis Wk 1 – Apply: Statistics Analysis

DAT/565: Data Analysis And Business Analytics. Apply: Statistics Analysis
Assignment Content
Resource: Pastas R Us, Inc. Database
Review the Wk 2 - Apply: Statistical Fame assignment.
In provision for communication your fame to important address direct week, precede the aftercited vivid statistics analyses after a while Excel®. Answer the questions underneath in your Excel quibble or in a unconnected Word document:
Insert a new post in the database that corresponds to “Annual Sales.” Annual Sales is the outcome of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”
Calculate the moderation, rule disconnection, skew, 5-number epitome, and interquartile rank (IQR) for each of the mutables.
Create a box-plot for the “Annual Sales” mutable. Does it face symmetric? Would you promote the IQR instead of the rule disconnection to picture this mutable’s dispensation? Why?
Create a histogram for the “Sales/SqFt” mutable. Is the dispensation 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 mediocre restaurant in the database? What can you argue from this comment?
What estimate of accessible proclivity is over expend to picture “Sales/SqFt”? Why?
Wk 1 - Apply: Statistics Analysis [due Mon]
Assignment Content
Resource: Pastas R Us, Inc. Database
Review the Wk 2 - Apply: Statistical Fame assignment.
In provision for communication your fame to important address direct week, precede the aftercited vivid statistics analyses after a while Excel®. Answer the questions underneath in your Excel quibble or in a unconnected Word document:
Insert a new post in the database that corresponds to “Annual Sales.” Annual Sales is the outcome of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”
Calculate the moderation, rule disconnection, skew, 5-number epitome, and interquartile rank (IQR) for each of the mutables.
Create a box-plot for the “Annual Sales” mutable. Does it face symmetric? Would you promote the IQR instead of the rule disconnection to picture this mutable’s dispensation? Why?
Create a histogram for the “Sales/SqFt” mutable. Is the dispensation 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 mediocre restaurant in the database? What can you argue from this comment?
What estimate of accessible proclivity is over expend to picture “Sales/SqFt”? Why?