學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Analysis ToolPak in Excel and VBA
內容大綱
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.
學習目標
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.