Analysis ToolPak
The Analysis Toolpak add-in for Excel includes a collection of 19 data-analysis tools designed to save steps when users develop complex statistical or engineering analyses. Users provide the data and parameters for each analysis; the tool applies the appropriate statistical or engineering macro functions, and then displays the results in a same or separate worksheet or workbook. It is mainly used for these analysis : Descriptive Statistics, Hypothesis Testing, Regression and Correlation, Time Series Forecasting.
Click on the Excel Options located at the bottom of the windows menu

Select Add–Ins option and then Click on the Go button
The Analysis Toolpak add-in for Excel includes a collection of 19 data-analysis tools designed to save steps when users develop complex statistical or engineering analyses. Users provide the data and parameters for each analysis; the tool applies the appropriate statistical or engineering macro functions, and then displays the results in a same or separate worksheet or workbook. It is mainly used for these analysis : Descriptive Statistics, Hypothesis Testing, Regression and Correlation, Time Series Forecasting.
How to Install Analysis ToolPak
Step 1:

Step 2:
At step 2, I get "eviews add-in for excel 2007" under active application add ins. Thats why I cannot install the analysis toolpack, and thats why i failed to get data analysis- how do I solve it?
ReplyDeleteRegards
meher afroze