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 test of independence.
A)z-Test: Two Sample for Means
B)t-Test: Two Sample Assuming Equal Variances
C)CHISQ.TEST
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 test of independence.
A)z-Test: Two Sample for Means 
B)t-Test: Two Sample Assuming Equal Variances 
C)CHISQ.TEST 
D)NORM.S.DIST

Quizplus · Accepted Answer

The CHISQ.TEST function is used to perform a test of independence between two categorical variables, such as age and drink preferences. The other options (z-Test and t-Test) are used for comparing means between two groups, and NORM.S.DIST is used to calculate the standard normal cumulative distribution function.

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