cancel
Showing results for
Show  only  | Search instead for
Did you mean:
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
Level III

## Within standard deviation formula

Hi, can anyone help me ideally in excel to show me how Within sigma was calculated, I am able to get only Overall

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Within standard deviation formula

Actually, the picture you posted is using a moving range to estimate the within standard deviation.  The MR uses a surrogate subgroup size of 2 (previous-current).  You will need the average MR.

estimated standard deviation = MR-bar/d2

"All models are wrong, some are useful" G.E.P. Box
6 REPLIES 6
Super User

## Re: Within standard deviation formula

Hi @MichaH : Hopefully this answers your question.

Level III

## Re: Within standard deviation formula

Hi,

I have subgroup size of 1, so not cleaver much...

Super User

## Re: Within standard deviation formula

Actually, the picture you posted is using a moving range to estimate the within standard deviation.  The MR uses a surrogate subgroup size of 2 (previous-current).  You will need the average MR.

estimated standard deviation = MR-bar/d2

"All models are wrong, some are useful" G.E.P. Box
Level III

## Re: Within standard deviation formula

Hi,

stunning evening. Finally I got it and able to replicate by manual calculation. You saved my day. Thank you a lot.

Michal

Super User

## Re: Within standard deviation formula

Why do you need to do this in Excel?

Jim
Level III

## Re: Within standard deviation formula

Hi Jim,

because I need to understand the mechanism behind to explain others