17.3.8.1 The Two-Sample Proportion Test Dialog Box

Supporting Information

To open the Two-Sample Proportion Test dialog box:

  1. With the worksheet active, click Statistics: Hypothesis Testing: Two-Sample Proportion Test...

See Also:

Results Log Output

Results Log Output

Select to output results to the Results Log.

Input Data Form

Summarized Perform the test using summary statistics that you enter into the dialog box manually.
Number of Success of Sample1
The number of observed "successes" in sample 1
Sample Size of Sample1
The total number of observations in sample 1
Number of Success of Sample2
The number of observed "successes" in sample 2
Sample Size of Sample2
The total number of observations in sample 2
Raw

Perform the test using two datasets composed of "success" or "failure" values. The datasets must contain no more than two distinct values.

Input Data Form
Specify the data ranges of sample 1 and sample 2
1st Data Range
2nd Data Range
Success
The dataset value that denotes success.
Index

Perform the test on input data consisting of one sample data column and one "grouping" column. The sample data column should be in the form of "success" or "failure" and must contain no more than two distinct values. The grouping column should contain information on the two populations of interest, indexed (by row number) to the sample data column.

Input Data Form
Specify one sample data column and one grouping column.
Group Range
Data Range
Success
The dataset value that denotes success.

Proportion Test

Test Difference The hypothetical proportion difference to be tested (generally "0").
Null Hypothesis The null hypothesis to be tested.
Alternative Hypothesis Options:
Proportion 1 - Proportion2<> Test Difference
Perform a two-tailed test of the hypothesis that Proportion1 - Proportion2 = Test Difference.
Proportion 1 - Proportion2 > Test Difference
Perform an upper-tailed test of the hypothesis that Proportion1 - Proportion2 is greater than Test Difference.
Proportion 1 - Proportion2 < Test Difference
Perform a lower-tailed test of the hypothesis that Proportion1 - Proportion2 is less than Test Difference.
Significance Level The significance level of the test.
Confidence Interval(s) Compute confidence intervals for proportion differences.
Confidence Level(s) in % Specifies the confidence levels for which the confidence intervals will be computed. This option is only available when Confidence Interval(s) is selected.

Test Methods

To learn more about test methods, see the algorithms page.

Normal Approximation Compute the p value and confidence interval in result with normal approximation normal distribution
Use pooled p for test Specify to use a pooled estimate of p for the test when Test Difference is 0
Fisher's Exact Test Compute the p value and confidence interval with the Fisher's exact test, which is based on the Binomial Test .

Power Analysis

Power Analysis check box: If checked, power will be computed for the porportion test.

Actual Power If checked, actual power will be computed
Significance Level Specify the significance level (\alpha) for power computation. This option is only available when either Actual Power or Hypothetical Power is checked.
Hypothetical Power If checked, hypothetical power will be computed.
Hypothetical Sample Size(s) Specifies the hypothetical sample size(s), for which power will be computed. This option is only available when Hypothetical Power is checked.

Outputs

Output Results Specify the output worksheet for test results