Each question will indicate which database you need to use.

Use the link below to access "Excel Databases.xls":

https://drive.google.com/file/d/19TI3HId0greXS0nkmDuoITv1IMPF_TUK/view

__________________________________________________________________________

QUESTION 1

Use the U.S. International Stock Market database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict the DJIA by the Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC.Performing a stepwise regression analysis at a 5% level of significance, which independent variable is the best single predictor of the DJIA?This is Step 1 of the stepwise regression. Select 1 answer below.

A.Nasdaq

B.S&P 500

C.Nikkei

D.Hang Seng

E.FTSE 100

F.IPC

______________________________________________________________________________

QUESTION 2

Use the U.S. International Stock Market database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict the DJIA by the Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC.Performing a stepwise regression analysis at a 5% level of significance, add in the best single predictor and perform Step 2 of the stepwise regression.Which independent variable will be added in to the model at Step 2? Select 1 answer below.

A.Nasdaq

B.S&P 500

C.Nikkei

D.Hang Seng

E.FTSE 100

F.IPC

______________________________________________________________________________

QUESTION 3

Use the U.S. International Stock Market database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict the DJIA by the Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC.Performing a stepwise regression analysis at a 5% level of significance, add the independent variable from Step 2 and continue to perform the stepwise regression analysis until you have reached the best linear model.Which independent variables are in the best linear model?Check all answers that apply.

Nasdaq

S&P 500

Nikkei

Hang Seng

FTSE 100

IPC

______________________________________________________________________________

QUESTION 4

Use the U.S. International Stock Market database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict the DJIA by the Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC.What is the increase in the r-squared value from the best initial model (step 1) to the final model you've chosen?Write the answer as a number and round the final answer to 3 decimal places. (i.e.if r²= 0.24135 in step 1 and r²= 0.5255 in step 2, the increase would be 0.284)

______________________________________________________________________________

QUESTION 5

Use the Financial database from "Excel Databases.xls".Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company.Use Excel to perform a forward selection regression analysis.Assume a 5% level of significance.Which independent variables are in the final model?Select all answers that apply.

Total Revenues

Total Assets

Return on Equity

Earnings Per Share

Average Yield

Dividends Per Share

______________________________________________________________________________

QUESTION 6

Use the Financial database from "Excel Databases.xls".Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company.Use Excel to perform a forward selection regression analysis.Assume a 5% level of significance.Based on your final model, what is the p-value from the test of the overall model?Write the answer as a number and round to 3 decimal places.

______________________________________________________________________________

QUESTION 7

Use the Financial database from "Excel Databases.xls".Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company.Use Excel to perform a forward selection regression analysis.Assume a 5% level of significance.Identify observation 2 in the original dataset.Use the observed values from observation 2 to find the predicted value y-hat based on your final model selected.Write the answer as a number and round your final answer to a whole number.

______________________________________________________________________________

QUESTION 8

Use the Manufacturer database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, Number of Production Workers, Value Added by Manufacture, New Capital Expenditures, and End-of-Year Inventories.Use Excel to perform a backward elimination regression analysis at a 5% level of significance.What is the test statistic of the independent variable that is dropped from the linear model in the first step.Write the answer as a number and round to 2 decimal places.

______________________________________________________________________________

QUESTION 9

Use the Manufacturer database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, Number of Production Workers, Value Added by Manufacture, New Capital Expenditures, and End-of-Year Inventories.Use Excel to perform a backward elimination regression analysis at a 5% level of significance.What independent variables are included in your final model?Check all answers that apply.

Number of Employees

Number of Production Workers

Value Added by Manufacture

New Capital Expenditures

End-of-Year Inventories

______________________________________________________________________________

QUESTION 10

Use the Manufacturer database from "Excel Databases.xls".Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, Number of Production Workers, Value Added by Manufacture, New Capital Expenditures, and End-of-Year Inventories.Does multicollinearity seem to be a problem in this analysis?Use Excel to create the correlation matrix that includes all 5 of the independent variables in this study.Which two independent variables have the highest correlation?Select 2 answers below.

Number of Employees

Number of Production Workers

Value Added by Manufacture

New Capital Expenditures

End-of-Year Inventories

______________________________________________________________________________