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