Question

W74) Please answer in detail with EXCEL Function since I am learning in EXCEL function

Tests with Chi-Square distribution

1.    Variance

              A random sample of the number of games played by individual NBA scoring leaders is shown below and reproduced in the Excel answer workbook. If a sports analyst argues that this sample variance is no different from 40 at α = .05, is she correct? Assume, of course, that the number of games played variable is normally distributed.   Use the P-value method. (Round to 4 digits.) In your answer, as you’ll see in the Excel worksheet, you’re to identify the hypotheses, chi-square test statistic, and p-value, compute those values from the data set, and type in the correct conclusion.

(Hint: this is a two-tailed test. So compute the P/2 value corresponding to the Chi-square test statistic and compare it with α/2. Which tail of the Chi-square distribution to use? Compare your computed sample variance with the hypothesized population variance. If (n-1) s² / σ² > (n-3), use right tail; if less, use left tail.)

              88         86         80         74         82        

              79         82         78         60         75

2.   

              A university administrator found that 60% of all students view courses as very useful, 20% as somewhat useful, and 20% as worthless. Of a random sample of 100 students taking business courses, 68 found the course in question very useful; 18, somewhat useful; and 14, worthless. Test the null hypothesis that the population distribution for business courses is the same as that for all courses at a 10% level of significance.   In your answer, as usual, identify the hypotheses, compute the chi-square test statistic and p-value, and type in the correct conclusion.

Answer 1