Question

question13: TABLE 14-1

A manager of a product sales group believes the number of sales made by an employee ( Y) depends on how many years that employee has been with the company ( X ₁) and how he/she scored on a business aptitude test ( X ₂). A random sample of 8 employees provides the following:

Employee	Y	X1	X2
1	100	10	7
2	90	3	10
3	80	8	9
4	70	5	4
5	60	5	8
6	50	7	5
7	40	1	4
8	30	1	1

Referring to Table 14-1, for these data, what is the estimated coefficient for the variable representing scores on the aptitude test?

		21.293
		4.698
		3.103
		0.998

question 14:

TABLE 14-1

A manager of a product sales group believes the number of sales made by an employee ( Y) depends on how many years that employee has been with the company ( X ₁) and how he/she scored on a business aptitude test ( X ₂). A random sample of 8 employees provides the following:

Employee	Y	X1	X2
1	100	10	7
2	90	3	10
3	80	8	9
4	70	5	4
5	60	5	8
6	50	7	5
7	40	1	4
8	30	1	1

Referring to Table 14-1, if an employee who had been with the company 5 years scored a 9 on the aptitude test, what would his estimated expected sales be?

		17.98
		55.62
		60.88
		79.09

Answer 1

Using Excel, (Data -> Data Analysis -> Regression), we get the following output -

The regression equation is :

The estimated coefficient for the variable representing scores on the aptitude test

= 4.698

The estimated expected sales for an employee who had been with the company 5 years scored a 9 on the aptitude test