1 and 2-Sample Poisson Rate - Confidence Level - Minitab/Excel

M

mikethepenguin

#1
Hello all I have been looking at the breakdowns.mtw file in minitab help and I have tried to calculate the 1-Sample Poisson Rate, 95% confidence interval. I just can't seem to get the same answer as minitab. Can anyone offer any help for hand calculations?

The data is below.


15, 16, 16,16, 17, 17, 17, 18, 18, 18, 18, 18, 19, 19, 19, 20, 21, 21, 21, 21,21, 21, 22, 22, 23, 23, 24, 25, 26, 26

Mean = 19.93


Variance 9.236781609
Standard deviation 3.039207398
95% confidence level (i used the t-table for this)2.045

Standard deviation/ Square root of (30) = 0.554880816

Confidence Interval (min, max)
= Mean - (2.045) * (0.5548)
=Mean + (2.045) * (0.5548)

18.79860206
21.0680646

The answers from Minitab are 18.3675, 21.5970

Can anyone help?
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Leader
Admin
#2
The mistake was in your calculation of standard deviation. You treated the data as if they were continuous. They are Poisson. Therefore the variance = mean, and the standard deviation is the square root of the mean (i.e., 4.465, not 3.039).

If you substitute 4.465 for 3.039 in your calculations, you will obtain the Minitab results.
 
M

mikethepenguin

#3
Thanks for that. Could you please show me the formula you used? I can't find it on minitab.

Having tried it on my calculator, for the lower interval I am getting 18.266 however the upper is 21.6 so I guess this is as close as I will get?
 
Last edited by a moderator:

Miner

Forum Moderator
Leader
Admin
#4
You used the correct formula. The only difference is that the standard deviation of a Poisson distribution is equal to the square root of the mean.
 
M

mikethepenguin

#6
Hi guys I am still struggling to get the answer. I have followed both suggestions but for the "Min" I am not getting the same result.

Likewise I can't even workout how they did the 2-Sample Poisson Rate... :agree1:

To save any confusion I have attached my working file.
 

Attachments

Thread starter Similar threads Forum Replies Date
I Mixing tank sample points Qualification and Validation (including 21 CFR Part 11) 3
T Sample size calculation Using Minitab Software 3
C What Theory is MIL-STD-105E Sample Size Code Letters Based on? Quality Tools, Improvement and Analysis 3
Stefan Mundt AS9100D Engineering sample purchases - Supplier not approved AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
U Determining population defect rate from sample defect rate Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
D Locking Control Limits and SPC Sample Sizes (AIAG/Automotive Requirements) Six Sigma 2
Y FMEA link to Control Plan frequency and sample size FMEA and Control Plans 19
T Noob question regarding sample size Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
S Help needed in choosing the method of calculating the minimum sample size Internal Auditing 12
P Worst case HLD sample for efficacy studies Other US Medical Device Regulations 0
D Estimate Sample Size for very rare event Using Minitab Software 1
M Summative evaluation: how many sample per participant? IEC 62366 - Medical Device Usability Engineering 5
S Determining Sample Size and Method Quality Tools, Improvement and Analysis 11
C Complaint Return Sample Size Question 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
shimonv Frequency and sample size for lot release of EtO sterilized products EU Medical Device Regulations 2
X Sample SOC2 audit report (or a redacted one) IEC 27001 - Information Security Management Systems (ISMS) 0
A Clinical assessment sample size - Medical device Class IIb implantable (93/42 directive) EU Medical Device Regulations 2
M Sample record for verification performed by importers before placing a device on the market EU Medical Device Regulations 0
P Sample Size for Distribution Simulation Testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 11
E Any sample of a full software life cycle IEC 62304 report ( any class )? IEC 62304 - Medical Device Software Life Cycle Processes 4
G Where to buy Template / sample SCSMS Manual, checklist Supply Chain Security Management Systems 1
C Stress / Challenge Conditions for Design Verification Testing to Reduce Sample Size 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 11
K How can Acceptance Number and Reject Number be larger than Sample Size on Z1.4 Table? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
P MSA - what exactly mean "system" and master sample Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
J Validation Sample Size for Tray Seal Qualification and Validation (including 21 CFR Part 11) 4
D Design Verification Sample Size vs Repeats Statistical Analysis Tools, Techniques and SPC 9
S Determining sample sizes for PQ Qualification and Validation (including 21 CFR Part 11) 4
M Minimum sample size - Guidance and statistical rationale Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
L Sample Procedure from Contract Manufacturer Prospective ISO 14971 - Medical Device Risk Management 1
D Adding a Class I to a sample box Canada Medical Device Regulations 5
P Unrealistic Packaging Validation Sample Size 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 41
M ISO 9001:2015 case study sample ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
M Sample of Nonconformity report for ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
A Sample Agreement available for Outsourcing Medical Device Design activity? ISO 13485:2016 - Medical Device Quality Management Systems 1
B Control chart and sample time Statistical Analysis Tools, Techniques and SPC 1
J Control chart for huge sample size Statistical Analysis Tools, Techniques and SPC 9
D How to list multi-product sample pack in GUDID 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
S Is there a standard for sample size during R&D phase Other ISO and International Standards and European Regulations 18
M Minitab assistant: 1-Sample % Defective Test Using Minitab Software 1
J Sample size definition in an Automotive SMT pilot lot run Misc. Quality Assurance and Business Systems Related Topics 1
T ISO 27001 sample audit report IEC 27001 - Information Security Management Systems (ISMS) 5
B IATF 16949 - Is a Deviation required for sample components in a prototype build? IATF 16949 - Automotive Quality Systems Standard 13
D Sample Calibration SOP for ISO 13485 General Measurement Device and Calibration Topics 4
T Sample of 1st Article Inspection Report wanted APQP and PPAP 3
E Correct way to certify hydrostatic testing when it is not 100% (and Sample Size) Various Other Specifications, Standards, and related Requirements 6
N Design Verification & Process Validation - Statistical sample sizes Design and Development of Products and Processes 2
B Determining sample size for device sterility Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
A In which EU countries would it be okay to use sample labels for registration? EU Medical Device Regulations 0
D Determining of sample size for 'Operational Qualification' AQL - Acceptable Quality Level 5
F Bayes Success run Theorem for sample size during OQ&PQ Qualification and Validation (including 21 CFR Part 11) 4

Similar threads

Top Bottom