Lesson 21: Practicing Simple Linear Regression in Sheets

April 15, 2026

Review:

• Cautions about Correlation and Regression
• Prospective and Retrospective Studies
• Exam 3 next week

Assignment:

• Download Simple Regression Datasets
• You’ll find 8 separate datasets
• For each dataset
  • Create a Scatterplot (select data then Insert>Chart)
  • Fit a Trendline
  • Add a Label showing the linear equation
  • Show R^2
• Challenge 1
  • Select the dataset with the best fitting linear regression equation
  • Reproduce the linear equation
  • Have it refer to a cell location with an example x value
  • The equation should refer to the cell location with x and produce a corresponding y-hat value
  • For example, if using the Sleep vs Quiz Score data and linear equation
    • You will type in an example number for x (e.g., 8)
    • In a separate cell you will recreate the linear equation (e.g., =1.5*B2 + 20)
    • The equation will refer to the cell location for x (e.g., the equation above refers to cell “B2”)
    • The linear equation will calculate a y-hat value for x=8
  • I haven’t shown you how to do this but see if you can meet the challenge
• Challenge 2
  • Create a Google Slides file with 2 separate slides
  • On Slide 1 create a display showing the scatterplot charts for the 4 best fitting linear models
  • On Slide 2 create a display showing the scatterplot charts for the 4 worst fitting linear models
  • You can arrange the charts however you like but if it were me I’d create a 4 quadrant display with each chart the same size and dimensions
  • Sort of like this image below

Be prepared to show your worksheet in class on Monday