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

Tests with Chi-Square distribution

1.    Variance

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

(Hint: this is a two-tailed test. Socompute the P/2 value corresponding to the Chi-square teststatistic and compare it with α/2. Which tail ofthe Chi-square distribution to use? Compare your computed samplevariance 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

1.   

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