Question: Insert a new column in the database that corresponds to Annual Sales. Annual Sales is the result of multiplying a restaurants SqFt. by Sales/SqFt. Calculate

Insert a new column in the database that corresponds to Annual Sales. Annual Sales is the result of multiplying a restaurants 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 variables 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?

Insert a new column in the database that corresponds to Annual Sales.

Annual Sales is the result of multiplying a restaurants SqFt. by Sales/SqFt.

Annual Sales Median HH Income Per Sq Ft (3 Miles Median Age (3 Miles) % w/ Bachelor's Degree (3 Miles) 4 5 6 7. 8 9 10 12 13 14 15 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Sales/SqFt 701.97 209.93 364.92 443.04 399.20 264.64 571.59 642.25 461.45 638.82 484.38 581.09 267.71 572.84 586.48 368.73 351.47 458.24 987.12 357.45 405.77 680.80 368.02 303.95 393.90 562.12 494.88 310.07 373.46 235.81 413.08 625.22 274.30 542.62 178.56 375.33 329.09 297.37 323.17 468.84 352.57 380.34 Medincome 45177 51888 51379 66081 50999 41562 44196 50975 72808 79070 78497 41245 33003 90988 37950 45206 79312 37345 46226 70024 54982 54932 34097 46593 51893 88162 89016 114353 75366 48163 49956 45990 45723 43800 68711 65150 39329 63657 67099 75151 93876 79701 + MedAge 34.4 41.2 40.3 35.4 31.5 36.3 35.1 37.6 34.9 34.8 36.2 32.2 30.9 37.7 34.3 32.4 32.1 31.4 30.4 33.9 35.6 35.9 33.6 37.9 40.6 37.7 36.4 40.9 35.0 26.4 37.1 30.3 31.3 29.6 32.9 40.7 29.3 37 3 39.8 33.9 35.0 35.0 BachDeg% 31 20 24 29 18 30 14 33 28 29 39 23 22 37 24 17 37 22 36 34 26 20 20 26 21 37 34 34 30 16 28 36 18 36 18 24 22 29 25 28 40 39 Data G H - 37.3 39.8 33.9 35.0 35.0 35.9 33.0 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 F 297.37 323.17 468.84 352.57 380.34 398.12 312.15 452.16 698.64 367.19 431.93 367.06 400.53 414.36 481.11 538.06 330.48 249.93 291.87 517.40 551.58 386.81 427.50 453.94 512.46 345.27 234.04 348.33 348.47 294.95 361.14 467.71 403.78 245.74 339.94 400.82 326.54 63657 67099 75151 93876 79701 77115 52766 32929 87863 73752 85366 39180 56077 77449 56822 80470 55584 78001 75307 76375 61857 61312 72040 92414 92602 59599 72453 67925 42631 75652 39650 48033 67403 80597 60928 73762 64225 29 25 28 40 39 30 17 22 29 19 29 18 19 34 25 30 21 30 30 28 31 16 31 40 33 28 23 16 25 25 18 15 19 27 21 29 15 30.9 38.5 40.5 32.1 34.8 38.0 37.0 34.7 36.4 36.8 32.2 34.8 36.7 33.8 34.2 39.0 34.9 39.3 35.6 36.0 41.1 24.7 40.5 32.9 30.3 36.2 32.4 43.5 41.6 31.4 F 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 Annual Sales Median HH Income Per Sq Ft (3 Miles Median Age (3 Miles) % w/ Bachelor's Degree (3 Miles) 4 5 6 7. 8 9 10 12 13 14 15 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Sales/SqFt 701.97 209.93 364.92 443.04 399.20 264.64 571.59 642.25 461.45 638.82 484.38 581.09 267.71 572.84 586.48 368.73 351.47 458.24 987.12 357.45 405.77 680.80 368.02 303.95 393.90 562.12 494.88 310.07 373.46 235.81 413.08 625.22 274.30 542.62 178.56 375.33 329.09 297.37 323.17 468.84 352.57 380.34 Medincome 45177 51888 51379 66081 50999 41562 44196 50975 72808 79070 78497 41245 33003 90988 37950 45206 79312 37345 46226 70024 54982 54932 34097 46593 51893 88162 89016 114353 75366 48163 49956 45990 45723 43800 68711 65150 39329 63657 67099 75151 93876 79701 + MedAge 34.4 41.2 40.3 35.4 31.5 36.3 35.1 37.6 34.9 34.8 36.2 32.2 30.9 37.7 34.3 32.4 32.1 31.4 30.4 33.9 35.6 35.9 33.6 37.9 40.6 37.7 36.4 40.9 35.0 26.4 37.1 30.3 31.3 29.6 32.9 40.7 29.3 37 3 39.8 33.9 35.0 35.0 BachDeg% 31 20 24 29 18 30 14 33 28 29 39 23 22 37 24 17 37 22 36 34 26 20 20 26 21 37 34 34 30 16 28 36 18 36 18 24 22 29 25 28 40 39 Data G H - 37.3 39.8 33.9 35.0 35.0 35.9 33.0 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 F 297.37 323.17 468.84 352.57 380.34 398.12 312.15 452.16 698.64 367.19 431.93 367.06 400.53 414.36 481.11 538.06 330.48 249.93 291.87 517.40 551.58 386.81 427.50 453.94 512.46 345.27 234.04 348.33 348.47 294.95 361.14 467.71 403.78 245.74 339.94 400.82 326.54 63657 67099 75151 93876 79701 77115 52766 32929 87863 73752 85366 39180 56077 77449 56822 80470 55584 78001 75307 76375 61857 61312 72040 92414 92602 59599 72453 67925 42631 75652 39650 48033 67403 80597 60928 73762 64225 29 25 28 40 39 30 17 22 29 19 29 18 19 34 25 30 21 30 30 28 31 16 31 40 33 28 23 16 25 25 18 15 19 27 21 29 15 30.9 38.5 40.5 32.1 34.8 38.0 37.0 34.7 36.4 36.8 32.2 34.8 36.7 33.8 34.2 39.0 34.9 39.3 35.6 36.0 41.1 24.7 40.5 32.9 30.3 36.2 32.4 43.5 41.6 31.4 F 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!