Resource Image

Linear Regression (Excel) and Cellular Respiration for Biology, Chemistry and Mathematics

Author(s): Irene Corriette1, Beatriz Gonzalez1, Daniela Kitanska2, Henriette Mozsolits2, Sheela Vemu3

1. Santa Fe College 2. Passaic County Community College 3. Waubonsee Community College

4134 total view(s), 1569 download(s)

0 comment(s) (Post a comment)

Summary:
Students typically find linear regression analysis of data sets in a biology classroom challenging. These activities could be used in a Biology, Chemistry, Mathematics, or Statistics course. The collection provides student activity files with Excel…

more

Students typically find linear regression analysis of data sets in a biology classroom challenging. These activities could be used in a Biology, Chemistry, Mathematics, or Statistics course. The collection provides student activity files with Excel instructions and Instructor Activity files with Excel instructions and solutions to problems. Students will be able to perform linear regression analysis, find correlation coefficient, create a scatter plot and find the r-square using MS Excel 365. Students will be able to interpret data sets, describe the relationship between biological variables, and predict the value of an output variable based on the input of an predictor variable.

Description

Students typically find linear regression analysis of data sets in a biology classroom challenging. These activities could be used in a Biology, Chemistry, Mathematics, or Statistics course. The collection provides student activity files with Excel instructions and Instructor Activity files with Excel instructions and solutions to problems. 

Students will be able to perform linear regression analysis, find correlation coefficient, create a scatter plot and find the r-square using MS Excel 365. Students will be able to interpret data sets, describe the relationship between biological variables, and predict the value of an output variable based on the input of an predictor variable.

Upon completion of the activities students will be able to: 

  • Describe the function of cellular respiration

  • Identify the type of reaction of cellular respiration

  • Identify the reactants and products of the cellular respiration reaction

  • Interpret data sets to show the presence of CO2 as a product in cellular respiration 

  • Perform linear regression analysis using MS Excel 365

    • Interpret the regression output using the correlation coefficient

    • Construct a scatter plot using MS Excel 365

    • Use R-squared to judge the fit of the regression line

    • Describe the relationship between the biological variables presented in this experiment. 

    • Predict the value of an output variable (response) based on the input of an input (predictor) variable. 

 

This material is based upon work supported by the National Science Foundation under Grant No. 1919613. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

Cite this work

Researchers should cite this work as follows: