6. [12 Points] An individual's income varies with age. The table shows the median income I of in

Step 1: Calculate the quadratic function of best fit using the given data points in Excel or a c

Question

6. [12 Points] An individual's income varies with age. The table shows the median income I of individuals of different age groups within the United States for a certain year. For each age group, let the class midpoint represent the independent variable x. For the class "65 years and older," assume that the class midpoint is 69.5. Age | Class Midpoint, x | Median Income, I 15-24 years | 19.5 | $10,963.00 25-34 years | 29.5 | $32,131.00 35-44 years | 39.5 | $41,636.00 45-54 years | 49.5 | $44,692.00 55-64 years | 59.5 | $41,477.00 65 years and older | 69.5 | $23,500.00 (a) Using Excel, find the quadratic function of best fit the median income with respect to class midpoint age. (b) Use the function found in part (a) to determine the age at which an individual can expect to earn the most income.

          6. [12 Points] An individual's income varies with age. The table shows the median income I of individuals of different age groups within the United States for a certain year. For each age group, let the class midpoint represent the independent variable x. For the class "65 years and older," assume that the class midpoint is 69.5.

Age | Class Midpoint, x | Median Income, I
15-24 years | 19.5 | $10,963.00
25-34 years | 29.5 | $32,131.00
35-44 years | 39.5 | $41,636.00
45-54 years | 49.5 | $44,692.00
55-64 years | 59.5 | $41,477.00
65 years and older | 69.5 | $23,500.00

(a) Using Excel, find the quadratic function of best fit the median income with respect to class midpoint age.
(b) Use the function found in part (a) to determine the age at which an individual can expect to earn the most income.

6. [12 Points] An individual's income varies with age. The table shows the median income I of individuals of different age groups within the United States for a certain year. For each age group, let the class midpoint represent the independent variable x. For the class "65 years and older," assume that the class midpoint is 69.5.

Age | Class Midpoint, x | Median Income, I
15-24 years | 19.5 | 10,963.00
25-34 years | 29.5 |32,131.00
35-44 years | 39.5 | 41,636.00
45-54 years | 49.5 |44,692.00
55-64 years | 59.5 | 41,477.00
65 years and older | 69.5 |23,500.00

(a) Using Excel, find the quadratic function of best fit the median income with respect to class midpoint age.
(b) Use the function found in part (a) to determine the age at which an individual can expect to earn the most income.

Added by Steven M.

Question

Please give Ace some feedback