Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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.
- make a a boxplot (sometimes referred to as a box and whisker chart) for the "Annual Sales" variable.
- make a histogram for the "Sales/SqFt" variable.
Location number (Obs) | Square Feet | Per Person Average Spending | Sales Growth Over Previous Year (%) | Loyalty Card % of Net Sales | Annual Sales Per Sq Ft | Median Household Income (3 Miles) | Median Age (3 Miles) | % w/ Bachelor's Degree (3 Miles) | Annual Sales (in $000) |
Obs | SqFt | Sales/Person | SalesGrowth% | LoyaltyCard% | Sales/SqFt | MedIncome | MedAge | BachDeg% | AnnualSales |
1 | 2354 | 6.81 | -8.31 | 2.07 | 701.97 | 45177 | 34.4 | 31 | 1652.4 |
2 | 2604 | 7.57 | -4.01 | 2.54 | 209.93 | 51888 | 41.2 | 20 | 546.7 |
3 | 2453 | 6.89 | -3.94 | 1.66 | 364.92 | 51379 | 40.3 | 24 | 895.1 |
4 | 2340 | 7.13 | -3.39 | 2.06 | 443.04 | 66081 | 35.4 | 29 | 1036.7 |
5 | 2500 | 7.04 | -3.30 | 2.48 | 399.20 | 50999 | 31.5 | 18 | 998.0 |
6 | 2806 | 6.93 | -1.94 | 2.96 | 264.64 | 41562 | 36.3 | 30 | 742.6 |
7 | 2250 | 7.11 | -0.77 | 2.28 | 571.59 | 44196 | 35.1 | 14 | 1286.1 |
8 | 2400 | 7.13 | -0.37 | 2.34 | 642.25 | 50975 | 37.6 | 33 | 1541.4 |
9 | 2709 | 6.58 | -0.25 | 2.20 | 461.45 | 72808 | 34.9 | 28 | 1250.1 |
10 | 1990 | 6.77 | -0.17 | 2.34 | 638.82 | 79070 | 34.8 | 29 | 1271.3 |
11 | 2392 | 6.66 | 0.47 | 2.09 | 484.38 | 78497 | 36.2 | 39 | 1158.6 |
12 | 2408 | 7.03 | 0.55 | 2.47 | 581.09 | 41245 | 32.2 | 23 | 1399.3 |
13 | 2627 | 7.03 | 0.77 | 2.04 | 267.71 | 33003 | 30.9 | 22 | 703.3 |
14 | 2500 | 7.00 | 1.92 | 2.02 | 572.84 | 90988 | 37.7 | 37 | 1432.1 |
15 | 1986 | 7.38 | 2.05 | 2.01 | 586.48 | 37950 | 34.3 | 24 | 1164.7 |
16 | 2500 | 7.18 | 2.12 | 2.64 | 368.73 | 45206 | 32.4 | 17 | 921.8 |
17 | 2668 | 7.35 | 2.84 | 2.22 | 351.47 | 79312 | 32.1 | 37 | 937.7 |
18 | 2517 | 6.95 | 2.88 | 2.07 | 458.24 | 37345 | 31.4 | 22 | 1153.4 |
19 | 1251 | 7.02 | 3.96 | 1.94 | 987.12 | 46226 | 30.4 | 36 | 1234.9 |
20 | 2998 | 6.85 | 4.04 | 2.17 | 357.45 | 70024 | 33.9 | 34 | 1071.6 |
21 | 2625 | 7.16 | 4.05 | 0.72 | 405.77 | 54982 | 35.6 | 26 | 1065.1 |
22 | 2300 | 6.99 | 4.05 | 2.00 | 680.80 | 54932 | 35.9 | 20 | 1565.8 |
23 | 2761 | 7.28 | 4.24 | 1.81 | 368.02 | 34097 | 33.6 | 20 | 1016.1 |
24 | 2764 | 7.07 | 4.58 | 2.13 | 303.95 | 46593 | 37.9 | 26 | 840.1 |
25 | 2430 | 7.05 | 5.09 | 2.50 | 393.90 | 51893 | 40.6 | 21 | 957.2 |
26 | 2154 | 6.54 | 5.14 | 2.63 | 562.12 | 88162 | 37.7 | 37 | 1210.8 |
27 | 2400 | 6.70 | 5.48 | 1.95 | 494.88 | 89016 | 36.4 | 34 | 1187.7 |
28 | 2430 | 6.91 | 5.86 | 2.04 | 310.07 | 114353 | 40.9 | 34 | 753.5 |
29 | 2549 | 7.58 | 5.91 | 1.41 | 373.46 | 75366 | 35.0 | 30 | 951.9 |
30 | 2500 | 7.03 | 5.98 | 2.05 | 235.81 | 48163 | 26.4 | 16 | 589.5 |
31 | 3653 | 6.84 | 6.08 | 2.13 | 413.08 | 49956 | 37.1 | 28 | 1509.0 |
32 | 2440 | 6.94 | 6.08 | 2.08 | 625.22 | 45990 | 30.3 | 36 | 1525.5 |
33 | 2600 | 7.07 | 6.13 | 2.73 | 274.30 | 45723 | 31.3 | 18 | 713.2 |
34 | 2160 | 7.00 | 6.27 | 1.95 | 542.62 | 43800 | 29.6 | 36 | 1172.1 |
35 | 2800 | 7.08 | 6.57 | 2.04 | 178.56 | 68711 | 32.9 | 18 | 500.0 |
36 | 2757 | 6.75 | 6.90 | 1.62 | 375.33 | 65150 | 40.7 | 24 | 1034.8 |
37 | 2450 | 6.81 | 6.94 | 1.95 | 329.09 | 39329 | 29.3 | 22 | 806.3 |
38 | 2400 | 7.64 | 7.12 | 1.64 | 297.37 | 63657 | 37.3 | 29 | 713.7 |
39 | 2270 | 6.62 | 7.39 | 1.78 | 323.17 | 67099 | 39.8 | 25 | 733.6 |
40 | 2800 | 6.76 | 7.67 | 2.23 | 468.84 | 75151 | 33.9 | 28 | 1312.8 |
41 | 2520 | 7.11 | 7.91 | 2.15 | 352.57 | 93876 | 35.0 | 40 | 888.5 |
42 | 2487 | 7.05 | 8.08 | 2.83 | 380.34 | 79701 | 35.0 | 39 | 945.9 |
43 | 2629 | 6.90 | 8.27 | 2.37 | 398.12 | 77115 | 35.9 | 30 | 1046.7 |
44 | 3200 | 7.17 | 8.54 | 3.07 | 312.15 | 52766 | 33.0 | 17 | 998.9 |
45 | 2335 | 6.75 | 8.58 | 2.19 | 452.16 | 32929 | 30.9 | 22 | 1055.8 |
46 | 2500 | 7.45 | 8.72 | 1.28 | 698.64 | 87863 | 38.5 | 29 | 1746.6 |
47 | 2449 | 7.00 | 8.75 | 1.76 | 367.19 | 73752 | 40.5 | 19 | 899.2 |
48 | 2625 | 6.96 | 8.79 | 2.51 | 431.93 | 85366 | 32.1 | 29 | 1133.8 |
49 | 3150 | 7.30 | 8.90 | 1.90 | 367.06 | 39180 | 34.8 | 18 | 1156.2 |
50 | 2625 | 6.96 | 9.12 | 1.98 | 400.53 | 56077 | 38.0 | 19 | 1051.4 |
51 | 2741 | 6.71 | 9.47 | 2.41 | 414.36 | 77449 | 37.0 | 34 | 1135.8 |
52 | 2500 | 6.82 | 10.17 | 2.17 | 481.11 | 56822 | 34.7 | 25 | 1202.8 |
53 | 2450 | 6.58 | 10.66 | 2.16 | 538.06 | 80470 | 36.4 | 30 | 1318.2 |
54 | 2986 | 7.56 | 10.97 | 0.29 | 330.48 | 55584 | 36.8 | 21 | 986.8 |
55 | 2967 | 6.98 | 11.34 | 1.85 | 249.93 | 78001 | 32.2 | 30 | 741.5 |
56 | 3000 | 7.28 | 11.45 | 1.88 | 291.87 | 75307 | 34.8 | 30 | 875.6 |
57 | 2500 | 6.76 | 11.51 | 2.19 | 517.40 | 76375 | 36.7 | 28 | 1293.5 |
58 | 2600 | 6.92 | 11.73 | 2.56 | 551.58 | 61857 | 33.8 | 31 | 1434.1 |
59 | 2800 | 6.73 | 11.83 | 2.16 | 386.81 | 61312 | 34.2 | 16 | 1083.1 |
60 | 2986 | 6.91 | 11.95 | 2.10 | 427.50 | 72040 | 39.0 | 31 | 1276.5 |
61 | 2223 | 6.77 | 12.47 | 1.98 | 453.94 | 92414 | 34.9 | 40 | 1009.1 |
62 | 2300 | 7.33 | 12.80 | 0.87 | 512.46 | 92602 | 39.3 | 33 | 1178.7 |
63 | 3799 | 7.87 | 13.78 | 1.07 | 345.27 | 59599 | 35.6 | 28 | 1311.7 |
64 | 2700 | 6.95 | 14.09 | 3.38 | 234.04 | 72453 | 36.0 | 23 | 631.9 |
65 | 2650 | 7.33 | 14.23 | 1.17 | 348.33 | 67925 | 41.1 | 16 | 923.1 |
66 | 2500 | 6.95 | 14.60 | 2.14 | 348.47 | 42631 | 24.7 | 25 | 871.2 |
67 | 2994 | 7.21 | 14.88 | 0.93 | 294.95 | 75652 | 40.5 | 25 | 883.1 |
68 | 2718 | 7.25 | 15.42 | 2.22 | 361.14 | 39650 | 32.9 | 18 | 981.6 |
69 | 3700 | 7.65 | 16.18 | 1.68 | 467.71 | 48033 | 30.3 | 15 | 1730.5 |
70 | 2000 | 6.93 | 17.23 | 2.41 | 403.78 | 67403 | 36.2 | 19 | 807.6 |
71 | 2400 | 6.79 | 18.43 | 2.81 | 245.74 | 80597 | 32.4 | 27 | 589.8 |
72 | 2450 | 7.37 | 20.76 | 1.09 | 339.94 | 60928 | 43.5 | 21 | 832.9 |
73 | 2575 | 6.76 | 25.54 | 0.64 | 400.82 | 73762 | 41.6 | 29 | 1032.1 |
74 | 2400 | 7.97 | 28.81 | 1.77 | 326.54 | 64225 | 31.4 | 15 | 783.7 |
Mean | 2580.47 | ||||||||
Standard. Dev. | 372.38 | ||||||||
Min | 1251.00 | ||||||||
Q1 | 2400.00 | ||||||||
Median | 2500.00 | ||||||||
Q3 | 2735.25 | ||||||||
Max | 3799.00 | ||||||||
Skew | 0.53 | ||||||||
IQR | 335.25 |
Mean | 2580.47 |
Standard. Dev. | 372.38 |
Min | 1251.00 |
Q1 | 2400.00 |
Median | 2500.00 |
Q3 | 2735.25 |
Max | 3799.00 |
Skew | 0.53 |
IQR | 335.25 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started