Question

universitypnesidunPs S alory 93 .000 , Noa ,000) ,aws, oco, 525,000, a calculoute The fine numbec Suumman vauixs iden htt any C) Draw n colified-boxplot by hand and not compue plearek

Answer 1

a) calculate five number summary

In the five number summary , calculate minimum value of the range , maximum range, and quartile 1,2 and 3

copy university presidents salary in excel

b) lower and upper fense and outliers

First we need to find inter quartile range from 5 number summary. so that we can find outliers. IQR is nothing but Q3 minus Q1

calculation formula has updated for min fence(lower) and max fense(upper).

outliers are below values of lower fense and above value of upper fenses.

outliers :

97,000

169,000

265,000

c) boxplot:

we have to find box1 hidden, lower and upper five number summary

hidden value is Q1 value from summary, lower value is Q2-Q1, upper value is Q3-Q2

refer above snap of formula sheet

1. select box1,box2, box3 value and create a bar chart.

2. select a chart and go to design tab and choose "switch row/ column" option to make single bar chart.

3, select top of the bar and go to "add chart element " option choose "error bars" --> " more error bars"

4. choose "plus" and choose custom and add whisker top value

5 choose bottom bar in the chart and choose negative and add whisker bottom value