Explore BrainMass

Using ANOVA to Test Productivity Levels

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The results shown below are mean productivity measurements (average number of assemblies completed per hour) for a random sample of workers at each of three plants. The research question is: Are the mean hourly productivity levels the same for workers in these three plants? Please compute the solution in an Excel document or another similar application.

Hourly Productivity of Assemblers in Plants
Plant Finished Units Produced Per Hour
A (9 workers) 3.6 5.1 2.8 4.6 4.7 4.1 3.4 2.9 4.5
B (6 workers) 2.7 3.1 5.0 1.9 2.2 3.2
C (10 workers) 6.8 2.5 5.4 6.7 4.6 3.9 5.4 4.9 7.1 8.4

© BrainMass Inc. brainmass.com October 16, 2018, 9:54 pm ad1c9bdddf

Solution Preview

Please see the attached Excel to understand how the answer has been ...

Solution Summary

Using ANOVA to test productivity levels in excel is determined.

Similar Posting


Primary Task Response: Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

You are going to look at how wealth might change one's life. Use the following steps to complete the task:

•Load gss.sav into SPSS.
•You are going to look at the relationships between the following:
◦Being wealthy (richwork)
◦Demographics of gender (sex)
◦Satisfaction level with your job (satjob)
◦Educational degree level (degree)
To run this analysis, go to Descriptive, then Crosstabs. Put richwork in the Rows box and the other three variables in the Columns box. Click on Click on Cells, then

Observed under Counts and all three boxes under Percentages. You can now Run the analysis.

Write a summary description of the findings based upon the output as it pertains to the variables and being rich and continuing to work.


MGMT814-1402C-01 Quantitative Research Methods
Task Name: Phase 3 Individual Project
Deliverable Length: SPSS Outputs and 300-700 words
Details: Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.
Part 1
Load atw.sav in SPSS. You are looking at a comparison of productivity under 2 organizational structures: The data are artificial estimates of productivity with column 1 representing traditional vertical management and column 2 representing other autonomous work teams (ATW). The background is that a company of 100 factory workers had been operating under traditional vertical management and decided to move to ATW. The same employees were involved in both systems having first worked under vertical management and then being converted to ATW.
Complete the following:
• Analyze the productivity levels of the 2 management approaches, and decide which is superior.
• Include the SAS output, which validates your conclusion.

Part 2
Load electric.sav in SPSS. You need to make a decision about whether a person's diastolic blood pressure (DBP) level is a predictor of whether he or she is going to be alive 10 years later. You will use "DBP58" as a dependent variable and "VITAL10" as your independent variable. Complete the following:
• Analyze these conditions to determine if there is a significant difference between the DBP levels of those (vital10) who are alive 10 years later compared to those who died within 10 years. Include the SAS output, which validates your conclusion.
• Write a brief paragraph describing your conclusions.

Part 3
Occasionally, you have one independent variable that has 3 or more levels within. Consider the following question, and examine it using the gss.savdatabase: You are interested in looking at the relationship between the dependent variable of the income level of respondents (rincdol) and the independent variable of their reported level of happiness (happy). Using SPSS, complete the following:
• Run the ANOVA program to determine the overall conclusion.
• Use the Bonferroni correction as a post-hoc analysis to determine the relationship of specific levels of happiness to income.
• Write your conclusion of the findings based upon the output.
Submit both the SPSS output file and your Word summary.
Please submit your assignment.

View Full Posting Details