# Please answer the whole question. (1) Let x be the age in years of a licensed automobile driver. Let y be the percentage of all fatal accidents (for a given age) due to speeding. For example, the first data pair indicates that 33% of all fatal accidents of 17-year-olds are due to speeding.x17273747576777y332822121075Complete parts (a) through (e), given Σx = 329, Σy = 117, Σx2 = 18,263, Σy2 = 2675, Σxy = 4119, and r ≈ −0.972. (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) Predict the percentage of all fatal accidents due to speeding for 35-year-olds. (Round your answer to two decimal places.) %

Question

(1) Let x be the age in years of a licensed automobile driver. Let y be the percentage of all fatal accidents (for a given age) due to speeding. For example, the first data pair indicates that 33% of all fatal accidents of 17-year-olds are due to speeding.

 x 17 27 37 47 57 67 77 y 33 28 22 12 10 7 5

Complete parts (a) through (e), given

Σx = 329, Σy = 117, Σx2 = 18,263, Σy2 = 2675, Σxy = 4119, and r ≈ −0.972.

(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) Predict the percentage of all fatal accidents due to speeding for 35-year-olds. (Round your answer to two decimal places.)
%
Step 1

(e) The value of coefficient of determination:

The given data is represented in the following table:

Step 2

The value of coefficient of determination can be obtained using EXCEL. Enter the values of x and y in two columns, say in columns A and B in an EXCEL sheet, with the first cell containing the data labels, x and y. Then, follow the procedure given below:

• Go to Data > Data Analysis > Regression.
• Enter Input Y Range as \$B\$2:\$B\$9 and Input X Range as \$A\$2:\$A\$9.
• Click OK.

The output is as follows:

Step 3

From the EXCEL output, the value of coefficient of determination is R-square is 0.945. That is, 94.5% of the variation in y can be...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in