Probability of regression result

#1
Hi!

A stock is selling at $50 now. Based on a 90-day linear regression (i.e., 90 historical periods), 80 days from today, the stock will be selling at $56. The standard error is 4. What is the 95% probability that the stock will be selling at least at $59? Using Excel, how is the 95% probability calculated?

Thank you!

Tony
 
Last edited: