Prepare a 3-page report using Excel as your processingtool to process 3 simple regression analyses. Create a graph withthe trendline displayed for each of the 3 differentregressions.
1.First run a regression analysis using the BENEFITS column of alldata points in the AIU data set as the independent variable and theINTRINSIC job satisfaction column of all data points in the AIUdata set as the dependent variable.
2.Run a regression analysis using the BENEFITS column of all datapoints in the AIU data set as the independent variable and theEXTRINSIC job satisfaction column of all data points in the AIUdata set as the dependent variable.
3.Run a regression analysis using the BENEFITS column of all datapoints in the AIU data set as the independent variable and theOVERALL job satisfaction column of all data points in the AIU dataset as the dependent variable.
4.Then answer the following questions: