Complete the following question using EXCEL. If no EXCEL formula or equation is
ID: 3227455 • Letter: C
Question
Complete the following question using EXCEL. If no EXCEL formula or equation is given, no credit will be provided.
The Administrator data contains a sample of school administrator salaries in Ohio. Using this data, answer the questions below in the space provided.
a. Compute the following sample descriptive statistics.
b. Construct a five-number summary of this data and compute the inter-quartile range.
c. Use the IQR to determine if there are any outliers. If you find any, list them here:
d. What are the salaries at the 40th and 60th percentile? What are the percent rank of $80,000 and $100,000?
Ohio Salary 77600 76000 90700 97200 90700 101800 78700 81300 84200 97600 77500 75700 89400 84300 78700 84600 87700 103400 83800 101300 94700 69200 95400 61500 68800 78700 84600 87700 103400 83800 Ohio Salary 77600 76000 90700 97200 90700 101800 78700 81300 84200 97600 77500 75700 89400 84300 78700 84600 87700 103400 83800 101300 94700 69200 95400 61500 68800 78700 84600 87700 103400 83800Explanation / Answer
B
C
C
E
3
N
skew
=SKEW(A2:A31)
4
Mean
=AVERAGE(A2:A31)
CV
=C7/C4
5
Median
=MEDIAN(A2:A31)
6
variance
=VAR.S(A2:A31)
7
std dev
=STDEV.S(A2:A31)
8
range
=A31-A2
9
std error
=STDEV.S(A2:A31)
10
11
Min
=MIN(A2:A31)
Q1
=QUARTILE.INC(A1:A31,1)
Q2
=QUARTILE.INC(A1:A31,2)
Q3
=QUARTILE.INC(A1:A31,3)
Max
=MAX(A2:A31)
IQR
=C14-C12
Lower limit
=C12-1.5*C16
Upper limit
=C14+1.5*C16
Outliers
None
P40
=PERCENTILE.INC(A2:A31,0.4)
Rank(80000)
=PERCENTRANK.INC(A2:A31,80000,1)
P60
=PERCENTILE.INC(A2:A31,0.4)
Ranks(100000)
=PERCENTRANK.INC(A2:A31,100000,1)
Ohio Salary 61500 68800 N 30 skew -0.0934 69200 Mean 85666.66667 CV 0.12453 75700 Median 84450 76000 variance 113807126.4 77500 std dev 10668.0423 77600 range 41900 78700 std error 10668.0423 78700 78700 Min 61500 81300 Q1 78700 83800 Q2 84450 83800 Q3 93700 84200 Max 103400 84300 IQR 15000 84600 84600 Lower limit 56200 87700 Upper limit 116200 87700 Outliers None 89400 90700 P40 83800 Rank(80000) 0.3 90700 P60 87700 Ranks(100000) 0.8 94700 95400 97200 97600 101300 101800 103400 103400Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.