|
|
 |

18th October 2005, 07:48 PM
|
|
Inactive Registered Visitor
Registration Date: Jul 2005
Location: Salt Lake City, Utah
|
|
Posts: 4
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 18 Karma: 10 
|
|
Finding standard deviation of ranges in Minitab
I have recently been assigned the task of calculating a variety of statistics for our top 15 products. The one statistic that has me baffled is the sigma of the ranges. I can't seem to find it in Minitab. Is there a way to do this in Minitab? Thanks.
Jim Thomson
|

18th October 2005, 09:36 PM
|
 |
Forum Moderator
Registration Date: Apr 2002
Location: Wisconsin
|
|
Posts: 1,840
Thanks Given to Others: 166
Thanked 670 Times in 457 Posts
Karma Power: 251
|
|
Quote:
|
Originally Posted by Jim Thomson
I have recently been assigned the task of calculating a variety of statistics for our top 15 products. The one statistic that has me baffled is the sigma of the ranges. I can't seem to find it in Minitab. Is there a way to do this in Minitab? Thanks.
Jim Thomson
|
How do you intend to use this information?
You can brute force this information by putting each value of the subgroup in a separate column. Use the Calc by Rows function to calculate the Range and place the results in a new column. Then do statistics on that column to obtain the sigma.
However, I cannot understand why you would want this information. The Range is influenced by the subgroup size. This is why you have to use different A2, D4, d2, etc. constants based on subgroup size to calculate control limits.
|

19th October 2005, 10:31 AM
|
 |
Courtesy Access
Registration Date: Mar 2002
Location: Monterrey Mexico
Age: 47
|
|
Posts: 338
Thanks Given to Others: 21
Thanked 84 Times in 59 Posts
Karma Power: 65
|
|
Quote:
|
Originally Posted by Jim Thomson
The one statistic that has me baffled is the sigma of the ranges.
|
Maybe I don't understand but..
Setting MINITAB Options
Quote:
Methods and Standard Values
Statisticians sometimes disagree about the best methods for estimating certain parameters. Similarly, acceptable standard values (like alpha levels) may vary from person to person or company to company. Options allow you to choose your preferred test methods and parameters.
Problem: You prefer to use the average of subgroup ranges to estimate the standard deviation in n X-R chart.
Solution: Change the estimation Options setting.
|
and welcome to the cove.
__________________
Vits er thorf, theim vitha ratar; daelt er heima hvat; at augabragthi verthr, sá er ekki kann ok med snotrom sitr.
|

19th October 2005, 05:58 PM
|
|
Inactive Registered Visitor
Registration Date: Jul 2005
Location: Salt Lake City, Utah
|
|
Posts: 4
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 18 Karma: 10 
|
|
This is a customer driven requirement. I asked the same question as I have never seen this metric before.
I will probably use the "brute force" method and grind through the thousands of numbers  We have a great deal of data but it is not readily available.
Thanks for the help in this.
Jim Thomson
Quote:
|
Originally Posted by Miner
How do you intend to use this information?
You can brute force this information by putting each value of the subgroup in a separate column. Use the Calc by Rows function to calculate the Range and place the results in a new column. Then do statistics on that column to obtain the sigma.
However, I cannot understand why you would want this information. The Range is influenced by the subgroup size. This is why you have to use different A2, D4, d2, etc. constants based on subgroup size to calculate control limits.
|
|

7th May 2006, 01:37 PM
|
 |
Consultant
Registration Date: May 2005
Location: Maryland
Age: 44
|
|
Posts: 472
Thanks Given to Others: 36
Thanked 42 Times in 28 Posts
Karma Power: 43
|
|
Quote:
|
Originally Posted by Jim Thomson
This is a customer driven requirement. I asked the same question as I have never seen this metric before.
I will probably use the "brute force" method and grind through the thousands of numbers  We have a great deal of data but it is not readily available.
Thanks for the help in this.
Jim Thomson
|
General question here....if the customer asks for an invalid statistical analysis, do you do it just because they ask for it?
Can you ask the customer what does sigma of the range mean? Sounds like you are taking the variance of variances.
__________________
Steven Walfish
When in doubt, ask your company statistician!
|

8th May 2006, 08:36 AM
|
 |
Courtesy Access
Registration Date: Feb 2003
Location: Marion, IN USA
Age: 57
|
|
Posts: 514
Thanks Given to Others: 0
Thanked 20 Times in 13 Posts
Karma Power: 66
|
|
Quote:
|
Originally Posted by Jim Thomson
I have recently been assigned the task of calculating a variety of statistics for our top 15 products. The one statistic that has me baffled is the sigma of the ranges. I can't seem to find it in Minitab. Is there a way to do this in Minitab? Thanks.
Jim Thomson
|
You might want to give your customer a call and ask their intent. Because as I read this they could be asking for "the sigma of ranges [or list of numbers, instead of the statistical meaning of the word "range"]. In other words, their intent may be as simple as asking for the sigma of your actual data. Then again, maybe not - but you will not know without asking.
__________________
David D. Hartman
|
Lower Navigation Bar
|
|
|
|
Visitors Currently Viewing this Thread: 1 (0 Registered Visitors and 1 Unregistered Guests)
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate Thread Content |
Linear Mode
|
|
Posting Settings
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|