OzGrid

How to use Standard Deviation Formula in Excel

< Back to Search results

 Category: [Excel]  Demo Available 

How to use Standard Deviation Formula in Excel

 

Standard deviation :

Code:
=STDEVP(A2:E2)

 

Average :

Code:
SUMPRODUCT((A1:E1)*(A2:E2))/SUM(A2:E2)

 

 

Obtained from the OzGrid Help Forum.

Solution provided by Carim.

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

See also:

How to use VBAs Find Function
How to drag a formula to the right and skip x columns
How to pull data from a worksheet where variables are met

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


Gallery



stars (0 Reviews)