twhalon72
twhalon72
25.01.2021 • 
Mathematics

The total amount in millions of dollars, M, spent by the federal government on mathematics research is given below, where t is the years since 1980. t 0 1 2 3 4 5 6 7 8 9 10 M 91 118 128 134 151 184 185 205 212 230 245 (A) Createagraphofthedata. labels. (B) Use theTrendlinefeature ofExcel to determine the equation of the regression line modelforthedata. (C) . (D) State the y-intercept of the model and interpret its meaning in context of the problem. (E) Use the model to predict the amount spent for mathematics research in 1995. (F) Use Goal Seek to predict in what year the expenditures will reach $0.5 billion dollars.

Solved
Show answers

Ask an AI advisor a question