Engineering Statistics Excel Tutorial

A. Enter the data as two columns in an Excel spreadsheet. Consider the column of Shell Areas to be X and the Energy Consumption to be Y. In the cell beneath each column calculate the average value of each variable in fixed digit format with 1 decimal place. Calculate the regression slope and regression y intercept for this data. ................
................