b. residuals against predicted y to check constant variability. do you have constant variability? the data is in the residuals sheet. copy and paste the predicted y and the residuals values next to each other with the predicted values series first. highlight both of those data series and use insert - scatter plot.
