View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default I know how to use 2003 with statistic but I'm having trouble with

While I don't know how to access the ATP Descriptive Statistics tool in 2007,
I can tell you how to calculate all of the quantities using formulas.

Mean: =AVERAGE(data)
Standard Error: =STDEV(data)/SQRT(COUNT(data))
Median: =MEDIAN(data)
Mode: =MODE(data)
Standard Deviation: =STDEV(data)
Sample Variance: =VAR(data)
Kurtosis: =KURT(data)
Skewness: =SKEW(data)
Range: =MAX(data)-MIN(data)
Minimum: =MIN(data)
Maximum: =MAX(data)
Sum: =SUM(data)
Count: =COUNT(data)

Jerry

"phoenixs_paiste12" wrote:

I know how to do Statistics tests like the T-Tests and Median tests, for the
Excel 2003 but I'm having trouble with the Excel 2007. I need to get the
median with theStandard Error, Mode, Mean, Standard Deviation, Sample
Variance, Kurtosis, Skewness, Range, etc chart for a set of data and I also
need to do a T-Test: Two sample assuming unequal variances witht he chart,
along with a Regresssion again with the charts. I can find the tests but I
must be doing something wrong cause I can't get it to give me a chart with
all the data I need! Can any one help? I would appreciate it if you can.