Question

1. Calculate a correlation coefficient for body mass versus power using Excel.

2. Men versus women, what percent of subjects were in each power category?

TABLE 2. Data Table
Subject	Sex (M or F)	Weight (kg)	Power (Watts)	Rating
1	F	61.23	768.68	Fair
2	F	58.74	746.52	Fair
3	F	62.8	646.48	Fair
4	F	62.3	763.49	Fair
5	F	111.5	956.56	Good
6	M	102	1521.6	Excellent
7	M	113	1971.6	Excellent
8	F	72	600	Fair
9	M	124.7	1214.82	Excellent
10	M	95.2	982.36	Average
11	M	114	1324	Excellent
12	M	78	1599	Excellent
13	M	88	1191.44	Excellent
14	M	121.1	1780.9	Excellent
15	F	76.2	564.32	Fair
16	F	59.2	889.22	Average
17
18
Mean		87.50	1095.06

Answer 1

(1)

	X	Y	X2	Y2	XY
	61.23	768.68	3749.1129	590868.9424	47066.2764
	58.74	746.52	3450.3876	557292.1104	43850.5848
	62.8	646.48	3943.84	417936.3904	40598.944
	62.3	763.49	3881.29	582916.9801	47565.427
	111.5	956.56	12432.25	915007.0336	106656.44
	102	1521.6	10404	2315266.56	155203.2
	113	1971.6	12769	3887206.56	222790.8
	72	600	5184	360000	43200
	124.7	1214.82	15550.09	1475787.632	151488.054
	95.2	982.36	9063.04	965031.1696	93520.672
	114	1324	12996	1752976	150936
	78	1599	6084	2556801	124722
	88	1191.44	7744	1419529.274	104846.72
	121.1	1780.9	14665.21	3171604.81	215666.99
	76.2	564.32	5806.44	318457.0624	43001.184
	59.2	889.22	3504.64	790712.2084	52641.824
SUM	1399.97	17520.99	131227.3	22077393.73	1643755.116

Sxy	6918.834
Sx	23.36203
Sy	425.0607

(2) Male-50%

Female-50%