Complete the following on the Data tab of the Pastas R Us data file:? Calculate Annual Sales? for each restaurant. Annual Sales is the result of multiplying a
Complete the following on the Data tab of the Pastas R Us data file:
- Calculate “Annual Sales” for each restaurant. Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.” The first value has been provided for you.
- Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables. The formulas and the first results have been provided for you.
- Create a boxplot (sometimes referred to as a box and whisker chart) for the “Annual Sales” variable.
- Create a histogram for the “Sales/SqFt” variable.
Respond to the following questions on the Questions tab of the Pastas R Us data file that's attached.
Due on Monday at 7pm est
ChartDataSheet_
This worksheet contains values required for MegaStat charts. | ||||
Residuals X data 3/19/2007 7:49.25 | ||||
66 | 18 | 45177 | 34.4 | 31 |
69 | 16 | 51888 | 41.2 | 20 |
67 | 10 | 51379 | 40.3 | 24 |
70 | 4 | 66081 | 35.4 | 29 |
78 | 0 | 50999 | 31.5 | 18 |
62 | 28 | 41562 | 36.3 | 30 |
70 | 28 | 44196 | 35.1 | 14 |
84 | 29 | 50975 | 37.6 | 33 |
68 | 22 | 72808 | 34.9 | 28 |
60 | 42 | 79070 | 34.8 | 29 |
80 | 36 | 78497 | 36.2 | 39 |
64 | 32 | 41245 | 32.2 | 23 |
80 | 22 | 33003 | 30.9 | 22 |
88 | 78 | 90988 | 37.7 | 37 |
42 | 35 | 37950 | 34.3 | 24 |
68 | 32 | 45206 | 32.4 | 17 |
80 | 48 | 79312 | 32.1 | 37 |
84 | 32 | 37345 | 31.4 | 22 |
35 | 27 | 46226 | 30.4 | 36 |
84 | 24 | 70024 | 33.9 | 34 |
78 | 16 | 54982 | 35.6 | 26 |
80 | 39 | 54932 | 35.9 | 20 |
70 | 70 | 34097 | 33.6 | 20 |
76 | 33 | 46593 | 37.9 | 26 |
56 | 12 | 51893 | 40.6 | 21 |
65 | 32 | 88162 | 37.7 | 37 |
62 | 0 | 89016 | 36.4 | 34 |
66 | 20 | 114353 | 40.9 | 34 |
76 | 24 | 75366 | 35 | 30 |
92 | 36 | 48163 | 26.4 | 16 |
112 | 34 | 49956 | 37.1 | 28 |
66 | 15 | 45990 | 30.3 | 36 |
70 | 28 | 45723 | 31.3 | 18 |
60 | 15 | 43800 | 29.6 | 36 |
86 | 10 | 68711 | 32.9 | 18 |
76 | 0 | 65150 | 40.7 | 24 |
68 | 16 | 39329 | 29.3 | 22 |
64 | 0 | 63657 | 37.3 | 29 |
52 | 36 | 67099 | 39.8 | 25 |
78 | 26 | 75151 | 33.9 | 28 |
64 | 28 | 93876 | 35 | 40 |
82 | 32 | 79701 | 35 | 39 |
86 | 30 | 77115 | 35.9 | 30 |
92 | 16 | 52766 | 33 | 17 |
72 | 10 | 32929 | 30.9 | 22 |
90 | 24 | 87863 | 38.5 | 29 |
64 | 20 | 73752 | 40.5 | 19 |
80 | 20 | 85366 | 32.1 | 29 |
102 | 30 | 39180 | 34.8 | 18 |
70 | 26 | 56077 | 38 | 19 |
62 | 26 | 77449 | 37 | 34 |
68 | 20 | 56822 | 34.7 | 25 |
74 | 24 | 80470 | 36.4 | 30 |
84 | 14 | 55584 | 36.8 | 21 |
70 | 32 | 78001 | 32.2 | 30 |
96 | 32 | 75307 | 34.8 | 30 |
70 | 22 | 76375 | 36.7 | 28 |
76 | 32 | 61857 | 33.8 | 31 |
62 | 28 | 61312 | 34.2 | 16 |
92 | 23 | 72040 | 39 | 31 |
60 | 20 | 92414 | 34.9 | 40 |
54 | 15 | 92602 | 39.3 | 33 |
110 | 23 | 59599 | 35.6 | 28 |
78 | 0 | 72453 | 36 | 23 |
72 | 31 | 67925 | 41.1 | 16 |
74 | 29 | 42631 | 24.7 | 25 |
94 | 0 | 75652 | 40.5 | 25 |
80 | 16 | 39650 | 32.9 | 18 |
124 | 0 | 48033 | 30.3 | 15 |
46 | 20 | 67403 | 36.2 | 19 |
66 | 0 | 80597 | 32.4 | 27 |
63 | 28 | 60928 | 43.5 | 21 |
72 | 15 | 73762 | 41.6 | 29 |
76 | 24 | 64225 | 31.4 | 15 |
NormalPlot data 3/19/2007 7:49.03 | ||||
-259.9497306439 | -2.3669115357 | |||
-188.5900144767 | -2.0061237235 | |||
-178.1863109741 | -1.8007082352 | |||
-165.2888689211 | -1.6514108613 | |||
-156.2930386781 | -1.5318456091 | |||
-147.1995334043 | -1.4308738679 | |||
-145.0204151759 | -1.3426905457 | |||
-132.7962270775 | -1.2638662791 | |||
-132.5838765031 | -1.1921973902 | |||
-127.8657575015 | -1.1261791757 | |||
-124.4916500844 | -1.0647357757 | |||
-123.016384493 | -1.0070695657 | |||
-118.431306853 | -0.952571595 | |||
-110.8440652315 | -0.9007655189 | |||
-110.1477551652 | -0.8512709934 | |||
-109.3430277914 | -0.8037789242 | |||
-105.1097263145 | -0.7580342264 | |||
-104.7616892077 | -0.7138235056 | |||
-100.1917272772 | -0.6709660579 | |||
-96.9455399284 | -0.6293071641 | |||
-78.5222407532 | -0.588713006 | |||
-66.833182556 | -0.5490667518 | |||
-63.9367962151 | -0.5102654979 | |||
-54.9666697606 | -0.4722178495 | |||
-49.5089341383 | -0.4348419815 | |||
-43.817663257 | -0.3980640685 | |||
-30.5622414309 | -0.3618169976 | |||
-29.7056802184 | -0.3260393031 | |||
-28.8211160258 | -0.2906742745 | |||
-21.3829190469 | -0.2556692022 | |||
-20.8096302471 | -0.220974732 | |||
-18.0336858908 | -0.1865443062 | |||
-16.4732294274 | -0.152333674 | |||
-15.5268611118 | -0.1183004556 | |||
-12.5832024808 | -0.0844037498 | |||
-11.5991899485 | -0.0506037738 | |||
-10.6416197419 | -0.0168615273 | |||
-6.4663288735 | 0.0168615273 | |||
6.6082090726 | 0.0506037738 | |||
10.1026389027 | 0.0844037498 | |||
10.1556691582 | 0.1183004556 | |||
11.5424324103 | 0.152333674 | |||
13.4792557233 | 0.1865443062 | |||
15.0213966843 | 0.220974732 | |||
18.9663798116 | 0.2556692022 | |||
19.2122025279 | 0.2906742745 | |||
19.5938287738 | 0.3260393031 | |||
19.7419844304 | 0.3618169976 | |||
23.7470781354 | 0.3980640685 | |||
25.1736217387 | 0.4348419815 | |||
28.9194386872 | 0.4722178495 | |||
38.4697564504 | 0.5102654979 | |||
50.9831788417 | 0.5490667518 | |||
53.0357068283 | 0.588713006 | |||
61.102903906 | 0.6293071641 | |||
63.1204953548 | 0.6709660579 | |||
63.8380153718 | 0.7138235056 | |||
71.0833539728 | 0.7580342264 | |||
71.3281648375 | 0.8037789242 | |||
75.1828858929 | 0.8512709934 | |||
75.2802525469 | 0.9007655189 | |||
81.3206554357 | 0.952571595 | |||
81.6351025536 | 1.0070695657 | |||
105.576464442 | 1.0647357757 | |||
115.0253844293 | 1.1261791757 | |||
122.2233804168 | 1.1921973902 | |||
150.1178490106 | 1.2638662791 | |||
180.3934285167 | 1.3426905457 | |||
196.2671375845 | 1.4308738679 | |||
205.7993140008 | 1.5318456091 | |||
234.8563337617 | 1.6514108613 | |||
289.7338930992 | 1.8007082352 | |||
336.0904495556 | 2.0061237235 | |||
372.5195939607 | 2.3669115357 | |||
Residuals X data 3/19/2007 8:01.41 | ||||
66 | 18 | 45177 | 34.4 | 31 |
69 | 16 | 51888 | 41.2 | 20 |
67 | 10 | 51379 | 40.3 | 24 |
70 | 4 | 66081 | 35.4 | 29 |
78 | 0 | 50999 | 31.5 | 18 |
62 | 28 | 41562 | 36.3 | 30 |
70 | 28 | 44196 | 35.1 | 14 |
84 | 29 | 50975 | 37.6 | 33 |
68 | 22 | 72808 | 34.9 | 28 |
60 | 42 | 79070 | 34.8 | 29 |
80 | 36 | 78497 | 36.2 | 39 |
64 | 32 | 41245 | 32.2 | 23 |
80 | 22 | 33003 | 30.9 | 22 |
88 | 78 | 90988 |