# Minitab assistant: 1-Sample % Defective Test

#### magicstars

##### Registered
Hello Masters! I need your help!
Firstly, I run "1-Sample % Defective Test" to get the confidence intervals by using Minitab's Assistant - Hypothesis Tests directly.
Then, I also use excel referring the Formula B2 listed in Minitab Assistant White Paper (as attached) to compare the results.
Whatever total number tested and defectives x>0 Minitab and excel output the same confidence intervals, until I input x=0.
eg. n=30, x=0, to determine if defective<1%.
Minitab Assistant reports 90% confidence interval: 0~7.39%, and 95% confidence less than 7.39% while excel 90% confidence interval: 0~9.5%.
According to Formula B2, 7.39 should be against 90% (not 95%), and this is inconsistent with the results by another way: Stat->Basic Statistics->1-Proportion (95% upper bound).
Has anyone encountered this? Could anyone help clarify me? Many Thanks!

#### Attachments

• 422.3 KB Views: 71
• 27.3 KB Views: 75

#### magicstars

##### Registered
don't know why but should be
Whatever total number tested n and defectives x>0 Minitab and excel output the same confidence intervals, until I input x=0.

Minitab - Updating Graph with specific data points Using Minitab Software 2
Need help with analysing a survey on minitab Using Minitab Software 1
Interesting Discussion Analysis of half normal distribution in minitab Using Minitab Software 11
Batch printing reports in Minitab Using Minitab Software 3
Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 7
Number of decimals in equation calculated by MiniTab Using Minitab Software 0
Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
How to change the display of optimization plot in Minitab 18 Using Minitab Software 2
Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
Including Repeats in DoE using Minitab Using Minitab Software 5
Minitab 18: How to automate GRR Summary Table save Reliability Analysis - Predictions, Testing and Standards 1
What subcommands can be used with "Stop" in Minitab 18? Using Minitab Software 8
Minitab - Factor Analysis: Label on second series of data for Biplot Using Minitab Software 4
Which Anova dropdown to use for R&R in Minitab? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
DoE - Number of runs in Plackett-Burman (Minitab) Using Minitab Software 2
Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Generating samples from a population in Minitab Using Minitab Software 0
Random data generation in Minitab Statistical Analysis Tools, Techniques and SPC 2
DOE: High variance and small effects in Minitab Using Minitab Software 1
Informational Expanded Gage R&R Analysis using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
Rank Deficiency Error Minitab Using Minitab Software 5
Minitab 15 - Factorial Design - 3 factors: 4x3x2 - How to? Using Minitab Software 4
Capability Analysis for Packaging Seal Strength with spec. >0.1 Kgf using Minitab Using Minitab Software 6
MiniTab 17 Question-Standard Deviation Default Capability, Accuracy and Stability - Processes, Machines, etc. 5
Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
MINITAB 17 - Changing Data Using Minitab Software 3
Conjoint Analysis - Minitab 18 Statistical Analysis Tools, Techniques and SPC 2
How to make an ANOVA of a design with repeats (not replicates) in Minitab? Using Minitab Software 18
Minitab runs at different speeds on identical PCs Using Minitab Software 5
Response Surface Method to create design matrix in Minitab Using Minitab Software 5
Minitab limit definition from R & R Using Minitab Software 4
ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
Standard Deviation Selection on Control Charts - Minitab "pooled deviation" Statistical Analysis Tools, Techniques and SPC 3
P Minitab Data Analysis - Understanding if a Process is in Control or Not Using Minitab Software 2
P Basic Minitab Help - It's about Linear Regression Using Minitab Software 1
A Taguchi Minitab - Continuous Data - What should I choose as response variable? Using Minitab Software 3
K Taguchi Experiments for Factorial Design Analysis - Reliability of Minitab Results Using Minitab Software 1
G How to create a mixed OAs in Minitab Using Minitab Software 1
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
N DOE (design of experiments) in Minitab 16 Using Minitab Software 6
R How To Calculate & Print CDF and Lower Bound CDF value for some t(time) with Minitab? Using Minitab Software 1
D minitab macro to pull access query with parameters Using Minitab Software 1
B Could I combine IQ, OQ and PQ for Minitab Software Validation ? Software Quality Assurance 3
A How to calculate Mean and standard deviation without sample size in Minitab Using Minitab Software 5
Y Using Minitab's ifelse command Using Minitab Software 1
Measurement Uncertainty using Minitab Measurement Uncertainty (MU) 2