Introduction to Excel data analysis

We also have Free training videos on this site ( visit the Home page or the Training Page)

It is possible to perform Excel data analysis by simply making use of the toolkit available within the program. If you click on the Tools option in the menu bar, you should see the Excel data analysis option. If you don’t see it, it means that it is not installed. To ensure that you can use the advanced tool, click on Tools in the menu bar and select Add-ins.

Once you have selected Add-ins select the appropriate box at the top of the menu that opened. If it is still not available after you have clicked on the OK button, you will need to browse to the location where your program files are stored and then select it for installation.

Once the tool is installed you will be able to use the range of advanced functions available through the add-in. It is however, important to note that you will need to be knowledgeable in the area of statistics to fully exploit the functions.

From the Excel data analysis option you can select the function needed. The input and output range must be selected and provided. The following functions are available:

• ANOVA single factor
• ANOVA two factor with replication
• ANOVA two factor without replication
• Correlation
• Covariance
• Descriptive statistics
• Exponential smoothing
• F-test two samples for variances
• Fourier analysis
• Histogram
• Moving average
• Random number generation
• Rank and percentile
• Regression
• Sampling
• T-test options
• Z-Test option.

Browse our site training categories for help on the above functions or contact us to book a seat at one of our courses to learn more about Excel data analysis functions.