Using the first 33 months of data for years 2017, 2018, and 2019, forecast the price of BERIX for months 34, 35, and 36 in year 2019. In all cases, the response variable is the price of your Fund. You need to indicate BERIX in your submission.

In order to insure for validity of your Minitab 18.0 regression computations, you must show a link between your Minitab 18.0 data set, your Minitab 18.0 regression drop downs, and your Minitab 18.0 regression outputs. That is, for each regression run, the data file, the drop down, and the output all need to be given.

1. gdp (1,2,,33 )

2. price per barrel of oil (1,2,, 33 )

3. unemployment (1,2,, 33 )

Using the Best Subsets regression program and the multiple regression program, relate the dependent variable Fund price simultaneously to the 3 sets of explanatory variables:

Set 1 variable time (1, 2,, 33)

Set 2 variable finance (1, 2,, 33)

Set 3 variable economic (1, 2,, 33)

Pick the best 3 models from the best subsets modeling procedure and the proposed models (best 3) into a multiple regression program:

a. Determine which of the 3 models is best in terms of R2 and S values

b. Using the model structures used in part (1), display the forecast of stock price of your Fund for months 34, 35 and 36), determine which model gives the best forecast and why.

using Mini tab, if it requires more than 1 qustion let me know