{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# hw-excel-1 - the slope from the previous point to this...

This preview shows page 1. Sign up to view the full content.

Excel Homework 1 Please use one sheet (Sheet1, Sheet2, Sheet3) per question (A,B,C) Question A: Using Excel or some other spreadsheet, i) graph f(x) = (x+3)(x+1)(x-2)(x-5) on the x range [-4,6] in steps of 0.1. ii) Also graph its approximate derivative the way we did in class, by taking the slope from the previous point to this point. iii) Write a sentence (you may type it in a cell) that describes how you verify that the curve in part (ii) is indeed the approx. deriv. of f(x). Include approximate particular values of x and f'(x) as evidence. iv) Why might you not want to take the derivative "by hand" and plot that? v) (optional) can you think of a slightly sneaky way to take the deriv. by hand? Question B: Using Excel or some other spreadsheet, i) graph f(t) = 500-200 cos(2 pi t/24) - 100 cos(2*2 pi t/24) on the t range [0,24] in steps of 0.1 Remember that you use pi() to get the value of pi in Excel. ii) Also graph its approximate derivative the way we did in class, by taking
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the slope from the previous point to this point. iii) Write a sentence (you may type it in a cell) that describes how you verify that the curve in part (ii) is indeed the approx. deriv. of f(t). Include approximate particular values of t and f'(t) as evidence. Question C: Using Excel or some other spreadsheet, i) Graph f(x) = sin(x) on the x range [0,7] in steps of 0.1 ii) Also compute its approximate derivative the way we did in class, by taking the slope from the previous point to this point. iii) Now compute the 2nd derivative by the same method: using the approximate-derivative column as your "y" values, compute the slope from the previous point to this point. iv) Graph all 3 data sets (f, f', f'') on the same graph. v) Write a sentence (you may type it in a cell) that describes how you verify that your 2nd-derivative computation worked....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online