# t-Test in Excel, F-test and z-Test Quiz

## The Data Analysis Toolpak Excel 2016 Training

### 10 Question Multiple Choice Quiz with Answers and Answer Explanations

***GO TO THE TEST ANSWER EXPLANATIONS PAGE
* Go to the t-Test in Excel, F-test and z-Test Tutorial

### t-Test in Excel, F-test and z-Test Quiz

1) Ariel has been asked to run a t-Test on samples, at the brewery where she works. She’s a little unsure of where to do this in Excel, so she asks some of her colleagues. Which of the responses below best explains the process?
a) Under the Data tab, click Data Analysis, specify Variable Ranges and Output options, select one of three t-Test types, and click OK
b) Under the Data tab, click Data Analysis, select one of three t-Test types, specify Variable Ranges and Output options, and click OK
c) Under the Analysis tab, click Data Analysis, specify Variable Ranges and Output options, select one of three t-Test types, and click OK
d) Under the Analysis tab, click Data Analysis, select one of three t-Test types, specify Variable Ranges and Output options, and click OK

2) Robert, an intern at the brewery, is tasked to run t-Tests on different samples. Ariel gives him her spreadsheets as an example to help him. Robert dutifully replaces Ariel’s sample data with the new sample data, however none of the t-Test output values change. Confused, he approaches Ariel for help. Which of the below statements best explains the situation?
a) The wizard generates static data, Robert needs to run the t-Test again to get new values.
b) Robert’s samples are from the same product, it would be unusual for the values to change, so this is normal and expected.
c) Robert has forgotten to refresh his data; he must go to the Data tab and click Refresh All.
d) None of the above.

3) Using the table pictured, which of the following is the correct syntax for generating a two-tail P value, assuming unequal variances?
a) =T.TEST(B2:B11, C2:C11, 1, 2)
b) =T.TEST(B2:B11, C2:C11, 3, 2)
c) =T.TEST(B2:B11, C2:C11, 2, 1)
d) =T.TEST(B2:B11, C2:C11, 2, 3)

4) Which of the following statements about the F-Test analysis tool are true?
a) There are 3 types of F-Test to choose from
b) While the ‘Hypothesized Mean Difference’ can be left blank, the 2 Variable Variances must contain values greater than zero.
c) F-Test outputs 3 columns and 10 rows of text
d) All of the above

5) Bertrand needs to run an F-Test on new samples. He decides to reuse an old spreadsheet, rather than starting over. He captures the new sample data and reruns the F-Test with the same values in Variable 1 Range, Variable 2 Range, and Output Range. However, when he clicks OK, a warning message appears, stating that clicking OK will overwrite data in his worksheet. Refer to his screenshot of the error. Which of the following statements explains the cause of this?
a) This is in reference to Bertrand overwriting the Variable Ranges with new sample data, he must specify different ranges.
b) Bertrand has forgotten to rename his spreadsheet; this warning is in reference to the fact that he will lose his old data. He can cancel and use Save As to give the spreadsheet a new name.
c) Running an F-Test produces 3 columns and 10 rows of data which, in the example, will overwrite his old F-Test data.
d) None of the above.

6) Edgar asks you for help running a z-Test on some data. Which of the following statements best describes the process?
a) Under the Data tab, click Data Analysis, select the z-Test, specify Variable Ranges and Output options, and click OK
b) Under the Data tab, click Data Analysis, select the z-Test, specify either the Variable Ranges or the Variable Variances (but not both) and click OK
c) Under the Data tab, click Data Analysis, select the z-Test, specify Variable Ranges, the Hypothesized Mean Difference and Output options, and click OK
d) Under the Data tab, click Data Analysis, select the z-Test, specify Variable Ranges, both Variable Variances and Output options, and click OK

7) Elroy is eager to run a z-test on his data, after reading a tutorial online, but when he goes to the Data tab on the ribbon, he can’t find the Data Analysis button. What could be the reason for Elroy’s predicament?
a) He hasn’t activated the Analysis ToolPak add-in
b) He is in the wrong tab; he should be looking under Formulas
c) He is in the wrong tab; he should be looking under Analysis
d) None of the above

8) Which of the following statements regarding the T.TEST() formula are accurate?
a) Returns the probability associated with a t-Test
b) Generates 3 columns and 14 rows of output
c) Requires Array1 and Array2 have an equal number of data points for Types 2 and 3
d) Both [a] and [c]

9) Karl has been asked to run an F-Test on samples. Unsure of where to do this in Excel, he looks for answers online but some of the results seem to give conflicting details. Which of the following best explains the process?
a) Under the Data tab, click Data Analysis, select the F-Test type, specify the Hypothesized Mean Difference and Output options, and click OK
b) Under the Data tab, click Data Analysis, select one of three F-Test types, specify Variable Ranges and Output options, and click OK
c) Under the Data tab, click Data Analysis, select the F-Test, specify Variable Ranges and Output options, and click OK
d) Under the Data tab, click Data Analysis, select one of three T-Test types, specify the Hypothesized Mean Difference and Output options, and click OK

10) Which of the following statements about the z-Test analysis tool are true?
a) There are 3 types of z-Test to choose from
b) While the ‘Hypothesized Mean Difference’ can be left blank, the 2 Variable Variances must contain values greater than zero.
c) z-Test outputs 3 columns and 10 rows of text
d) All of the above