The first step in analyzing data sets is to find some summary descriptive statistics for key variables. Since the assignment problems will

focus mostly on the compa-ratios, we need to find the mean, standard deviations, and range for our groups: Males, Females, and Overall.

Males Females Overall

Means Means Means

standard deviations standard deviations standard deviations

Range Range Range

Data values used: Discriptive Statistic; to show how results are formed. For Examples cell should have an “=XX” formula in them showing the value of the Discriptive statistic table.

if you choose to use generate each value using fx functions,then each function should be inside the cell, along with location of data value in the cell.

If you use Descriptive statistics, Place the output table in row 1 of a column to the right.

2. Probability

A key issue in comparing data sets is to see if they are distributed/shaped the same. At this point we can do this

by looking at the probabilities that males and females are distributed in the same way for a grade levels.

Empirical Probability: What is the probability for a:

a. Randomly selected person being in grade E or above

b. Randomly selected person being a male in grade E or above

c. Randomly selected male being in grade E or above

d. Why are the results different

3. Normal Curve based probability: For each group (overall, females, males), what are the values for each question below

A. Make sure your answer cells show the Excel function and cell location of the data used.

Overall

Female

Male

B. How do you interpret the relationship between the data sets What does this suggest about our equal pay for equal work question

4. Based on our sample data set, can the male and female compa-ratios in the population be equal to each other

A. First, we need to determine if these two groups have equal variances, in order to decide which t-test to use.

What is the data input ranged used for this question: decide equal variance

Step 1: Ho:

Ha:

Step 2: Decision Rule:

Step 3: Statistical test:

Why

Step 4: Conduct the test – place cell B77 in the output location box.

Step 5: Conclusion and Interpretation

What is the p-value:

Is the P-value < 0.05 (for a one tail test) or 0.025 (for a two tail test)

What is your decision: REJ or NOT reject the null

What does this result say about our question of variance equality

B Are male and female average compa-ratios equal

(Regardless of the outcome of the above F-test, assume equal variances for this test.)

What is your decision: REJ or NOT reject the null

Step 1: Ho:

Ha:

Step 2: Decision Rule:

Step 3: Statistical test:

Why

4. Conduct the test – place cell B109 in the output location box.

Step 5: Conclusion and Interpretation

What is the p-value:

Is the P-value < 0.05 (for a one tail test) or 0.025 (for a two tail test)

What, besides the p-value, needs to be considered with a one tail test

Decision: Reject or do not reject Ho

What does your decision on rejecting the null hypothesis mean

If the null hypothesis was rejected, calculate the effect size value:

If the effect size was calculated, what doe the result mean in terms of why the null hypothesis was rejected