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.

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.

Analysis Toolpac: open the Data Tab then look in Analysis group at far right
If it is missing: use Office button (that colourful circle); click Excel
Options at bottom of the resulting dialog; click Addins tab at left of next
dialog; use Mage Addins at bottom of dialog.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"phoenixs_paiste12" wrote in
message ...
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.