Explore BrainMass
Share

Explore BrainMass

    Calculate all measures of central tendency for data that are interval or ratio in measurement - mean, median, mode

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

    Data for Practice Problems

    Standard Test Scores
    Name Gender Absences PE Math Writing Reading
    Alex Boy 5 49 85 86 80
    Anthony Boy 18 51 39 71 75
    Douglas Boy 1 82 74 78 79
    Jorge Boy 4 56 66 68 60
    Joshua Boy 5 83 79 78 77
    Luke Boy 0 94 89 84 84
    Robert Boy 17 36 36 56 50
    Rupert Boy 4 24 55 56 52
    Seth Boy 0 61 92 89 83
    Wayne Boy 1 65 92 96 91
    Blair Girl 3 94 59 66 90
    Brooke Girl 2 75 35 43 46
    Carmen Girl 0 49 91 91 90
    Charlita Girl 16 23 49 55 49
    Kim Girl 2 71 90 92 95
    Li Girl 1 73 98 93 95
    Rachel Girl 2 92 87 92 91
    Sara Girl 3 33 87 93 94
    Sheetal Girl 0 18 100 97 97
    Tawayna Girl 14 31 65 55 63

    Continue using the information from Inferential Practice Problems Part I and determine the following using the Excel® Analysis ToolPak? when necessary:
    a. Calculate all measures of central tendency for data that are interval or ratio in measurement - mean, median, mode
    b. Calculate the standard deviation for data that are interval or ratio in measurement
    c. Assume this is a sample of students, calculate a t-test that compares boys and girls on the number of absences (you can assume equal variances). Is there a significant difference in absences based on gender?
    d. Write out 3 hypotheses related to an ARP topic of your interest that would involve a correlational test or a t-test in the analysis plan.

    © BrainMass Inc. brainmass.com October 10, 2019, 1:44 am ad1c9bdddf
    https://brainmass.com/statistics/quantative-analysis-of-data/347223

    Solution Summary

    Comments guide students through work.

    $2.19