Excel 2003 and Capability Studies for Dummies - Help needed!

reunalla

Involved In Discussions
#1
Hello!

I would like to ask for your help with process capability in Excel 2003. I would like to create a capability study sheet.
My company has no Minitab and only an Excel 2003. I never was good at statistics and at my last job I used Minitab for conducting a process capability analysis so I never really calculated any process capability indexes ever. And to be honest my Excel skills are not on the top either.

So I would like to create a very simple spreadsheet as a form to use during initial process studies.
n=125 and I have some characteristics that unilateral (for example retention forces) and some are bilateral (mostly dimensions).

I would like to have a template which calculates the same things that minitab does, and all I need to do is later that to change the specification and the measured data. A histogram would be nice too.

What I got so far is not good. (see the attachement) Since I do not really know how to calculate sigma and what constants do I need to use ( I finished the uni many years ago and since then I did not use anything else just Minitab which is easy but not very educating:frust:)

Could you check please what I made wrong and give me some advice?:thanx:
 

Attachments

Elsmar Forum Sponsor
D

Darius

#2
Sample Group?, did you notice that the sample is not the same used for the charts (so the charts only are for reference not to accomplish such value, sample size=30 vs sample size=125)?

and Cp =(F15-F13)/6*M14, wrong..., =(F15-F13)/(6*F18)
and so the other Cpi

and St.dev within , not that formula.
 
Last edited by a moderator:

reunalla

Involved In Discussions
#3
Hello!

Thank you for replying.

The charts are from the internet, just for reference - I would like to have the same indexes in my form as in that minitab chart (so that is an example for me :). I really like Minitab )

My samples will be/are n=125 subgroup=1.
 
D

Darius

#4
Another issue that I detected is that you sorted the data set. You shouldn't do it, SPC or Capability Studies take the data as they appear, no previous sorting is done.

I try to work with your data, according to what you said, Moving range (individuals), I reordered the data (randomized) so the analysis could be seen more "normal", because if you take sorded data the autocorrelation is high (although I checked autocorrelation and it looked low, because the big difference of the last numbers, a few outliers that I am sure that if you take them off, the autocorrelation must be higher than 85%). And your specs where too wide, so the chart bars didn't show (just one show), so I changed for academic propouses.

Don't take it as good (I didn't have time to check if it was OK, a shame you didn't give the same data set that was used for the Minitab chart), but it's a start, sorry about the sheet, I left it a little messy, I have a bussy week, and It took me two nights because I try (and accomplished) to do it without MACROS (like blind driving, a little bit difficult).

If there are any questions, I will try to explain..
 

Attachments

Last edited by a moderator:

reunalla

Involved In Discussions
#5
Hello!

Thank you Darius :thanks:and just vow...it really-really looks very nice. On the weekend I will go trough every equation and try to understand it :). I really need to freshen up my statistics skills :read:, since my company is a bit behind the world average on the software front. And I think I need to take an excel course too - I am OK with bare basics but the more advance stuff is not for me. I already have some training material on it :)

The good news is that -according to the IT guys - in the near future we will upgrade from Excel 2003 to 2013 but unfortunately no Minitab or any other statistics software...We have only a ProMSA which is unknown by me and the licence is out-of-date so I did not have a chance to try it out yet (I started at this company 3 weeks ago).

So thank you again, have a nice weekend.
 
Thread starter Similar threads Forum Replies Date
P IF formula - Excel 2003 Excel .xls Spreadsheet Templates and Tools 4
X Microsoft Excel 2003 Formula Restrictions Excel .xls Spreadsheet Templates and Tools 9
J Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
S 95% UCL - Attaching an excel for recovery study Statistical Analysis Tools, Techniques and SPC 0
T EXCEL - How do I make the cell stay blank until a date is entered in N7? Excel .xls Spreadsheet Templates and Tools 6
Ed Panek Validating Excel (XLS) formulas 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 9
J Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
I Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
M Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
G Excel report with pictures Excel .xls Spreadsheet Templates and Tools 5
A Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Y Excel Automation - Printing Word Documents from within Excel Excel .xls Spreadsheet Templates and Tools 0
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
C Excel date format from Denmark to USA Excel .xls Spreadsheet Templates and Tools 6
G ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
N Where I can find an Excel sample/template for recording Delivery Time and Cost Excel .xls Spreadsheet Templates and Tools 2
D How do I go about creating document logs and registers with the MS Excel Excel .xls Spreadsheet Templates and Tools 2
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
Q Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
B Zeiss CMM Calypso output to Excel or CSV file Help Inspection, Prints (Drawings), Testing, Sampling and Related Topics 17
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
N Gantt Chart / Time Tracker in Excel - Combining Tasks on the Same Line Excel .xls Spreadsheet Templates and Tools 2
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
Ajit Basrur MS Excel to study Correlation between Humidity & Differential Pressure Excel .xls Spreadsheet Templates and Tools 7
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
T Where can I get a PPAP workbook in Excel .xls with links? APQP and PPAP 1
L Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3

Similar threads

Top Bottom