Question

Pat.#	Before	After
1	195	125	To the left is 2 datasets measured for a sample of 107 patients with the high cholesterol level before and after taking medication. Obtain the following for both sets:
2	208	164
3	254	152		1- the mean, mode and median
4	226	144
5	290	212		2- the variance and standard deviation
6	239	171
7	216	164		3- First, second and third quartiles
8	286	200
9	243	190
10	217	130	Also, Draw the following diagrams for both datasets:
11	245	170
12	257	182		1- Histogram and probability distribution
13	199	153
14	277	204		2- Box and whesker diagram in one graph
15	249	174
16	197	160		3- the Stem and Leaf diagram for the first 30 values of the "After" dataset
17	279	205
18	226	159
19	262	170
20	231	180
21	234	161
22	170	139
23	242	159
24	186	114
25	223	134
26	220	166
27	277	170
28	235	136
29	216	134
30	197	138
31	253	181
32	209	147
33	245	164
34	217	159
35	187	139
36	265	171
37	221	191
38	245	164
39	250	162
40	266	180
41	240	161
42	218	168
43	278	200
44	185	139
45	280	207
46	278	200
47	223	134
48	205	133
49	285	161
50	314	203
51	235	152
52	248	198
53	291	193
54	231	158
55	208	148
56	263	203
57	205	156
58	230	161
59	250	150
60	209	181
61	269	186
62	261	164
63	255	164
64	275	195
65	239	169
66	298	177
67	265	217
68	220	191
69	196	129
70	177	142
71	211	138
72	244	166
73	205	151
74	298	163
75	305	171
76	262	129
77	320	191
78	271	167
79	195	158
80	345	192
81	223	117
82	220	114
83	279	181
84	252	167
85	246	158
86	304	190
87	292	177
88	276	148
89	250	169
90	236	185
91	256	172
92	269	188
93	235	172
94	184	151
95	253	156
96	352	219
97	266	186
98	321	206
99	233	173
100	224	109
101	274	109
102	222	136
103	194	131
104	293	228
105	262	211
106	306	192
107	239	174

Answer 1

Formuals to find the above informations:

Mean "=AVERAGE(B2:B108)"

Mode    "=MODE(B2:B108)"

Median "=MEDIAN(B2:B108)"

Variance "=VAR(B2:B108)"

Standard deviation "=STDEV(B2:B108)"

First Quartile "=QUARTILE(B2:B108,1)"

Third Quartile "=QUARTILE(B2:B108,3)"

Histogram - Before:

1. First bring "before" data set in to excel..

2. Create bin value for the entire data set..

3. go to Data tab--> choose data analysis --> choose Histogram Statistics

Output:

Histogram chart looks like probability of distribution is skewed.

Histogram - After:

select the histogram chart and goto design tab--> choose quick layout tab--> choose layout 8. It will change the histogram has probability distribution histogram.

Histogram chart looks like probability of distribution is skewed.

Box and Whisker:

1. First prepare 5 number summary for the data set.

2. Next prepare Box-1 hidden, lower and upepr values from 5 number summary output.

3. prepare whisker top and bottom from boxplot output.

step-by-step procedure:

Formuals used to 5 number summary, boxplot and whisket data

1. Select Box1-hidden,lower and upper value and insert stacked column chart. After creating stacked column chart, select the chart and choose"switch row/column" option to make entire columns in the single row.

2. next, select the top of the bar and goto "design" tab and choose "add chart element"--> error bars--> more error bars

3. "you an see "format error bar option" in the left hand side. where you have to choose "Plus" option and click custom in the bottom and add positive number as whisker top value.

4. Next select bottom of the bar and add error bar. Next choose minus in the format error bar and in the custom value choose negat number as whisker bottom value.

Boxplot and Whisker for After:

3- the Stem and Leaf diagram for the first 30 values of the "After" dataset