Explore BrainMass

Explore BrainMass

    Hypothesis Testing: Two sample Z & t test

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

    Please see attached files.

    "Salaries" and instruction below.

    Large Sample Case
    Select the Tools pull-down menu
    Choose Data Analysis
    When Data Analysis dialog box appears:
    Choose z-Test:Two Sample for Means
    Click Ok

    When the z-Test: Two Sample for Means dialog box appears:
    Enter B1:B115 in the Variable 1 Range box
    Enter C1:C115 in the Variable 2 Range box
    Enter 0 in the Hypotesized Mean Difference box
    Enter k in the Variable 1 Variance box (you must use another program to calculate the variance first -replace k with the value)
    Enter m in the Variable 2 Variance box (you must use another program to calculate the variance first -rplace m with it)
    Select Labels
    Enter .05 in the Alpha box
    Select Output Range and Enter D1 in the box
    Click Ok.

    Please see attached file.
    "Textbooks" and instruction below.

    Select the Tools pool-down menu
    Choose Data Analysis
    When Data Analysis dialog box appears:
    Choose t-Test: Two Sample Assuming Equal Variances
    Click OK

    When the t-Test: Two Sample Assuming Equal Variances dialog box appears:
    Enter A1:A16 in the Variablee 1 Range box
    Enter B1:B16 in the Variable 2 range box
    Enter 0 in the Hypothesized Mean Difference box
    Select Labels
    Enter .05 in the Aplha box
    Select Output Range and enter C1 in the box
    Click OK

    Please use Excel 2003.

    © BrainMass Inc. brainmass.com June 3, 2020, 6:07 pm ad1c9bdddf
    https://brainmass.com/statistics/students-t-test/hypothesis-testing-two-sample-test-333336

    Attachments

    Solution Summary

    The solution provides step by step method for the calculation of testing of hypothesis in excel.

    $2.19

    ADVERTISEMENT