DAT/565: Data Analysis And Business Analytics Wk 1 - Apply: Statistics Analysis [due Mon] Wk 1 - Apply: Statistics Analysis [due Mon] Assignment Content Resource: Pastas R Us, Inc. Database Review the Wk 2 - Apply: Statistical Report assignment. In preparation for writing your report to senior management next week, conduct 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. build 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? build 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?

Square Over Previour Loyalty Card Salar Par SqFu SalertSafe Income (3 Miles) Miles ) 2.07 2604 -4.01 2.54 209.93 20 2453 6.$9 -3.94 1.66 :64.92 $137 2340 2501 -3.3 399.20 50999 31.5 DAT/565: Data Analysis And Buriness Analytier Wk 1- Apply: Statistier Analysis [due 2806 2.96 264.64 30 571.59 35.1 Man]Wk 1- Apply: Statistics Analysis [due Mon] Arrianment Content Resource: Partor R 240 7.13 -0.37 2.34 642.25 :0975 37.6 Ur, Inc. Databare Review the Wk 2- Apply: Statistical Report arrianment. In preparation 2709 -0.25 2.20 461.45 72808 1997 2.34 79070 2342 0.47 2.09 $497 36.2 sheet or in aseparate Word document: Insert a new column in the databare that 240 7.03 0.5 2.47 arrespond to "Annual Sales."Annual Sales in the result of multiplying a restaurant's 262 2.04 1.92 2.02 572.$4 1986 7.38 2.05 2.01 526.48 $7950 34.3 24 the "Annual Sales" variable. Does it looksymmetric? Would you prefer the IQR instead of 2500 7.19 2.12 2.64 36#.73 15206 32.4 2.$4 2.22 74312 3.96 9$7.12 16226 outlier(s)smaller or larger than the average restaurant in the databare! What can you 125 4.05 405.77 49$2 35.6 26 to describe "SalertSqFE? Why? 0.72 2300 4.05 2.00 680.20 :4932 35.9 20 2761 4.24 1.$1 :68.02 34097 20 343.90 51$93 215 2.63 562.12 $$162 37 2400 1.95 494.$8 2.04 310.07 40.9 254 7.5# 1.41 373.46 75366 35.0 30 2500 7.03 5.91 5.98 4$163 3653 6.08 6.08 2.08 625.22 15490 2601 2.73 45723 2160 13801 2.04 178.56 2757 6.90 1.62 $5150 40.7 245 6.94 1.45 29.09 :4324 7.12 323.17 7049 227 2801 2.23 75151 252 $.08 2.$3 79701 35.0 6.90 2.37 398.12 77115 35.9 3201 7.17 $.27 3.07 2766 33.0 233 2.14 $.72 698.64 $7863 244 1.76 367.19 13752 262 $.90 367.06 39180 50 2625 9.12 1.98 400.53 56077 38.0 274 9.47 414.36 '744 37.0 2500 10.66 534.06 $0470 7.56 10.97 0.29 330.48 36.# 296 291.$7 75307 57 2500 11.51 2.19 517.40 4375 5 # 2600 6.42 11.73 2.56 651.5 33.8 11.$3 2.16 386.81 $1312 427.50 2040 39.0 222 1.98 453.94 9241 2301 2602 13.73 345.27 35.6 2700 14.09 3.38 234.04 72453 65 2650 7.33 14.23 1.17 348.33 7925 250 14.60 294.95 5652 40.5 271: 15.42 2.22 361.14 4650 3701 1.68 43033 30.3 2000 403.78 7403 36.2 71 2400 18.43 2.81 245.74 :0597 72 2450 20.76 1.09 .0928 43.5 2400 20.$1 326.54