Statistics
First, download the dataset MHA610_Week 5_Discussion_Regression_Data.xls. This is a simple Excel workbook, with data on one sheet. There are eight columns of data, with headings X1, Y1, X2, Y2, X3, Y3, X4, Y4. Import the data into Statdisk using the MHA610_Week 5_Discussion_Regression_Data.CSV file, and perform the following analyses.
•Calculate the regressions of Y1 on X1, Y2 on X2, Y3 on X3, and Y4 on X4, and compare the results (summary statistics). Explain what, if anything, you find unusual about these results.
•Plot each set of data, along with the fitted regression line. Describe what the graphs tell you about the relationships between the X’s and the Y’s.
•Explain what lessons you draw from this exercise.