Calculating summary statistics in excel

[milney]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Gday there,

I have been using the word 03 for widnows. I have downloaded and paid for the new 08 version for mac.

I understand the the stat data analysis is inbuilt and I dont need to install any add-ins.

I am still wondering how to calculate the summary statistics, to tell me the mean, standard deviation, 95%, etc etc etc.

Your help is greatly valued.

Cheers

Adam.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Gday there,

I have been using the word 03 for widnows. I have downloaded and paid for the
new 08 version for mac.

I understand the the stat data analysis is inbuilt and I dont need to install
any add-ins.

I am still wondering how to calculate the summary statistics, to tell me the
mean, standard deviation, 95%, etc etc etc.

Your help is greatly valued.

Cheers

Adam.

Have you looked in Excel help for Mean, Standard Deviation, etc.? I think
you will find a lot of info there. Post back here with specific questions.

 

[milney]

the table I have been using, just with entering the cell data range contains
• Sample size (n)
• Mode
• Median
• Mean
• Range
• Variance
• Standard Deviation
• Standard Error
• 95% Confidence limits

all set out in a nice table.