Question

Pat.#	Before	After
1	195	125	IN EXCEL To the left is 2 datasets measured for a sample of 107 patients with high colestrol level before and after taking medication. Obatin 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 probabilty 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

1) MEAN:

The mean is the average of all numbers and is sometimes called the arithmetic mean. To calculate mean, add together all of the numbers in a set and then divide the sum by the total count of numbers.

Excel function used is "=AVERAGE(select array of values of each variables)"

MEDIAN:

The statistical median is the middle number in a sequence of numbers. To find the median, organize each number in order by size; If the number of observations is odd, the median is the middle value and if the number of number of observations is even, the median is the mean of middle two values.

Excel function used is "=MEDIAN(select array of values of each variables)"

MODE:

The mode is the number that occurs most often within a set of values.

Excel function used is "=MODE(select array of values of each variables)"

TABLE OF VALUES:

2) STANDARD DEVIATION:

The standard deviation is the square root of the arithmetic mean of the squares of deviations of observations from their mean value. It is generally denoted by .

Excel function used is "=STDEV(select array of values of each variables)"

VARIANCE:

Variance is the square of standard deviation.

Excel function used is "=VAR(select array of values of each variables)"

TABLE OF VALUES:

3) FIRST QUARTILE:

The first quartile, denoted by Q₁ , is the median of the lower half of the data set. This means that about 25% of the numbers in the data set lie below Q₁ and about 75% lie above Q₁ .

Excel function used is "=QUARTILE(select array of values of each variables,1)"

Here 1 specifies first quartile.

SECOND QUARTILE (MEDIAN):

The median is the midpoint value of a data set, where the values are arranged in ascending or descending order denoted by Q₂.This means that about 50% of the numbers in the data set lie below Q₂ and about 50% lie above Q₂ .

Excel function used is "=QUARTILE(select array of values of each variables,2)"

Here 2 specifies second quartile.

THIRD QUARTILE:

The third quartile, denoted by Q₃ , is the median of the upper half of the data set. This means that about 75% of the numbers in the data set lie below Q₃ and about 25% lie above Q₃.

Excel function used is "=QUARTILE(select array of values of each variables,3)"

Here 3 specifies third quartile.

TABLE OF VALUES:

PLOTS:

1) HISTOGRAM AND FREQUENCY DISTRIBUTION:

For After:

For Before:

3) STEM AND LEAF DIAGRAM FOR FIRST 30 VALUES OF AFTER:

First get the maximum and minimum values of the sample using excel function "=MAX(array of values)" and "=MIN(array of values)". In our data minimum value is 112 and maximum value is 212. Check the first two digits and form the stem and last digits will be the leaves. So stem values lies from 11 to 21. And then form the leaves by filling up the last digit of each sample values. Hence we get the stem and leaf plot.