Create bar graph using 2 different colors to represent the male and female categories

Statistics Create bar graph using 2 different colors to represent the male and female categories. Use age to categorize and graph the average height. Create pie to represent the age bracket of participants Compare males and females Cholesterol levels. Support results by including all measures of contral tendencies and measures of dispersion that have been covered.


Age	height	weight	waist	pulse	systolic	diastolic	Cholestoral	BMI	Leg	elbow	wrist	arm
12	63.3	156.3	81.4	64	104	41	89	27.5	41	6.8	5.5	33
16	57	100.7	68.7	64	106	64	2	21.9	33.8	5.6	4.6	26.4
17	64.3	114.8	67.2	76	104	61	264	19.6	41.6	6	4.6	23.6
18	61.8	123.9	72.7	88	92	46	920	22.8	39.7	5.8	5	26.5
19	64.8	105.4	72.9	76	112	62	44	17.7	39.1	5.7	4.8	23.7
19	63.1	136.1	85	68	107	48	8	24	40.3	6.6	5.1	28.4
22	60.7	124.3	75.5	64	97	64	325	23.8	38.2	5.9	5	27
23	66.7	182.4	85.7	72	116	62	112	28.9	48.6	7.2	5.6	34
23	64.7	108.8	74.5	72	98	61	62	18.3	43.4	6.2	5.2	24.7
23	62.7	147.8	79.5	72	95	59	301	26.5	39	6.3	4.9	31
23	61.3	112.9	69.1	72	108	72	223	21.2	36.6	5.9	4.7	27
24	62.6	106.7	70	76	106	59	237	19.2	38.1	6.1	5	23.6
25	62.3	107.8	66.7	88	102	65	267	19.6	39	5.7	4.6	26.3
25	59.8	111.7	73.6	80	108	61	126	22	38.7	5.7	5.1	27.9
27	59.6	127.1	82.6	72	94	58	98	25.2	36.2	5.5	4.8	29.2
27	65.1	119	74.5	68	100	53	98	19.8	41.5	6.3	5.3	27
29	63.6	123.1	75.4	68	101	66	62	21.4	43.2	6	4.9	26.4
29	68	135.5	75.9	88	119	81	271	20.7	39	6.3	4.9	27.8
31	66.7	188.3	100.7	80	89	56	175	29.9	42.3	6.6	5.2	34.4
31	63.4	130	74.5	60	113	66	123	22.8	40.2	5.9	5.1	27
32	66.4	149.3	82.5	72	99	64	181	23.8	42.8	6.7	5.5	26.3
32	61.4	110.2	67.7	68	93	61	130	20.6	37.3	6.3	5	26.5
32	64.1	179.9	95.5	76	107	67	596	30.9	39.2	6.2	5	32.8
34	60.5	135	85.7	60	125	73	149	26	39.9	6.4	5.2	30.9
36	63.2	124.2	78.8	80	104	73	146	21.9	38.5	5.6	4.7	25.5
37	60.6	149.9	98	76	110	70	173	28.7	38	7	5.1	34.3
37	65	141.4	92.8	72	124	85	149	23.5	37.5	6.1	4.8	27.9
40	66.8	238.4	126	96	181	102	462	37.7	33.2	7	5.4	35.2
40	58.6	94.3	67.8	80	118	82	94	19.3	32.1	5.4	4.2	23.3
41	67.9	218.8	99.4	68	123	72	531	33.5	43.8	7.8	5.8	38.6
41	64.3	174.1	92.8	64	107	67	125	29.7	38.2	6.8	4.7	33.1
45	61.9	161.9	94	72	127	74	447	29.8	40	6.8	5	35
45	60.2	159.7	99.3	104	133	83	280	31	31.1	6.4	5.2	35.6
47	58.2	195.6	105.5	88	114	79	293	40.6	27	7.5	5.5	41.2
48	67	130.4	68.6	124	93	64	207	20.5	41.6	6	5.3	23
52	67.6	162.8	91.1	88	113	75	254	25.1	39.4	7.1	5.3	31.8
55	62.3	160.1	93	60	114	76	384	29.1	40.2	6.2	5	32.6
56	63.4	181.2	105.5	80	116	71	318	31.7	38.2	6.9	5.4	39.6
57	63.4	255.9	126.5	80	155	85	600	44.9	41	8	5.6	43.8
59	63.5	163.1	104.7	76	105	69	309	28.5	36	6.7	5.1	34.4
Women data

Age	height	weight	waist	pulse	systolic	diastolic	Cholestoral	BMI	Leg	elbow	wrist	arm
17	63	156.3	86.7	96	109	65	78	27.8	44.2	7.1	5.3	31.7
17	71	237.1	108.7	64	125	76	272	33.1	45.2	8.3	6.6	41.1
18	62.9	151.8	85	68	95	58	762	27	38	7.4	5.8	32.8
18	65.6	164.7	91.1	60	118	68	113	26.9	41.1	7	6.1	34.5
20	68.3	175.2	89.1	76	137	85	121	26.4	42.1	7.5	5.5	32
20	69.7	137.4	75.2	88	112	44	139	19.9	44.8	6.9	5.6	25.9
20	65.4	164.2	87.7	72	121	65	638	27.1	40.9	7	5.6	33.7
20	66.3	151	79.9	72	115	65	172	24.2	44	7.1	5.4	30.7
22	66.2	144.2	78.1	64	107	54	127	23.2	40.2	7.6	6.2	31
25	67.6	151.3	75.6	64	119	81	265	23.3	41	7	5.7	30.6
26	68.5	144.1	79.6	64	110	70	303	21.6	41	6.8	5.7	31
26	68	173.3	98.9	88	116	81	1252	26.4	42.9	6.7	5.8	31.3
28	67.6	152.6	87.1	64	110	66	230	23.5	40	7.1	6	30.1
28	68	161.9	86.9	60	131	69	957	24.6	40.5	7.3	5.7	32.9
28	71.9	174.8	88	56	109	64	339	23.8	44.2	7.8	6	30.9
29	68	209.4	105.5	60	113	82	273	31.9	39.8	6.9	6	34.2
29	70	162.4	77	56	116	64	613	23.4	43.1	7.5	5.2	30.3
31	68.7	175.8	87.7	72	110	68	49	26.2	42.8	7.5	5.9	33.4
32	71.7	179.3	96.5	88	126	81	740	24.6	44.4	7.3	5.8	32.7
32	66.3	166.1	91.3	84	132	81	138	26.6	39	7.5	5.7	31.2
33	68.3	204.6	103.8	60	110	66	690	30.9	46	7.4	6.1	36.2
33	73	198	93.1	84	132	74	702	26.2	48.2	7.8	6	33.6
34	63.7	119.5	75.7	56	125	77	277	20.7	42.6	6.6	5.3	26.9
36	70.3	137.1	81.6	64	112	77	176	19.6	40.8	7.1	5.3	27.9
37	66.1	169.8	91.5	84	112	79	416	27.4	41.8	7	6.1	34
40	72.4	213.3	102.9	72	127	72	120	28.7	47.2	7.5	5.9	34.8
41	66.5	135	78.8	60	113	71	590	21.5	43.4	6.5	5.2	27.6
41	61.3	176.7	104	84	131	80	972	33.2	40.2	6.7	5.7	33.1
42	71.1	189.1	95	56	120	83	649	26.3	44.9	7.4	6	36.9
44	68.3	170.1	94.9	64	115	75	656	25.6	44.5	7.3	5.8	32.1
46	69.2	166.8	92.4	72	107	83	316	24.5	47.3	7.1	5.8	30.5
52	73.1	191.1	91.8	56	112	77	250	25.2	48.4	8	5.2	34.7
52	76.2	220.6	103	76	121	75	75	26.7	46.2	7.9	6	32.2
53	69.2	172.9	97.1	60	124	79	189	25.5	42.7	6.6	5.9	31.9
53	68.7	214.5	107.5	56	125	84	288	32.1	42.8	8.2	5.9	37.6
54	65.6	139	82.5	60	110	71	578	22.7	36	6.9	5.5	29.3
55	69.4	193.8	103	68	125	82	31	28.3	41.4	7.2	6	33.6
56	67.2	201.5	103.3	88	126	72	466	31.4	40.1	7.5	5.6	38
58	70.8	169.1	90.6	68	125	78	522	23.8	42.5	7.7	6.4	31.9
73	68.3	186.6	103.3	72	153	87	265	28.1	36.7	8.1	6.7	30.7

10 years ago

Report issue

Create bar graph using 2 different colors to represent the male and female categories

NOT RATED

Purchase the answer to view it

womens_and_mens_data.xls

Create bar graph using 2 different colors to represent the male and female categories

Tutor Faith Only

Statistics Create bar graph using 2 different colors to represent the male and female categories ...