I need help on knowing how to start a long and involved question for best subset. The website says I can attach files, but I do not see where to attach an excel file. **I only need to know which variables to place as the X and Y values in excel. I will do all the work, just need to know how to start.**

Scenario: You have put together a time-series data set that includes numerous financial and economic variables. The data runs quarterly from the years 2000 through 2016. Before doing more complex econometric modeling, you are interested in seeing if there is a basic predictive model that can be created from your data for Gross Domestic Product (GDP). Therefore, you are interested in utilizing GDP as a dependent variable and several predictor (independent) variables to generate a statistically significant regression model.

Utilizing PHStat, run a Best Subsets regression for GDP. Use the following 5 variables as predictors: S&P Quarterly Close, 10yr Treasury, M2 Supply, Unemployment Rate and Housing Starts. Use 95% confidence level.

Utilizing PHStat, run a regular Multiple Regression for GDP using the same 5 predictor variables as in part 1. In the options part of the input table select ANOVA and Coefficients Table, Durbin-Watson Statistic and VIF. Use 95% confidence level.

### Recently Asked Questions

- apply the rational model of decision making in any relevant business example

- Company M uses the percentage of sales method of estimating bad debts. At the beginning of the current fiscal year, for doubtful accounts had a credit balance

- Please refer to the attachment to answer this question. This question was created from PY 2720 Midterm Study Guide.docx.