Support

Support Options

• Knowledge Base

Find information on common questions and issues.

• Support Messages

Check on the status of your correspondences with members of the QUBES team. Linear Regression (Excel) and Cellular Respiration for Biology, Chemistry and Mathematics

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

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…
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.

Version 1.0 - published on 03 Dec 2021 doi:10.25334/5PX5-H796 - cite this

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: