Answer
Scatterplot is appended below. Red line is the least-squares line without Hawaiian and Frontier Airlines while blue line is with Hawaiian and Frontier Airlines.
Least squares equation with Hawaiian and Frontier Airlines: $\hat y = -0.1458x + 21.036 = -0.1458 (79.1) + 21.036$ = 11.65% delays
Least squares equation without Hawaiian and Frontier Airlines: $\hat y = -0.0373x + 17.474 = -0.0373 (79.1) + 17.474 = $ 20.42% delays
From above we can conclude that Hawaiian and Frontier Airlines are very influential for least squares line.
Work Step by Step
Insert scatterplot in Excel using given data and then display line and equation on the chart using options.
