# mat 110 exam excel.xlsx - There are two tabs to complete in...

• 5

This preview shows page 1 - 5 out of 5 pages.

x f(x) -10 7.29911 -8 10.73484 -6 15.6833 -4 22.69646 -2 32.41192 0 45.4555 2 62.24417 4 82.72721 6 106.1403 8 130.9906 10 155.3752 12 177.5277 14 196.287 16 211.2504 18 222.6266 20 230.9639 There are two tabs to complete in this Excel file. Be sure to complete both this tab and the other tab This is problem #1 where you will do the following: * Demonstrate your ability to create an input-output table of a function in Excel. * Demonstrate your ability to make a graph of a function in Excel. -15 -10 -5 0 5 10 15 20 25 0 50 100 150 200 250 f(x)
b! Instructions for Problem #1 : a) (1 point) Fill in cells A10 thru A25 with the x-values x = -10 up to x = 2 in increments of 2 units. So your x-values will be -10, -8, -6,...,16, 18, 20. They will end in cell A25. b) (5 points) Create a formula in cell B10 to define the function ?(𝑥)=250/(1+4.5𝑒^(−0.2𝑥) ) where the x-value is pulled from the cell A10. c) (1 point) Drag the formula down thru cell B25. d) (3 points) Create a smoothline graph of the function.
x f(x) -5 -323.56631163 -4 -254.161534043 -3 -186.841643953 -2 -121.839643908 -1 -59.4406285449
• • • 