complete the following descriptive statistics analyses with Excel. Answer the questions below in your Excel sheet or in a separate Word document:

• Insert a new column in the database that corresponds to "Annual Sales." Annual Sales is the result of multiplying a restaurant's "SqFt." by "Sales/SqFt."
• Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.
• make box-plot for the "Annual Sales" variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable's dispersion? Why?
• make 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?

AutoSave On nateexcel - Saved + Search madlockkim24@outlook.com M X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 ~ AA ab Wrap Text General EX A O Paste BIU- E Merge & Center ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting * Table Styles v Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas T69 X V B C D E F G H J K L M N O P Q R S T U . A Pastas R Us, Inc. Database (n = 74 restaurants) 2 Sales Per Growth Median % w/ Person Over Loyalty Annual HH Median Bachelor Square Average Previous Card % of Sales Per Income (3 Age (3| s Degree A W Feet Spending Year (%) | Net Sales Sq Ft Miles Miles) (3 Miles) Obs SqFt Sales/Per SalesGro LoyaltyC Sales/Sq Medinco MedAge BachDeg son wth% ard% m % 1 2354 6.81 8.31 2.07 701.97 45177 34.4 31 IN 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 2340 7.13 -3.39 2.06 443.04 66081 35.4 29 10 2500 7.04 -3.30 2.48 399.20 50999 31.5 18 11 6 2806 6.93 -1.94 2.96 264.64 41562 36.3 30 12 7 2250 7.11 -0.77 2.28 571.59 44196 35.1 14 13 2400 7.13 -0.37 2.34 642.25 50975 37.6 33 14 9 2709 0.25 2.20 461.45 72808 34.9 28 15 10 1990 6.77 -0.17 2.34 638.82 79070 34.8 29 16 11 2392 6.66 0.47 2.09 484.38 78497 36.2 39 17 12 2408 7.03 0.55 2.47 581.09 41245 32.2 23 18 13 2627 7.03 0.77 2.04 267.71 33003 30.9 22 10 Tenn 1 02 202 onnoo 27 7 27 Sheet1 + + 100% Enter O I'm Cortana. Ask me anything. W X ? 3:46 PM 8/30/2020AutoSave On nateexcel - Saved + Search madlockkim24@outlook.com M X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 ~ A A ab Wrap Text General Merge & Center ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Paste BIU- Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas T69 X V A B C D E F G H J K L M N O P Q R S T 19 14 2500 7.00 1.92 2.02 572.84 90988 37.7 37 20 15 1986 7.38 2.05 2.01 586.48 37950 34.3 24 21 16 2500 7.18 2.12 2.64 368.73 45206 32.4 17 22 17 2668 2.84 2.22 79312 32.1 37 23 18 2517 6.95 2.88 2.07 458.24 37345 31.4 22 24 19 1251 7.02 3.96 987.12 46226 30.4 36 25 20 2998 6.8 4.04 2.17 357.45 70024 33.9 34 26 21 2625 0.72 405.77 54982 26 27 22 2300 6.99 4.05 2.00 680.80 54932 35.9 20 28 23 7.28 4.24 1.81 368.02 34097 20 29 24 2764 4.58 2.13 303.95 46593 37.9 26 30 25 2430 7.05 5.09 2.50 51893 40.6 21 31 26 2154 6.54 5.14 2.63 562.12 88162 37.7 37 32 27 2400 6.70 5.48 494.88 89016 36.4 34 33 28 2430 5.86 2.04 310.07 114353 40.9 34 34 20 2549 7.58 5.91 1.41 373.46 75366 35.0 30 35 30 2500 5.98 2.05 235.81 48163 26.4 16 36 31 3653 6.84 6.08 2.13 413.08 49956 37.1 28 37 32 2440 6.94 6.08 2.08 625.22 45990 30.3 36 38 33 2600 7.07 6.13 2.73 274.30 45723 31.3 18 39 34 2160 7.00 6.27 1.95 542.62 43800 29.6 36 40 35 2800 7.08 2.04 178.56 68711 32.9 18 26 6 76 376 32 GE 160 40 7 Sheet1 + + Enter O I'm Cortana. Ask me anything. X 3:47 PM 8/30/2020AutoSave On nateexcel - Saved + Search madlockkim24@outlook.com M X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 ~ A A ab Wrap Text General Merge & Center ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas BIU - Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas T69 X V A B C D E F G H J K L M N O P Q R S T 41 36 2757 6.75 6.90 375.33 65150 40.7 24 42 37 2450 6.8 6.94 329.09 39329 29.3 22 43 38 2400 7.64 7.12 1.64 297.37 63657 37.3 29 44 39 2270 7.39 1.78 323.17 67099 39.8 25 45 40 2800 7.67 2.23 468.84 75151 33.9 28 46 41 2520 7.11 7.91 2.15 93876 35.0 40 47 42 2487 7.05 8.08 2.83 380.34 79701 35.0 39 48 43 2629 6.90 8.27 2.37 398.12 77115 35.9 30 49 44 3200 8.54 3.07 312.15 52766 33.0 17 50 45 2335 6.75 8.58 2.19 452.16 32929 30.9 22 51 46 2500 7.45 8.72 1.28 698.64 87863 38.5 29 52 47 2449 7.00 8.75 1.76 367.19 73752 40.5 19 53 48 2625 8.79 2.51 431.93 85366 32.1 29 54 49 3150 7.30 8.90 367.06 39180 34.8 18 55 50 2625 9.12 1.98 400.53 56077 38.0 19 56 51 6.71 9.47 2.41 414.36 77449 37.0 34 57 52 2500 10.17 2.17 481.11 56822 34.7 25 58 53 2450 10.66 2.16 538.06 80470 30 59 54 2986 10.97 0.29 330.48 55584 36.8 21 60 55 2967 11.34 249.93 78001 32.2 30 61 56 3000 11.45 1.88 75307 34.8 30 62 57 2500 6.76 11.51 2.19 517.40 76375 36.7 28 62 11 73 2 6G 661 68 61867 23 8 21 Sheet1 + + Enter O I'm Cortana. Ask me anything. X ? 3:47 PM 8/30/2020AutoSave On nateexcel - Saved + Search madlockkim24@outlook.com M X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 ~ A A ab Wrap Text General Paste BIU - Merge & Center ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas T69 X V A B C D E F G H J K L M N O P Q R S T 58 53 2450 6.58 10.66 2.16 538.06 80470 36.4 30 59 54 2986 7.56 10.97 0.29 330.48 55584 21 60 55 2967 11.34 1.85 249.93 78001 32.2 30 61 56 3000 7.28 11.45 1.88 75307 34.8 30 62 57 2500 11.51 2.19 517.40 76375 36.7 28 63 58 2600 11.73 2.56 551.58 61857 31 64 59 2800 11.83 2.16 386.81 61312 34.2 16 65 60 2986 6.91 11.95 2.10 427.50 72040 39.0 31 66 61 2223 6.77 12.47 1.98 453.94 92414 34.9 40 67 62 2300 7.33 12.80 0.87 512.46 92602 39.3 33 68 63 3799 7.87 13.78 1.07 345.27 59599 35.6 28 69 64 2700 6.95 14.09 3.38 234.04 72453 36.0 23 70 65 2650 14.23 1.17 348.33 67925 41.1 16 71 66 2500 6.95 14.60 2.14 348.47 42631 24.7 25 72 67 2994 14.88 0.93 294.95 75652 40.5 25 73 68 2718 15.42 2.22 361.14 39650 32.9 18 74 69 3700 16.18 1.68 467.71 48033 30.3 15 75 70 2000 6.93 17.23 2.41 403.78 67403 19 76 71 2400 6.79 18.43 2.81 245.74 80597 32.4 27 77 72 2450 7.37 20.76 339.94 60928 21 78 73 2575 6.76 25.54 0.64 400.82 73762 41.6 29 79 74 2400 7.97 28.81 1.77 326.54 64225 31.4 15 on Sheet1 + Enter + O I'm Cortana. Ask me anything. X ? 3:47 PM 8/30/2020