Explore BrainMass
Share

Using AIU's survey: Intrinsic by Gender, null, test statist

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

Using AIU's survey responses from the AIU data set, can you please help me complete the following requirements:

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

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

â?¢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.

GENERAL ANALYSIS (Research Required)

â?¢Explain when to use a t-test and when to use a z-test. Explore the differences.
â?¢Discuss why samples are used instead of populations.

© BrainMass Inc. brainmass.com March 21, 2019, 11:44 pm ad1c9bdddf
https://brainmass.com/statistics/hypothesis-testing/using-aiu-s-survey-intrinsic-by-gender-null-test-statist-471091

Attachments

Solution Preview

Your excel file and word document are attached for best formatting. In excel, each is a separate tab.

I am not allowed to write the report for you as we have strict rules against writing essays for students but I have given you an outline to enable you to create the final polished product for your work.

-------------------------------------------------

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

NULL: There is no difference between the intrinsic motivation of male and female.
ALT: There is a difference between the intrinsic motivation of male and female.

â?¢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.

Anova: Single Factor

SUMMARY
Groups Count Sum Average Variance
Gender 50 81 1.62 0.240408163
Intrinsic 50 264.6 5.292 0.188097959

ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 337.0896 1 337.0896 1573.324545 3.61551E-62 3.938111078
Within Groups 20.9968 98 0.214253061

Total 358.0864 99

â?¢Identify the significance level, the test statistic, and the critical value.

Significance level: 3.61551 e-62 means 62 zeros before the 3.61551...which is very very close to zero!
Test statistic is F = 1,573.324545
The critical value is ...

Solution Summary

Your tutorial is 585 words including two ANOVA charts from Excel to test how the groups differ in levels of motivation. Each response is brief and clear in everyday language suitable for a novice. Four reference are included.

$2.19