Can you help me solve this stat question please?
2) A local firm wishes to establish an organizational baseline for employee well-being, One important criteria is employee satisfaction; in fact, one manager is convinced improving satisfaction with internal communication is key. A few issues need to be cleared up before her new plan can be implemented, the first Is to understand if one department is different (better) than the others. She believes, one group may be using certain practices that can be shared with other. departments. Use the attached file - Satisfaction 10 1 to test the theory employee satisfaction with internal communications differs between the four departments. Present your test in a well formatted, neatly labeled Excel spreadsheet. Satisfaction My work I have the tools and I have a good balance I have good My supervisor information needed to between work and my Overall Job recognizes a job I receive the proper conditions are good do my job well personal life satisfaction communication with my supervisor well done training to do my job Work Conditions Tools and Information |Work/Life Balance Satisfaction Communication Recognition Training 64 Department 92 73 59 73 Management 50 34 17 59 58 83 95 83 30 Management 65 79 36 80 44 79 Marketing 34 22 45 20 Marketing 67 38 34 87 77 26 Quality 73 50 85 49 63 85 24 60 85 89 35 Management 37 66 61 Management 46 28 36 45 43 97 49 15 41 83 82 29 96 61 Quality 47 31 74 54 56 30 15 Quality 76 76 32 16 66 80 Marketing 69 61 91 43 95 17 Marketing 58 25 18 34 83 82 18 Production 38 71 97 60 76 19 25 13 Production 95 74 65 27 16 20 Marketing 24 23 93 21 Production 47 22 60 34 96 22 Quality 77 65 47 62 22 87 23 Production Production 91 60 80 67 15 24 19 25 Production 16 57 36 91 92 40 51 26 Management 16 60 27 Marketing 18 74 28 Quality 88 69 74 Management 93 19 30 Management 78 Marketing 80 Quality Production Quality Marketing 98 Marketing Management 46 60 35 Quality 39 40 41 42 43 44 Data