The excel file posted contains four sets of xy data Together

The excel file posted contains four sets of x-y data. Together, these data sets are known as Anscombes Quartet. Use both 1) Excel and 2) Minitab to find the best fit linear model (y=mx+b) for each set of data. Report the model, the RA2 value, SSE, and plots of each set of data (along with the linear fit). In Excel. use the full regression routine- not just the trendline function. below is the data that is given.

Excel result

Regression Analysis y1 with x1

Regression Analysis y1 with x1

	R

The excel file posted contains four sets of x-y data. Together, these data sets are known as Anscombes Quartet. Use both 1) Excel and 2) Minitab to find the be

The excel file posted contains four sets of xy data Together

Solution

Get Help Now

Submit a Take Down Notice