Assignment 12

Using Spreadsheets

Page Bird

 

 

1. Construct a graph of any function y = f(x) by generating a table of values with the x values in one column and the y values in another.

For this assignment, I to chose to use two equations:


 

 


Using excel, I plug the first formula into the equation:

x

3x+5

-10

-25

-9

-22

-8

-19

-7

-16

-6

-13

-5

-10

-4

-7

-3

-4

-2

-1

-1

2

0

5

1

8

2

11

3

14

4

17

5

20

6

23

7

26

8

29

9

32

10

35

11

38

12

41

13

44

14

47

15

50

16

53

17

56

 

 

Next, using the chart function, I graphed the numbers to get this graph:


 


The other table looked like:

x

3x^2 + 5

-10

305

-9

248

-8

197

-7

152

-6

113

-5

80

-4

53

-3

32

-2

17

-1

8

0

5

1

8

2

17

3

32

4

53

5

80

6

113

7

152

8

197

9

248

10

305

11

368

12

437

13

512

14

593

15

680

16

773

17

872

And the graph looks like:

 


 

 

 


Click here to see the excel file.

 

EMAT 6680 Class Page for Page Bird