97.4k views
5 votes
Data were collected as part of a study of coffee consumption among graduate students. The following reflect cups per day consumed, 3,4,6,8,2,1,0,2. a. use the data analysis tool to compute the sample mean, standard deviation, and median. Use the QUARTILE function to compute the first and third quartiles. In a study of new antihypertensive medication, SBPs are measured at baseline (or the start of the study, before any treatment is administered). The data are as follows:

120 112 138 145 135 150 145 163

148 128 143 156 160 142 150

User Yeyene
by
7.4k points

1 Answer

6 votes

Answer:

a) =AVERAGE(3,4,6,8,2,1,0,2)

=MEDIAN(3,4,6,8,2,1,0,2)

=STDEV.S(3,4,6,8,2,1,0,2)

And we got:


\bar X= 3.25 , Median =2.5, s= 2.659

b) =QUARTILE(C1:C15,1)

=QUARTILE(C1:C15,3)

And we got:


Q_1 = 136.5, Q_3 =150

Explanation:

Part a

For this case we have the following data given:

3,4,6,8,2,1,0,2

The problem wants the mean , median and standard deviation from technology using the data anlysis toolpack, so for this case we can use the following codes on Excel:

=AVERAGE(3,4,6,8,2,1,0,2)

=MEDIAN(3,4,6,8,2,1,0,2)

=STDEV.S(3,4,6,8,2,1,0,2)

And we got:


\bar X= 3.25 , Median =2.5, s= 2.659

Part b

For this case we have the following data:

20; 112; 138 ;145; 135; 150; 145; 163; 148; 128; 143; 156; 160; 142; 150

We put the data from Cell C1 to C15 and we use the following codes:

=QUARTILE(C1:C15,1)

=QUARTILE(C1:C15,3)

And we got:


Q_1 = 136.5, Q_3 =150

User Werrf
by
7.4k points