Answered You can hire a professional tutor to get the answer.

QUESTION

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 59.6 76 22.8 24 35 75.9...

I need help please.  The assignment is listed below and I have attached a spreadsheet where the week 3 tab must be completed.

Problem Set Week Three 

During this week, we will look at ways of testing multiple (more than two) data samples at the same time.

We will continue to use the data and assignment file that we opened in Week 2, we just move on to the Week 3 tab.The first question asks us to determine if the average compa-ratio is equal across 10K salary groups (20 – 29K. 30 – 39K, etc.).  The second question asks us to identify which of the salary groups have different averages.  The final question asks us to interpret the new information presented in the lecture and assignment; how does the new information we analyzed help us answer our equal pay for equal work question.

The data and assignment file can be found in the Course Materials link, at the bottom in the Multi-Media section.  If you save the files from last week, you do not need to open them again.

Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.

Description: 

Total Possible Score: 8.00

Performs and Interprets an ANOVA Test on Performance Data

Total: 3.00

Distinguished - Performs the following correctly: identification of the null and alternate hypotheses, identification of the test to use, correct data, identification of where data used is located, set-up for the test, answers to the questions, and  a clear and accurate interpretation of the results.

Proficient - Performs the following with no more than one error: identification of the null and alternate hypotheses, identification of the test to use, correct data, identification of where data used is located, set-up for the test, answers to the questions, and  a clear and accurate interpretation of the results.

Basic - Performs the following with no more than three errors: identification of the null and alternate hypotheses, identification of the test to use, correct data, identification of where data used is located, set-up for the test, answers to the questions, and  a clear and accurate interpretation of the results.

Below Expectations - Performs the following with more than three errors: identification of the null and alternate hypotheses, identification of the test to use, correct data, identification of where data used is located, set-up for the test, answers to the questions, and  a clear and accurate interpretation of the results.

Non-Performance - There is no response to Problem One, or it does not provide any correct responses to the question elements.

Performs and Interprets an ANOVA Test on Performance Data

Total: 3.00

Distinguished - Performs all elements correctly: identifies the correct pairs to compare, mean differences, and correct t-value; calculates the correct +/- values; and correctly identifies the significantly different pairs of means.

Proficient - Has errors in only one area: identification of the correct pairs to compare, mean differences, and the correct t-value; calculation of the +/- values; and identification of the significantly different pairs of means.

Basic - Has errors in only two or three areas: identification of the correct pairs to compare, mean differences, and the correct t-value; calculation of the +/- values; and identification of the significantly different pairs of means.

Below Expectations - Has errors in four or five areas: identification of the correct pairs to compare, mean differences, and the correct t-value; calculation of the +/- values; and identification of the significantly different pairs of means.

Non-Performance - There is no response to Problem Two, or it does not provide any correct responses to the problem’s elements.

Conclusions and Interpretations

Total: 2.00

Distinguished - Performs all elements correctly: identifies the correct pairs to compare, mean differences, and correct t-value; calculates the correct +/- values; and correctly identifies the significantly different pairs of means.

Proficient - Has errors in only one area: identification of the correct pairs to compare, mean differences, and the correct t-value; calculation of the +/- values; and identification of the significantly different pairs of means.

Basic - Has errors in only two or three areas: identification of the correct pairs to compare, mean differences, and the correct t-value; calculation of the +/- values; and identification of the significantly different pairs of means.

Below Expectations - Has errors in four or five areas: identification of the correct pairs to compare, mean differences, and the correct t-value; calculation of the +/- values; and identification of the significantly different pairs of means.

Non-Performance - There is no response to Problem Two, or it does not provide any correct responses to the problem’s elements.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question