Math 115 Lab #2
M. Flashman
Introduction to Excel.
Tables in a spreadsheet
A: x is 5
to -5 in 10 steps ( size of 1)
B: y is = 3*x + 1
C: y =
-2x2
- 8x +3 = -2*x^2 - 8*x + 3
Record
your answers for the next work and submit them on Moodle by Wednesday,
Feb 3.
Use a speadsheet to find the
largest value of y in each of the following:
- y = -5x2
- 10x + 4 with x between
-5 and 5.
- y = -x2 +
4x + 4 with x
between -5 and 5.
Scatter Plot of data
with Excel.
Reverse variables!
Winplot:
- Equa
Menu _
- Plot an equation
:
- explicit... y = f(x)
- example: f(x) =
-2x^2-8x+3
The Inventory :
Inventory... Ctrl
I
Record
your answers for the next work and submit them on Moodle by Wednesday, Feb
3.
- Use winplot to look
for the largest value of y in each of the following:
- y = -5x2
- 3x + 4 with x between
-5 and 5.
- y = -5x2
- 6x + 4 with x between -5 and 5.
- One Function
Menu
- Slider...
- function
choice
- the "slider"
[used for tracing and finding values of f(x).]
- Extremes...