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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started