Linear Regression (Excel) and Cellular Respiration for Biology, Chemistry and Mathematics
Author(s): Irene Corriette^{1}, Beatriz Gonzalez^{1}, Daniela Kitanska^{2}, Henriette Mozsolits^{2}, Sheela Vemu^{3}
1. Santa Fe College 2. Passaic County Community College 3. Waubonsee Community College
666 total view(s), 100 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 rsquare 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 Rsquared 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/5PX5H796