Contents of salaries.xls Salary Rank Gender ...

70.2K

Verified Solution

Question

Accounting

image

image

Contents of salaries.xls

Salary Rank Gender
155690.6 1 1
139550.3 1 1
132050.2 1 1
116450.4 1 1
154240.4 1 1
144320.5 1 1
91050.7 1 1
82730.1 1 1
141250.9 1 1
139200.9 1 1
151430.2 1 2
110820.4 1 2
146290.4 1 2
145680.6 1 2
59900.6 1 2
115600.6 1 2
90560.1 1 2
78130 1 2
163270.3 1 2
104420.4 1 2
93966.7 2 1
93075.8 2 1
94580.4 2 1
95055.5 2 1
95920.4 2 1
93846.1 2 1
91900.4 2 1
94707.1 2 1
97582.2 2 1
96316.7 2 1
89348 2 2
89281.3 2 2
89649.6 2 2
96927.2 2 2
95696.8 2 2
92245.1 2 2
93694.7 2 2
93408.8 2 2
93612.1 2 2
90471.8 2 2
76616.3 3 1
78979.3 3 1
73854.5 3 1
77283 3 1
81067 3 1
80577.5 3 1
76894.1 3 1
77405.5 3 1
78028.6 3 1
80937.8 3 1
74441.1 3 2
70006.6 3 2
78930.3 3 2
72367.4 3 2
74048.9 3 2
74858.1 3 2
69644.6 3 2
71568.6 3 2
75303.6 3 2
71846.3 3 2
Exercise 1 Each year, Statstics Canada reports on salaries of academic professors at universities and colleges in Canada. The following data (in dollars), adapted from this report, are based on samples of n = 10 in each of three professorial ranks, for both male and female professor. The corresponding dataset is given in the file salaries.xls Full Professor Associate Professor Assistant Professor Male Female Male Female Male Female 155690.6 151430.2 93966.7 89348.0 76616.3 74441.1 139550.3 110820.4 93075.8 89281.3 78979.3 70006.6 132050.2 146290.4 94580.4 89649.6 73854.5 78930.3 116450.4 145680.6 95055.5 96927.2 77283.0 72367.4 154240.4 59900.6 95920.4 95696.8 81067.0 74048.9 144320.5 115600.6 93846.1 92245.1 80577.5 74858.1 91050.7 90560.1 91900.4 93694.7 76894.1 69644.6 82730.1 78130.0 94707.1 93408.8 77405.5 71568.6 141250.9 163270.3 97582.2 93612.1 78028.6 75303.6 139200.9 104420.4 96316.7 90471.8 80937.8 71846.3 1. Identify the design used in this survey. 2. Using SPSS, perform the appropriate analysis of variance for these data and give the complete ANOVA table. 3. Do the data indicate that the salary at the different ranks vary by gender? 4. If there is no interaction, determine whether there are differences in salaries by rank, and whether there are differences by gender. Discuss your results. 5. Using SPSS, plot the average salaries using an interaction plot. If the main effect of ranks is significant, use Tukey's method for pairwise comparisons to determine if there are significant differences among the ranks. Exercise 1 Each year, Statstics Canada reports on salaries of academic professors at universities and colleges in Canada. The following data (in dollars), adapted from this report, are based on samples of n = 10 in each of three professorial ranks, for both male and female professor. The corresponding dataset is given in the file salaries.xls Full Professor Associate Professor Assistant Professor Male Female Male Female Male Female 155690.6 151430.2 93966.7 89348.0 76616.3 74441.1 139550.3 110820.4 93075.8 89281.3 78979.3 70006.6 132050.2 146290.4 94580.4 89649.6 73854.5 78930.3 116450.4 145680.6 95055.5 96927.2 77283.0 72367.4 154240.4 59900.6 95920.4 95696.8 81067.0 74048.9 144320.5 115600.6 93846.1 92245.1 80577.5 74858.1 91050.7 90560.1 91900.4 93694.7 76894.1 69644.6 82730.1 78130.0 94707.1 93408.8 77405.5 71568.6 141250.9 163270.3 97582.2 93612.1 78028.6 75303.6 139200.9 104420.4 96316.7 90471.8 80937.8 71846.3 1. Identify the design used in this survey. 2. Using SPSS, perform the appropriate analysis of variance for these data and give the complete ANOVA table. 3. Do the data indicate that the salary at the different ranks vary by gender? 4. If there is no interaction, determine whether there are differences in salaries by rank, and whether there are differences by gender. Discuss your results. 5. Using SPSS, plot the average salaries using an interaction plot. If the main effect of ranks is significant, use Tukey's method for pairwise comparisons to determine if there are significant differences among the ranks

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students