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)
- Instructor Version Linear Regression and Cellular Respiration.docx(DOCX | 1000 KB)
- Instructor Version Linear Regression and Cellular Respiration.pdf(PDF | 932 KB)
- Student Version Linear Regression and Cellular Respiration.docx(DOCX | 682 KB)
- Student Version Linear Regression and Cellular Respiration.pdf(PDF | 759 KB)
- License terms
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:
- Corriette, I., Gonzalez, B., Kitanska, D., Mozsolits, H., Vemu, S. (2021). Linear Regression (Excel) and Cellular Respiration for Biology, Chemistry and Mathematics. Fall 2021 QB@CC Incubator #2, QUBES Educational Resources. doi:10.25334/5PX5-H796