Problem #1: Assume that the current stock price for a company is $9.75 per share. The daily changes in stock price over the last historic 500 trading days have been analyzed, resulting in the following frequency distribution: Price Change Frequency -$5.00 1 -$1.00 20 -$0.50 55 -$0.38 95 $0.00 140 $0.38 100 $0.50 73 $1.00 10 $2.00 6 A data scientist would like to develop a simulation model to predict the average ending value of the stock price on day 30 using. Develop a spreadsheet to simulate and predict the average ending value of the stock price on day 30 (i.e., track the ending value of the stock price from day 1 till day 30, whereby ending price on day 30 will be your Defined Forecast). Use Crystal Ball employing 5000 runs to find the average ending value of the stock