SCATTER PLOT.xlsx

	A	B	C	D	E	F	G
1	sl.no	height	weight	Gender
2	1	149	49.2	F
3	2	149	58	F
4	3	138	58	F
5	4	133	55.7	F
6	5	128	53.4	F
7	6	121.1	52.1	F
8	7	107.9	47.6	F
9	8	105.6	46.3	F
10	9	102.5	45.8	F
11	10	101.3	41.5	F
12	11	100	36.9	F
13	12	98.9	31.9	F
14	13	94.3	28.2	F
15	14	92	25.8	F
16	15	90	22.4	F
17	16	89	19.9	F
18	17	85	17.9	F	Above average of height
19	18	84	15.4	F
20	19	83.4	14.2	F
21	20	82.5	12	F
22	21	81.7	11.7	M
23	22	80	11.3	M
24	23	79.4	11	M
25	24	78.4	10.8	M
26	25	77	10.5	M
27	26	76	10	M
28	27	75.1	9.9	M
29	28	74	9.7	M
30	29	72.8	9.5	M
31	30	71.6	9.2	M
32	31	70.1	9	M
33	32	68.8	8.8	M
34	33	67.3	8.5	M
35	34	65.1	8.2	M
36	35	64.2	7.9	M
37	36	62.2	7.5	M
38	37	59.9	7	M
39	38	56.1	6.9	M
40	39	53.8	6	M
41	40	49.2	5.3	M			27.97262098
42	41	7	4.3	M
43
44
45	Mean	85.95609756	22.32195122
46	Median	81.7	81.7
47	Mode	149	58
48	STD DEV	27.97262098	27.97262098
49	Corrl	0.9014217446
50
51		Height
52		above average of height			113.9287185	7
53		below average of height			91.60676732	27
54		average			88.6024	6
55
56		weight
57		above average of weight			50.2945722	6
58		below average of weight			-5.650669759	5
59		average			22.32195	31
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100