The critical values from the chi-square distribution table are important to compute the confidence interval of...

Transcribed Image Text:

The critical values from the chi-square distribution table are important to compute the confidence interval of a population variance. Use Excel to replicate the chi-square critical values table from the book. The left column should show all degrees of freedom between 1 and 120, and the top row should show levels of significance (a) as shown in the table below. Report critical values to 4 decimal places. What it should look like: vla 1 2 3 4 THE 118 0.999 0.995 0.999 0.975 0.0000 0.0000 0.0000 0.0010 0.0020 0.0100 0.0020 0.0506 0.0717 0.0243 0.2158 0.2070 0.0908 0.0243 0.0908 0.95 0.0039 0.1026 0.3518 0.4844 0.7107 0.9 0.5 0.0158 0.4549 0.2107 1.3863 0.5844 2.3660 1.0636 3.3567 0.05 0.025 0.01 3.8415 5.0239 6.6349 0.1 2.7055 4.6052 5.9915 7.3778 9.2103 6.2514 7.8147 7.7794 9.4877 11.1433 13.2767 14.8603 0.005 0.001 7.8794 10.8276 10.5966 13.8155 9.3484 11.3449 12.8382 16.2662 18.4668 89.8271 93.9183 98.7902 117.3340 138.0660 144.3537 149.9569 156.6483 161.3141 171.2171 99.7067 118.3340 139.1495 145.4607 151.0844 157.7995 162.4815 172.4177 120 77.7551 83.8516 77.7551 91.5726 95.7046 100.6236 119.3340 140.2326 146.5674 152.2114 158.9502 163.6482 173.6174 76.1550 82.1854 76.1550 76.9547 83.0182 76.9547 119 90.6996 94.8112 The critical values from the chi-square distribution table are important to compute the confidence interval of a population variance. Use Excel to replicate the chi-square critical values table from the book. The left column should show all degrees of freedom between 1 and 120, and the top row should show levels of significance (a) as shown in the table below. Report critical values to 4 decimal places. What it should look like: vla 1 2 3 4 THE 118 0.999 0.995 0.999 0.975 0.0000 0.0000 0.0000 0.0010 0.0020 0.0100 0.0020 0.0506 0.0717 0.0243 0.2158 0.2070 0.0908 0.0243 0.0908 0.95 0.0039 0.1026 0.3518 0.4844 0.7107 0.9 0.5 0.0158 0.4549 0.2107 1.3863 0.5844 2.3660 1.0636 3.3567 0.05 0.025 0.01 3.8415 5.0239 6.6349 0.1 2.7055 4.6052 5.9915 7.3778 9.2103 6.2514 7.8147 7.7794 9.4877 11.1433 13.2767 14.8603 0.005 0.001 7.8794 10.8276 10.5966 13.8155 9.3484 11.3449 12.8382 16.2662 18.4668 89.8271 93.9183 98.7902 117.3340 138.0660 144.3537 149.9569 156.6483 161.3141 171.2171 99.7067 118.3340 139.1495 145.4607 151.0844 157.7995 162.4815 172.4177 120 77.7551 83.8516 77.7551 91.5726 95.7046 100.6236 119.3340 140.2326 146.5674 152.2114 158.9502 163.6482 173.6174 76.1550 82.1854 76.1550 76.9547 83.0182 76.9547 119 90.6996 94.8112

Answer rating: 100% (QA)

Here columns represent level of significance and row represents degrees of freedom Then we can compl... View the full answer