<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-PHTV9K7" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to Main Content
Product cover image for Analysis ToolPak in Excel and VBA

Analysis ToolPak in Excel and VBA

Mehmet A. Begen; Wei Xia

Product #:9B13E025
Supplier:Ivey
Discipline:Information Systems
Setting:2013
Details:Note (PDF) • 22 pages • 2013-09-13

Subjects:

Regression analysisStatistical analysisTechnology and analyticsInformation systems
Your Price:$9.71

Purchase this material with a free Educator Account and enjoy more benefits:

  • Free Educator Copy
  • Free Teaching Notes
  • Build your coursepack
  • Discounted academic price

This note is an introduction to using Analysis ToolPak, a Microsoft Excel add-in program. The note describes most of the tools available in Analysis ToolPak, illustrates the steps through screenshots and provides examples of the program’s utility in Excel and Visual Basic for Applications (VBA). The note also shows how to automate use of these tools with VBA. The tools explained in the note are ANOVA, correlation, descriptive statistics, exponential smoothing, F-test two-sample for variances, Fourier analysis, random numbers, histogram, moving average, random number generation, rank and percentile, regression, sampling, t-test and z-test.

Learning Objectives

This introduction to Analysis ToolPak in Excel and with Excel VBA is intended as an introductory reading or as lecture notes in any course that teaches and/or requires the tools available in this Excel add-in program.
Loading
Note: Analysis ToolPak in Excel and VBA (English version) | Ivey Publishing