The letter being D so use column D, "the table posted on classes is the table attached

12.6. Jessica Williams, manager of kitchen appliances for the Midtown Department Store, feels that her inventory levels of stoves have been running higher than necessary. Before revising the inventory policy for stoves, she records the number sold each day over a period of 25 days, as summarized below. 2 4 5 6 Number sold Number of days 3 7 07 07 4 00 8 5 1 a Use these data to estimate the probability distribu- tion of daily sales. b Calculate the mean of the distribution obtained in part a. C Describe how random numbers can be used to sim- ulate daily sales. d Use the random numbers 0.4476, 0.9713, and 0.0629 to simulate daily sales over three days. Com- pare the average with the mean obtained in part b. e Formulate a spreadsheet model for performing a computer simulation of the daily sales. Perform 300 replications and obtain the average of the sales over the 300 simulated days. E e 1 1 2 A 25 32 33 2 3 4 4 33 5 6 85 57 7 93 | | D 54 87 43 66 23 42 32 87 2 56 41 43 19 19 4 87 56 85 51 88 81 97 4 62 86 14 75 98 75 25 86 50 59 53 20 18 37 7 82 70 48 46 60 90 27 8 93 8 9 9 38 10 84 11 74 12 94 1360 14 7 15 29 Consider the scenario in problem 12.6 on page 359. Compute the probabilities for sales of 2,3,4,5,6 stoves sold per day from the information given. Use your probabilities to simulate: 1. Simulate 10 days of sales long hand. Use the random number table posted on Classes under Data files; use numbers from the column with the letter from your name. Compute the average number of stoves sold per day based on your simulation. 2. Simulate 100 days of sales using Excel. Compute the cumulative sales, and the running average of sales per day as part of your simulation. 3. Based on your simulation, if the store inventory is never more than 3 stoves how many sales would be lost? 12.6. Jessica Williams, manager of kitchen appliances for the Midtown Department Store, feels that her inventory levels of stoves have been running higher than necessary. Before revising the inventory policy for stoves, she records the number sold each day over a period of 25 days, as summarized below. 2 4 5 6 Number sold Number of days 3 7 07 07 4 00 8 5 1 a Use these data to estimate the probability distribu- tion of daily sales. b Calculate the mean of the distribution obtained in part a. C Describe how random numbers can be used to sim- ulate daily sales. d Use the random numbers 0.4476, 0.9713, and 0.0629 to simulate daily sales over three days. Com- pare the average with the mean obtained in part b. e Formulate a spreadsheet model for performing a computer simulation of the daily sales. Perform 300 replications and obtain the average of the sales over the 300 simulated days. E e 1 1 2 A 25 32 33 2 3 4 4 33 5 6 85 57 7 93 | | D 54 87 43 66 23 42 32 87 2 56 41 43 19 19 4 87 56 85 51 88 81 97 4 62 86 14 75 98 75 25 86 50 59 53 20 18 37 7 82 70 48 46 60 90 27 8 93 8 9 9 38 10 84 11 74 12 94 1360 14 7 15 29 Consider the scenario in problem 12.6 on page 359. Compute the probabilities for sales of 2,3,4,5,6 stoves sold per day from the information given. Use your probabilities to simulate: 1. Simulate 10 days of sales long hand. Use the random number table posted on Classes under Data files; use numbers from the column with the letter from your name. Compute the average number of stoves sold per day based on your simulation. 2. Simulate 100 days of sales using Excel. Compute the cumulative sales, and the running average of sales per day as part of your simulation. 3. Based on your simulation, if the store inventory is never more than 3 stoves how many sales would be lost