Ask Question
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)
  1. 16 October, 05:49
    0
    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
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Use the Financial database from "Excel Databases. xls" on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per ...” in 📗 Mathematics if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers