In most of the statistical surveys conducted using Microsoft Excel software, we need a few simple and useful parameters. It is useful and necessary to know the average number of numbers or Mean, the number in the middle of the sequence of numbers, or the Median, the variance representing the dispersion of the data, as well as the standard deviation, and the error, for the person who regularly analyzes the statistical data. To learn how to calculate Statistical analysis in excel follow below steps.
How to reach the goal
As we saw in previous tutorials, we enabled Data Analysis for Excel. On the Data tab at the top, click Data Analysis.
In the new window, select the Descriptive Statistics option and click OK.
Click the Input Range field and the area where you entered the numbers and statistics by clicking on the cell first and dragging to the last cell.
Click Labels in first row to add the headings in the first row.
Select the cells containing the analysis results through the Output Range field. You can also use the New Worksheet Ply and New Workbook options to insert a result on another page or in a new file.
Click Statistics Summary to get a statistical summary. Finally, click OK to close the Descriptive Statistics window and see the output.
Finally you learned How to calculate Statistical analysis in excel in a simple way.