Answer all parts complete and correct to get 100% feedback!! NO USE OF EXCEL, ONLY USE MANUAL FORMULAS.

4. The owner of a firm is interested in finding out how education for his new hires interacts with sales. He is uncertain of the type of relationship that might exist and is wondering if he could hire less educated employees, thereby saving money on payroll, and still not have a reduction in sales levels. He has hired you to develop a Linear Regression Model and forecast sales for 8, 14, and 17 years of education. You have been provided the following data from HR and Accounting. Sales (1,000) Year's of Education 24 10 9 18 11 20 22 6 26 13 23 16 21 18