Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using results below, tabulate and interpret relevant summary statistics in the report for private employees. Summary Stats. Stepwise Calc. Mean 37.50266 Standard Error 1.724434 x
Using results below, tabulate and interpret relevant summary statistics in the report for private employees.
Summary Stats. | Stepwise Calc. | |||||||||
Mean | 37.50266 | |||||||||
Standard Error | 1.724434 | x is wage | x | |||||||
Median | 32.42105 | 4987.854 | ||||||||
Mode | 27.16667 | n is sample size | n | |||||||
Standard Deviation | 19.88714 | 133 | ||||||||
Sample Variance | 395.4984 | mean is x/n | mean | |||||||
Kurtosis | 1.503935 | 37.50266165 | ||||||||
Skewness | 1.263652 | |||||||||
Range | 97.57237 | mode is no. that appears the most | mode | |||||||
Minimum | 3.009027 | 27 | ||||||||
Maximum | 100.5814 | median position is n+1/2 | median position | |||||||
Sum | 4987.854 | 67 | ||||||||
Count | 133 | median is 67th value | median | |||||||
Largest(1) | 100.5814 | 32.42105 | ||||||||
Smallest(1) | 3.009027 | calc. variance & standard dev. | ||||||||
Confidence Level(95.0%) | 3.411101 | x | y is x - xbar | z is y^2 | ||||||
3.009027 | -34.49363465 | 1189.810832 | ||||||||
6.521739 | -30.98092265 | 959.8175685 | ||||||||
9.2 | -28.30266165 | 801.0406567 | ||||||||
10 | -27.50266165 | 756.3963981 | ||||||||
10.56 | -26.94266165 | 725.907017 | ||||||||
13.5 | -24.00266165 | 576.1277665 | ||||||||
14.58333 | -22.91933165 | 525.2957635 | ||||||||
16.26667 | -21.23599165 | 450.9673415 | ||||||||
16.42857 | -21.07409165 | 444.117339 | ||||||||
17.5 | -20.00266165 | 400.1064732 | ||||||||
18 | -19.50266165 | 380.3538116 | ||||||||
18.2 | -19.30266165 | 372.5927469 | ||||||||
18.34211 | -19.16055165 | 367.1267397 | ||||||||
19.18 | -18.32266165 | 335.7199301 | ||||||||
19.18182 | -18.32084165 | 335.6532389 | ||||||||
19.67442 | -17.82824165 | 317.8462005 | ||||||||
19.90625 | -17.59641165 | 309.6337031 | ||||||||
19.98333 | -17.51933165 | 306.9269816 | ||||||||
20 | -17.50266165 | 306.343165 | ||||||||
20.18421 | -17.31845165 | 299.9287677 | ||||||||
20.83333 | -16.66933165 | 277.8666178 | ||||||||
21 | -16.50266165 | 272.3378417 | ||||||||
21.4 | -16.10266165 | 259.2957123 | ||||||||
21.4186 | -16.08406165 | 258.6970393 | ||||||||
21.48889 | -16.01377165 | 256.4408826 | ||||||||
21.5 | -16.00266165 | 256.08518 | ||||||||
21.81818 | -15.68448165 | 246.0029648 | ||||||||
21.90476 | -15.59790165 | 243.294536 | ||||||||
22 | -15.50266165 | 240.3325184 | ||||||||
22.275 | -15.22766165 | 231.8816795 | ||||||||
22.5 | -15.00266165 | 225.0798567 | ||||||||
22.63158 | -14.87108165 | 221.1490696 | ||||||||
22.64151 | -14.86115165 | 220.8538285 | ||||||||
23.08 | -14.42266165 | 208.0131692 | ||||||||
24.56 | -12.94266165 | 167.5124907 | ||||||||
24.57143 | -12.93123165 | 167.2167521 | ||||||||
24.95 | -12.55266165 | 157.5693146 | ||||||||
25 | -12.50266165 | 156.3165484 | ||||||||
25.56667 | -11.93599165 | 142.4678968 | ||||||||
25.66667 | -11.83599165 | 140.0906984 | ||||||||
26 | -11.50266165 | 132.3112251 | ||||||||
26.24 | -11.26266165 | 126.8475475 | ||||||||
26.31579 | -11.18687165 | 125.1460974 | ||||||||
26.90476 | -10.59790165 | 112.3155195 | ||||||||
27.16667 | -10.33599165 | 106.8327235 | ||||||||
27.16667 | -10.33599165 | 106.8327235 | ||||||||
27.34043 | -10.16223165 | 103.2709522 | ||||||||
27.625 | -9.877661654 | 97.56819975 | ||||||||
28 | -9.502661654 | 90.30057851 | ||||||||
28 | -9.502661654 | 90.30057851 | ||||||||
28.33333 | -9.169331654 | 84.07664298 | ||||||||
28.33333 | -9.169331654 | 84.07664298 | ||||||||
28.62 | -8.882661654 | 78.90167806 | ||||||||
28.775 | -8.727661654 | 76.17207795 | ||||||||
28.85 | -8.652661654 | 74.8685537 | ||||||||
28.92105 | -8.581611654 | 73.64405858 | ||||||||
29.08333 | -8.419331654 | 70.8851455 | ||||||||
29.30909 | -8.193571654 | 67.13461645 | ||||||||
29.69767 | -7.804991654 | 60.91789472 | ||||||||
31 | -6.502661654 | 42.28460859 | ||||||||
31.11111 | -6.391551654 | 40.85193255 | ||||||||
31.125 | -6.377661654 | 40.67456817 | ||||||||
31.2093 | -6.293361654 | 39.60640091 | ||||||||
31.42857 | -6.074091654 | 36.89458942 | ||||||||
31.66667 | -5.835991654 | 34.05879859 | ||||||||
32.34375 | -5.158911654 | 26.61436946 | ||||||||
32.42105 | -5.081611654 | 25.822777 | ||||||||
32.5 | -5.002661654 | 25.02662363 | ||||||||
33.18605 | -4.316611654 | 18.63313617 | ||||||||
33.33333 | -4.169331654 | 17.38332644 | ||||||||
33.4 | -4.102661654 | 16.83183265 | ||||||||
34.375 | -3.127661654 | 9.782267423 | ||||||||
34.87273 | -2.629931654 | 6.916540505 | ||||||||
34.92 | -2.582661654 | 6.67014122 | ||||||||
37.09302 | -0.4096416541 | 0.1678062848 | ||||||||
37.44737 | -0.05529165414 | 0.003057167017 | ||||||||
37.5 | -0.002661654135 | 0.000007084402736 | ||||||||
37.6 | 0.09733834586 | 0.009474753576 | ||||||||
38.15789 | 0.6552283459 | 0.4293241852 | ||||||||
38.35 | 0.8473383459 | 0.7179822724 | ||||||||
38.35 | 0.8473383459 | 0.7179822724 | ||||||||
38.46154 | 0.9588783459 | 0.9194476822 | ||||||||
38.8 | 1.297338346 | 1.683086784 | ||||||||
38.85185 | 1.349188346 | 1.820309193 | ||||||||
39 | 1.497338346 | 2.242022122 | ||||||||
39.5 | 1.997338346 | 3.989360468 | ||||||||
39.85 | 2.347338346 | 5.50999731 | ||||||||
39.95 | 2.447338346 | 5.989464979 | ||||||||
40 | -979.5144563 | 959448.57 | ||||||||
40.04546 | 2.542798346 | 6.465823428 | ||||||||
41.66667 | 4.164008346 | 17.3389655 | ||||||||
41.83636 | 4.333698346 | 18.78094135 | ||||||||
42.44186 | 4.939198346 | 24.3956803 | ||||||||
42.51351 | 5.010848346 | 25.10860115 | ||||||||
43.02222 | 5.519558346 | 30.46552433 | ||||||||
43.15 | 5.647338346 | 31.89243039 | ||||||||
43.16 | 5.657338346 | 32.00547716 | ||||||||
43.34286 | 5.840198346 | 34.10791672 | ||||||||
43.85965 | 6.356988346 | 40.41130083 | ||||||||
44.6 | 7.097338346 | 50.3722116 | ||||||||
44.75555 | 7.252888346 | 52.60438936 | ||||||||
44.86666 | 7.363998346 | 54.22847164 | ||||||||
46.02 | 8.517338346 | 72.5450525 | ||||||||
46.02 | 8.517338346 | 72.5450525 | ||||||||
46.42105 | 8.918388346 | 79.53765069 | ||||||||
47.95 | 10.44733835 | 109.1468785 | ||||||||
48.075 | 10.57233835 | 111.7743381 | ||||||||
48.2 | 10.69733835 | 114.4330477 | ||||||||
48.9 | 11.39733835 | 129.8993214 | ||||||||
49.02222 | 11.51955835 | 132.7002245 | ||||||||
50.92857 | 13.42590835 | 180.2550149 | ||||||||
52.94 | 15.43733835 | 238.3114152 | ||||||||
56.25 | 18.74733835 | 351.4626951 | ||||||||
56.4 | 18.89733835 | 357.1093966 | ||||||||
57.525 | 20.02233835 | 400.8940328 | ||||||||
61.38 | 23.87733835 | 570.1272865 | ||||||||
61.5 | 23.99733835 | 575.8722477 | ||||||||
61.72093 | 24.21826835 | 586.5245217 | ||||||||
68.94736 | 31.44469835 | 988.7690541 | ||||||||
70 | 32.49733835 | 1056.077 | ||||||||
70.21277 | 32.71010835 | 1069.951188 | ||||||||
70.83334 | 33.33067835 | 1110.934119 | ||||||||
73.1 | 35.59733835 | 1267.170497 | ||||||||
73.64 | 36.13733835 | 1305.907223 | ||||||||
78.26 | 40.75733835 | 1661.160629 | ||||||||
79.68571 | 42.18304835 | 1779.409568 | ||||||||
79.88889 | 42.38622835 | 1796.592353 | ||||||||
80 | 42.49733835 | 1806.023766 | ||||||||
87.5 | 49.99733835 | 2499.733842 | ||||||||
91.17647 | 53.67380835 | 2880.877702 | ||||||||
100 | 62.49733835 | 3905.9173 | ||||||||
100 | 62.49733835 | 3905.9173 | ||||||||
100.5814 | 63.07873835 | 3978.927231 | ||||||||
sum | ||||||||||
4987.853956 | -982.0118386 | 1011648.126 | ||||||||
variance is (x - xbar)^2/n - 1 | n - 1 | |||||||||
132 | ||||||||||
(x-xbar)^2 is what we hv calc. previously as z | ||||||||||
so variance is | ||||||||||
7664.000958 | ||||||||||
standard dev. is sqrt of variance | so standard dev. is | |||||||||
87.54427998 | ||||||||||
range is max - min value | so range is | |||||||||
97.572373 | ||||||||||
quartile calc. | ||||||||||
Q1 position is 1/4 (n+1) | Q1 position | |||||||||
33.5 | ||||||||||
then Q1 is 33th + 34th value/2 | Q1 | |||||||||
22.860755 | ||||||||||
Q2 = median = 32.42105 | ||||||||||
Q3 position is 3/4 (n+1) | Q3 position | |||||||||
100.5 | ||||||||||
then Q3 is 100th + 101th value/2 | Q3 | |||||||||
44.677775 | ||||||||||
interquartile is Q3 - Q1 | interquartile | |||||||||
21.81702 | ||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started