BUS 308 week 3 and 4 Assignment

profilecrunpr

Problem Set Week Three

Complete the problems included in the resources 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 the Week 3 assignment sheet.

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

Description:

 

Total Possible Score: 8.00

 

1. Performs and Interprets an ANOVA Test on Performance Data

Total: 1.60

Distinguished - Performs the following correctly: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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.

Proficient - Performs the following with no more than one error: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with no more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 no response to problem one, or it does not provide any correct responses to the question elements.

 

 

2. Performs and Interprets an ANOVA Test on Average Salary Per Grade Data

Total: 1.60

Distinguished - Performs the following correctly: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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.

Proficient - Performs the following with no more than one error: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with no more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 no response to problem two, or it does not provide any correct responses to the problem’s elements.

 

 

3. Interprets a Two Way ANOVA with Replication Sample Test on compa Data

Total: 1.60

Distinguished - Performs the following correctly for each of the three hypotheses: 1. Identifies the appropriate p-value. 2. Decides on rejecting or not rejecting the null hypothesis. 3. If appropriate, determines and interprets the effect size measure. 4. Provides a clear and accurate interpretation of the results.

Proficient - Performs the following with no more than one error per hypothesis section for each of the three hypotheses: 1. Identifies the appropriate p-value. 2. Decides on rejecting or not rejecting the null hypothesis. 3. If appropriate, determines and interprets the effect size measure. 4. Provides a clear and accurate interpretation of the results.

Basic - Performs the following with no more than two errors per hypothesis section for each of the three hypotheses: 1. Identifies the appropriate p-value. 2. Decides on rejecting or not rejecting the null hypothesis. 3. If appropriate, determines and interprets the effect size measure. 4. Provides a clear and accurate interpretation of the results.

Below Expectations - Performs the following with no more than three errors per hypothesis section for each of the three hypotheses: 1. Identifies the appropriate p-value. 2. Decides on rejecting or not rejecting the null hypothesis. 3. If appropriate, determines and interprets the effect size measure. 4. Provides a clear and accurate interpretation of the results.

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

 

 

4. Performs and Interprets a Two Sample Test on salary and compa

Total: 1.60

Distinguished - Performs the following correctly: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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.

Proficient - Performs the following with no more than one error: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with no more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 no response to problem four, or it does not provide any correct responses to the problem’s elements.

 

 

5. Conclusions About the Male and Females Pay Equality

Total: 1.60

Distinguished - Provides thorough and accurate conclusions about the following issues: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

Proficient - Provides mostly accurate conclusions about the following issues, but replies are not complete: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

Basic - Provides incomplete conclusions about the following issues: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

 

Below Expectations - Conclusions about the following issues are not accurate and/or do not consider all of the statistical information: 1.Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

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

 

 

 

Problem Set Week Four

Let’s look at some other factors that might influence pay. Complete the problems included in the resources 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 the Week 4 assignment sheet.

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

 

 

Description:

 

Total Possible Score: 8.00

 

1. Constructs One Sample Confidence Intervals and Compares with One Sample T-Test Results

Total: 1.60

Distinguished - Performs the following correctly: 1. Identifies the mean, standard error, and t-values for each gender. 2. Calculates confidence intervals for each gender. 3. Interprets interval results in light of equal pay question. 4. Compares results with the one sample t-test results from earlier.

Proficient - Performs the following with no more than one error: 1. Identifies the mean, standard error, and t-values for each gender. 2. Calculates confidence intervals for each gender. 3. Interprets interval results in light of equal pay question. 4. Compares results with the one sample t-test results from earlier.

Basic - Performs the following with no more than two errors: 1. Identifies the mean, standard error, and t-values for each gender. 2. Calculates confidence intervals for each gender. 3. Interprets interval results in light of equal pay question. 4. Compares results with the one sample t-test results from earlier.

Below Expectations - Performs the following with no more than three errors: 1. Identifies the mean, standard error, and t-values for each gender. 2. Calculates confidence intervals for each gender. 3. Interprets interval results in light of equal pay question. 4. Compares results with the one sample t-test results from earlier.

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

 

 

2. Constructs a Confidence Interval (CI) for the Mean Difference Between Male and Female Salaries and Compares the Result with the Two Sample T-Test Result

Total: 1.60

Distinguished - Performs the following correctly: 1. Identifies the mean difference, standard error, and t-values for each gender. 2. Calculates the CI for the mean difference. 3. Interprets interval result in light of equal pay question. 4. Compares results with the one sample t-test results from earlier. 5. Identifies why the difference CI is more accurate.

Proficient - Performs the following with no more than one error: 1. Identifies the mean difference, standard error, and t-values for each gender. 2. Calculates the CI for the mean difference. 3. Interprets interval result in light of equal pay question. 4. Compares results with the one sample t-test results from earlier. 5. Identifies why the difference CI is more accurate.

Basic - Performs the following with no more than two errors: 1. Identifies the mean difference, standard error, and t-values for each gender. 2. Calculates the CI for the mean difference. 3. Interprets interval result in light of equal pay question. 4. Compares results with the one sample t-test results from earlier. 5. Identifies why the difference CI is more accurate.

Below Expectations - Performs the following with no more than three errors: 1. Identifies the mean difference, standard error, and t-values for each gender. 2. Calculates the CI for the mean difference. 3. Interprets interval result in light of equal pay question. 4. Compares results with the one sample t-test results from earlier. 5. Identifies why the difference CI is more accurate.

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

 

 

3. Performs a Chi Square Analysis on the Distribution of Gender/Degree Groups Across Grades

Total: 1.60

Distinguished - Performs the following correctly: 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.

Proficient - Performs the following with no more than one error: 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 - Performs the following with no more than two errors: 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 - Performs the following with no more than three errors: 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 any correct responses to the question elements.

 

 

4. Performs a Chi Square Analysis on the Distribution of Gender/Degree Groups Across Grades

Total: 1.60

Distinguished - Performs the following correctly: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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.

Proficient - Performs the following with no more than one error: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with no more than two errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 - Performs the following with no more than three errors: 1. Identifies the null and alternate hypotheses. 2. Identifies the correct 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 any correct responses to the question elements.

 

 

5. Conclusions About the Male and Females Pay Equality

Total: 1.60

Distinguished - Provides thorough conclusions about the following issues: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

Proficient - Provides mostly accurate conclusions about the following issues but are slightly underdeveloped: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

Basic - Provides conclusions about the following issues but are underdeveloped or inaccurate: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

Below Expectations - Provides conclusions about the following issues but are significantly underdeveloped and inaccurate: 1. Male and female pay inequality. 2. Consistency between and among different statistical measures of equality.

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

 
  • 11 years ago
  • 15
Answer(3)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    copy_of_bus308_week_3_data_questions.xls
  • attachment
    copy_of_bus308_week_4_data_questions.xls

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    bus_308_week_4_assignment_new_data_2015.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    bus_308_week_3_assignment_new_data_2015.xlsx