Resource: Pastas R Us, Inc. DatabaseReview the Wk 2 - Apply: Statistical Report assignment.In...

Question

Resource: Pastas R Us, Inc. DatabaseReview 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?Submityour assignment.

Vignesh · Accepted Answer

1. 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.”
Solution: refer excel sheet
2. Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.
Solution: We know that Minimum, maximum,Q1,Q3 and median are the  five statistics summary
	statistics\variable
	SqFt
	Sales/Person
	SalesGrowth%
	LoyaltyCard%
	Sales/SqFt
	MedIncome
	MedAge
	BachDeg%
	Median
	2500
	7
	7.03
	2.075
	396.01
	62757
	35
	26.5
	Minimum
	1251
	6.54
	-8.31
	0.29
	178.56
	32929
	24.7
	14
	Maximum
	3799
	7.97
	28.81
	3.38
	987.12
	114353
	43.5
	40
	Q1
	2400
	6.825
	3.98
	1.8575
	332.845
	46953
	32.525
	20.25
	Q2
	2735.25
	7.1775
	11.4225
	2.325
	483.5625
	76194.25
	37.525
	30.75
	IQR
	335.25
	0.3525
	7.4425
	0.4675
	150.7175
	29241.25
	5
	10.5
3. Create a box-plot for the “Annual Sales” variable. Does it look symmetric?

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment