Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast the stock price for the next year. Use regression analysis, and/or moving average, etc. to create your forecast. Using 1 year monthly history shown

Forecast the stock price for the next year. Use regression analysis, and/or moving average, etc. to create your forecast.

Using 1 year monthly history shown stock prices, create a graph from the historical data and show your forecast on the same graph. You can add a trend line to the graph to help you with a forecast. Include the graph in your report and the exact forecast value for the next year. Is it reasonable?

image text in transcribed

Date Open High Low Close Adj Close Volume 9/1/16 770.90002 839.95001 10/1/16 756 837.31 837.31 67335700 836847.21002 774.60999 789.82001 789.82001 77063800 799800.84003 710.09998 750.57001750.57001 110018200 12/1/16752.40997 782.46002 736.70001 768.65997 768.65997 79303900 1/1/17 757.91998 843.84003 747.70001 823.47998 823.47998 70614000 803845.03998 845.03998 71748300 833.5886.53998 886.53998 60710700 888949.59003 884.48999 924.98999924.9899973539700 994.62 76148000 968 96102300 951 987.78003 987.78003 78812400 1006.4 951.38001 967.98999 967.9899 32917600 960 970.39002 951.38001 967.98999 967.989993468017 2/1/17829.21002 860.85999 3/1/17 853.04999 890.34998 994.62 968 5/1/17927.79999 6/1/17 998.59003 7/1/17 972.78998 1083.3101 8/1/17996.10999 1001.2 927.79999 1017 927

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions