Question

Given are data for two variables, x and y.

xi	6	11	15	18	20
yi	5	9	12	21	30

(a)

Develop an estimated regression equation for these data. (Round your numerical values to two decimal places.)

ŷ =

1.66x−7.82

(b)

Compute the residuals. (Round your answers to two decimal places.)

xi	yi	Residuals
6	5
11	9
15	12
18	21
20	30

(c)

Develop a plot of the residuals against the independent variable x.

A residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 25 and is labeled: x. The vertical axis ranges from −6 to 6 and is labeled: Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points start above the line at x = 6 in the upper left corner of the plot, then are plotted from left to right in a downward, diagonal direction until reaching a low below the line at x = 15. They then continue to be plotted in an upward diagonal direction until reaching a high above the line at x = 20. The maximum residual is located at x = 20.

A residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 25 and is labeled: x. The vertical axis ranges from −6 to 6 and is labeled: Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points are plotted from left to right in an upward, diagonal direction starting from the lower left corner of the plot. The minimum residual is located at x = 6 and the maximum occurs at x = 20.

A residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 25 and is labeled: x. The vertical axis ranges from −6 to 6 and is labeled: Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points start above the line at x = 6 in the upper left corner of the plot, then are plotted from left to right in a downward, diagonal direction until reaching a low below the line at x = 15. They then continue to be plotted in an upward diagonal direction until reaching a high above the line at x = 20. The maximum residual is located at x = 6.

A residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 25 and is labeled: x. The vertical axis ranges from −6 to 6 and is labeled: Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points are plotted from left to right in a downward, diagonal direction starting from the upper left corner of the plot. The maximum residual is located at x = 6 and the minimum occurs at x = 20.

Do the assumptions about the error terms seem to be satisfied?

The plot suggests a funnel pattern in the residuals indicating that the error term assumptions are not satisfied.The plot suggests a generally horizontal band of residual points indicating that the error term assumptions are not satisfied.    The plot suggests curvature in the residuals indicating that the error term assumptions are not satisfied.The plot suggests a generally horizontal band of residual points indicating that the error term assumptions are satisfied.The plot suggests curvature in the residuals indicating that the error term assumptions are satisfied.

(d)

Compute the standardized residuals. (Round your answers to two decimal places.)

xi	yi	Standardized Residuals
6	5
11	9
15	12
18	21
20	30

(e)

Develop a plot of the standardized residuals against ŷ.

A standardized residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 30 and is labeled: y hat. The vertical axis ranges from −3 to 3 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 3 points lie above the line and 2 lie below it. The points start below the line at about y hat = 2 in the lower left corner of the plot, then are plotted from left to right in an upward, diagonal direction until reaching a high above the line at about y hat = 17. They then continue to be plotted in a downward, diagonal direction until reaching a low below the line at about y hat = 25.

A standardized residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 30 and is labeled: y hat. The vertical axis ranges from −3 to 3 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points are plotted from left to right in an upward, diagonal direction starting from the lower left corner of the plot. The points are between 2 to 26 on the horizontal axis and between −1.3 to 1.5 on the vertical axis.

A standardized residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 30 and is labeled: y hat. The vertical axis ranges from −3 to 3 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points are plotted from left to right in a downward, diagonal direction starting from the upper left corner of the plot. The points are between 2 to 26 on the horizontal axis and between −1.3 to 1.5 on the vertical axis.

A standardized residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 30 and is labeled: y hat. The vertical axis ranges from −3 to 3 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points start above the line at about y hat = 2 in the upper left corner of the plot, then are plotted from left to right in a downward, diagonal direction until reaching a low below the line at about y hat = 17. They then continue to be plotted in an upward diagonal direction until reaching a high above the line at about y hat = 25.

What conclusions can you draw from this plot?

The standardized residual plot has the same shape as the original residual plot. The plot suggests curvature in the residuals indicating that the error term assumptions are not satisfied.The standardized residual plot has the same shape as the original residual plot. The plot suggests a generally horizontal band of residual points indicating that the error term assumptions are not satisfied.    The standardized residual plot has a different shape than the original residual plot. The plot suggests a generally horizontal band of residual points indicating that the error term assumptions are satisfied.The standardized residual plot has a different shape than the original residual plot. The plot suggests curvature in the residuals indicating that the error term assumptions are satisfied.The standardized residual plot has a different shape than the original residual plot. The plot suggests a funnel pattern in the residuals indicating that the error term assumptions are not satisfied.

Answer 1

Sol:

install analysis toolpak in excel

Go to Data>Data analysis>Regression

select X as X

selectr Y as Y

Click ok

we get

From ouptut:

ANSWER(A)

y^=-7.82+1.66x

ANSWER(B)

ANSWER(C)

A residual plot has 5 points plotted on it. The horizontal axis ranges from 0 to 25 and is labeled: x. The vertical axis ranges from −6 to 6 and is labeled: Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. 2 points lie above the line and 3 lie below it. The points start above the line at x = 6 in the upper left corner of the plot, then are plotted from left to right in a downward, diagonal direction until reaching a low below the line at x = 15. They then continue to be plotted in an upward diagonal direction until reaching a high above the line at x = 20. The maximum residual is located at x = 6.

The plot suggests a funnel pattern in the residuals indicating that the error term assumptions are not satisfied

ANSWER(D)

ANSWER(E)