|
One-Sample Tests for Means dialog box |
|
Use this dialog box to carry hypothesis tests for population means based on sample statistics. It is recommended you use the t-Test (t-distribution statistics) instead of the z-Test (normal distribution statistics) when the number of items in the sample is small, typically less than 30, or when the population variance is not known.
Refer to One-Sample Tests for Population Means and to Statistical Inference, Decision Theory and Hypothesis Testing for additional information on this subject.
Input
Specifies the worksheet location of the input data for this operation.
Provides a reference to the extent of the data available in the currently active worksheet. Use this range as a guide for typing valid extents in the Input Range box.
Type in this box the range of cells containing the data you want to use as input for this command.
Check this box to indicate that the data specified by the Input Range box is organized in rows as opposed to columns (the default).
Refer to Specifying Input Arguments for additional information on this subject.
 | The input to this operation is converted to a series of samples, which are then considered individually for the test. |
Output
Specifies the worksheet location for placing the results of this operation.
Select this option to place the results of this operation in a new document workbook.
Select this option to place the results of this operation in a new worksheet.
Select this option to place the results of this operation starting at the worksheet location specified in the box to the right of this option.
Refer to Specifying Output Locations for additional information on this subject.
Options
z-Test
Choose this option to carry the hypothesis test using normal distribution statistics. It is recommended you choose this option when the number of items in the sample is relatively large, typically 30 or more, and the population variance is known.
t-Test
Choose this option to carry the hypothesis test using t-distribution statistics. It is recommended you choose this option when the number of items in the sample is small, typically less than 30, or the population variance is not known.
Type in this box the population variance corresponding to the sample specified by the Input Range box.
Type in this box the hypothetical mean for the test.
Type in this box the significance level you want to assign to the test.
z-Test Options
When the population variance is not known, the distribution of the means of independent samples will have a Student's t-distribution. However, if the size of the sample is large enough it is possible to infer from the sample variance and normal distribution statistics. Check this box if the population variance is not known, the sample is large enough and you want to carry a z-Test.
Refer to One-Sample Tests for Population Means for more information on this subject.
Closes the dialog box and carries out this operation.
Closes the dialog box without carrying out this operation.
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support