Question

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.

Answer 1

Answer:

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