BUS 308 week 2 Assignment

profilecrunpr

Problem Set Week Two

In the Week Two Assignment sheet, complete the problems below and submit your work in an Excel document.  Be sure to show all of your work and clearly label all calculations. All statistical calculations will use the Employee Salary Data Set and Week 2 assignment sheet.

(Note: Questions 1- 4 have additional elements to respond to below the analysis results and included in the Week Two Assignment sheet are 2 one-sample t-tests comparing male and female average salaries to the overall sample mean.)

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

 

Description:

 

Total Possible Score: 8.00

 

1. Interprets t-test Results

Total: 1.60

Distinguished - Answers the questions correctly, and provides a clear and correct interpretation of the outcome meanings.

Proficient - Answers no more than one of the questions (for each test result) incorrectly, and provides a clear and correct interpretation of the outcome meanings.

Basic - Answers no more than two of the questions (for each test result) incorrectly, and/or provides an unclear and/or somewhat incomplete/ inaccurate interpretation of the outcome meanings.

Below Expectations - Answers three or more of the questions (for each test result) incorrectly, and/or provides an unclear and inaccurate or missing interpretation of the outcome meanings.

Non-Performance - There is either no response to problem one, or it fails to provide any correct descriptive statistics in response to the question elements.

 

 

2. Performs and Interprets a Two Sample Test on Salary Data

Total: 1.60

Distinguished - Correctly identifies the null and alternate hypotheses, identifies the test to use, uses the correct data, sets up the test correctly, answers the questions, and provides a clear and accurate interpretation of the results.

Proficient - Has an error in no more than one of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Basic - Has an error in no more than three of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly.5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Below Expectations - Has an error in  more than three of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Non-Performance - There is either no response to problem two, or it does not provide correct statistical outcomes as asked for.

 

 

3. Performs and Interpret a Two Sample Test on Compa Data

Total: 1.60

Distinguished - Correctly identifies the null and alternate hypotheses, identifies the test to use, uses the correct data, sets up the test correctly, answers the questions, and provides a clear and accurate interpretation of the results.

Proficient - Has an error in no more than one of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Basic - Has an error in no more than three of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Below Expectations - Has an error in  more than three of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Non-Performance - There is either no response to problem three, or it does not provide correct statistical outcomes as asked for.

 

 

4. Performs and Interpret a two Sample Test on Performance Rating Data

Total: 1.60

Distinguished - Correctly identifies the null and alternate hypotheses, identifies the test to use, uses the correct data, sets up the test correctly, answers the questions, and provides a clear and accurate interpretation of the results.

Proficient - Has an error in no more than one of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Basic - Has an error in no more than three of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Below Expectations - Has an error in more than three of the following elements: 1. Identifies the null and alternate hypotheses. 2. Identifies the test to use. 3. Uses the correct data. 4. Sets up the test correctly. 5. Answers the questions. 6. Provides a clear and accurate interpretation of the results.

Non-Performance - There is either no response to problem four, or it does not provide correct statistical outcomes as asked for.

 

 

5. Conclusions About the Male and Females Pay Equality

Total: 1.60

Distinguished - Provides thorough conclusions about the issue of male and female pay inequality. Identifies results that appear inconsistent and addresses why.

Proficient - Provides weak conclusions about one of the following issues: 1. Male and female inequality. 2. Consistency of the findings.

Basic - Provides weak conclusions about both of the following issues: 1. Male and female inequality. 2. Consistency of the findings.

Below Expectations - One of the following conclusions is not present: 1. Male and female inequality. 2. Consistency of the findings.

Non-Performance - There is either no response to problem five, or it fails to address the issue of equal pay for equal work statistical results to date.

 
  • 11 years ago
  • 10
Answer(4)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    bus_308_week_2_assignment.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    rejecting_and_accepting_hypothesis_333333.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    15_bus_308_statistics_for_managers_bam1538b.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    15_bus_308_statistics_for_managers_bam1538b.xlsx