Applied Calculus Spring 2017 Sitaraman 3-7-2017 Extra Credit Project Work on the

Question

Applied Calculus Spring 2017 Sitaraman 3-7-2017 Extra Credit Project Work on the following and answer my questions in office by 3/22/2017 2pm Extra credit 200 points All the problems in this project refer to the Excel chart given on update page. Please watch the tutorial if you want to know how to use Excel You don't really need to use Excel if you don't want to, but you will need the data from that chart. Excel is a basic tool in the business world, so it would help you to learn it 1. For each value of the seven values of r, approximate the slope of the tangent at r by calculating slope with three nearby values of z and taking their average. For example, for 2009, 1. Use the slope formula to find the slope between (1,7.5) and (2,5.8), (1,7.5) and (3,4.7) and finally (1,7.5) and (4,3.6). Take the average of the three slopes. Call this average si. Similarly calculate s2, s3, ST. 2. For each of the seven values of r, approximate the rate of change of the slope of the tangents by calculating slope with three nearby values of slopes calculated in (a) and and taking their average. For example, if we call the seven answers from (a) to be si, s2, ST, then for 2009,use the slope formula (4,84). Take the average of the three rates of change of slopes

Explanation / Answer

I am attaching all the Excel Sheet Data here. It contains all the information.

Year X Y Slope 1 Slope 2 Slope 3 Slope s1 s2 s3 Rate of Change of Slope 2009 1 7.5 -1.7 -1.4 -1.3 -1.46667 0.422222 0.275 0.298148 0.331790123 2010 2 5.8 -1.1 -1.1 -0.93333 -1.04444 0.127778 0.236111 0.292593 0.21882716 2011 3 4.7 -1.1 -0.85 -0.8 -0.91667 0.344444 0.375 0.37963 0.366358025 2012 4 3.6 -0.6 -0.65 -0.46667 -0.57222 0.405556 0.397222 0.295503 0.366093474 2013 5 3 -0.7 -0.4 0.6 -0.16667 0.388889 0.240476 -0.03333 0.198677249 2014 6 2.3 -0.1 0.383333 0.383333 0.222222 0.092063 0.037037 0.037037 0.055379189 2015 7 2.2 0.314286 0.314286 0.314286 0.314286 0.044898 0.044898 0.044898 0.044897959

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.