The resulting spreadsheet should come up with these values.  

A

B

C

D

E

F

G

H

temperature

water

y-hat

Residual (y-y-hat)

residual^2

HI1

 

DFITS

75

16

11.9948

4.0052

16.04163

0.53588

 

2.083637

83

20

23.6044

-3.6044

12.9917

0.200997

 

-0.54506

85

25

26.5068

-1.5068

2.270446

0.163787

 

-0.17607

85

27

26.5068

0.4932

0.243246

0.163787

 

0.05664

92

32

36.6652

-4.6652

21.76409

0.180066

 

-0.72153

97

48

43.9212

4.0788

16.63661

0.331229

 

1.029987

99

48

46.8236

1.1764

1.383917

0.424252

 

0.320602

 

 

 

 

 

 

 

 

 

 

 

sum squared error

71.33164

 

 

 

 

 

 

n

7

 

 

 

 

 

 

p

2

 

 

 

 

Any data set will be considered to be unusual if the corresponding DFITS value is greater  than 1.  As you can see, the data when temperature is 75 and 97 is greater than 1 here.  Therefore the conclusions drawn should be to reexamine those data points to account for the inaccuracies

Regression Tutorials Menu  STATS @ MTSU   Dictionary