Statistics Multiple Regression Analysis Salary

Statistics Multiple Regression Analysis

Use the dataset labeled "GenderBias2.xls" to answer questions 1 through 9.

Question 1

Use the Regression function in Excel (part of the Data Analysis toolpack) to estimate the effect Experience (in years), Female (1 = female, 0 = male) and Business Degree (1 = business major) have on a worker's salary (in thousand $s).

What is the r-squared for the regression?

Select one:

a. 0.96

b. 0.93

c. 0.91

d. 0.10

Question 2

What is the regression sum of squares (SSR)?

Select one:

a. 7434

b. 549

c. 6884

d. 2294

Question 3

When testing whether the regression equation is significant at the 0.05 level, what is the test statistic?

Select one:

a. 108.60

b. 0.93

c. 15.22

d. -7.36

Question 4

Is the regression equation significant at the 0.05 level?

Select one:

a. Yes

b. No

c. I need more information to answer this correctly.

Question 5

Which variable(s) significantly affect salary at the 0.05 level?

Select one:

a. Female

b. Female, Experience

c. Experience

d. Female, Experience, Business Degree

Question 6

Choose the correct interpretation for the coefficient for the variable Female.

Select one:

a. If Female inceases by 1 unit, the worker's salary increases by $8.82.

b. The predicted salary for a female worker without any experience is $12,999 LESS than a male worker without any experience.

c. For every level of experience a women's salary is $15,000

d. As a worker's experience increases the salary gap between men and women decreases.

Question 7

What is the predicted effect of gaining one more year of experience on a worker's salary?

Select one:

a. We predict the worker would increase his or her salary by $4,265

b. We would predict no significant increase in salary

c. We predict the worker would increase his or her salary by $32,213

d. We predict the worker would increase his or her salary by $4,799

Question 8

Do business majors earn significantly higher starting salaries compared to non business majors at the 0.10 significance level?

Select one:

a. No

b. Yes

Question 9

Predict the salary for a Female worker with an English degree and 4 years of experience. (Use 4 decimal places in your calculations)

Select one:

a. $39, 329

b. $32, 761

c. $34, 986

d. $39,500

Question 10

What is inferential statistics (i.e., the objective of his course)?

Select one:

a. Inferential statistics is all about organizing and presenting data.

b. Inferential statistics is when you don't have any data so you just infer what the data should look like.

c. Inferential statistics describes using sample data to make inferences about unknown population parameters.

d. Inferential statistics is using population datasets to test hypotheses about smaller sample datasets.