Explore BrainMass

Explore BrainMass

    School Committee members of a midsized New England city

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

    Exe_1Wk1.xls

    The School Committee members of a midsized New England city agreed that a strict
    discipline code has caused an increase in the number of student suspensions. The
    number of suspensions for September 1992 - February 1993 for a sample of the schools is provided below. {Data}
    The average number of suspensions for the previous year mean{X bar} = 130.5 and the Standard deviation {STDEV}
    was 158.2
    (a) Set up the null and alternative hypothesis to test if the averave number of suspensions
    has changed.
    (b) Test your hypothesis with alpha = 0.05.
    (c) Find the p value.
    (d) Display the data in an Excel Chart to see if it is reasonable to assume that the underlaying population
    distribution is normal.
    (e) Based on the p value, what can you conclude about the average number of suspensions?
    See Attachment for the above exercise.

    Part II

    Look at Exe_1Wk1.xls again and suppose that we did not include the two outliers in the database. Remove the MCDI and Putnam schools and repeat the calculations for just 9 of the schools. Please provide one paragraph to discuss the impact of this calculation on the conclusion shown in the Exercise.

    © BrainMass Inc. brainmass.com June 3, 2020, 9:06 pm ad1c9bdddf
    https://brainmass.com/statistics/hypothesis-testing/the-school-committee-members-of-a-midsized-new-england-city-agreed-that-a-strict-166019

    Attachments

    Solution Summary

    The school committee members of a midsizes New England City is analyzed.

    $2.19

    ADVERTISEMENT