Exhibit 12-5
The table below gives beverage preferences for random samples of teens and adults. We are asked to test for independence between age (i.e., adult and teen) and drink preferences.
-Excel's ____ function is used to perform a goodness of fit test.
A)z-Test: Two Sample for Means
B)t-Test: Two Sample Assuming Equal Variances
C)CHISQ.DIST.RT
D)NORM.S.DIST

Question

Exhibit 12-5
The table below gives beverage preferences for random samples of teens and adults.  We are asked to test for independence between age (i.e., adult and teen) and drink preferences.
-Excel's ____ function is used to perform a goodness of fit test.
A)z-Test: Two Sample for Means 
B)t-Test: Two Sample Assuming Equal Variances 
C)CHISQ.DIST.RT 
D)NORM.S.DIST

Quizplus · Accepted Answer

The appropriate function to perform a goodness of fit test in Excel is the CHISQ.DIST.RT function, which calculates the right-tailed probability of the chi-square distribution. This function can be used to test for independence between two categorical variables, such as age and drink preferences. Therefore, the correct answer is C. The z-Test and t-Test functions are used to test for differences in means between two groups, which is not the case in this scenario. The NORM.S.DIST function calculates the standard normal cumulative distribution function, which is not applicable to this problem.

Exhibit 12-5 the Table Below Gives Beverage Preferences for Random Samples of Samples