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 your answer as a number and round to 3 decimal places.

Question

Quintin Cabrera

Mathematics

16 October, 05:26

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 your answer as a number and round to 3 decimal places.

+2

Answers (1)

Know the Answer?

Memphis Barron · Answer 1

Check the explanation

Step-by-step explanation:

Variable Name R2 squared value Adj R2 value

Earning Per Share 0.086535 0.077214

Earning Per Share,

Dividends per Share 0.103976 0.085501

Earning Per Share,

Dividends per Share,

Average Yield 0.180303 0.154687

Earning Per Share,

Dividends per Share,

Average Yield,

Return on Equity 0.183215 0.148824

Earning Per Share,

Dividends per Share,

Average Yield,

Return on Equity,

Total Assests 0.184669 0.141301

Earning Per Share,

Dividends per Share,

Average Yield,

Return on Equity,

Total Assets,

Total Revenues 0.187297 0.134865