Must show all work please. a. Using Excel, plot the graph that shows the amount

Question

Must show all work please.

                                a.Using Excel, plot the graph that shows the amount of savings that you have in each of the years t= 0,1...20 That is, plot                                 St against t.                             

                                b.Using Excel, plot the graph of Ln(St) against t.                             

                                c.What can you say about the shape of the graph in part b? What is the exact slope of the graph in part b?                             

Explanation / Answer

a& b are in the excel file given below:

https://docs.google.com/file/d/0B4u66295jlpIMUJET20wNUFVb2s/edit

Please download and look at it...

c) The plot Ln(St) against 't ' is completely linear(staright line) as compared to St against t.

the slope in the graph is .0035 which is shown in excel...

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

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