How do I average and then get a standard devation in excel

G

Guest

This is my first time using Excel, and I'm having trouble with it. I have
alot of data to calculate, and I'm trying to cut short the time to do my
calculations and these are to get a mean (average) and then a standard
deviation.
 
C

changeable

Go to Tools>Add Ins then tick Data Analysis
Go to Tools >Data analysis, Descriptive statistics...you can get al
you need
else

type =Average( "put your cell here")
type =Stdev( "put your cell here"
 
J

JulieD

Hi

sorry to butt in here, but i don't have Data Analysis under tools / add-ins
.... is it a MS product or 3rd party?

Cheers
JulieD
 
J

Jim Cone

Julie,
It is the "Analysis ToolPak" in Tools | Add-Ins that you should 'tick'.
Regards,
Jim Cone
San Francisco, CA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top