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. 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). 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. It is used by most of the data scientists who require the understanding of statistical concepts and behaviour of the data. You can perform statistical analysis with the help of Excel. By Harshita Srivastava on Febru, UPDATED ON June 6, 2018, in Advanced Excel Functions and Formulas, Basic Excel Functions and Formulas
