In: Finance
As part of a research program for a new cholesterol? drug, a pharmaceutical company would like to investigate the relationship between the ages and LDL? (low-density lipoprotein) cholesterol of men. The accompanying data set shows the ages and LDL cholesterol levels of seven randomly selected men. Construct a? 95% prediction interval to estimate the LDL cholesterol level of a 33?-year-old man. Age Cholesterol 22 141 36 177 25 156 31 198 42 158 32 145 40 207 Determine the upper and lower limits of the prediction interval
Solution :
We can do the regression analysis to find the cholesterol level in 33-years old person. Here dependent variable is Cholesterol level and the independent variable is age.
Regression is performed in excel sheet and result is given there
Equation is
Y = intercept + X * Age
Cholesterol level = 112.35 + 1.735 * Age