Problem 2 A survey conducted by a research team who want to understand business

Question

Problem 2 A survey conducted by a research team who want to understand business professionals in terms of education level, tenure in current employment, age, and annual income. A sample 20 employees was selected and the data is given below. Length of tenure in current Education (No. of years) employment (No.(No. of years)income (S) Age Annual of vears 40 Accountin Management Information Svstems Accountin Management Information Svstems Information Svstems Accountin Marketin Marketin Management Information Svstems Marketin Accountin Information Svstems Management Accountin Accounting Information Svstems Management 124,000 30,000 193,000 88,000 37,000 43,000 96,000 110,000 88,000 82,000 81,000 38,000 140,000 41,000 51,000 151,000 124,000 48,000 36,000 124,000 17 12 20 14 12 4 42 19 28 43 37 36 39 36 12 18 12 17 45 42 20 19 40 35 38 19 12 12 Using Pivot Table on the provided data, answer the following 3 questions 1. What is the average income for accountant professionals who have had 17 years of education? What is the average annual income for individuals who have been in the job for 10 years and had 18 vears of education? How many individuals in the sample have the salary between $120,000 and $129,999? 2. 3.

Explanation / Answer

1) There is only one such professional . Average income = 124000

b) Only one such individul. Average income =110000

c) Number of people with salary between 120000-129999 = 3

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.