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 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 Per Person Average Sales Growth Over Loyalty Card % of | Annual Sales Median Household Income Median Age Obs) Square Feet % w/ Bachelor's Degree Annual Sales Spending Previous Year (%) Net Sales Per Sq Ft 3 Miles) (3 Miles) (3 Miles) (in $000) Obs SqFt Sales/Person Sales Growth% LoyaltyCard% Sales/SqFt Medincome MedAge BachDeg% Annual Sales 1 2354 6.81 -8.31 2.07 701.97 45177 34.4 31 16 2604 7.57 4.01 2.54 209.93 51888 41.2 20 2453 6.89 -3.94 1.66 364.92 51379 40.3 24 DOI AWN 2340 7.13 3.39 2.06 443.04 66081 35.4 29 250 7.04 3.30 2.48 399.20 50999 31.5 18 2806 6.93 1.94 2.96 264.64 41562 36.3 30 2250 7.11 0.77 2.28 571.59 44196 35.1 14 2400 7.13 0.37 2.34 642.25 50975 37.6 33 2709 6.58 .0.25 2.20 461.45 72808 34.9 28 990 6.77 0.17 2.34 638.82 79070 34.8 29 2392 6.66 0.47 2.09 484.38 78497 36.2 39 2408 7.03 0.55 2.47 581.09 41245 32.2 23 2627 7.03 0.77 2.04 267.71 33003 30.9 22 14 2500 7.00 1.92 2.02 572.84 90988 37.7 37 15 1986 7.38 2.05 2.01 586.48 37950 34.3 24 16 2500 7.18 2.12 2.64 368.73 45206 32.4 17 17 2668 7.35 2.84 2.22 351.47 79312 32.1 37 18 2517 6.95 2.88 2.07 458.24 37345 31.4 22 19 1251 7.02 3.96 1.94 987.12 46226 30.4 36 20 2998 6.85 4.04 2.17 357.45 70024 33.9 34 21 2625 7.16 4.05 0.72 405.77 54982 35.6 26 22 2300 6.99 4.05 2.00 680.80 54932 35.9 20 23 2761 7.28 4.24 1.81 368.02 34097 33.6 20 24 2764 7.07 4.58 2.13 303.95 46593 37.9 26 25 2430 7.05 5.09 2.50 393.90 51893 40.6 21 26 2154 6.54 5.14 2.63 562.12 88162 37.7 37 27 2400 6.70 5.48 1.95 494.88 39016 36.4 34 28 2430 5.86 2.04 310.07 114353 40.9 34 29 2549 7.58 5.91 1.41 373.46 75366 35.0 30 30 2500 7.03 5.98 2.05 235.81 48163 26.4 16 31 3653 6.84 6.08 2.13 413.08 49956 37.1 28 32 2440 6.94 6.08 2.08 625.22 45990 30.3 36 33 2600 7.07 6.13 2.73 274.30 45723 31.3 18 34 2160 7.00 6.27 1.95 542.62 43800 29.6 36 35 2800 7.08 6.57 2.04 178.56 68711 32.9 18 36 2757 6.75 6.90 1.62 375.33 65150 40.7 24 37 2450 6.81 5.94 1.95 329.09 39329 29.3 22 38 2400 7.64 7.12 1.64 297.37 63657 37.3 29 39 2270 6 62 7 39 323 17 67099 39 8 25\fMean 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.25Answer Does the annual sales box plot chart look symmetric? Would you prefer the QR instead of the standard deviation to describe the dispersion of the annual sales variable? If so, why? Does the histogram show that the sales per square foot distribution is symmetric? If the sales per square foot distrubiton is not symmetric, what is the skew? If there are any outliers, 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 may be more appropriate to describe \"Sales/SqFt"? Why
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