Explore BrainMass
Share

Hypothesis Tests in Excel

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 March 21, 2019, 10:14 pm ad1c9bdddf
https://brainmass.com/statistics/hypothesis-testing/hypothesis-tests-in-excel-409951

Attachments

$2.19