ANOVA – The career center at a local university is researching job prospects and salaries for accounting graduates in a local area. The research is based on a sample of 100 reported data points separated by two factors, 1) whether the job is in the accounting or finance fields or not (i.e. Pay_AF = 1 for individuals employed in the accounting or finance fields), and 2) whether the employee has a CPA/CFA certificate or not (i.e. cpa = 1 for employees with a CPA/CFA certification). SEE IMAGE FOR FULL HOMEWORK PROBLEM A two-way ANOVA analysis of the salaries data returned the following results.   What is the average salary for all employees in the sample? What is the average salary for employees who hold a CPA/CFA license but are NOT employed in the accounting or finance fields? In the ANOVA results, what do the results in the Columns row indicate? In the ANOVA results, what do the results in the Interaction row indicate? Overall, what conclusion can we draw from the ANOVA?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 30PPS
icon
Related questions
Question
  • ANOVA – The career center at a local university is researching job prospects and salaries for accounting graduates in a local area. The research is based on a sample of 100 reported data points separated by two factors, 1) whether the job is in the accounting or finance fields or not (i.e. Pay_AF = 1 for individuals employed in the accounting or finance fields), and 2) whether the employee has a CPA/CFA certificate or not (i.e. cpa = 1 for employees with a CPA/CFA certification).

SEE IMAGE FOR FULL HOMEWORK PROBLEM

A two-way ANOVA analysis of the salaries data returned the following results.

 

  1. What is the average salary for all employees in the sample?
  2. What is the average salary for employees who hold a CPA/CFA license but are NOT employed in the accounting or finance fields?
  3. In the ANOVA results, what do the results in the Columns row indicate?
  4. In the ANOVA results, what do the results in the Interaction row indicate?
  5. Overall, what conclusion can we draw from the ANOVA?
1) ANOVA - The career center at a local university is researching job prospects and salaries for
accounting graduates in a local area. The research is based on a sample of 100 reported data points
separated by two factors, 1) whether the job is in the accounting or finance fields or not (i.e. Pax AE
= 1 for individuals employed in the accounting or finance fields), and 2) whether the employee has a
CPA/CFA certificate or not (i.e. spa= 1 for employees with a CPA/CFA certification).
A two-way ANOVA analysis of the salaries data returned the following results.
Anova: Two-Factor With Replication
SUMMARY
Count
Sum
Average
Variance
Count
Sum
Average
Variance
Count
Sum
Average
Variance
cpa
Total
no ncpa
Total
ANOVA
Source of Variation
Sample
Columns
Interaction
Within
Pay_AF Pay_Othe Total
25
25
50
3582590.2 1913396 5495986
143303.61 76535.82 109919.7
1189E+09 6.55E+08 2.04E+09
25
50
25
2183073 4127298
1944226
77769.039 87322.9 82545.97
792544342 7.79E+08 7.93E+08
50
50
5526816.1 4096468
110536.32 81929.36
2.066E+09 7.32E+08
SS
1873E+10
2.046E+10
3.641E+10
8.199E+10
1576E+11
df
MS
F
P-value Fcrit
1 187E+10 21.93487 9.28E-06 3.940163
1 2.05E+10 23.95577 3.97E-06 3.940163
1 3.64E+10 42.6287 3.14E-09 3.940163
96 8.54E+08
99
a. What is the average salary for all employees in the sample?
b.
What is the average salary for employees who hold a CPA/CFA license but are NOT employed in
the accounting or finance fields?
c. In the ANOVA results, what do the results in the Columns row indicate?
d. In the ANOVA results, what do the results in the Interaction row indicate?
e. Overall, what conclusion can we draw from the ANOVA?
Transcribed Image Text:1) ANOVA - The career center at a local university is researching job prospects and salaries for accounting graduates in a local area. The research is based on a sample of 100 reported data points separated by two factors, 1) whether the job is in the accounting or finance fields or not (i.e. Pax AE = 1 for individuals employed in the accounting or finance fields), and 2) whether the employee has a CPA/CFA certificate or not (i.e. spa= 1 for employees with a CPA/CFA certification). A two-way ANOVA analysis of the salaries data returned the following results. Anova: Two-Factor With Replication SUMMARY Count Sum Average Variance Count Sum Average Variance Count Sum Average Variance cpa Total no ncpa Total ANOVA Source of Variation Sample Columns Interaction Within Pay_AF Pay_Othe Total 25 25 50 3582590.2 1913396 5495986 143303.61 76535.82 109919.7 1189E+09 6.55E+08 2.04E+09 25 50 25 2183073 4127298 1944226 77769.039 87322.9 82545.97 792544342 7.79E+08 7.93E+08 50 50 5526816.1 4096468 110536.32 81929.36 2.066E+09 7.32E+08 SS 1873E+10 2.046E+10 3.641E+10 8.199E+10 1576E+11 df MS F P-value Fcrit 1 187E+10 21.93487 9.28E-06 3.940163 1 2.05E+10 23.95577 3.97E-06 3.940163 1 3.64E+10 42.6287 3.14E-09 3.940163 96 8.54E+08 99 a. What is the average salary for all employees in the sample? b. What is the average salary for employees who hold a CPA/CFA license but are NOT employed in the accounting or finance fields? c. In the ANOVA results, what do the results in the Columns row indicate? d. In the ANOVA results, what do the results in the Interaction row indicate? e. Overall, what conclusion can we draw from the ANOVA?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax