Question: QUESTION 1 Each week Smith's Department Store selects a simple random sample of 100 customers to learn about the amount spent per shopping trip. Use

QUESTION 1 Each week Smith's Department Store selects a simple random sample of 100 customers to learn about the amount spent per shopping trip. Use the data from the excel file to solve the following. What's the margin of error at alpha 0.05? (Hint: Use formula "CONFIDENCE. NORM(alpha, stdev, size)" Smith's Data.xIsx O 3.62 4.31 O 5.67 O 3.92 QUESTION 2 Each week Smith's Department Store selects a simple random sample of 100 customers to learn about the amount spent per shopping trip. Use the data from the excel file to solve the following. What's the upper limit and lower limit when alpha is 0.05? Smith's Data.xIsx 83.58 & 79.52 O 76.13 & 69.13 O 90.31 & 81.69 O 93.33 & 97.23 QUESTION 3 Each week Smith's Department Store selects a simple random sample of 100 customers to learn about the amount spent per shopping trip. Use the data from the excel file to solve the following. What's the upper limit and lower limit when alpha is 0. 10? Smith's Data.xIsx O 76.13 & 69.13 O 93.33 & 97.23 O 83.58 & 79.52 O 89.62 & 82.38
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
