Explore BrainMass

Explore BrainMass

    T-Test and Estimated Normal distribution

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Calculate and Display, using Excel, the following:

    1. Draw the statistics as a histogram. Do they resemble the Normal Distribution?
    2. Find the median, the average grade and the standard deviation of the two terms.
    3. Calculate using the t-student distribution to find out if there is a significant difference among these two terms.

    Grade Range Numeric Grade Number of Students in term 1 Number of Students in term 2
    Outstanding (A*) 80 + 85 1 1
    Excellent (A) 70-79 75 3 4
    Very Good (B) 60-69 65 8 7
    Good (C) 50-59 55 5 7
    Marginal Fail (D) 40-49 45 2 4
    Fail (F) Below 40 0 1 2
    Total 20 25

    © BrainMass Inc. brainmass.com June 4, 2020, 4:23 am ad1c9bdddf
    https://brainmass.com/statistics/students-t-test/t-test-and-estimated-normal-distribution-558802

    Solution Preview

    For calculations see attached xls file.

    Q 1. See attachment for histograms. Term 2 distribution is closer to Normal distribution than Term 1.

    Q 2.
    Median:
    Me = L + (n/2 - cfp)*i/fm
    L: lower bound of class (or interval) containing median
    n = sample size
    cfp = cumulative frequency of the class before median class
    fm = frequency of median class
    i interval of class

    Term 1:
    Middle ranked candidate (10th+11th)/2 = 10.5 th i.e., class ...

    Solution Summary

    For a given sample data of students of a class with their grades, some statistical analyses are carried out.

    $2.19

    ADVERTISEMENT