166k views
1 vote
The data below shows brake weight (x, in grams) and retail price (y, in dollars) for a random sample of ten high-performance brakes used on racing bicycles. Use Excel to find the slope and y-intercept for the least squares regression line.

The data below shows brake weight (x, in grams) and retail price (y, in dollars) for-example-1

1 Answer

5 votes

The slope is 4.986 and the y-intercept is -327.399. The regression equation is y = 4.986x - 327.399.

To find the slope and y-intercept for the least squares regression line, we need to use Excel.

The slope is the coefficient of the independent variable (x), and the y-intercept is the constant term. Using Excel, we get:

Slope = 4.986

Y-Intercept = -327.399

Therefore, the slope is 4.986 and the y-intercept is -327.399 (rounded to three decimal places).

The regression equation is y = 4.986x - 327.399, where x is the brake weight (in grams) and y is the retail price (in dollars).

User Marko Previsic
by
9.1k points