Calculating the 3rd Decile

[Pointedcoast78]

a. Arrange data in an array
b. Determine the:
i. Range
ii. Mode
iii. Median
c. Compute the 3rd decile


My problem is on sheet 3 of my excel file. I dont understand what my professor means by array, and 3rd decile. How do I arrange in an array and how do I find the 3rd decile?

[martindwilson]

its already in an array on sheet 3 he must mean get your raw data to look like that
i think that the 3 decile is the same as the 30% percentile
=PERCENTILE(B2:B21,0.3)

[TMS]

For an explanation: http://www.mathsisfun.com/data/percentiles.html


Regards, TMS

[newdoverman]

Entering your data into a Decile calculator at http://www.hackmath.net/en/calculator/decile

This was the result and is "roughly" equivalent to PERCENTILE(RANGE,.3) for Decile 3 but the formula is much more complicated than that from what I have found out. This site has the formula and examples: http://easycalculation.com/statistics/learn-deciles.php

Statistical file:
{2, 2, 1, 5, 6, 6, 7, 10, 10, 9, 15, 14, 12, 12, 8, 6, 6, 6, 9, 10}

1st decile: 2 (Too few data to calculate deciles)
2nd decile: 5.5
3rd decile: 6
4th decile: 6
5th decile: 7.5
6th decile: 9
7th decile: 10
8th decile: 11
9th decile: 13

Other statistical characteristics:
Average: 7.8
Minimum: 1
Maximum: 15
Variance: 14.06
Standard deviation σ=3.74966665185
Corrected sample standard deviation s=3.84707681233
Coefficient of variation calculator cV=0.49321497594
Signal-to-noise ratio calculator SNR=2.02751345515
Median: 7.5
Quartile Q1: 6
Quartile Q2: 7.5
Quartile Q3: 10
1st decile: 2 (Too few data to calculate deciles)
2nd decile: 5.5
3rd decile: 6
4th decile: 6
5th decile: 7.5
6th decile: 9
7th decile: 10
8th decile: 11
9th decile: 13
Interquartile range IQR: 4
Lower fence: 0
Upper fence: 16
Interdecile range IDR: 11
Mode: 6 - unimodal
Geometric mean: 6.55317934929
Harmonic mean: 4.84475632029
Sum: 156
Sum of absolute values: 156
Average absolute deviation: 3.1
Range: 14
Count items: 20
Sorted statistic file: {1, 2, 2, 5, 6, 6, 6, 6, 6, 7, 8, 9, 9, 10, 10, 10, 12, 12, 14, 15}