Answered step by step
Verified Expert Solution
Link Copied!

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 boxplot (sometimes referred to as a box and whisker chart) for the "Annual Sales" variable.
  • Make a histogram for the "Sales/SqFt" variable.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Data Analysis and Decision Making

Authors: S. Christian Albright, Wayne L. Winston

5th edition

1133629601, 9781285965529 , 978-1133629603

More Books

Students also viewed these Mathematics questions