Question

2+ Considera.sample with the following-data values: 에 41c 85c 37c 300 38c 12c 42c 44C 6t 36c 70c a.→ Compute the .Z scores forte observations-T b→ Compute the probability forthe observations-T c→Providethe re-numbersummary.for.the dataT d→ Draw and label the boxplot for the data 'value sT e.r Compute the mean, standa rddevi tion, vanance, mode, and median for the data1 Page Brea...mar

Answer 1

Question 2 answer )

a) 41,85,37,30,38,12,42,44,6,36,70.

Firat find mean and standard deviation ,

For that use command as , =AVERAGE(....) in blank select data you will get mean

and for standard deviation =STDEV(...) in blank select data values .

in excel sue command to find z-score as , =STANDARDIZE( x, mean , standard deviation)

plug the values you will get z-score . Also you cn use formula as , Z = (x - mean) / standard deviation)

b ) To find probability use command as =NORMSDIST(z score ) .. plug z-score value or select z-score values

you will get probability .

X values Z-score Probability 41 0.04059527   0.516190721 85 2.00540815 0.977540284 37 -0.1380241 0.445110691 30 -0.450608 0.326136067 38 -0.0933692 0.46280511 12 -1.254395 0.104849227 42 0.08525011 0.533968721 44 0.17455978 0.569287223 6 -1.5223241 0.06396395 36 -0.1826789 0.427524977 70 1.33558557 0.909157616

) Five number summary :

1 ) minimum , command as =MIN( ....) in blank select data

2 ) Q1 = first quartile - first quartile mean 25% data values .

=QUARTILE( array , quart) . array = given dara values , quart = 1

3) median use command as , =MEDIAN(... ) select data value in blank and hit enter .

4 ) Q3 = third quartile = 0.75

command , =QUARTILE(array , quart) , array = given data values , quart =3

5 ) maximum , =MAX( ....) in blank select data .

Minimum	6
Q1	33
Median	38
Q3	43
Maximum	85

d ) for mean , =AVERAGE ( .......)

for standard deviation , =STDEV( ........)

for variance , =VAR( .........)

For mode , =MODE ( .......)  

Fro median , =MEDIAN( ....)

For each blank select and and hit enter .

Mean	40.09091
Standard deviation	22.39399
variance	501.4909
Mode	#N/A
Median	38

Mode is not frequent value in data ,

Note : here no one value is come most frequent ( repeat ) , so here no mode .

Boxplot 33 38 43 85 16 11 16 21 26 31 36 41 46 51 56 61 66 71 76 81 86 9

**** General boxplot images *******************