The 1 Proportion conducts a hypothesis test and calculates a confidence interval of the population proportion. It is a test of one binomial proportion.
| Test | Null Hypothesis, H0 | Alternate Hypothesis, H1 |
| One-tailed | p = p0 | p < p0 or p > p0 |
| Two-tailed | p = p0 | p <> p0 |
where p is the population proportion and p0 is the hypothesised value
At the Excel Menu (For Excel 2007, go to Add-ins first)
Choose ProcessMA > Statistics > Basic Statistics > 1 Proportion
For Summarized Data:
In No. of Trials, enter the number of trials (Integer, >=Successes)
In No. of Successes, enter the number of successes within the set of trials (Integer, >=0)
For Raw Data:
In Variable, select the column containing the raw data (Exactly 2 distinct values, success and failure)
In Test Proportion, enter hypothesized proportion (Numeric, >0 & <1)
In Alternate, select the appropriate alternate test
In Confidence Level, enter value for confidence level (Numeric, >0 & <1)
Click OK
A telecommunication company recently launched a new customer help service. The company conducted a customer survey to find out if customer satisfaction has improved from last year’s 68%. 860 customers were randomly selected for the survey and of which 590 were satisfied.
Open data worksheet by choosing ProcessMA > Tools > Data
Choose ProcessMA > Statistics > Basic Statistics > 1 Proportion
Click Summarized Data
In No. of Trials, enter 860
In No. of Successes, enter 590
In Test Proportion, enter 0.68
In Alternate, select Greater than
Click OK
For a desired a = 0.05, since p = 0.3519 > a, we fail to reject H0. Therefore, we conclude that there is no significant evidence that customer satisfaction has improved.
Copyright © ProcessMA