Question

The following data represent the weight of a child riding a bike and the rolling distance achieved after going down a hill without pedaling.

Weight (lbs.)	Rolling Distance (m.)
59	26
83	43
97	49
56	20
103	65
87	44
88	48
91	42
52	39
63	33
71	39
100	49
89	55
103	53
99	42
74	33
75	30
89	30
102	40
103	33
99	33
102	35
86	37
85	37

Find the 99% prediction interval for rolling distance when a child riding the bike weighs 99 lbs. (round to 4 decimal places)

  < y <   

using excel.

Answer 1

excel output (Regression analysis):

from the table 99% prediction interval is (-17.08,37.752)