17.3.8.1 The Two-Sample Proportion Test Dialog Box

1 Supporting Information
2 Results Log Output
3 Input Data Form
4 Proportion Test
5 Test Methods
6 Power Analysis
7 Outputs

Supporting Information

To open the Two-Sample Proportion Test dialog box:

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.