# How to Calculate Standard Deviation in Google Sheets

Viewport: 1920x951 @0.75x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Calculate Standard Deviation in Google Sheets
   - body: This walkthrough provides a detailed step-by-step guide on calculating the standard deviation of a dataset in Google Sheets. Follow these instructions to effectively perform the calculation.
   - voiceover: This guide provides a detailed walkthrough on how to calculate the standard deviation of a dataset in Google Sheets. Follow these steps to quickly and accurately find the standard deviation for your data range.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqe9yr00000cl43nr4hrtf.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the range you want
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (238.9084403057303, 184.75779584256304), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (238.9084403057303, 184.75779584256304), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: First, open your Google Sheets document. Click and drag your mouse to select the range of cells that contain the dataset for which you want to calculate the standard deviation.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqee0200020cl43ggv8elh.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8qnb0000033pm39r3ca2.png
2. step_02 [video] - Click here
   - source type: VIDEO
   - target: (1342, 93), rect: top=75.60417175292969 left=280.5 width=1754 height=1366
   - hotspots: 1
     - hotspot_01 (1342, 93), rect: top=75.60417175292969 left=280.5 width=1754 height=1366
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - clip: start=0.977 end=4.467 duration=3.4899999999999998
   - video: url=https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8mrr00010cl73y8hga89.webm speed=1 muted=true
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8mrr00010cl73y8hga89.webm
3. step_03 [image] - Click on Functions option
   - source type: IMAGE
   - description: Create a New Spreadsheet
   - target: (1383.573776131052, 65.59231612154862), rect: top=75.60417175292969 left=280.5 width=1754 height=1366
   - hotspots: 1
     - hotspot_01 (1383.573776131052, 65.59231612154862), rect: top=75.60417175292969 left=280.5 width=1754 height=1366
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Once the range is selected, go to the toolbar at the top of the screen and click on the 'Functions'  button. This is usually located next to the formula bar.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqf8x700140ckydgs5bz30.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8vz50002033paza35oqs.png
4. step_04 [image] - Click on Statistical option
   - source type: IMAGE
   - description: Enter Your Data
   - target: (1291.4880679754635, 738.7278013482228), rect: top=739.6666870117188 left=1346 width=125 height=20
   - hotspots: 1
     - hotspot_01 (1291.4880679754635, 738.7278013482228), rect: top=739.6666870117188 left=1346 width=125 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the drop-down menu that appears after clicking 'Functions', hover your mouse over the 'Statistical' category to reveal additional function options.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqee1t00040cl4c278f6wg.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8xh40003033p299bkipr.png
5. step_05 [image] - Click on STDEV formula
   - source type: IMAGE
   - description: Select the Cell for the Result
   - target: (1666.0588958047438, 536.9698657739675), rect: top=544.3333740234375 left=1539 width=237.5 height=14.666666984558105
   - hotspots: 1
     - hotspot_01 (1666.0588958047438, 536.9698657739675), rect: top=544.3333740234375 left=1539 width=237.5 height=14.666666984558105
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Within the 'Statistical' category, scroll down and click on the 'STDEV' function. This function is specifically designed to calculate the standard deviation of your selected data range.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqee3l00050cl46tht7yio.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq90g90004033p4m0ysf4c.png
6. step_06 [video] - Click here
   - source type: VIDEO
   - target: (198, 844), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (198, 844), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - clip: start=13.704 end=26.246 duration=12.541999999999998
   - video: url=https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8mrr00010cl73y8hga89.webm speed=2 muted=true
   - voiceover: Type to enter the mean value in the formula. The format is Mean value, comma, then the range
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqgujp004t0cl704uq2nmk.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq8mrr00010cl73y8hga89.webm
7. step_07 [image] - The standard deviation will be at the bottom cell
   - source type: IMAGE
   - description: Enter the Standard Deviation Formula
   - target: (257.4228058450789, 823.121684595882), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (257.4228058450789, 823.121684595882), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: The standard deviation of your dataset will automatically be calculated and displayed in the cell immediately below the selected range. You can now see the standard deviation value.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqee4j00060cl406y2dm8g.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gq9ajt0006033ptjbbp1ag.png
9. [Outro] Next Steps
   - body: After calculating the standard deviation, you may want to format the result, create charts, or perform additional statistical analyses. Explore other features in Google Sheets for more advanced data handling.
   - voiceover: You've successfully calculated the standard deviation! You can now use this value for further statistical analysis or visualization in your Google Sheets document.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gq8mq6000dl70cc2stqlec/cm6gqeccu00010cl4ebji8n1n.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6gq8mq6000dl70cc2stqlec/tour