LU7 EXCEL

Sheet1

AN EXAMINATION OF AGE AND BLOOD PRESSURE USING EXCEL STATISTICS
SUBJECT		AGE x		BLOOD PRESSURE y
A		43		128
B		43		120
C		56		135
D		66		143
E		67		141
F		70		152
MODE		43		ERROR:#N/A
MEDIAN		61		138
MEAN		57.5		136.5
GEO MEAN		56.36		136.10
				SCATTER PLOT
	CORRELATION		0.945996599

AGE 43 43 56 66 67 70 BLOOD PRESSURE 43 43 56 66 67 70 128 120 135 143 141 152

Sheet2

Sheet3