Question

# DAT/565: Data Analysis And Business Analytics Wk 1 - Apply:...

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?

Image transcription text

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 &quot;Annual Sales.&quot;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 &quot;Annual Sales&quot; 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 &quot;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

...

Solved by verified expert
<p>nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Explore over 16 million step-by-step answers from our library

i lectus, congue vel laoreet ac, dictuoamet, consecteturtdictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipi

fficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dicinia pulvinar tortor nec facilisis. Pellentescongue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, uipsum dolor sit amet, consectetur adipiscing elio. Donec aliquet. Lorem ipsum dolo

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultricesnec facilisis. Pellentesque dapibec facilisis. Pemolestiem ipsum dgue vel laoreet ac, dictu, dictum vitae odio. Donec aliquet. Lorem ip

at, ultrices ac m, consectetFusce dui lectus, congue vel laoreet ac, dictum vitae odfficamet, coonec aliquet. Lorem ipsum dolor sitfacilisis. Pellentesque dapng elit. Nam lacinia pulvinar tfficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consecteturctum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam laci

llentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec

Fusce dui lectus, congue vels a molestie consequat, ultrices ac magna. Fusce dui lectua. Fusce dui lectus, congue vel lao

Step-by-step explanation

ce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliqu

sus ante, dapibus a mol

ac, dictum vitae odio. Donec al

3 Attachments
JPG
JPG
JPG
Student reviews
83% (18 ratings)