The following section refers to the MS Excel spreadsheet for Final data 1 Construction 6. (20 points) a. Based on the ce

[answerhappygod]

The Following Section Refers To The Ms Excel Spreadsheet For Final Data 1 Construction 6 20 Points A Based On The Ce 1 (23.67 KiB) Viewed 19 times

The Following Section Refers To The Ms Excel Spreadsheet For Final Data 1 Construction 6 20 Points A Based On The Ce 2 (20.92 KiB) Viewed 19 times

The Following Section Refers To The Ms Excel Spreadsheet For Final Data 1 Construction 6 20 Points A Based On The Ce 3 (20.09 KiB) Viewed 19 times

The Following Section Refers To The Ms Excel Spreadsheet For Final Data 1 Construction 6 20 Points A Based On The Ce 4 (65.02 KiB) Viewed 19 times

The following section refers to the MS Excel spreadsheet for Final data 1 Construction 6. (20 points) a. Based on the central limit theorem, consider the pallet of cement prices, can you assume that the data is normally distributed? b. why or why not? c. Which item is the most expensive? d. Which item is cheapest? e. Calculate the point estimate (average) for every store. f. Which store has the highest average prices? g. Which item has the highest variability in price (price range)? h. Which graph shows the pricing trends best so your boss can see the data quickly? į. Michelle's pallet of durarock materials is very low, do you think it is real or a mis-print?
A B D E F G H 1 supplies v suppliers ---> Michelle's Home Depot Means Bryce's Ace Menards True Valu. Tyler's 84 Lumber 2 1. pallet 50lb cement 221 324 284 254 350 304 253 226 250 3 2. pallet 2x4 359 376 358 383 407 338 376 319 445 4 3. pallet 2x6 534 497 436 497 463 509 427 485 440 5 4. pallet 1/2 drywall 243 271 217 292 265 251 265 252 228 6 5. pallet 1/4 durarock 131 303 353 339 303 386 370 308 363 7 6. carpet 567 409 465 419 511 589 504 640 503 8 7. pallet of floor tile 519 611 669 648 696 656 678 679 622 9 8. pallet of wall tile 314 595 448 589 383 399 338 464 354 10 9. shingles 320 339 305 314 216 240 229 205 218 11 10. toilet paper pallet 880 940 865 713 897 718 708 697 679
Scatter plot of cost per item by store 10 Hundreds 9 .... 8 ca 7 . ... 6 on 5 4 .. ... 3 ..... 00. 2 2 1 0 0 1 2 3 4 5 6 7 8 9 10 11 • Michelle's • Home Depot • Means • Bryce's • Ace • Menards • True Value • Tyler's • 84 Lumber
line chart 1000 900 800 700 600 US DOLLARS 500 400 300 200 100 0 1. pallet 50lb cement 2. pallet 2x4 3. pallet 2x6 4. pallet 1/2 drywall 5. pallet 6. carpet 7. pallet of 8. pallet of 9. shingles 10. toilet 1/4 floor tile wall tile paper pallet durarock SUPPLIES PLOTTED BY SUPPLIER Michelle's Home Depot Means Bryce's Ace Menards True Value Tyler's 84 Lumber