• 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?

Data Below

Excel File Edit View Insert Format Tools Data Window $ Help # G Sun 1:23 PM Yadira Villarreal 9 PastasAUS (1).xlsx H Home o Q. Bearch in het n . Charts SmartArt 2.2.7. E Formulas Data 100% Review Layout Tebles A H = = = abe Neutral - 10A A DAE raplac ange AH Cher BI U : General % Pomlad Linda Nole God Output Calculation Heading 1 the cel Heading 2 Expory Heading 3 out Heading . Pas AM . Traurt M Sarilo . A S Thru Aa i M Pastas R Us, Inc. Database (n = 74 restaurants) Square Feet Per Person Average Spending Sales Growth Over Loyalty Card % af Previous Year % Net Sales Annual Sales Median HH Per Sq Ft Income (3 Miles) Median Age (3 Miles) % w Bachelor's Degree (3 Miles) Obs SqFt Sales/Person Sales Growth% LoyaltyCard% Sales/SqFt Medincome ModAge BachDeg% 6.81 34.4 7.57 6.89 2.07 2.54 412 40.3 7.13 T 10 5 7.04 -8.31 -4.01 -3.94 3.39 -3.30 -1.94 -0.77 -0.37 -0.25 -0.17 0.47 0.55 711 7.13 15 2354 2604 2453 2340 2500 2006 2250 2400 2709 1990 2392 2409 2627 2500 1996 2500 2669 2517 1251 2999 2625 2300 10 6.58 6.77 6.66 7.03 NNNNNNNNNNNN 17 12 7.03 7.00 19 14 2015 0.77 1.92 7.38 2.05 701.97 209.93 384 92 443.04 299 20 284.64 571.59 84225 461.45 838.82 484.38 591.09 287.71 572.84 596,48 368.73 351.47 458 24 987.12 357,45 405.77 690.80 308.02 303.95 393.90 562.12 494.88 310.07 373.46 45177 518.99 51379 66081 50999 41562 44196 50975 72808 79070 78497 41245 33003 90998 37950 45206 79312 37345 46226 70024 54982 54932 34097 46593 51893 88162 89016 114353 75366 7.1B 2.12 ?g 22 17 2.84 YTUS 7.35 8.95 7.02 6.85 2 07 2.88 3.96 1.94 2.17 0.72 35.9 4.04 4.05 4 05 4.24 4.58 5.09 6.99 7.26 7.07 7.05 2.00 1.81 2761 33.6 22 2.13 30 25 2764 2430 2154 2400 2430 2549 379 40.6 37.7 2.50 2.63 5.14 670 1.95 32 11 34 27 28 29 5.48 5.86 5.91 36.4 40.9 6.91 2.04 7.58 1.41 35.0 + Normal RN Det Ready 40A9XPWA ENEU Excel File Edit View Insert Format Tools Data Window $ Help # G Sun 1:23 PM Yadira Villarreal 9 PastasAUS (1).xlsx H Home o Q. Beach in n . Charts SmartArt 2.2.7. E Formulas Data 100% Review Layout Tebles - 10 D -AA = = = abe A ESSE r aplac Mange Tour . Pas MID General % . AM Cher BI U : I . 38 garlo Heading 1 Heading 2 Heading 3 Heading Traurte ere har Aa: 2649 14 29 1.41 2.05 35 36 30 31 7.58 7.03 6.84 6.94 7.07 5.91 5.98 6.08 6.0B 6.13 2 DB 38 33 8.27 2.73 1.95 7.OB 6.75 6.57 6.90 2 04 1.82 6.81 1.95 7.64 6.62 7.12 1.64 1.78 6.76 9 35.0 7.05 6.90 2.63 2.37 35.0 3.07 2500 3653 2440 2800 2160 2800 2757 2450 2400 2270 2800 2520 2487 2629 3200 2335 2500 2449 2625 3150 2625 2741 2500 2450 2986 2967 3000 2500 2800 2800 6.75 7.45 2.19 1.28 7.00 373.46 235.81 413.08 625.22 274.30 542 62 178.56 375.33 329.09 297.37 323. 17 468.84 252.57 380.34 398.12 312.15 452.16 098.64 387.19 431.93 387.06 400.53 414.36 481.11 538.06 330.48 249.93 291.87 517.40 551.58 306.81 427.50 453.94 512.46 SO 45 5146 5247 53 48 54 49 55 50 56 51 1.76 6.96 2.51 1.90 1.98 38.0 75386 48163 49956 4599 45723 43800 68711 65150 39329 63657 67099 75151 93876 79701 77115 52768 32929 87883 73752 85366 39 180 56077 77449 56822 90470 55584 78001 75307 76375 61857 61312 72040 92414 92602 59599 72453 67925 42631 75652 39650 48033 67403 6.96 6.71 6.82 6.58 7.58 52 2.41 2.17 2.16 58 59 7.67 7.91 8.0B 8.27 3.54 3.58 8.72 8.75 8.79 8.90 9.12 9.47 10.17 10.66 10.97 11.34 11.45 11.51 11.73 11.83 11.95 12.47 12 B 13.70 14.09 14.23 14.80 14.BB 15.42 16.10 17.23 53 54 0.29 1.85 6.98 6156 7.28 1.88 2.19 6.76 WONOSOVO 256 459 2986 2223 2.18 2.10 1.98 6.92 6.73 6.91 6.77 7.33 7.87 6.95 7.33 0.87 2300 3799 2700 125.27 1.07 3.38 2550 41.1 71 86 6.95 2.14 24.7 40.5 234.04 348.33 348.47 294.95 361.14 467.71 403.78 73 74 75 2500 2994 2718 3700 2000 68 69 70 7.21 7.25 7.65 2.22 1.68 2.41 362 Normal RN Ready Sur-D 9A9XPWA NEU Excel File Edit View Insert Format Tools Data Window $ Help # G Sun 1:23 PM Yadira Villarreal 9 PastasAUS (1).xlsx H Home o Q. Beach in n . Charts SmartArt 2.2.7. E Formulas Data 100% Review Layout Tebles - 10 = = abe . A. Pas MO AM BI -AA A E = S r aplac Mange General % Calculation Heading 1 check e Heading 2 put Heading Cher U Salon Heading 3 Traurte ere har Aa: : 1.68 74 75 76 69 70 71 7.65 6.93 6.79 3700 2000 2400 2450 2575 2400 16.10 17 23 18.43 20.76 467.71 403.78 245.74 339.94 400.82 326.54 48033 67403 80597 6092a 73762 64225 7.37 1.09 0.64 73 6.76 7.97 25,57 28.81 1.77 E E EEEEEEEEEEEEEEEEEEEEEEEE Normal VN Randy AS9 XPWAPE Excel File Edit View Insert Format Tools Data Window $ Help # G Sun 1:23 PM Yadira Villarreal 9 PastasAUS (1).xlsx H Home o Q. Bearch in het n . Charts SmartArt 2.2.7. E Formulas Data 100% Review Layout Tebles A H = = = abe Neutral - 10A A DAE raplac ange AH Cher BI U : General % Pomlad Linda Nole God Output Calculation Heading 1 the cel Heading 2 Expory Heading 3 out Heading . Pas AM . Traurt M Sarilo . A S Thru Aa i M Pastas R Us, Inc. Database (n = 74 restaurants) Square Feet Per Person Average Spending Sales Growth Over Loyalty Card % af Previous Year % Net Sales Annual Sales Median HH Per Sq Ft Income (3 Miles) Median Age (3 Miles) % w Bachelor's Degree (3 Miles) Obs SqFt Sales/Person Sales Growth% LoyaltyCard% Sales/SqFt Medincome ModAge BachDeg% 6.81 34.4 7.57 6.89 2.07 2.54 412 40.3 7.13 T 10 5 7.04 -8.31 -4.01 -3.94 3.39 -3.30 -1.94 -0.77 -0.37 -0.25 -0.17 0.47 0.55 711 7.13 15 2354 2604 2453 2340 2500 2006 2250 2400 2709 1990 2392 2409 2627 2500 1996 2500 2669 2517 1251 2999 2625 2300 10 6.58 6.77 6.66 7.03 NNNNNNNNNNNN 17 12 7.03 7.00 19 14 2015 0.77 1.92 7.38 2.05 701.97 209.93 384 92 443.04 299 20 284.64 571.59 84225 461.45 838.82 484.38 591.09 287.71 572.84 596,48 368.73 351.47 458 24 987.12 357,45 405.77 690.80 308.02 303.95 393.90 562.12 494.88 310.07 373.46 45177 518.99 51379 66081 50999 41562 44196 50975 72808 79070 78497 41245 33003 90998 37950 45206 79312 37345 46226 70024 54982 54932 34097 46593 51893 88162 89016 114353 75366 7.1B 2.12 ?g 22 17 2.84 YTUS 7.35 8.95 7.02 6.85 2 07 2.88 3.96 1.94 2.17 0.72 35.9 4.04 4.05 4 05 4.24 4.58 5.09 6.99 7.26 7.07 7.05 2.00 1.81 2761 33.6 22 2.13 30 25 2764 2430 2154 2400 2430 2549 379 40.6 37.7 2.50 2.63 5.14 670 1.95 32 11 34 27 28 29 5.48 5.86 5.91 36.4 40.9 6.91 2.04 7.58 1.41 35.0 + Normal RN Det Ready 40A9XPWA ENEU Excel File Edit View Insert Format Tools Data Window $ Help # G Sun 1:23 PM Yadira Villarreal 9 PastasAUS (1).xlsx H Home o Q. Beach in n . Charts SmartArt 2.2.7. E Formulas Data 100% Review Layout Tebles - 10 D -AA = = = abe A ESSE r aplac Mange Tour . Pas MID General % . AM Cher BI U : I . 38 garlo Heading 1 Heading 2 Heading 3 Heading Traurte ere har Aa: 2649 14 29 1.41 2.05 35 36 30 31 7.58 7.03 6.84 6.94 7.07 5.91 5.98 6.08 6.0B 6.13 2 DB 38 33 8.27 2.73 1.95 7.OB 6.75 6.57 6.90 2 04 1.82 6.81 1.95 7.64 6.62 7.12 1.64 1.78 6.76 9 35.0 7.05 6.90 2.63 2.37 35.0 3.07 2500 3653 2440 2800 2160 2800 2757 2450 2400 2270 2800 2520 2487 2629 3200 2335 2500 2449 2625 3150 2625 2741 2500 2450 2986 2967 3000 2500 2800 2800 6.75 7.45 2.19 1.28 7.00 373.46 235.81 413.08 625.22 274.30 542 62 178.56 375.33 329.09 297.37 323. 17 468.84 252.57 380.34 398.12 312.15 452.16 098.64 387.19 431.93 387.06 400.53 414.36 481.11 538.06 330.48 249.93 291.87 517.40 551.58 306.81 427.50 453.94 512.46 SO 45 5146 5247 53 48 54 49 55 50 56 51 1.76 6.96 2.51 1.90 1.98 38.0 75386 48163 49956 4599 45723 43800 68711 65150 39329 63657 67099 75151 93876 79701 77115 52768 32929 87883 73752 85366 39 180 56077 77449 56822 90470 55584 78001 75307 76375 61857 61312 72040 92414 92602 59599 72453 67925 42631 75652 39650 48033 67403 6.96 6.71 6.82 6.58 7.58 52 2.41 2.17 2.16 58 59 7.67 7.91 8.0B 8.27 3.54 3.58 8.72 8.75 8.79 8.90 9.12 9.47 10.17 10.66 10.97 11.34 11.45 11.51 11.73 11.83 11.95 12.47 12 B 13.70 14.09 14.23 14.80 14.BB 15.42 16.10 17.23 53 54 0.29 1.85 6.98 6156 7.28 1.88 2.19 6.76 WONOSOVO 256 459 2986 2223 2.18 2.10 1.98 6.92 6.73 6.91 6.77 7.33 7.87 6.95 7.33 0.87 2300 3799 2700 125.27 1.07 3.38 2550 41.1 71 86 6.95 2.14 24.7 40.5 234.04 348.33 348.47 294.95 361.14 467.71 403.78 73 74 75 2500 2994 2718 3700 2000 68 69 70 7.21 7.25 7.65 2.22 1.68 2.41 362 Normal RN Ready Sur-D 9A9XPWA NEU Excel File Edit View Insert Format Tools Data Window $ Help # G Sun 1:23 PM Yadira Villarreal 9 PastasAUS (1).xlsx H Home o Q. Beach in n . Charts SmartArt 2.2.7. E Formulas Data 100% Review Layout Tebles - 10 = = abe . A. Pas MO AM BI -AA A E = S r aplac Mange General % Calculation Heading 1 check e Heading 2 put Heading Cher U Salon Heading 3 Traurte ere har Aa: : 1.68 74 75 76 69 70 71 7.65 6.93 6.79 3700 2000 2400 2450 2575 2400 16.10 17 23 18.43 20.76 467.71 403.78 245.74 339.94 400.82 326.54 48033 67403 80597 6092a 73762 64225 7.37 1.09 0.64 73 6.76 7.97 25,57 28.81 1.77 E E EEEEEEEEEEEEEEEEEEEEEEEE Normal VN Randy AS9 XPWAPE