Lesson 10: Building Multiple Regression Models

March 1, 2016 at 9:28 pm  •  Posted in s16-busad360 by  •  2 Comments

Previous | Next

Wed, Mar 2


  • Regression Output Interpretation


  • 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


  • 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

Leave a Reply