= Homework: Ch 12 Assign 16 Question list K * Question 1 Question 1, 12.5.43 Part 1 of 7 HW Score: 25%, 25 of 100 points Points: 25 of 100 Save A certain company produces software designed to enhance company creativity. The current stock price for the company is $9.74 per share. The daily changes in stock price over the last 500 trading days have been analyzed, resulting in the accompanying frequency distribution. Develop a spreadsheet model to simulate the stock performance over the next 50 trading days. Use Monte Carlo simulation with 50 trials to replicate the spreadsheet and find the distribution of the ending stock price. Click here to view the frequency distribution. Click here to view the random numbers. Click here to view the simulation data for the stock prices. Determine the random number intervals for the lookup table. (Type integers or decimals. Do not round.) Random number interval Frequency Distribution Random Numbers Price Change Lower Bound Upper Bound - $5.00 - $1.00 - $0.50 - $0.38 Price Change Frequency - $5.00 1 - $1.00 18 - $0.50 60 $0.00 0.606 - $0.38 92 $0.38 0.606 0.814 $0.00 132 $0.38 104 $0.50 $0.50 75 $1.00 0.964 0.984 $1.00 10 $2.00 0.984 $2.00 8 Print Done Simulation Data 0.4745263967079 0.9063408895891 0.7799531746562 0.3511688031029 0.3544068929527 0.0856343717713 0.6505450027299 0.1366659012328 0.1973723434831 0.4596528273354 0.4589440233349 0.4175255389034 0.1982775084666 0.4769015659005 0.2300883188053 0.8405098257775 0.2299165577767 0.3908227921421 0.7535346265666 0.6739628271544 0.5231282909043 0.6937825361703 0.3932730380414 0.0540848346679 0.5796858973707 0.1084801885805 0.2846425167679 0.0125058861508 0.8374741872947 0.2533882480363 0.6032201906681 0.5946494865206 0.2176690917544 0.5804507679215 0.4617089514908 0.6480963209868 0.1622416908677 0.2993358971082 0.3016824197498 0.8382333805031 0.7457740813241 0.0315819294339 0.9619711367236 0.8325438922423 0.5400106141064 0.7382737019743 D 6.38 10.37 14.49 10.94 7.15 10.42 14.04 10.76 7.08 13.53 10.84 7.61 9.91 9.62 13.78 10.97 7.49 10.07 13.21 11.22 7.52 9.94 12.96 11.69 7.77 9.96 13.21 11.28 8.01 9.14 12.51 11.53 8.49 9.07 12.55 11.17 8.03 9.25 12.51 11.41 8.21 8.66 12.56 12.08 8.74 8.99 12.15 12.12 8.59 11.71 Help me solve this View an example Get more help - Print Done 0.2201909242292 0.8155348965971 0.7416991427269 0.3122847058402 Print Done Clear all Check answer