Answers are given. Please solve using excel ONLY!

As part of a research program for a new cholesteroldrug, 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 42 -year old man

Age Cholesterol

25 146

39 183

28 162

34 217

44 159

33 148

43 211

Determine the upper and lower limits of the prediction interval.

UPL = 271.1

LPL = 103.9