Exp19_Excel_Ch08_CapAssessment_Employee_Satisfaction

Employee Satisfaction

	Employee Survey Results
	ID Number	Salary	Job Satisfaction		Frequency Distribution
	1165	$30,176.00	1		Satisfaction Score	Frequency		Salary
	4584	$30,701.00	2		1			30000
	3004	$30,982.00	1		2			40000
	3808	$31,632.00	2		3			50000
	4239	$32,107.00	1		4			60000
	1486	$32,666.00	1		5			70000
	3161	$32,709.00	2					>70000
	1503	$32,757.00	3		Statistics
	3473	$33,501.00	2		Standard Deviation
	3402	$33,852.00	3		Variance
	3874	$34,154.00	2		Covariance
	3877	$34,775.00	2
	1828	$35,230.00	2		Correlation
	2291	$35,242.00	3
	4243	$35,316.00	3
	3338	$36,942.00	3
	3948	$37,404.00	3
	3217	$40,449.00	2
	4398	$41,130.00	4
	2206	$42,383.00	2
	2292	$44,854.00	3
	1519	$45,674.00	3
	1102	$45,700.00	3
	1047	$45,855.00	4
	3782	$45,927.00	4
	3314	$45,983.00	4
	1473	$45,993.00	4
	1085	$46,063.00	4
	1106	$47,572.00	4
	3638	$48,005.00	4
	3652	$48,706.00	3
	3818	$49,575.00	4
	1675	$49,617.00	4
	2742	$58,154.00	4
	3969	$52,022.00	4
	4652	$58,802.00	5
	4269	$53,860.00	5
	1603	$57,324.00	5
	2528	$55,639.00	5
	4541	$56,564.00	5
	2624	$62,263.00	5
	4771	$65,492.00	5
	2416	$66,009.00	4
	4911	$68,365.00	5
	2003	$69,389.00	5
	3083	$70,125.00	5
	1529	$72,862.00	5
	1601	$73,564.00	4
	2250	$74,767.00	5
	4954	$77,846.00	5

Office_Data

	Clients by office
	Year	NYC Office	OKC Office	SF Office
	1990	500	475	500
	1991	750	725	745
	1992	1000	950	989
	1993	1050	1000	1010
	1994	1125	1020	1025
	1995	1210	1100	1109
	1996	1300	1250	1275
	1997	1500	1425	1475
	1998	1550	1510	1500
	1999	1580	1575	1580
	2000	1600	1600	1590
	2001	1730	1710	1725
	2002	1800	1755	1775
	2003	1930	1875	1850
	2004	2000	1950	1900
	2005	2015	2000	2010
	2006	2035	2010	2015
	2007	2045	2025	2025
	2008	2075	2058	2050
	2009	2150	2100	2100
	2010	2225	2200	2105
	2011	2400	2374	2300
	2012	2450	2375	2325
	2013	2475	2375	2375
	2014	2800	2490	2400
	2015	2900	2500	2800
	2016	3050	2575	3000
	2017	3025	2600	3025
	2018	3100	2625	3075
	2019	3150	2675	3100
	2020	3275	2700	3125
	2021	3300	2750	3150

Customers

	NYC Office
	Year	Clients		Intercept	Slope	RSQ	Standard Error		Forecast Limit
	1990	500							2022
	1991	750
	1992	1000		Forecast	High	Low
	1993	1050
	1994	1125
	1995	1210
	1996	1300
	1997	1500
	1998	1550
	1999	1580
	2000	1600
	2001	1730
	2002	1800
	2003	1930
	2004	2000
	2005	2015
	2006	2035
	2007	2045
	2008	2075
	2009	2150
	2010	2225
	2011	2400
	2012	2450
	2013	2475
	2014	2800
	2015	2900
	2016	3050
	2017	3025
	2018	3100
	2019	3150
	2020	3275
	2021	3300

1

2

3

4

5

6

7

8

9

A

B

C

D

Employee Survey Results

ID Number

Salary

Job Satisfaction

1165

$30,176.00

1

4584

$30,701.00

2

3004

$30,982.00

1

3808

$31,632.00

2

4239

$32,107.00

1

1486

$32,666.00

1