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

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.

https://brainmass.com/statistics/hypothesis-testing/using-aiu-s-survey-intrinsic-by-gender-null-test-statist-471091

#### 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.