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 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
• Table
• Params
• family

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 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...