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

4295 total view(s), 1674 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.