Data Analysis Toolpak--Descriptive Stats Question

  • Thread starter Arsenio Oloroso
  • Start date
A

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
 
M

Michael R Middleton

Arsenio Oloroso -
I recently fired up the data analysis toolpak to get some summary
Click to expand...
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
 
Top