<< Chapter < Page Chapter >> Page >
This module provides a lab of Linear Regression and Correlation as a part of Collaborative Statistics collection (col10522) by Barbara Illowsky and Susan Dean.

Class Time:

Names:

Student learning outcomes:

  • The student will calculate and construct the line of best fit between two variables.

Collect the data

Use 8 members of your class for the sample. Collect bivariate data (distance an individual lives from school, the cost of supplies for the current term).

  1. Complete the table.
    Distance from school Cost of supplies this term
  2. Which variable should be the dependent variable and which should be the independent variable? Why?
  3. Graph “distance” vs. “cost.” Plot the points on the graph. Label both axes with words. Scale both axes.
    Blank graph with vertical and horizontal axes.

Analyze the data

Enter your data into your calculator or computer. Write the linear equation below, rounding to 4 decimal places.

  1. Calculate the following:
    • a =
    • b =
    • correlation =
    • n =
    • equation: y ^ =
  2. Supply an answer for the following senarios:
    • For a person who lives 8 miles from campus, predict the total cost of supplies this term:
    • For a person who lives 80 miles from campus, predict the total cost of supplies this term:
  3. Obtain the graph on your calculator or computer. Sketch the regression line below.
    Blank graph with vertical and horizontal axes.

Discussion questions

  1. Answer each with 1-3 complete sentences.
    • Does the line seem to fit the data? Why?
    • What does the correlation imply about the relationship between the distance and the cost?
  2. Are there any outliers? If so, which point is an outlier?
  3. Should the outlier, if it exists, be removed? Why or why not?

Get Jobilize Job Search Mobile App in your pocket Now!

Get it on Google Play Download on the App Store Now




Source:  OpenStax, Collaborative statistics using spreadsheets. OpenStax CNX. Jan 05, 2016 Download for free at http://legacy.cnx.org/content/col11521/1.23
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Collaborative statistics using spreadsheets' conversation and receive update notifications?

Ask