The outline is set on excel spread sheet, just need assistance with imputing the functions and data on the master sheet, to be able to answer the data analysis: Do Males make more the Females. Can negotiate a fee if interested.
1 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?
What does the result of this test tell us about our question on salary equality?
6 Considering both the salary information in the lectures and your compa-ratio information, what conclusions can you reach about equal pay for equal work?
Why – what statistical results support this conclusion?
