Statistics · real student question

For 37 students with three assessment columns (Tugas, UAS and a second Tugas), compute the mean, median, mode, range, sample variance, standard deviation and quartiles of each column.

Question

Thirty-seven students have three recorded scores each. The columns are:

Tugas: 57, 78, 80, 83, 76, 63, 55, 56, 81, 64, 87, 85, 83, 63, 85, 90, 56, 90, 83, 60, 58, 73, 72, 0, 86, 68, 72, 62, 84, 74, 88, 0, 88, 89, 85, 55, 77

UAS: 55, 86, 76, 78, 83, 60, 70, 77, 75, 62, 86, 80, 87, 60, 81, 86, 55, 86, 73, 56, 50, 68, 81, 0, 81, 55, 80, 77, 81, 71, 92, 0, 83, 78, 80, 60, 70

TUGAS: 73, 71, 85, 84, 81, 74, 81, 80, 88, 82, 93, 84, 86, 82, 93, 90, 81, 84, 86, 80, 66, 74, 88, 32, 77, 81, 85, 86, 92, 61, 87, 32, 94, 77, 71, 63, 82

Produce a descriptive statistical analysis of each column.

Step-by-step solution

  1. Total each column and divide by n = 37. Summing carefully:

    Tugas=2606,UAS=2579,TUGAS=2906\sum \text{Tugas} = 2606, \qquad \sum \text{UAS} = 2579, \qquad \sum \text{TUGAS} = 2906

    xˉTugas=260637=70.4324,xˉUAS=257937=69.7027,xˉTUGAS=290637=78.5405\bar{x}_{\text{Tugas}} = \frac{2606}{37} = 70.4324, \quad \bar{x}_{\text{UAS}} = \frac{2579}{37} = 69.7027, \quad \bar{x}_{\text{TUGAS}} = \frac{2906}{37} = 78.5405

    The totals are worth re-adding: a single mis-keyed row shifts a mean by up to 2.42.4 points here.

  2. Find the medians. With n=37n = 37 (odd) the median is the 1919th value of the sorted list, with no averaging needed:

    MedianTugas=76,MedianUAS=77,MedianTUGAS=82\text{Median}_{\text{Tugas}} = 76, \qquad \text{Median}_{\text{UAS}} = 77, \qquad \text{Median}_{\text{TUGAS}} = 82

    Every median exceeds its mean, the signature of a left-skewed distribution — caused here by the two students scoring 00.

  3. Identify the modes. Counting frequencies: Tugas is bimodal at 8383 and 8585 (three times each); UAS is bimodal at 8181 and 8686 (four times each); TUGAS has a single mode at 8181 (four times). Modes this weak — a top frequency of only three or four out of 3737 — carry little information about a nearly continuous score variable.

  4. Compute the sample variance and standard deviation. Using s2=(xixˉ)2n1s^2 = \dfrac{\sum(x_i - \bar x)^2}{n-1} with n1=36n - 1 = 36:

    sTugas2=427.3634, sTugas=20.6728s^2_{\text{Tugas}} = 427.3634,\ s_{\text{Tugas}} = 20.6728

    sUAS2=406.9925, sUAS=20.1741s^2_{\text{UAS}} = 406.9925,\ s_{\text{UAS}} = 20.1741

    sTUGAS2=190.3664, sTUGAS=13.7973s^2_{\text{TUGAS}} = 190.3664,\ s_{\text{TUGAS}} = 13.7973

  5. Report ranges and quartiles. Minimum, maximum and the Tukey quartiles Q1,Q2,Q3Q_1, Q_2, Q_3:

    ColumnMinMaxRangeQ1Q_1Q2Q_2Q3Q_3IQR
    Tugas0909061768524
    UAS0929260778121
    TUGAS32946274828612
  6. Interpret the spread, and flag the outliers. The two rows of (0,0,32)(0, 0, 32) are almost certainly absentees rather than genuine performance. By the 1.5×1.5\timesIQR rule the Tugas fence is 611.5(24)=2561 - 1.5(24) = 25, so both zeros are outliers; the UAS fence is 601.5(21)=28.560 - 1.5(21) = 28.5, likewise; and the TUGAS fence is 741.5(12)=5674 - 1.5(12) = 56, so both 3232s are outliers there too. Excluding those two students would raise the Tugas mean to 260635=74.46\tfrac{2606}{35} = 74.46 and cut its standard deviation sharply. The third column is genuinely the most homogeneous (s=13.80s = 13.80 versus 20\approx 20 for the other two), and it stays so even after the outliers are removed.

Answer

Tugas: xˉ=70.43, M=76, s=20.67;UAS: xˉ=69.70, M=77, s=20.17;TUGAS: xˉ=78.54, M=82, s=13.80\text{Tugas: } \bar{x}=70.43,\ M=76,\ s=20.67;\quad \text{UAS: } \bar{x}=69.70,\ M=77,\ s=20.17;\quad \text{TUGAS: } \bar{x}=78.54,\ M=82,\ s=13.80

Need to solve a different problem like this? Open the solver →