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

Miner

Forum Moderator
Leader
Admin
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

Miner

Forum Moderator
Leader
Admin
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

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

  • Example.xlsx
    21.5 KB · Views: 158
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
T Human Factors and Usability Testing in the US - smaller sample size than the required 15 users Human Factors and Ergonomics in Engineering 6
D Contract Review Evidence/ Sample for API Monogram Licensing Oil and Gas Industry Standards and Regulations 9
D Risk Based Sample Size and Standards Compliance ISO 14971 - Medical Device Risk Management 2
Z Design verification test sample size under the scope of first in human study submission in Europe Medical Device and FDA Regulations and Standards News 3
T Mandatory requirements for design verification sample 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 11
B Sample Size vs Number of Measurements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
T Attribute MSA-AIAG 4th How to calculate sample size IATF 16949 - Automotive Quality Systems Standard 12
H A question about Null Hypothesis for 1 Sample T-test Statistical Analysis Tools, Techniques and SPC 6
A Sample size selection for process validation - continuous data Reliability Analysis - Predictions, Testing and Standards 9
L PQ Sample Size across multiple lots Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
S Sample size considerations in medical process qualification Reliability Analysis - Predictions, Testing and Standards 11
H How to calculate sample size and sample frequency Statistical Analysis Tools, Techniques and SPC 2
K Sample size calculation for the medical device with multiple indications. e.g. suture US Food and Drug Administration (FDA) 3
R 18 different charts? 18 sample points over 28 days Capability, Accuracy and Stability - Processes, Machines, etc. 13
V Sample Size rationale to reduce size and use special levels EU Medical Device Regulations 6
C Sample qualification to be IEC 60601-1 series tested IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
Y DFMEA Sample in Semiconductor FMEA and Control Plans 2
T Cease Production Sample Procedure Manufacturing and Related Processes 1
Q Gage Pin Sets? Calibrate/Verify them all or just a sample size? General Measurement Device and Calibration Topics 22
Quality Runner Continuous monitoring of validated process – sample sizes 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
S How to determine sample size to test when the acceptance criteria is x >= Standard value? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
I Mixing tank sample points Qualification and Validation (including 21 CFR Part 11) 4
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 3
Y FMEA link to Control Plan frequency and sample size FMEA and Control Plans 20
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 12
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

Similar threads

Top Bottom