Please help with answers and what to do on excel file need soon thanks

management information systems

5. The result helps you find the sample regression equation: Predicted Salary =Be+B1= Education The summary output shows three tables. Please pay special attention to the bolded items. 1) Based on the R Square value, how much variance in Salary can be explained by Education? 2) What are the B and B4 values? (The values can be found in the third table in the summary output.) 3) How many years of higher Education do you have? (Thib is based on your case. Different students will have different answers, for example, a eraduating senior may have 3.5 years of higher education.) 4) Based on your answers to 2) and 3), predict your solary using the equation: Predicted Salary =B0+B+ Education What is your predicted salary (in \$1,000s)? Note: Please pay attention to the arder of operations: muliplication first and then addition 1) Based on the R Square value, how much variance in Salary can be explained by Education? 2) What are the B0 and B2 values? (The values can be found in the third table in the summary output) 3) How many years of higher Education do you have? (This is based on your case. Different students will have different answers. For example, a graduating senior may have 3.5 years of higher education.) WI AM STARTING MY JUNIOR YEAR AFTER THIS SEMESTER 4) Based on your answers to 2) and 3), predict your salary using the equation: Predicted Salary =B0+B1 Education What is your predicted salary (in $1,000 s)? Note: Please pay attention to the order of operations: multiplication first and then addition. Page 2 of 3 Predicted Salary =B0+B1 Education is the same as: Predicted Salary =B0+(B1 Education ) 7. Submit your completed Excel file Please note: Your assignment grade is based on the completed Excel file AND your answers to step 6