Minitab assistant: 1-Sample % Defective Test

#1
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 (n) 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

Elsmar Forum Sponsor
#2
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.
 
Thread starter Similar threads Forum Replies Date
Z Minitab - Updating Graph with specific data points Using Minitab Software 2
S Need help with analysing a survey on minitab Using Minitab Software 1
0 Interesting Discussion Analysis of half normal distribution in minitab Using Minitab Software 11
G Batch printing reports in Minitab Using Minitab Software 3
B Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
V Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 7
I Number of decimals in equation calculated by MiniTab Using Minitab Software 0
A Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
M How to change the display of optimization plot in Minitab 18 Using Minitab Software 2
M Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
E Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
N Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
J Including Repeats in DoE using Minitab Using Minitab Software 5
A Minitab 18: How to automate GRR Summary Table save Reliability Analysis - Predictions, Testing and Standards 1
N What subcommands can be used with "Stop" in Minitab 18? Using Minitab Software 8
S Minitab - Factor Analysis: Label on second series of data for Biplot Using Minitab Software 4
J Which Anova dropdown to use for R&R in Minitab? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
J DoE - Number of runs in Plackett-Burman (Minitab) Using Minitab Software 2
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
A Generating samples from a population in Minitab Using Minitab Software 0
Ron Rompen Random data generation in Minitab Statistical Analysis Tools, Techniques and SPC 2
I DOE: High variance and small effects in Minitab Using Minitab Software 1
B Informational Expanded Gage R&R Analysis using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
R Rank Deficiency Error Minitab Using Minitab Software 5
H Minitab 15 - Factorial Design - 3 factors: 4x3x2 - How to? Using Minitab Software 4
A Capability Analysis for Packaging Seal Strength with spec. >0.1 Kgf using Minitab Using Minitab Software 6
Coury Ferguson MiniTab 17 Question-Standard Deviation Default Capability, Accuracy and Stability - Processes, Machines, etc. 5
N Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
L MINITAB 17 - Changing Data Using Minitab Software 3
R Conjoint Analysis - Minitab 18 Statistical Analysis Tools, Techniques and SPC 2
F How to make an ANOVA of a design with repeats (not replicates) in Minitab? Using Minitab Software 18
W Definitive screening design in Minitab 17 Manufacturing and Related Processes 1
S Minitab runs at different speeds on identical PCs Using Minitab Software 5
S Response Surface Method to create design matrix in Minitab Using Minitab Software 5
S Minitab limit definition from R & R Using Minitab Software 4
G ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
S 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
B Measurement Uncertainty using Minitab Measurement Uncertainty (MU) 2

Similar threads

Top Bottom