I need help reviewing if I did this correctly in excel. the question is to deter

Question

I need help reviewing if I did this correctly in excel. the question is to determine a distribution consistent with each set of data and provide the paramaters. Here is what I have. Please provide as much detail as possible and point me in right direction

Column A Z-score Column B Z-score Column C Z-score Column D Z-score 367.26 -2.83 0.06 -0.88 11.26 -1.99 0.04 -2.16 387.02 -2.42 0.06 -0.88 14.34 -1.57 0.07 -1.89 387.18 -2.42 0.10 -0.87 14.54 -1.54 0.08 -1.76 399.31 -2.17 0.10 -0.87 14.63 -1.53 0.09 -1.66 427.48 -1.59 0.14 -0.87 14.82 -1.50 0.10 -1.58 429.22 -1.55 0.17 -0.86 15.11 -1.46 0.12 -1.44 435.88 -1.41 0.19 -0.86 15.46 -1.41 0.12 -1.42 438.11 -1.37 0.25 -0.85 15.69 -1.38 0.13 -1.35 439.95 -1.33 0.29 -0.84 16.15 -1.32 0.13 -1.34 447.07 -1.18 0.30 -0.84 16.57 -1.26 0.13 -1.31 447.28 -1.18 0.39 -0.82 17.13 -1.19 0.13 -1.31 454.02 -1.04 0.39 -0.82 17.61 -1.12 0.14 -1.25 454.88 -1.02 0.49 -0.81 17.83 -1.09 0.14 -1.22 456.15 -0.99 0.50 -0.80 17.86 -1.09 0.15 -1.20 458.76 -0.94 0.64 -0.78 18.32 -1.02 0.15 -1.17 458.91 -0.94 0.67 -0.77 18.36 -1.02 0.16 -1.09 460.43 -0.91 0.69 -0.77 18.49 -1.00 0.16 -1.09 462.15 -0.87 0.73 -0.76 19.04 -0.92 0.16 -1.09 462.33 -0.87 0.80 -0.75 19.15 -0.91 0.17 -1.03 462.62 -0.86 0.86 -0.74 19.39 -0.88 0.17 -1.03 463.56 -0.84 1.05 -0.71 19.41 -0.87 0.17 -1.03 465.00 -0.81 1.26 -0.67 20.14 -0.77 0.17 -1.01 465.30 -0.80 1.31 -0.66 20.95 -0.66 0.18 -0.91 465.60 -0.80 1.38 -0.65 21.21 -0.63 0.18 -0.87 466.59 -0.78 1.44 -0.64 21.41 -0.60 0.19 -0.83 467.19 -0.77 1.45 -0.64 21.57 -0.58 0.19 -0.83 468.75 -0.73 1.45 -0.64 21.78 -0.55 0.19 -0.82 469.80 -0.71 1.49 -0.63 21.85 -0.54 0.20 -0.73 470.33 -0.70 1.51 -0.63 21.94 -0.53 0.20 -0.73 472.08 -0.66 1.56 -0.62 22.16 -0.50 0.21 -0.60 472.14 -0.66 1.83 -0.58 22.32 -0.48 0.22 -0.59 472.45 -0.66 1.83 -0.57 22.67 -0.43 0.22 -0.56 478.94 -0.52 1.87 -0.57 22.70 -0.42 0.22 -0.56 479.90 -0.50 1.89 -0.56 22.72 -0.42 0.25 -0.31 483.65 -0.43 2.05 -0.54 23.06 -0.37 0.25 -0.30 485.25 -0.39 2.08 -0.53 23.06 -0.37 0.25 -0.29 488.36 -0.33 2.09 -0.53 23.39 -0.33 0.25 -0.26 489.65 -0.30 2.15 -0.52 23.44 -0.32 0.26 -0.22 490.91 -0.28 2.17 -0.52 23.52 -0.31 0.26 -0.19 491.40 -0.27 2.27 -0.50 23.63 -0.30 0.26 -0.15 496.64 -0.16 2.32 -0.49 23.70 -0.29 0.26 -0.15 499.01 -0.11 2.33 -0.49 23.74 -0.28 0.28 -0.06 500.61 -0.08 2.49 -0.46 23.85 -0.27 0.28 -0.02 501.75 -0.05 2.50 -0.46 24.02 -0.24 0.29 0.04 503.79 -0.01 2.66 -0.43 24.26 -0.21 0.29 0.07 503.94 -0.01 2.75 -0.42 24.75 -0.14 0.29 0.10 504.67 0.01 2.77 -0.41 24.88 -0.13 0.30 0.13 505.28 0.02 2.84 -0.40 24.95 -0.12 0.30 0.14 505.81 0.03 2.89 -0.39 25.02 -0.11 0.30 0.14 507.84 0.07 3.15 -0.35 25.05 -0.10 0.30 0.14 513.10 0.18 3.25 -0.33 25.09 -0.10 0.30 0.14 513.58 0.19 3.41 -0.30 25.23 -0.08 0.30 0.15 514.02 0.20 3.42 -0.30 25.40 -0.05 0.30 0.19 515.18 0.22 3.52 -0.28 25.46 -0.05 0.30 0.20 517.14 0.27 3.53 -0.28 25.53 -0.04 0.31 0.21 517.23 0.27 3.75 -0.24 25.90 0.01 0.31 0.22 518.31 0.29 4.03 -0.20 25.95 0.02 0.31 0.22 518.53 0.29 4.03 -0.19 25.96 0.02 0.31 0.22 518.70 0.30 4.09 -0.19 26.65 0.12 0.31 0.24 519.05 0.30 4.12 -0.18 26.65 0.12 0.31 0.24 519.96 0.32 4.32 -0.15 27.09 0.18 0.31 0.25 522.28 0.37 4.63 -0.09 27.15 0.18 0.31 0.25 522.81 0.38 4.67 -0.09 27.27 0.20 0.31 0.26 526.45 0.46 4.76 -0.07 27.31 0.21 0.31 0.29 527.07 0.47 4.87 -0.05 27.53 0.24 0.32 0.32 528.89 0.51 4.92 -0.04 27.70 0.26 0.32 0.36 529.62 0.52 5.22 0.01 27.85 0.28 0.32 0.37 530.78 0.55 5.86 0.12 27.87 0.28 0.32 0.38 531.20 0.56 5.96 0.14 28.57 0.38 0.33 0.39 532.34 0.58 6.22 0.18 28.69 0.39 0.33 0.44 534.39 0.62 6.27 0.19 28.70 0.40 0.34 0.48 536.25 0.66 6.71 0.27 28.84 0.42 0.34 0.50 536.46 0.66 6.90 0.30 28.90 0.42 0.34 0.50 540.79 0.75 7.07 0.33 28.91 0.42 0.34 0.50 543.38 0.81 7.27 0.36 29.06 0.45 0.34 0.55 544.99 0.84 7.42 0.39 29.16 0.46 0.35 0.56 545.21 0.84 7.98 0.49 29.49 0.50 0.35 0.62 545.59 0.85 8.04 0.50 30.01 0.58 0.36 0.66 546.24 0.87 8.12 0.51 30.70 0.67 0.36 0.69 550.98 0.96 8.57 0.59 30.95 0.70 0.36 0.69 552.96 1.00 8.57 0.59 31.58 0.79 0.36 0.72 553.36 1.01 8.81 0.63 31.64 0.80 0.36 0.72 553.70 1.02 9.36 0.72 31.80 0.82 0.37 0.80 553.78 1.02 9.84 0.80 32.38 0.90 0.38 0.89 553.84 1.02 10.21 0.87 33.02 0.99 0.40 1.05 554.37 1.03 10.56 0.93 33.22 1.01 0.41 1.11 556.59 1.08 10.68 0.95 33.94 1.11 0.41 1.15 558.69 1.12 10.69 0.95 34.02 1.12 0.42 1.22 560.47 1.16 11.26 1.05 34.13 1.14 0.44 1.36 566.08 1.28 12.59 1.28 34.91 1.24 0.44 1.39 567.14 1.30 13.07 1.36 35.90 1.38 0.45 1.48 568.26 1.32 13.21 1.39 36.35 1.44 0.46 1.56 570.36 1.36 14.79 1.66 37.50 1.60 0.47 1.65 572.93 1.42 16.15 1.89 41.13 2.10 0.48 1.74 576.58 1.49 16.72 1.99 41.43 2.14 0.50 1.96 576.73 1.50 24.19 3.28 43.19 2.38 0.51 1.98 584.80 1.66 25.11 3.44 46.23 2.79 0.51 2.01 590.47 1.78 26.24 3.63 46.38 2.81 0.55 2.33 621.23 2.41 27.69 3.88 47.13 2.92 0.56 2.46 NO U Column B Column C Column D 504.293| |Mean Mean 5.1653 Mean 25.802 [Mean Standard Error 4868951 Standard Error 0.58331 Standard Error 0.7352 Standard Error 0 0114 507.837| |Median 3.1497| |Median 25.046 Median 0.2982 Mode N/A Mode Mode Standard Deviation! 48.4455 Standard Deviation! 58038 Standard Deviation! 7.3155 Standard Deviation! 0.113 SampleVariance | 2346.97| |SampleVari ance | 33.684| |Sample Variance 53.5161 1SampleVariance | 0.0128 Kurtosis 0,00781 Kurtosis 4.7109 Kurtosis 0.84671 Kurtosis -0.343331 Skewness 2.0677 |Skewness 0.7659 0.1776 253.9741 Range 27.622| |Range 35.8611 Range 0.5223 Minimum 367.257 | |Minimum 9529 |Minimum 11.265| |Minimum 0 0376 Maximum 621.231| |Maximum 27.685 Maximum 47.126 |Maximum 0.5599 49925-Sum. 511.36| |Sum 2554,41 Isum 27.925 Count 991 Count 99| |Count 99 Count 108.358| |a 0.7921 la 12.44 | | a 6.2297-13-2)/TB 0.214371 IB 01533| |B 0.48211 IB | 22 085|TbMB K

Explanation / Answer

Yes, all the parts that you have done is correct.

Only one of these distribution has outliers

i.e the chi-square distribution.

Please let me know if you want to ask anything else about this question.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.