BUAD 2070-001/002 Computer Assignment 2 Fall 2017 Due Date: Oct. 23, 2017 Questions: I . Develop an estimated regression equation using Excel. What is the estimated regression equation? 2. What annual income would you estimated for an adult with 37 years

BUAD 2070-001/002

Computer Assignment 2

Fall 2017

Due Date: Oct. 23, 2017

Questions:

I . Develop an estimated regression equation using Excel. What is the estimated regression equation?

2. What annual income would you estimated for an adult with 37 years old, 12 years of education,

and 10 years of work?

3. Use the F test to determine the overall significance of the regression relationship. What is the pa

value? What is the conclusion at the 0.05 level of significance?

4. Write a short essay describing an impact of years of education and age on annual income using the

regression analysis output.

5. Attach your Excel output.

The accompanying table presents raw data on sample of 15 adults, where income is in dollars. Enter the

data into Excel and solve the problems using the multiple regression procedures.

Years of Education Years of Work Age Annual Income

X.2 Y (10000 Xi x3

15