Explore BrainMass

Explore BrainMass

    Hypothesis Tests in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    See attached data file.

    Using AIU's survey responses from the AIU data set, complete the following requirements in the form of a report:

    TEST #1

    Perform the following two-tailed hypothesis test, using a .05 significance level:

    -Intrinsic by Gender
    -State the null and an alternate statement for the test
    -Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test. Copy and paste the results of the output to your report in Microsoft Word.
    -Identify the significance level, the test statistic, and the critical value.
    -State whether you are rejecting or failing to reject the null hypothesis statement.
    -Explain how the results could be used by the manager of the company.

    TEST #2

    -Extrinsic variable by Position Type
    -State the null and an alternate statement for the test
    -Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test.
    -Copy and paste the results of the output to your report in Microsoft Word.
    -Identify the significance level, the test statistic, and the critical value.
    -State whether you are rejecting or failing to reject the null hypothesis statement.
    -Explain how the results could be used by the manager of the company

    © BrainMass Inc. brainmass.com November 24, 2021, 4:04 pm ad1c9bdddf
    https://brainmass.com/statistics/hypothesis-testing/hypothesis-tests-in-excel-409951

    Attachments

    $2.49

    ADVERTISEMENT