HW 9: Linear Regression and Correlation Analysis
INSTRUCTIONS: Please modify the Excel sheet attached tocomplete this assignment. Turn in the following work including: 1)written formulas, 2) values from Excel plugged into formulas, and3) final answer.
Scenario: A graduate student has administered apro-inflammatory substance, lipopolysaccharide (LPS), to rats inthe form of a pill (several doses – 0 mg or placebo, 1.25 mg, 2.5mg, 5.0 mg, and 10 mg). She then determines the blood concentrationof a particular protein that is thought to be upregulated due toLPS called Inflammo using ELISA. Find the linear model and thecorrelation coefficient of the experimental data on Blackboardlabeled “HW9 Raw Dataâ€.
| LPS delivered (mg) | Inflammo (ug/mL) |
| 10 | 2.234 |
| 5 | 1.198 |
| 2.5 | 0.735 |
| 1.25 | 0.411 |
| 0 | 0.105 |
| 10 | 2.337 |
| 5 | 1.201 |
| 2.5 | 0.805 |
| 1.25 | 0.431 |
| 0 | 0.088 |
| 10 | 2.115 |
| 5 | 1.275 |
| 2.5 | 0.881 |
| 1.25 | 0.249 |
| 0 | 0.101 |
| 10 | 2.176 |
| 5 | 1.303 |
| 2.5 | 0.691 |
| 1.25 | 0.383 |
| 0 | 0.089 |
(10pts)Equation for Linear Model:
(10pts)Correlation Coefficient:
(10pts)Does the linear model describe therelationship between LPS and Inflammotin concentration well?
(10pts)If so, what type of correlation existsbetween LPS dosage and Inflammo concentration?
Equations/formulas (30 pts)(Attach work):
