Please show formula for used for each letter when finishing. Follow special instructions.
15-26. Dana and Riley have a bet on who will make the highest cumulative sales over the next 90 a days. Each day the probabilities are 25% Dana makes no sales, 30% Dana makes 1 sale, 3.500 Dana makes 2 sales, and 10% Dana makes 3 sales. Each day the probabilities are 10% Riley loses a previous sale, 65% Riley makes 0 sales, and 25% Riley makes 5 sales. Yes, Riley's sales can go negative. Dana's daily sales and Riley's daily sales are independent of each other. (a) Create a worksheet to simulate the bet. You should have a row for each day. You should have columns for at least day number, Dana's sales that day, Riley's sales that day, Dana's cumulative sales, Riley's cumulative sales, and who is ahead in cumulative sales at the end of the day (Dana, Riley or tie). You may use other columns and cells as you wish. At the top of the worksheet give the winner of the bet (or possibly it's a tie). (b) Create a chart that has days along the horizontal axis and cumulative sales along the vertical axis. The chart should have two lines showing the cumulative sales of Dana and Riley during the 90 days. Pressing F9 to run a new 90-day simulation should cause the chart to be updated. (c) Add a data table to see 1,000 simulations of the 90-day bets. The output column should give the winner of the bet, either Dana, Riley, or tie. Above the data table give the percent of times that Dana wins, the percent of time Riley wins, and the percent of time they tie. o Change the length of the bet to 10 days (instead of 90 days). o Change the number of simulations in part c to 25 (instead of 1,000). 15-26. Dana and Riley have a bet on who will make the highest cumulative sales over the next 90 a days. Each day the probabilities are 25% Dana makes no sales, 30% Dana makes 1 sale, 3.500 Dana makes 2 sales, and 10% Dana makes 3 sales. Each day the probabilities are 10% Riley loses a previous sale, 65% Riley makes 0 sales, and 25% Riley makes 5 sales. Yes, Riley's sales can go negative. Dana's daily sales and Riley's daily sales are independent of each other. (a) Create a worksheet to simulate the bet. You should have a row for each day. You should have columns for at least day number, Dana's sales that day, Riley's sales that day, Dana's cumulative sales, Riley's cumulative sales, and who is ahead in cumulative sales at the end of the day (Dana, Riley or tie). You may use other columns and cells as you wish. At the top of the worksheet give the winner of the bet (or possibly it's a tie). (b) Create a chart that has days along the horizontal axis and cumulative sales along the vertical axis. The chart should have two lines showing the cumulative sales of Dana and Riley during the 90 days. Pressing F9 to run a new 90-day simulation should cause the chart to be updated. (c) Add a data table to see 1,000 simulations of the 90-day bets. The output column should give the winner of the bet, either Dana, Riley, or tie. Above the data table give the percent of times that Dana wins, the percent of time Riley wins, and the percent of time they tie. o Change the length of the bet to 10 days (instead of 90 days). o Change the number of simulations in part c to 25 (instead of 1,000)
