Statistical analysis on windows PC, what software, Excel?

[NeoPTLD]

How do I go about doing a distribution curve of a large number of samples like:

age of high school students, with category for every age, then number of samples for each one.

Out of 2700 sample

14y/o = 720
15 y/o = 600
16 y/o = 500
17 y/o = 450
18 y/o = 400
>18 = 30

If the sample size and number of categories is small enough, it isn't bad to simply list out however many observations, it becomes impractical when the sample size is large.

Is there anyway I can tell MS Excel to properly calculate distribution, mean, median, CI, etc by entering in the form category value and sample size, instead of having to type in "14" into 720 rows and so on?

If not, what software do I need to do it?

 

[BigPoppa]

We used SPSS in my Stats course. They have a free demo or you could find it in alternative locations.

 

[Thyme]

You have two problems it seems:
1) Getting your data into a form software can understand
2) Getting stats from the data

1) Nothing I've used will out-of-the-box normalize your data like that (not to say none exists). It'd be easy to do in vba or Matlab, though.
2) Excel should be able to handle those simple measures and maybe able to make a histogram. Still, I'd recommend Matlab or Minitab.

Alternatively, if those are the only parameters you need, just do it by hand.

 

[sactoking]

Excel + StatPro is the best, easiest way to go