Question: This exercise will use the data file Gala.xls. Description of the Data : The file contains data from a fictitious case of United States Department
This exercise will use the data file Gala.xls.
Description of the Data: The file contains data from a fictitious case of United States Department of Treasury v. Gala Trust and Savings Bank. The data include the monthly salary of 80 employees of the bank (SALARY) in dollars and their corresponding educational level (EDUCAT).
Regress SALARIES on EDUCAT. Which of the following statements is false according your regression results? (round your results to two decimals)
(a)Each additional year of education increases the predicted monthly salary by $96.79.
(b)Education explains approximately 12.04% of the variation in monthly salaries.
(c)Education is statistically significant at a 1% significance level.
(d)Education is statistically significant at a 5% significance level.
(e)None of the above.
Salary 4800.00
Educat 12.00
4800.00
12.00
4800.00
12.00
4800.00
12.00
4800.00
12.00
4800.00
12.00
4800.00
12.00
4800.00
12.00
4800.00
16.00
4980.00
8.00
5100.00
8.00
5100.00
12.00
5100.00
12.00
5100.00
15.00
5100.00
15.00
5100.00
16.00
5160.00
12.00
5220.00
8.00
5220.00
12.00
5280.00
8.00
5280.00
8.00
5280.00
12.00
5400.00
8.00
5400.00
8.00
5400.00
12.00
5400.00
12.00
5400.00
12.00
5400.00
12.00
5400.00
12.00
5400.00
12.00
5400.00
15.00
5400.00
15.00
5400.00
15.00
5400.00
15.00
5520.00
12.00
5520.00
12.00
5580.00
12.00
5640.00
12.00
5700.00
12.00
5700.00
12.00
5700.00
15.00
5700.00
15.00
5700.00
15.00
6000.00
12.00
6000.00
15.00
6120.00
12.00
6300.00
12.00
6300.00
15.00
4620.00
12.00
5040.00
15.00
5100.00
12.00
5100.00
12.00
5220.00
12.00
5400.00
12.00
5400.00
12.00
5400.00
12.00
5400.00
15.00
5400.00
15.00
5700.00
15.00
6000.00
8.00
6000.00
12.00
6000.00
12.00
6000.00
12.00
6000.00
12.00
6000.00
12.00
6000.00
12.00
6000.00
15.00
6000.00
15.00
6000.00
15.00
6000.00
15.00
6000.00
15.00
6000.00
16.00
6300.00
15.00
6600.00
15.00
6600.00
15.00
6600.00
15.00
6840.00
15.00
6900.00
12.00
6900.00
15.00
8100.00
16.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help