Lean Strategies International
Menu

Glossary

Would you like to add a term to the community? Click Here!

Standard Deviation

10/5/2022

0 Comments

 
Standard Deviation
Click on the Picture to Visit our Training Page.
  The standard deviation is a statistic that tells you how tight or loose the range/spread of data is in relation to the mean or average of the data.  Typically when a data range is clustered tightly the "bell curve" will be tall/steep.  When the data is range is spread far apart the "bell" will appear flat or short and wide.  
Example of Spread:
Standard Deviation
As you can see here; A low standard deviation shows the cluster very close to the mean. The higher the standard deviation the more the values spread apart from the mean.
How to Calculate Standard Deviation:
  1. Compute the process average.
  2. Subtract the process average from each data value.
  3. Square each deviation that you calculated in step 2.
  4. Add all the squared deviations from the third step.
  5. Divide the result of step 4 by the sample size.
  6. Take the square root of step 5’s result.
Click Here to Subscribe to Our YouTube Channel.
Formulas in Google Sheets:
  
Remember that all formulas begin with an equal sign inside of your cell in google sheets.
  • =STDEV: calculates standard deviation for a sample. To calculate standard deviation across an entire population, use STDEVP.
  • =STDEVPA: Calculates the standard deviation based on an entire population, setting text to the value `0`.
  • =STDEVP: Calculates the standard deviation based on an entire population.
  • =STDEVA: Calculates the standard deviation based on a sample, setting text to the value `0`.
​
Ref: Google Docs Editor Help - STDEV
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.


    Glossary


    Subscribe below and receive lean, six sigma, operations, supply chain, logistics, distribution and business terms in your mailbox.

    CLICK HERE TO SUBSCRIBE

    Categories

    All
    #
    01. Add A Term
    3D
    3PL
    3P's
    5 Principles
    5S
    5 Why's
    6σ
    8 Wastes
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    VSM Shapes
    W
    X
    Y
    Z

    Archives

    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    May 2020
    April 2020
    March 2020
    November 2019
    October 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    March 2018
    February 2018
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    November 2015

Lean Strategies International LLC.
Follow Us on YouTube or Our Other Channels Below.
             ©2015-2021 Lean Strategies International LLC.  
  • Home Page
  • Services
    • Training >
      • Waste Training
      • Introduction to Lean
      • Lean Champions >
        • Lean Six Sigma White Belt
        • Lean Six Sigma Yellow Belt
      • Lean Tools You Can Use Series! >
        • The 5S System
        • The ©Gemba Methodology
        • The FISH Methodology
        • The CURE Methodology
        • Quick Changeover with REDUCE
        • Mistake Proofing and the Poka Yoke System
        • The Just in Time System
  • Lean Resources
    • Listen to The Gemba
    • Glossary
    • Lean and Six Sigma Quotes
    • Recommended Reading
    • Events
    • Masters of Lean and Six Sigma
    • Career /Jobs
  • Store
    • Workspace
  • Home Page
  • Services
    • Training >
      • Waste Training
      • Introduction to Lean
      • Lean Champions >
        • Lean Six Sigma White Belt
        • Lean Six Sigma Yellow Belt
      • Lean Tools You Can Use Series! >
        • The 5S System
        • The ©Gemba Methodology
        • The FISH Methodology
        • The CURE Methodology
        • Quick Changeover with REDUCE
        • Mistake Proofing and the Poka Yoke System
        • The Just in Time System
  • Lean Resources
    • Listen to The Gemba
    • Glossary
    • Lean and Six Sigma Quotes
    • Recommended Reading
    • Events
    • Masters of Lean and Six Sigma
    • Career /Jobs
  • Store
    • Workspace