# How to calculate Mean and standard deviation without sample size in Minitab

A

#### Artie21

Oops, i made a small error, the title was meant to say 'How to calculate Mean and standard deviation WITHOUT sample size in Minitab?

Hi everyone? How are you all?

I'm a new member and I'm running into a bit of a problem trying to figure out how to calculate the mean and standard deviation without a sample size.

I was given a problem:

A sample of 85 puppies under the age of 25 months were tested and of these 22 admitted for 'hyperactivity'. Is there sufficient evidence at a = 0.05 to show that the unknown population proportion exceeds 30%?

I've always been given the sample mean and standard deviation for a problem to calculate the test statistics in Minitab but this time, the teacher left that information out I can't use the Z-test or the T-test because there isn't enough information to compute the test, the mean and standard deviation is missing From my understanding, the Null hypothesis μ = 30% Vs Alternative hypothesis μ > 30%.

When a = 0.05 , the confidence interval would be at 95% and the Z-score/value is 1.645 to the right.

How do i compute the P-value and Z-value without the mean and standard deviation using Minitab??

How do i solve the problem at all!! Thanks and i appreciate for you help Last edited by a moderator:

#### Miner

##### Forum Moderator
Staff member
Try a 1-proportion test.

A

#### Artie21

Hi Miner, thanks for the reply I have looked into the 1-proportion test but in-order to compute the One-Sample Proportion test, i would need to input the 'number of trials' and the 'number of events' which are the values that i don't have or know.

All i got from the problem are the sample size of 85 puppies and 22 of them are Hyperactive and I need to show if the unknown population proportion exceeds 30%. I would need to use the Null Hypothesis Vs Alternative Hypothesis test - either Z-sample or T-Sample test to show the rejection region and critical value. BUT I can't run the Z-sample test or the T-sample test without the Mean and Standard Deviation of the sampled population Or should I just say there isn't enough sufficient data to compute the test?

This is why i'm asking is there anyway in Minitab that allows me to calculate the Mean and standard Deviation from the sample of '85' puppies.

#### Miner

##### Forum Moderator
Staff member
Number of trials = 85
Number of events = 22

#### Bev D

##### Heretical Statistician
Staff member
Super Moderator
Miner is correct (as always)
think about it - which is what your instructor wants you to do

A

#### Artie21

Yes, I followed Miner's advice/instruction again and got the 1-Proportion test to compute in minitab I'm not good with maths or Statistic calculations so I really appreciate your help!

Thanks guys for your time! You guys are the best!

M How to calculate MTTF (Mean Time to Failure) Reliability Analysis - Predictions, Testing and Standards 1
MTBOMF ("Mean Time Between Operation and Mission Failure") - How to Calculate Reliability Analysis - Predictions, Testing and Standards 9
M MTTR - Quick and dirty way to calculate Mean Time To Repair - Solenoid valves Statistical Analysis Tools, Techniques and SPC 6
J How do I calculate the percentage of errors, when I know min, max, mean, cp and CPK Capability, Accuracy and Stability - Processes, Machines, etc. 3
Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
How to calculate benefits? Moving some developed non controlled software/automation systems Service Industry Specific Topics 2
Calculate number of people in processes, considering cycle time/takt time = quantity of people Lean in Manufacturing and Service Industries 9
How to calculate the maximum allowable hysteresis of a pressure gauge General Measurement Device and Calibration Topics 1
How to Calculate the producer Risk AQL - Acceptable Quality Level 25
Methods to Calculate Available Production Rate ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
Why calculate LCL in P-chart? Statistical Analysis Tools, Techniques and SPC 4
How to calculate CPK with n = 1 Manufacturing and Related Processes 2
Add-On software for VMC to calculate setting time, Idle Time, OEE etc.. Manufacturing and Related Processes 2
L How to calculate the Probability of Deficiency of the AQL of an Inspection AQL - Acceptable Quality Level 16
V How to Calculate Unbiasing Constant C4 Statistical Analysis Tools, Techniques and SPC 1
J How to Calculate OEE Indicator for a Workshop (15 Machines) Lean in Manufacturing and Service Industries 6
R How to calculate UCL (Upper COntrol Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 5
I want to calculate reliability at 750 hours Reliability Analysis - Predictions, Testing and Standards 8
R How To Calculate & Print CDF and Lower Bound CDF value for some t(time) with Minitab? Using Minitab Software 1
How to calculate the Premium Freight charges Service Industry Specific Topics 4
When do I need to calculate Process OEE? Manufacturing and Related Processes 12
How to calculate Thread Pitch Diameter for non standard TPI like 5/8" 17.75 NF3 Manufacturing and Related Processes 3
C Definition and Way to Calculate some Metrics Lean in Manufacturing and Service Industries 6
M How calculate P value for Linearity and Bias using Excel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
Formula that will calculate the NoGo Major Diameter of an M20 x 1.5 6H Thread gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
M How to calculate Cg and Cgk for a 2-Dimensional Area Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
T Calculation Question - Calculate the runner weight for a part Manufacturing and Related Processes 2
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11 Excel .xls Spreadsheet Templates and Tools 6
Calculate PPMs by going back to Date of Production or Date Noticed Quality Tools, Improvement and Analysis 7
H How to calculate the Lot Reject Rate Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
L How calculate the number of samples Statistical Analysis Tools, Techniques and SPC 2
A Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
R How to calculate MMC when is placed after datum Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
S Which one is better to calculate, Cpk or Ppk? Statistical Analysis Tools, Techniques and SPC 11
C How to calculate P value on Probability Plot Statistical Analysis Tools, Techniques and SPC 1
S Supplier Disruption Score and how to calculate it Quality Tools, Improvement and Analysis 4
IAQG OASIS - New tool to calculate Audit Time AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
M How to calculate dimensions of trapezoid ? Quality Tools, Improvement and Analysis 3
How to calculate Surveillance Audit Days in Corporate Audit Scheme IATF 16949 - Automotive Quality Systems Standard 4
S How to calculate Supplier PPM at Receiving Inspection Document Control Systems, Procedures, Forms and Templates 2
How to Calculate Sample Size at 95% Confidence Interval on Surface Roughness Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
R How to calculate the value add time? Lean in Manufacturing and Service Industries 2
Should I calculate both Cp and Cpk for a Unilateral Tolerance? Statistical Analysis Tools, Techniques and SPC 8
H Continuous Monitoring Instrument Data Validation and how to calculate Outliers Quality Tools, Improvement and Analysis 1
How to calculate the Air Flow Rate in clause 201.12.4.4.105 of IEC 60601-2-16:2012 IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
A How to calculate Cpk & Ppk if the tolerance changes during the period? Capability, Accuracy and Stability - Processes, Machines, etc. 5
S PPAP - How to calculate tolerance on basic dimension APQP and PPAP 5
B Attrition Rate and the formula to calculate Attrition Rate Quality Manager and Management Related Issues 1