Lesson 10: Building Multiple Regression Models

March 1, 2016

Previous | Next

Wed, Mar 2

Review:

• Regression Output Interpretation

Presentation:

• Building multiple regression models
  • Demonstrate with black_7e_excel_database (Sheets)
  • Manufacturing
    • Cost of Materials (y)
    • Number of Employees, New Capital Expenditures, Value Added by Manufacturer, End of Year Inventories
  • Financial
    • Average P/E ratio (y)
    • Total Revenues, Total Assets, Return on Equity, Earnings per Share, Average Yield, Dividends per Share
  • International Stock Market
    • Nikkei (y)
    • DJIA, Nasdaq, S&P 500, Hang Seng, FTSE 100, IPC
  • Consumer Food
    • Annual Food Spending (y)
    • Annual Household Income, Non Mortgage Household Debt

Assignment:

• Use the Pueblo 2014 SF RE Sales Data (Sheets) data to build a regression model
  • Predict “Selling Price” (y)
  • Use “Beds”, “Baths” and “Total SqFt” as independent (x) variables