SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components

F

f1guru

#1
Help, our company is new to having to do any type of spc but a new customer is requesting spc on some parts we are doing for them, does anyone have any excel spreadsheet formula for a sample size of 40 components that i can have a look at.......:notme:
 
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Leader
Admin
#2
Re: spc

Welcome to the cove!

I did a search in the Post Attachments List (see the green button in the header) using "SPC" key word, and was returned this list to look through.

To see some similar discussions you can view their links near the bottom of this page.

I hope this helps!
 

Miner

Forum Moderator
Leader
Admin
#4
Re: SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 componen

Is there a particular reason why you would want to create a rational subgroup that large?

While subgroup sizes this large are possible, rational subgroups of this size are very rare. SPC beginners often err by creating non-rational subgroups that are too large.
 
F

f1guru

#5
Re: SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 componen

Yes our customer had requested that spc has to be done on the first batch of 40 components so this is what we have had to do!! Thanks for the posts i used one was on a earlier post:cool: its our first foray into aerospace work (which will hopefully be our last) so having to do this stuff is a nightmare bring back motor racing!!!
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#6
Re: SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 componen

Help, our company is new to having to do any type of spc but a new customer is requesting spc on some parts we are doing for them, does anyone have any excel spreadsheet formula for a sample size of 40 components that i can have a look at.......:notme:
What kind of process are you trying to implement SPC on?
 
F

f1guru

#7
Re: SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 componen

they want it on diameters, surface finish and perpendicularity
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#8
Re: SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 componen

they want it on diameters, surface finish and perpendicularity
Are these precision machined diameters? If so, you would use the X hi/lo-R chart and sample 1 part at a frequency determined by your capability study. A sample of 40 parts would be meaningless, and an X-bar R chart would be a waste. It may be OK if you are not precision machining - such as drilling.

Now, unless your perpendicularity and surface finish are horrible, you also have a beta distribution on those characteristics - that is, non-normal. This is from the physical limit of 0 (perfectly smooth, perfectly perpendicular.) Again, it is difficult to understand why you would want a 40 pc sample for those characteristics. On these you might try a X-bar R chart. The only thing is the "mean" will not be centered.
 

Bev D

Heretical Statistician
Leader
Super Moderator
#9
Re: SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 componen

f1guru: Can you clarify what you mean by "SPC on the first batch of 40 pieces"? this is strange even for aerospace companies, UNLESS the pieces are very large and they are looking for 'short run SPC' within the batch. perhaps they are looking for a capability study accompanied by a Gage R&R?

I assume you are measuring all 40 pieces after they are manufactured? or in-process?
 
Thread starter Similar threads Forum Replies Date
J Properly understanding SPC - Newbie SPC questions Statistical Analysis Tools, Techniques and SPC 34
N SPC charts, simple xls sheets and free software - Need newbie information Statistical Analysis Tools, Techniques and SPC 5
J Best Practices for Choosing In-process Inspection Dimensions & SPC Dimensions Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
PQ Systems 10 Ways to Improve Your SPC System Using SQCpack Software 0
S Process Monitoring using SPC software Quality Assurance and Compliance Software Tools and Solutions 6
B Wrong standard deviation calculation in AIAG SPC manual? Capability, Accuracy and Stability - Processes, Machines, etc. 13
K Sr Process Engineer (Hillsboro, OR) - SPC Program Focused - Ultra Clean Technology Job Openings, Consulting and Employment Opportunities 0
D Locking Control Limits and SPC Sample Sizes (AIAG/Automotive Requirements) Six Sigma 2
D SPC procedure Statistical Analysis Tools, Techniques and SPC 5
PQ Systems Scaling Up? Don't Leave SPC Behind Using SQCpack Software 0
PQ Systems 5 Costly Mistakes to Avoid When Applying SPC Using SQCpack Software 0
J Spec Limits in SPC charts Statistical Analysis Tools, Techniques and SPC 24
G Need journal and reference of abnormal bar chart SPC Statistical Analysis Tools, Techniques and SPC 4
Q CQI-26 SPC Short Run Supplement Capability, Accuracy and Stability - Processes, Machines, etc. 1
A SPC procedure / flow chart Statistical Analysis Tools, Techniques and SPC 2
P Informational SPC in Batch Processing Statistical Analysis Tools, Techniques and SPC 3
B Handling lower detection limits for SPC and process performance Statistical Analysis Tools, Techniques and SPC 1
A How to reduce the process SPC monitoring Capability, Accuracy and Stability - Processes, Machines, etc. 3
P SPC for machining processes Capability, Accuracy and Stability - Processes, Machines, etc. 1
earl62 What is the best way to control special characteristics in Control plan? Is it Mandatory to have SPC for IATF 16949? IATF 16949 - Automotive Quality Systems Standard 12
J SPC - Stamping parts - Small batch size Statistical Analysis Tools, Techniques and SPC 6
T Attributes SPC study - Attributive control (Go gage) Statistical Analysis Tools, Techniques and SPC 5
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
G Assignable cause/corrective action list for SPC Software Statistical Analysis Tools, Techniques and SPC 3
H SPC for special characteristics - CSR - Control of SC and CC Statistical Analysis Tools, Techniques and SPC 1
J Determining SPC tolerance Statistical Analysis Tools, Techniques and SPC 21
L SPC - Methods to collect data IATF 16949 - Automotive Quality Systems Standard 7
Marc Steve Prevette's Statistical Process Control (SPC) "Library" Statistical Analysis Tools, Techniques and SPC 0
A SPC for Eddy Current Testing Statistical Analysis Tools, Techniques and SPC 28
S SPC (Statistical Process Control) for Unilateral Tolerance - Questions Statistical Analysis Tools, Techniques and SPC 6
Proud Liberal Informational Use of Classical SPC in Precision Machining Statistical Analysis Tools, Techniques and SPC 9
J Recommendations on Inspection/SPC Software Statistical Analysis Tools, Techniques and SPC 4
Q Real Time Electronic SPC/Control Charting Statistical Analysis Tools, Techniques and SPC 4
Rameshwar25 Other types of Control Charts described in Chapter II of SPC Manual Statistical Analysis Tools, Techniques and SPC 6
A Electric terminal crimping machines - Is SPC appropriate for this process? Manufacturing and Related Processes 4
bobdoering SPC Charting frequency calculator for X hi/lo chart Imported Legacy Blogs 0
bobdoering Handy training tip for SPC - the Check Engine Light Analogy Statistical Analysis Tools, Techniques and SPC 0
QMMike SPC Software for MAC computers Statistical Analysis Tools, Techniques and SPC 2
Marc SPC based Dashboards - By Steve Prevette (November 2017) Statistical Analysis Tools, Techniques and SPC 1
H SPC Work Instructions (WI) Statistical Analysis Tools, Techniques and SPC 2
S Doubts about SPC taken in Machining - Part has +-0.01 Tolerance Statistical Analysis Tools, Techniques and SPC 5
A Short Term vs. Long Term SPC Study - Where is Cp and Cpk Defined Statistical Analysis Tools, Techniques and SPC 8
E SPC for Dummies - The correct meaning of all the graphs Statistical Analysis Tools, Techniques and SPC 3
Tagin Can/should SPC be applied to Computer Assembly and Software Imaging? Statistical Analysis Tools, Techniques and SPC 8
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
A Not all characteristics follow a Normal Distribution - How do you do SPC Chart Capability, Accuracy and Stability - Processes, Machines, etc. 5
T SPC in Insurance Back Office Operations Service Industry Specific Topics 4
C SPC for Particulate Alert/Action Levels Statistical Analysis Tools, Techniques and SPC 3
E SPC Production - Getting Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 8
M SPC with many data points from one dimension Statistical Analysis Tools, Techniques and SPC 16

Similar threads

Top Bottom