Descriptive Statistics in Microsoft Excel 2010

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:-

  • Click the File Tab, Click options and click on Add INS Category.

img1

  • In the Manage box, select the Analysis Toolpak and then click on Go button.

img2

  • In the Add Ins dialog box select the Analysis Toolpak check box and then click Ok.
  • If Analysis Toolpak is not listed in the Add Ins available box click browse to locate it.

img3
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.
img4

To use the descriptive statistics tool follow below given steps:-

  • Go to Data Tab.
  • Click on Data Analysis in the Analyses group.

img5

  • Data Analysis dialog box will appear.

img6

  • From the Analysis tool drop down menu select descriptive statistics and click on ok.
  • You will get another descriptive statistics dialog box will appear.
  • Click on Input range. Select the range D2:H9.
  • Tick on Labels in first row to get the students name as header in the result.
  • Tick on Summary Statistics.

img7

  • New sheet will generate with the analyses points of marks.

img8

This is how you can use descriptive statistics tool to analyses the data and save the time too.

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube