each column is a sample drawn from a different population (A, B, C or D). Determ
ID: 3242031 • Letter: E
Question
each column is a sample drawn from a different population (A, B, C or D). Determine a distribution consistent with each set of sample data, and provide all of the parameters of that distribution. (Show in excel)
560.4655 4.918859 20.94859 0.419428 544.991 0.491128 30.95293 0.359651 429.2184 4.757746 17.12933 0.275521 584.8015 4.868083 28.84488 0.411781 472.4478 1.454391 23.63152 0.33666 572.9316 3.251356 23.52303 0.15879 456.1499 8.122948 41.13305 0.324477 558.6903 24.19354 21.40928 0.146353 505.8051 4.119852 27.087 0.458752 466.586 6.707708 30.00816 0.187805 540.7949 13.07231 19.40909 0.3572 576.7306 2.767327 19.15459 0.32274 570.3594 4.323671 19.03946 0.214116 479.898 0.104773 37.49786 0.323826 507.8373 2.090879 33.01997 0.508886 501.7484 8.040531 25.4021 0.103088 528.8928 0.388383 28.90438 0.068054 439.9528 1.865061 36.34781 0.479079 491.4038 3.532398 43.19272 0.129356 546.2428 27.68543 28.90924 0.435942 522.8102 1.487542 21.7847 0.188287 536.4581 0.063567 27.31335 0.264735 505.2801 8.569506 24.2612 0.331884 458.9122 8.810032 23.43705 0.298215 534.3921 16.71986 23.06084 0.382908 556.5937 3.754929 18.48847 0.1306 490.914 1.308234 17.82898 0.33883 387.1789 2.664343 16.57102 0.314641 447.2765 0.692288 47.12638 0.345603 522.2762 16.15185 22.66562 0.310402 545.2103 1.449256 25.9501 0.304952 454.8829 4.085165 27.846 0.308804 483.6462 10.21049 28.69519 0.21845 529.6159 6.901372 30.70326 0.246781 465.3006 1.440636 29.06029 0.253199 469.7965 10.56115 31.57961 0.298332 435.8827 2.752488 22.32241 0.189229 576.5788 4.634763 22.70332 0.438698 553.7775 2.150943 16.15151 0.363581 460.4294 2.890062 14.53983 0.303034 552.9569 1.511067 29.16074 0.503804 621.2309 3.149725 27.27474 0.407953 462.6184 5.216381 21.57347 0.307321 519.9584 9.356777 21.20924 0.199513 527.0715 0.171523 11.26499 0.33845 531.2001 2.326663 14.34067 0.306605 545.5943 0.136525 17.86244 0.401081 496.6441 3.421756 34.01673 0.372049 472.0776 1.826474 24.95201 0.264648 387.0156 0.301262 25.22913 0.359729 513.5758 0.635305 21.84901 0.310244 503.9449 1.556117 23.73725 0.311577 485.2547 0.393071 21.94332 0.338977 514.0176 0.67292 41.42769 0.08287 553.3553 11.25798 35.90209 0.11937 462.3292 2.270286 26.6461 0.297459 468.7548 0.062941 24.01916 0.167406 489.6474 2.048286 25.90331 0.150223 519.0472 6.22263 27.15423 0.468634 532.3421 13.21424 34.90501 0.256784 438.109 10.68328 23.3909 0.134447 464.9998 2.082248 26.64735 0.215941 447.0661 14.78989 23.84871 0.248342 567.1383 2.316534 15.45833 0.037573 503.7932 1.375301 15.69124 0.545274 470.3294 7.073501 24.75193 0.351953 399.3073 25.11412 29.48825 0.134067 518.7042 7.420351 33.93789 0.44965 553.8396 0.192223 34.12987 0.144405 526.4486 0.10008 28.68671 0.183549 454.0208 0.254028 31.63502 0.165249 467.1866 0.503724 18.3154 0.318654 517.1415 2.48903 22.16331 0.219143 543.3828 0.862554 27.8675 0.325987 536.2535 4.031874 27.69991 0.158429 550.9785 0.292539 25.01798 0.179251 553.6997 1.045474 25.96132 0.121325 488.3586 12.58597 25.53175 0.306869 515.1802 3.520927 32.37926 0.297607 513.1048 1.263743 46.23084 0.344381 517.2305 7.269803 14.62631 0.30561 518.5269 4.033891 17.61454 0.363651 590.47 10.68991 27.52788 0.505851 478.9377 26.23871 25.04592 0.293076 504.6711 1.830269 22.72358 0.286807 462.151 2.838727 46.37649 0.20001 458.7598 2.499121 23.69578 0.559877 554.3699 2.173573 25.46013 0.094472 465.6017 6.266764 31.7997 0.296511 427.4827 9.836197 20.13683 0.290007 500.6129 5.863025 15.10754 0.165753 499.0139 4.667953 23.05867 0.159075 367.2572 1.894768 25.09401 0.260585 518.3076 5.963123 24.88473 0.279737 472.1358 3.40905 33.22413 0.16548 568.2603 0.798424 18.36375 0.249578 463.5614 0.73118 19.39286 0.309533 566.0763 7.984586 28.57105 0.141365 530.7794 8.566764 14.82382 0.298921Explanation / Answer
each column is a sample drawn from a different population (A, B, C or D). Determine a distribution consistent with each set of sample data, and provide all of the parameters of that distribution.
There are four populations with 99 observatons each.
We can find descriptive statistics for these datasets.
We can find descriptive statistics in EXCEL.
steps :
ENTER data into EXCEL sheet --> Data --> Data Analysis --> Descriptive statistics --> ok --> Input Range : select all the data --> Grouped by : columns --> click labels in first row --> Output Range : select one empty cell --> click on summary statistics --> ok
The output will give you all the parameters of the datasets.
c1 c2 c3 c4 Mean 504.2933949 Mean 5.165252606 Mean 25.80168323 Mean 0.282074364 Standard Error 4.868955102 Standard Error 0.583306643 Standard Error 0.735232059 Standard Error 0.0113583 Median 507.8373 Median 3.149725 Median 25.04592 Median 0.298215 Mode #N/A Mode #N/A Mode #N/A Mode #N/A Standard Deviation 48.44549159 Standard Deviation 5.803827821 Standard Deviation 7.315466618 Standard Deviation 0.113013657 Sample Variance 2346.965655 Sample Variance 33.68441737 Sample Variance 53.51605184 Sample Variance 0.012772087 Kurtosis 0.007797065 Kurtosis 4.710855639 Kurtosis 0.846741911 Kurtosis -0.30967611 Skewness -0.343326336 Skewness 2.067679053 Skewness 0.765891597 Skewness 0.177587277 Range 253.9737 Range 27.622489 Range 35.86139 Range 0.522304 Minimum 367.2572 Minimum 0.062941 Minimum 11.26499 Minimum 0.037573 Maximum 621.2309 Maximum 27.68543 Maximum 47.12638 Maximum 0.559877 Sum 49925.0461 Sum 511.360008 Sum 2554.36664 Sum 27.925362 Count 99 Count 99 Count 99 Count 99Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.