The definition of Descriptive Statistics is to quick calculate Numerical descriptive statistics like Mean, Median, Mode, Standard Deviation, Range, Min, Max in Microsoft Excel 2010.
We can use this tool to analyses the run rate, scores, marks etc.
To access this tool click on Data Tab, click on Data Analysis in the Analysis group. If the Data Analysis command is not available then you need to load the Analysis Toolpak.
To load and activate the Analysis Toolpak follow below mentioned steps:-
Let’s come back on the topic, to generate the descriptive statistics, let’s take an example. We have Marks obtaining data of students in the range C2:H9, in which we want to analyses the students’ performance in terms of what is average marks, minimum marks, maximum marks etc. To analyses the marks data we use here descriptive statistics tool.
To use the descriptive statistics tool follow below given steps:-
This is how you can use descriptive statistics tool to analyses the data and save the time too.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.