Accounting Department Survey Data Employee Gender Years of Service Years Undergr

Question

Accounting Department Survey Data
Employee Gender Years of Service Years Undergraduate Study Graduate Degree? CPA? Age Group
1 F 17 4 N Y 41-45
2 F 6 2 N N 26-30
3 M 8 4 Y Y 31-35
4 F 8 4 Y N 31-35
5 M 16 4 Y Y 36-40
6 F 21 1 N Y 51-55
7 M 27 4 N N 51-55
8 F 7 4 Y Y 26-30
9 M 8 4 N N 31-35
10 M 23 2 N Y 41-45
11 F 9 4 Y Y 31-35
12 F 8 2 N N 26-30
13 F 8 4 Y N 26-30
14 M 26 4 N Y 46-50
15 F 9 4 N Y 26-30
16 F 9 2 N N 26-30
17 M 19 2 Y Y 36-40
18 M 5 4 N N 36-40
19 M 19 4 Y N 51-55
20 M 20 4 N N 46-50
21 F 14 4 Y Y 36-40
22 M 31 4 N N 51-55
23 F 10 0 N N 51-55
24 F 10 4 N Y 31-35
25 M 26 4 Y Y 46-50
26 M 28 4 N N 51-55
27 F 5 4 N Y 21-25

Sheet 2:
Major Storm Events "Develop a frequency, relative frequency, and cumulative relative frequency table. Then develop a histogram." Year Events 2017 3 2016 2 2015 4 2014 4 2013 6 2012 2 2011 5 2010 3 2009 1 2008 3 2007 0 2006 1 2005 2 2004 3 2003 5 2002 0 2001 3 2000 1 1999 2 1998 4 1997 3 1996 2 1995 0 1994 3 1993 2 1992 0 1991 1 1990 4 1989 1 1988 3   

Use the data set above (Storms and Accounting Professionals Data.xlsx) to answer the questions below with the PIVOT Table. Also develop a histogram on the second worksheet per the class demonstration. When complete, click on this link (Lab Topic 02 Questions) to enter your numeric answers.

Determine the average years of service for those employees in the 31-35 (inclusive) age group without graduate degrees.

Determine the average years of service for employees between ages 21-25 inclusive.

Determine the average years of service for employees in the 26-30 (inclusive) year age bracket who have a graduate degree and a CPA.

Determine the probability of 2 storm events in any given season.

Determine the probability of experiencing less than 5 storm events in any given season.

Lastly, complete the frequency, relative frequency, cumulative relative frequency table AND develop a histogram.

(please upload Excel file for steps or write out steps to complete operation) thank you. )

Explanation / Answer

9 is the average years of service for those employees in the 31-35 (inclusive) age group without graduate degrees. because only two candidate are there

5 is the average years of service for employees between ages 21-25 inclusive.because only one candidate are there.

7 is the average years of service for employees in the 26-30 (inclusive) year age bracket who have a graduate degree and a CPA. because only one candidate are there.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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