Lesson 6: Simple Regression

0
February 9, 2017 at 10:00 am  •  Posted in s17-busad360 by  •  0 Comments

Thu, Feb 9

Review:

  • Scatter Plots (submit)

Presentation:

  • Simple (bivariate) regression
    • Demonstrate Linear Regression in Google Sheets
      • XL Miner Add-On
      • Line fit with Scatter Plot
    • Fitting Lines to Data (video)

Activity:

  • Run simple regression using Sheets with XL Miner using Data sets 1, 2 and 3 from previous activities.
    • Highlight the following:
      • R-Squared
      • SSE (SS Residual)
      • SSyy (SS Total)
      • b1 and b0 (coefficients)
  • Run simple regression using Sheets with Scatter Plot line fit for the Fertility-GDP data
  • Submit the following in class on Tue, Feb 14
    • Print regression output from XL Miner for all 3 data sets on 1 page
    • Print your Scatter Plot with line fit on 1 page

Leave a Reply