Show how to copy and paste the results of the two-tailed hypothesis test on a report. Show how to figure the significance level, the test statistic, and the critical values from this test.

Assignment Type: Individual Project Deliverable Length: 2 pages
Points Possible: 125 Due Date: 12/2/2012 11:59:59 PM CT
Using AIU’s survey responses from the AIU data set, complete the following requirements in the form of a 2-page 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.
We are to test here whether male and female have different intrinsic job satisfaction or not.
The null hypothesis is given by: H0: Male and female have equal intrinsic job satisfaction.
And the alternative hypothesis is given by: H1: They do not have equal intrinsic job satisfaction.
    F-Test Two-Sample for Variances
    
    
    
     
     Intrinsic of Male
    Intrinsic of Female
    Mean
    4.9625
    5.084375
    Variance
    0.528226
    0.581361
    Observations
    32
    32
    df
    31
    31
    F
    0.908602
    
    P(F<=f) one-tail
    0.395645
    
    F Critical one-tail
    0.548808
     
The F-test suggests that the variances of Intrinsic of male and female can be assumed to be equal.
    t-Test: Two-Sample Assuming Equal Variances
    
    
    
     
     Intrinsic of Male
    Intrinsic of Female...