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.

Copy and paste this data into an Excel file to get started.

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

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

Select one:

a. 911.25

b. 61.5

c. 0

d. 4

e. 43.7

What is the response variable in this regression model?

Select one:

a. Employee ID

b. Work experience

c. Professional certifications

d. Performance

e. Knowledge of computer languages

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

A. 62.7%

b. 79.2%

c. 8.96%

d. 64.7%

e. 45.4%

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Answer for Question 1 The standard devi... View the full answer