Question

Verizon Wireless records as a measure of productivity the number of weekly cell phone activations each of its retail employees achieves. The data below show a sample of 25 employees, for each employee giving the number of activations in the sampled week, the number of years of experience on the job, the gender (0-Male; 1-Female), the employee performance rating on a scale of 1-100, and the employee's age.

(Please help me solve this with MS EXCEL)

a. Estimate the mean number of activations in a week for a 30 year old male employee who has 5 years of experience and a performance rating of 90.

b. interpret the coefficient for the Gender variable:

c. What are the null and alternate hypotheses that would be used to test if the model is significant overall. (Express symbolically if possible)

d. What is the p-value that would be used for the hypothesis test corresponding to the hypotheses in part c?

e. What are the null and alternate hypotheses that would be used to determine if age is significantly related to the number of activations? (Express symbolically if possible)

f. Determine if age is significantly related to number of activations. Use α = 0.05. Give complete conclusions.

Activations	Experience	Gender	Rating	Age
19	1	0	80	27
20	7	0	76	32
20	2	0	82	46
22	5	0	82	35
23	1	0	80	41
24	5	1	62	25
24	4	0	77	22
25	3	0	78	41
26	4	0	85	53
27	6	0	71	39
27	4	0	87	29
27	7	0	74	33
29	2	0	75	31
29	6	1	83	38
30	6	0	81	44
32	2	0	80	21
33	8	1	94	47
33	6	1	85	40
35	8	1	92	35
36	6	1	88	39
36	5	1	92	41
36	5	1	85	34
38	7	1	92	28
40	10	0	90	40
40	9	1	96	32

Answer 1

a. Find the estimated regression equation for estimating an employee's number of activiations based on the other variables.

Activations=-3.16913+0.086536*Experience+3.44307*Gender+0.36828*Rating-0.1087*Age

b. Based on the equation from part a, how many activations would you estimate for a week for a 30 year old male employee who has 5 years of experience and a performance rating of 90?

=-3.16913+0.086536*Experience+3.44307*Gender+0.36828*Rating-0.1087*Age

=-3.16913+0.086536*(0.86536)+3.44307*(3.44307)+0.36828*(0.36828)-0.1087*(-0.1087)=31.04188261

c. interpret the coefficients for each of the following variables:

year of experience : if we increase years of experience by one unit keeping all other explanatory varianbles fixed then activations number will be increased by 0.86536 units.

gender : if we change the gender male to female or female to male keeping all other explanatory varianbles fixed then activations number will be increased by 3.44307 units.

d. Find and interpret the adjusted multiple coefficient of determination.

The multiple coefficient of determination is 0.67391 which means the regression model explains 67.391% variation of the total variation.

e. Determine whether the model is significant overall, using an alpha of 0.05. Give a complete report of your process and conclusions.

since the pvalue corresponding to F=10.33 is 0.00011 which is less than 0.05 at 5% levelof significance therefore the overall model is significant.

f. Determine if age is significantly related to number of activations. Use a = 0.05. Explain and justify your conclusions.

since the p value corresponding to age t=-0.99307 is 0.33254 which is greater than 0.05 at 5% level of signifivcance therefore the age is not significant for the regression model.

excel > data analysis> regression