You can perform statistical analysis with the help of Excel. It is used by most of the data scientists who require the understanding of statistical concepts and behaviour of the data.

But when the data set is huge or you need some specialized data analysis model such as linear or regression, you should go for advanced tools such as Python, R programming. Here, we will go through the basic concept of statistical analysis and will apply the concepts to our own data.īefore starting, you need to check whether Excel Analysis ToolPak is enabled in Excel or not (it is an add-in provided by Microsoft Excel). To check whether it is enabled or not, go to Excel → Data and check whether data analysis option is there or not on the top right corner. If it is not there, go to Excel → File → Options → Add-in and enable the Analysis ToolPak by selecting the Excel Add-ins option in manage tab and then, click GO. This will open a small window select the Analysis ToolPak option and enable it. Technician's Assistant: What device are you using to check your email Are you using a web browser Which one Google chrome. These are the tests you can perform using Excel Statistical Analysis. I installed the data analysis toolpak in excel, but it is not showing up on my excel sheet excel 2016. You can find descriptive analysis by going to Excel→ Data→ Data Analysis → Descriptive statistics. It is the most basic set of analysis that can be performed on any data set.

It gives you the general behaviour and pattern of the data. It is helpful when you a have a set of data and want to have the summary of that dataset. This will show the following statistic data for the chosen dataset. It is a data analysis method which shows whether the mean of two or more data set is significantly different from each other or not.

Install data analysis in excel