Parts xix, xx, xxi, and xxii only!

The model you made is: Price tomorrow = 2,590.97 + 0.87*(Price Today) +0.12"(Price Yesterday) - 0.000047"(Price Yesterday). To make this model work, you have to modify the data a little bit. Your modified "Price Today" = $600. Your modified "Price Yesterday" is $598. xv) What is your predicted "Price Tomorrow"? 2590.97 +0.87*600+ 0.13 *598-0.000047*596*6598 = 3161.92. xvi) Assuming the "Price Tomorrow" has a 95% confidence interval of Price tomorrow +/-2*(Std Er Model), what is the confidence interval? CI =(3167.9.2-1.96*61,9560, 3167.9.2+ 1.90*619552)=(3046,4842, 3229,358) xvii) Your boss wants to short the stock. But, it needs to be below $3,100.00. What is the probability the stock tomorrow will meet this requirement? NCDF(0,Stock Price, Price Tomorrow, Std Err Model) ne xviii) 0.5-0.3443 = 0. 1357 or 13.57% Based upon this info, would you recommend that your boss try to short the stock tomorrow? lag the Another boss heard you made a model and it looked greatl". They want to know to the dollar what the stock price will be tomorrow. Is your model good enough to give a price down to the dollar? xix) xx) Why not? (HINT HINT HINT) xxi) If today's price was $3,163.00. And your estimated price for tomorrow is in xv, would you suggest to your boss that you buy or sell Amazon stock at tomorrows close? (remember, buy low, sell high) xxii) If tomorrow's price at close is $3,200.00, is that within your confidence interval? xxiii) Suppose your company bought 100,000 stock today at $3,163.00 and sold them tomorrow at $3,200. How much money did your company just make? xxiv) If you make a 5% commission when you sell stock and it makes money, how much did you just make? The model you made is: Price tomorrow = 2,590.97 + 0.87*(Price Today) +0.12"(Price Yesterday) - 0.000047"(Price Yesterday). To make this model work, you have to modify the data a little bit. Your modified "Price Today" = $600. Your modified "Price Yesterday" is $598. xv) What is your predicted "Price Tomorrow"? 2590.97 +0.87*600+ 0.13 *598-0.000047*596*6598 = 3161.92. xvi) Assuming the "Price Tomorrow" has a 95% confidence interval of Price tomorrow +/-2*(Std Er Model), what is the confidence interval? CI =(3167.9.2-1.96*61,9560, 3167.9.2+ 1.90*619552)=(3046,4842, 3229,358) xvii) Your boss wants to short the stock. But, it needs to be below $3,100.00. What is the probability the stock tomorrow will meet this requirement? NCDF(0,Stock Price, Price Tomorrow, Std Err Model) ne xviii) 0.5-0.3443 = 0. 1357 or 13.57% Based upon this info, would you recommend that your boss try to short the stock tomorrow? lag the Another boss heard you made a model and it looked greatl". They want to know to the dollar what the stock price will be tomorrow. Is your model good enough to give a price down to the dollar? xix) xx) Why not? (HINT HINT HINT) xxi) If today's price was $3,163.00. And your estimated price for tomorrow is in xv, would you suggest to your boss that you buy or sell Amazon stock at tomorrows close? (remember, buy low, sell high) xxii) If tomorrow's price at close is $3,200.00, is that within your confidence interval? xxiii) Suppose your company bought 100,000 stock today at $3,163.00 and sold them tomorrow at $3,200. How much money did your company just make? xxiv) If you make a 5% commission when you sell stock and it makes money, how much did you just make