HW 9: Linear Regression and Correlation Analysis
INSTRUCTIONS: Please modify the Excel sheet attached to
complete this assignment. Turn in the following work including: 1)
written formulas, 2) values from Excel plugged into formulas, and
3) final answer.
Scenario: A graduate student has administered a
pro-inflammatory substance, lipopolysaccharide (LPS), to rats in
the form of a pill (several doses – 0 mg or placebo, 1.25 mg, 2.5
mg, 5.0 mg, and 10 mg). She then determines the blood concentration
of...