This note is an introduction to using Analysis ToolPak, a Microsoft Excel add-in software. The note describes a lot of the tools accessible in Analysis ToolPak, illustrates the steps via screenshots and offers illustration of the application'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 depicted in the note are ANOVA, correlation, descriptive statistics, F-test two-sample for variances, exponential smoothing, Fourier analysis, random numbers, histogram, moving average, random number generation, rank and percentile, regression, sampling, t-test and z-test.
PUBLICATION DATE: September 13, 2013 PRODUCT #: W13395-HCB-ENG
This is just an excerpt. This case is about LEADERSHIP & MANAGING PEOPLE
Related Case Solutions & Analyses:
NovoCure Ltd.
Quietly Brilliant: Transformational Change at HTC
Gravity Payments: $70,000 Minimum Salary Company
Aktiva Buys Yaco: A Case Study Of Market Manipulation With Options
Founder-CEO Succession at Acer
MacAfee Building Supply: Improving Performance Across Retail Stores (C)
UFIDA (B)
3i Group plc
A Note on Ethical Decision-Making
Leading by Leveraging Culture
