Question: 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
Get step-by-step solutions from verified subject matter experts
