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

M

#### mikethepenguin

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?

#### Miner

##### Forum Moderator
Staff member
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

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
Staff member
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.

#### Steve Prevette

##### Deming Disciple
Staff member
Super Moderator
Confidence Interval (min, max)
= Mean - (2.045) * sqrt(Mean)
=Mean + (2.045) * sqrt(Mean)

M

#### mikethepenguin

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...

To save any confusion I have attached my working file.

#### Attachments

• 21.5 KB Views: 149
Clinical assessment sample size - Medical device Class IIb implantable (93/42 directive) EU Medical Device Regulations 2
Sample record for verification performed by importers before placing a device on the market EU Medical Device Regulations 0
Sample Size for Distribution Simulation Testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 11
Any sample of a full software life cycle IEC 62304 report ( any class )? IEC 62304 - Medical Device Software Life Cycle Processes 1
Where to buy Template / sample SCSMS Manual, checklist Supply Chain Security Management Systems 1
Stress / Challenge Conditions for Design Verification Testing to Reduce Sample Size 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 11
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
MSA - what exactly mean "system" and master sample Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Validation Sample Size for Tray Seal Qualification and Validation (including 21 CFR Part 11) 3
Design Verification Sample Size vs Repeats Statistical Analysis Tools, Techniques and SPC 9
Determining sample sizes for PQ Qualification and Validation (including 21 CFR Part 11) 4
Minimum sample size - Guidance and statistical rationale Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Sample Procedure from Contract Manufacturer Prospective ISO 14971 - Medical Device Risk Management 1
Adding a Class I to a sample box Canada Medical Device Regulations 5
Unrealistic Packaging Validation Sample Size 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 41
ISO 9001:2015 case study sample ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
Sample of Nonconformity report for ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Sample Agreement available for Outsourcing Medical Device Design activity? ISO 13485:2016 - Medical Device Quality Management Systems 1
Control chart and sample time Statistical Analysis Tools, Techniques and SPC 1
Control chart for huge sample size Statistical Analysis Tools, Techniques and SPC 9
How to list multi-product sample pack in GUDID 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
Is there a standard for sample size during R&D phase Other ISO and International Standards and European Regulations 18
Minitab assistant: 1-Sample % Defective Test Using Minitab Software 1
Sample size definition in an Automotive SMT pilot lot run Misc. Quality Assurance and Business Systems Related Topics 1
ISO 27001 sample audit report IEC 27001 - Information Security Management Systems (ISMS) 0
IATF 16949 - Is a Deviation required for sample components in a prototype build? IATF 16949 - Automotive Quality Systems Standard 13
Sample Calibration SOP for ISO 13485 General Measurement Device and Calibration Topics 4
Sample of 1st Article Inspection Report wanted APQP and PPAP 3
Correct way to certify hydrostatic testing when it is not 100% (and Sample Size) Various Other Specifications, Standards, and related Requirements 6
Design Verification & Process Validation - Statistical sample sizes Design and Development of Products and Processes 2
Determining sample size for device sterility Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
In which EU countries would it be okay to use sample labels for registration? EU Medical Device Regulations 0
Determining of sample size for 'Operational Qualification' AQL - Acceptable Quality Level 5
Bayes Success run Theorem for sample size during OQ&PQ Qualification and Validation (including 21 CFR Part 11) 4
Identification of Test Sample in Test Reports? Design and Development of Products and Processes 22
AQL table - I need to sample 1250pcs AQL - Acceptable Quality Level 3
The correct way of doing a 2 Sample T test Reliability Analysis - Predictions, Testing and Standards 7
Device modifications - Clinical sample size rationale EU Medical Device Regulations 5
Informational How to perform a clinical evaluation of medical devices – Part 1 – Overview and sample of activities Medical Device and FDA Regulations and Standards News 0
SOP Sample for BC/ISO22301 (Business Continuity) wanted Business Continuity & Resiliency Planning (BCRP) 4
Sample size for creating a data base as a reference to a tested variable Other Medical Device and Orthopedic Related Topics 6
Medical Device Design verification sample prototype Other Medical Device and Orthopedic Related Topics 14
ISO 17025 - Please share a sample procedure for monitoring the validity of results ISO 17025 related Discussions 1
Inputs on definition of very similar processes for multi site audit sample - IAF MD1 2018 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Q Autoclave and Sample Container - Pressure-steam cooking's effect Reliability Analysis - Predictions, Testing and Standards 1
ISO 13485:2016 sample exam/test ISO 13485:2016 - Medical Device Quality Management Systems 3
M EU IVD Risk Determination of sample collection EU Medical Device Regulations 0
T Sample Size for Design Validation Design and Development of Products and Processes 4
C AS9138 Sample Size Determination AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
Small Sample - Lower Limit Probability Statistical Analysis Tools, Techniques and SPC 0