« Google form logic | Main | Drawing in Excel »

Analysis ToolPak in Excel

Excel has some advanced statistical analysis tools available that are NOT installed by default.  These MP900390096 tools are called the Analysis ToolPak.  This ToolPak allows the user to perform amazing things like the analysis of variance (ANOVA), correlations, covariance and make histograms.  It's hard to believe I actually knew what these things were in 1996.  Anyway, if you have any interest, these are the instructions to enable the Toolpak in Excel 2010.

  1. Open Excel
  2. Click File
  3. Click Options (beneath Help)
  4. Click Add-ins
  5. In the dropdown menu next to Manage, make sure Excel Add-ins is selected
  6. Click Go
  7. Check the box for the Analysis ToolPak
  8. Click OK

Now you can access the Analysis Toolpak by clicking the Data Analysis button on the Data tab.  On Vista/Windows 7 public stations, patrons can enable the Toolpak on a per session basis.  Thanks to the Ruth Culver Community Library for the post idea.


Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment