Question

Please show formulas in excel Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x 29 46 33 47 23 40 34 52 y 29 22 24 13 29 17 21 14 Complete parts (a) through (e), given Σx = 304, Σy = 169, Σx2 = 12,244, Σy2 = 3837, Σxy = 6045, and r ≈ −0.877. (a) Draw a scatter diagram displaying the data. Selection Tool Line Ray Segment Circle Vertical Parabola Horizontal Parabola Point No Solution Help 510152025303540455055605101520253035 Clear Graph Delete Layer Fill WebAssign Graphing Tool Graph LayersToggle Open/Closed Point 1 Remove This Layer Point 2 Remove This Layer Point 3 Remove This Layer Point 4 Remove This Layer Point 5 Remove This Layer Point 6 Remove This Layer Point 7 Remove This Layer Point 8 Remove This Layer Point 9 Remove This Layer Point 10 Remove This Layer (b) Verify the given sums Σx, Σy, Σx2, Σy2, Σxy, and the value of the sample correlation coefficient r. (Round your value for r to three decimal places.) Σx = Σy = Σx2 = Σy2 = Σxy = r = (c) Find x, and y. Then find the equation of the least-squares line y hat = a + bx. (Round your answers for x and y to two decimal places. Round your answers for a and b to three decimal places.) x = y = y hat = + x (d) Graph the least-squares line. Be sure to plot the point (x, y) as a point on the line. WebAssign Plot WebAssign Plot WebAssign Plot WebAssign Plot (e) Find the value of the coefficient of determination r2. What percentage of the variation in y can be explained by the corresponding variation in x and the least-squares line? What percentage is unexplained? (Round your answer for r2 to three decimal places. Round your answers for the percentages to one decimal place.) r2 = explained % unexplained % (f) Suppose a car weighs x = 34 (hundred pounds). What does the least-squares line forecast for y = miles per gallon? (Round your answer to two decimal places.)

Answer #1

a)

b)

ΣX = | 304.000 |

ΣY= | 169.000 |

ΣX^{2} = |
12244.000 |

ΣY^{2} = |
3837.000 |

ΣXY = | 6045.000 |

r = | -0.877 |

c)

X̅=ΣX/n = | 38.00 |

Y̅=ΣY/n = | 21.13 |

ŷ = | 41.827+-0.545x |

e)

coefficient of determination r^{2} = |
0.770 | |||

explained = | 77.0% | |||

unexplained= | 23.0% |

f)

predicted value =41.827+-0.545*34= | 23.30 |

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in hundreds of
pounds), and let y be the miles per gallon (mpg).
x2544344723403452
y3017271329172114
Complete parts (a) through (e), given Σx = 299, Σy = 168, Σx2 =
11,915, Σy2 = 3854, Σxy = 5816, and
r ≈ −0.943.
(a) Draw a scatter diagram displaying the data.
Selection Tool
Line
Ray
Segment
Circle
Vertical Parabola
Horizontal Parabola...

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in
hundreds of pounds), and let y be the miles per gallon
(mpg).
x
28
42
29
47
23
40
34
52
y
30
17
24
13
29
17
21
14
Complete parts (a) through (e), given Σx = 295,
Σy = 165, Σx2 = 11,587,
Σy2 = 3701, Σxy = 5650, and
r ≈ −0.945.
(a) Draw...

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in hundreds of
pounds), and let y be the miles per gallon (mpg). x 27 43 29 47 23
40 34 52 y 31 18 27 13 29 17 21 14 Complete parts (a) through (e),
given Σx = 295, Σy = 170, Σx2 = 11,617, Σy2 = 3950, Σxy = 5794, and
r ≈ −0.951. (a) Draw...

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in hundreds of
pounds), and let y be the miles per gallon (mpg). x 30 44 33 47 23
40 34 52 y 33 21 22 13 29 17 21 14 Complete parts (a) through (e),
given Σx = 303, Σy = 170, Σx2 = 12,123, Σy2 = 3950, Σxy = 6040, and
r ≈ −0.853.
(a) Draw...

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in
hundreds of pounds), and let y be the miles per gallon
(mpg).
x
27
46
30
47
23
40
34
52
y
30
20
25
13
29
17
21
14
Complete parts (a) through (e), given Σx = 299,
Σy = 169, Σx2 = 11,943,
Σy2 = 3861, Σxy = 5880, and
r ≈ −0.923.
(b) Verify...

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in hundreds of
pounds), and let y be the miles per gallon (mpg).
x
27
43
31
47
23
40
34
52
y
30
20
25
13
29
17
21
14
Complete parts (a) through (d), given Σx = 297, Σy = 169, Σx2 =
11,737, Σy2 = 3861, Σxy = 5845, and r ≈ −0.944.
(a) Verify...

Do heavier cars really use more gasoline? Suppose a car is
chosen at random. Let x be the weight of the car (in
hundreds of pounds), and let y be the miles per gallon
(mpg).
x
25
46
32
47
23
40
34
52
y
29
20
23
13
29
17
21
14
Complete parts (a) through (e), given Σx = 299,
Σy = 166, Σx2 = 11,963,
Σy2 = 3706, Σxy = 5781, and
r ≈ −0.932.
(c) Find...

You are the foreman of the Bar-S cattle ranch in Colorado. A
neighboring ranch has calves for sale, and you are going to buy
some calves to add to the Bar-S herd. How much should a healthy
calf weigh? Let x be the age of the calf (in weeks), and
let y be the weight of the calf (in kilograms).
x
1
5
8
16
26
36
y
44
53
71
100
150
200
Complete parts (a) through (e), given...

You are the foreman of the Bar-S cattle ranch in Colorado. A
neighboring ranch has calves for sale, and you are going to buy
some calves to add to the Bar-S herd. How much should a healthy
calf weigh? Let x be the age of the calf (in weeks), and let y be
the weight of the calf (in kilograms). x 3 3 9 16 26 36 y 41 51 78
100 150 200 Complete parts (a) through (e), given...

It is thought that basketball teams that make too many fouls in
a game tend to lose the game even if they otherwise play well. Let
x be the number of fouls more than (i.e., over and above) the
opposing team. Let y be the percentage of times the team with the
larger number of fouls wins the game. x 1 2 5 6 y 51 45 33 26
Complete parts (a) through (e), given Σx = 14, Σy =...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 6 minutes ago

asked 38 minutes ago

asked 43 minutes ago

asked 53 minutes ago

asked 57 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago