Question

The CIO of an IT company would like to investigate how a software developer’s work experience (in number of years), professional certifications (number of certificates), and knowledge of various computer languages (number of programming languages) contribute to his/her work performance. The work performance is measured on the scale of 1 to 1000 so that the higher one’s score, the better his/her work performance. He collects data from 20 software developers in his company which is provided in the table below.

Employee ID	Years of experience	Num of certificates	Num of progLang	Performance
1	27	3	8	880
2	11	1	2	686
3	6	2	1	681
4	21	3	4	877
5	26	3	4	975
6	21	3	4	902
7	18	3	3	900
8	15	2	5	882
9	14	2	3	775
10	5	1	3	650
11	17	2	5	908
12	14	2	4	687
13	15	3	4	891
14	7	2	3	566
15	5	3	1	959
16	13	2	5	793
17	11	2	4	778
18	31	3	7	975
19	16	2	5	846
20	12	3	6	779

Question 9

Using Pivot Table on this data, what is the standard deviation for the performance of software developers who have obtained 2 certificates and know 3 programming languages?

Select one:

a. 147.8

b. 1341

c. 670.5

d. 0

e. 2

Information

Going back to the last problem of measuring performance of software developers, we would like to create a regression model that would describe how performance depends on work experience, professional certifications, and knowledge of various computer languages.

Question 10

What is the response (i.e. dependent) variable in this regression model?

Select one:

a. Employee ID

b. Work experience

c. Professional certifications

d.  Performance

e. Knowledge of computer languages

Question 11

What is the value of R-squared of this regression model?

Select one:

a. 62.7%

b. 79.2%

c.  8.96%

d. 64.7%

e.  45.4%

Answer 1