Calculating Weighted Standard Deviation By Formula

Asked By Catherine R Roush 10 points N/A Posted on - 10/29/2017

Hey, I have a sample data with me, but how do I calculate the weighted standard deviation? What is its formula?

• Status: Open
• Question Views: 199
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Others
• Question Tags: formula

Answered By Bubbles Jade 30 points N/A #305450

Calculating Weighted Standard Deviation By Formula

Hey there, weighted Standard deviation’s formula is

Where,

N = Number of observations,

M = Number of non-zero weights,

wi = weights

xi = observations, and

x ̅*= weighted mean

The formula for weighted mean, x ̅* is:

Use appropriate weights as per your question or data sample.

Alternatively, you can directly calculate this value using excel. Calculate weighted mean first, then (xi – x ̅*)2 in the separate column. That way, you’ll calculate it easily.

Hope this helps!

About Bubbles Jade

Questions
13

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/29/2017
• Question Category: Others