AutoSave (. Off ) f project mat115 - Compatibility Mode - Saved to this PC frank.munoz@live.lagcc.cuny.edu X File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do Share X Cut Gac Replace Paste Copy Arial + 12 ~ A A Aa- A - = + OF. . 21 9 AaBbCcl AaBbCc] AaBbCcl AaBbCc[ AaBbCc[ AaBbCcl AaBbCc AaBbC Find * Format Painter B I U - abe X2 X? A Z . A . = =$ 2. Body Text Heading 1 1 List Para... 1 No Spac... 1 Normal 1 Table Par... Heading 2 Title Select Clipboard Font Paragraph Styles Editing L to see flow much is the ILLA increasing witIn the next years . 2003 $2.00 0.07 2009 $2.25 0.04 2013 $2.50 0.06 2015 $2.75 0.13 Step 2: Scatter Plot ( 5pts) Do these values suggest a linear trend? Explain. These values it does represent a linear trend because the average rate of Use the following data provided in the table below to obtain a scatter plot change is high enough to create a line. of time vs. price. Describe the trend of the price in the plot. Do you find the trend shocking? I do find this trend shocking because it clearly shows how the MTA increased the fares in a tremendous way. As we can see how from 1970 to 1980 the price increased $0.30 dollars but from 1980 to 2003 the price increased $1.50 dollars which is a big difference since it took 23 years to Step 5: Linear Modeling (6 pts) increase $1.50 dollars but in a difference of 10 years is only $0.30 dollars Assuming that the trend is linear, generate a linear model. To make the calculation easier, rescale the time values for 2009 through 2015 in the above table. Time Line Price(dollars) 1970 $0.20 Let 2009 be the year 0. 1980 $0.50 2003 $2.00 P(dollars) 2009 $2.25 0 2.25 2013 $2.50 2.50 2015 $2.75 2.75 2 Page 1 of 6 861 words & English (United States) EO - + 72% O Type here to search MODEOF w ] A O ENG 2:24 PM 5/27/2019AutoSave (. Off ) f project mat115 - Compatibility Mode frank.munoz@live.lagcc.cuny.edu X File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do Share X Cut Arial - 12 ~ A A' Aa- A - =- 8. . 21 1 AaBbCcl AaBbCc] AaBbCcl AaBbCc[ AaBbCc[ AaBbCcl AaBbCc AaBbC Find * Gac Replace Paste Copy Format Painter BI U - abe X2 X? A Z . A . = =_. Body Text Heading 1 1 List Para... 1 No Spac... 1 Normal 1 Table Par... Heading 2 Title Select Clipboard Font Paragraph Styles Editing Using any two data points from the rescaled table develop a possible linear model of the above data by filling in the blanks in the following calculation. (c) Generate the linear model through EXCEL. (0, 2. 25) and (,) P = at + b P = at + ? a = ( )(- ) (d) Using this model predict the price in 2018. a = / a = P = 21 + ? (e) Using this model predict the price in 2018? (a) Predict the price in 2020 For 2018, t = 2 P = 2( ? ) + Step 7: Reflection ( 5 pts) ? P = What have you learned from this activity? What challenges did you face and how did you overcome them? What mathematical skills and knowledge did you use to complete this assignment? Did you need to look According to this model, the Price is expected to be about $ in the year back at any prior mathematical skills? Did you seek assistance from 2018 anyone and was it helpful? Compare the predictions that you get from the two models? Is your computed value a reasonable one to what the fare is currently? What are some of the pitfalls with this linear modeling procedure? Has this activity help you to better appreciate mathematics? How has this change your feeling about mathematics? Page 3 of 6 861 words & English (United States) + 72% O Type here to search MODeo O MENG 2:25 PM 5/27/2019