How to get the Standard Deviation in Excel?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
Standard Deviation for population & sample?
Posted by:
Owais Akber
06-February-2017

=STDEV(select the range) (Put this formula in an Excel Sheet and select the range of cells where you want to apply it. You will get the deviation.

Microsoft Excel

Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/09/23

Upvote (9) Views (7) Followers (4) Answers (3) Report Question

Write an Answer
Register now or log in to answer.

3 Answers

by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Please participate and answer this question.

Downvote Reply () Report

by Mohamed Hemdan , Materials Control Division Head , Saudi Cement

Use this function

=Stdev(Range of Value)

Downvote Reply () Report

by adil shahid , Project Coordinator / Document Controller , CCCC (China Construction Communication Company)

Dear You may see the below and you know how to get standerd deviation in excel its very clear in the below link

http://www.psydrr.org/sullivan/rider/Sullivan-Psych-201-Std-Dev%20with%20Excel.pdf

Downvote Reply () Report

Popular Searches

Engineering Technicians Jobs Engineers Jobs Sales Executive Jobs Accountant Jobs Software Engineer Jobs

Write Your Answer

More Questions Like This

The standard deviation of project completion is?
Top Answer: B.1) a relationship of the uncertainty of critical path activities and2) an indicator of project end date ... See More

Answers (4)
Tricky question in Excel If you have a date cell, and want to make other cell contains a fixed day & month, but changeable year matches the 1st cell?
Top Answer: <p>Try this formula: ="6/4/"&YEAR(A1) </p> <p>Note: A1 should be t ... See More

Answers (14)
I have a table in excel 2010 and sum formula is not working for some rows. *my a1 b1 also pick the data from another formula. please help.
Top Answer: <h4>okey</h4> <h4>there are many ways </h4> <h4>* click File menu> ... See More

Answers (9)
What do this formula "=B4*B5" do in Excel?
Top Answer: <p>Thank you all for participation in answering this question. Yes agreed we can spend our weekend ... See More

Answers (7)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.