QUESTION 5

Use the Financial database from "Excel Databases.xls" on Blackboard.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 that apply.

a. Total Revenues b. Total Assets c. Return on Equity d. Earnings Per Share e. Average Yield f. Dividends Per Share

QUESTION 6

Use the Financial database from "Excel Databases.xls" on Blackboard.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 answer as a number and round to 3 decimal places.

QUESTION 7

Use the Financial database from "Excel Databases.xls" on Blackboard.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 answer as a number and round your final answer to a whole number.

Excel Data: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing

(Find "Financial" tab for data )(all I need is the answer for question 7)