statistics / forecasting

Project Description:

consider the following time series:
t 1 2 3 4 5 6 7
yt 120 110 100 96 94 92 88

a. construct a time series plot. what type of pattern exists in the data?

b. use excel solver or lingo to find the parameters for the line that minimizes mse this time series.

c. what is the forecast for t = 8?

mean squared error (mse) the average of the sum of squared forecast errors.
Skills Required:
Project Stats:

Price Type: Negotiable

Completed
Total Proposals: 19
1 Current viewersl
55 Total views
Project posted by:

Proposals

Proposals Reputation Price offered