Purchase Solution

Hypothesis Tests in Excel

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.