Feb 16, 2004 #1 shadowfein TCS Member Thread starter Alpha Cat Joined Jul 4, 2003 Messages 312 Purraise 24 Location Hampshire, United Kingdom I need help with working out 2 std dev and 3 std dev.... My brain is getting sore!
Feb 16, 2004 #2 okeefecl TCS Member Veteran Joined Apr 22, 2002 Messages 4,926 Purraise 2 Location Sparkleball ranch Do you have Excel? Put your values in a column, highlight the next cell, go to "Insert", select Function and then STDEV. That will give you one standard deviation. Simply multiply!
Do you have Excel? Put your values in a column, highlight the next cell, go to "Insert", select Function and then STDEV. That will give you one standard deviation. Simply multiply!
Feb 16, 2004 Thread Starter Thread Starter #3 shadowfein TCS Member Thread starter Alpha Cat Joined Jul 4, 2003 Messages 312 Purraise 24 Location Hampshire, United Kingdom Thanks! i just figured out what I was doing wrong. I was swapping around my calcs for Upper and lower control limits. Problem is, when I write my exam - I won't have excel - so I am trying to do everything manually. But my brain isn't really a numerate one! Thanks again.
Thanks! i just figured out what I was doing wrong. I was swapping around my calcs for Upper and lower control limits. Problem is, when I write my exam - I won't have excel - so I am trying to do everything manually. But my brain isn't really a numerate one! Thanks again.
Feb 16, 2004 #4 okeefecl TCS Member Veteran Joined Apr 22, 2002 Messages 4,926 Purraise 2 Location Sparkleball ranch Oooh, boy, manually! That's why I love Excel-it does all the hard work for me (and I'm NOT a statistician).
Oooh, boy, manually! That's why I love Excel-it does all the hard work for me (and I'm NOT a statistician).
Feb 16, 2004 Thread Starter Thread Starter #5 shadowfein TCS Member Thread starter Alpha Cat Joined Jul 4, 2003 Messages 312 Purraise 24 Location Hampshire, United Kingdom Lol. Thanks!
Feb 16, 2004 #6 auroraviva TCS Member Top Cat Joined Mar 10, 2003 Messages 2,136 Purraise 1 Location Georgia Good luck on your exam! (I am an Excel user, too . . . you're braver than I am. )