Data Analysis Toolpak--Descriptive Stats Question

[Arsenio Oloroso]

I recently fired up the data analysis toolpak to get some summary
statistics on class grades for a course I teach and discovered that
several of the figures were sample stats, not population stats.

Anyone here know how to get the toolpak to generate population statistics?

Much obliged for any leads.

Arsenio

 

[Michael R Middleton]

Arsenio Oloroso -

I recently fired up the data analysis toolpak to get some summary

statistics on class grades for a course I teach and discovered that several
of the figures were sample stats, not population stats. Anyone here know how
to get the toolpak to generate population statistics? Much obliged for any
leads. <

There isn't any way to get the Analysis ToolPak to do that. However, you can
use worksheet functions (e.g., STDEVP and VARP), or you can adjust the
ToolPak results (e.g., multiply by the appropriate power of (n-1)/n).

- Mike Middleton, www.usfca.edu/~middleton