Using Excel’s Descriptive Statistics Analysis ToolPak

Using Excel’s Descriptive Statistics Analysis ToolPak

 

Don't use plagiarized sources. Get Your Custom Essay on
Using Excel’s Descriptive Statistics Analysis ToolPak
Just from $13/Page
Order Essay

Excel’s Descriptive Statistics Analysis ToolPak allows you to find the mean, standard error, median, mode, standard deviation, sample variance, kurtosis, skewness, range, minimum, maximum, sum, count, largest number by position, smallest number by position, and the level of confidence simply by entering the numerical data.

 

On the Data tab select Data Analysis. If Data Analysis does not appear, you will need to activate the Data Analysis Toolpak.

 

  1. Click the File tab, scroll down and click on Options on the left side of the screen.
  2. On the left side of the screen, scroll down and click on Add-Ins.
  3. In the Name column select Analysis ToolPak. Then click on Go to the right of Manage Excel Add-Ins.
  4. In the box of Add-Ins Available, check the box next to Analysis ToolPak and then click OK.
  5. Go to Data tab and select Data Analysis.

 

 

Descriptive Statistics

 

  1. On a new worksheet, key your data in column A.
  2. Under the Data tab select Data Analysis. Choose Descriptive Statistics. Click on OK.
  3. For Input Range, key A2:A10 or appropriate range, or you may click your mouse on cell A2 then hold drag to highlight cells A2:A10. Your input range will vary depending on the number in your sample.
  4. Grouped by Columns should be selected.
  5. Labels in First Row should not be selected unless the column contains a label.
  6. Select Output Range. Select the text box, key in C1.

(New Worksheet Ply and New Workbook should not be selected.)

  1. Select Summary statistics.
  2. Select Confidence Level for Mean. Select the text box, key in 90%.
  3. Select Kth Largest. Select the text box, key in 2.
  4. Select Kth Smallest. Select the text box, key in 2.

 

The descriptive statistics will be computed automatically.

 

HINT:  After you get your results, cross-check the count in the output table to make sure it contains the correct number of sample items.

 

  1. Place your mouse arrow in the column heading between columns C and D. The arrow will change to a thick black plus sign. Double click your left mouse button. Column C will automatically widen to accommodate the longest description.
  2. Round the Mean and Standard Deviation to one decimal place.
  3. Round the Standard Error, Sample Variance, Kurtosis, Skewness, and Confidence Level to three decimal places.

 

 

Histograms

 

You can let Excel determine the bins or you can specify the bins as follows:

  1. Find the range by subtracting the lowest data value from the highest data value.
  2. Select the number of bins desired.
  3. Find the width by dividing the range by the number of bins and rounding up to the nearest whole number.
  4. Select a starting point (usually the lowest value or any convenient number less than the lowest value); add the width to the number taken as the starting point to get the lower limit of the next bin. Keep adding until you reach the desired number of bins.
  5. Subtract one unit from the lower limit of the second bin to get the upper limit of the first bin. Then add the width to each upper limit to get all the upper limits.
  6. Find the class boundaries by subtracting 0.5 from each lower bin limit and adding 0.5 to each upper bin limit.

 

 

Box Plots

 

In Excel, click on Insert, Charts, All Charts. Depending on your version of Excel, “Box and Whisker” might be an option.

 

If you do not see a chart template for Box & Whisker, you can create box plots by following the steps in the following article:

 

https://support.office.com/en-us/article/create-a-box-plot-10204530-8cdf-40fe-a711-2eb9785e510f

ORDER NOW »»

and taste our undisputed quality.