graph

Document Sample

```					Graph of the equation y = ax² + bx + c

Change the values of a, b and c
using the scroll bars to see what
happens.
x      y          a=     8
-5          212    b=     6

-4.9   204.68      c = 42
-4.8   197.52
-4.7   190.52
-4.6   183.68
-4.5     177
-4.4   170.48
-4.3   164.12
-4.2   157.92
-4.1   151.88
-4      146
-3.9   140.28                                -6     -4    -2
-3.8   134.72
-3.7   129.32
-3.6   124.08
-3.5        119                   To learn about Excel and construct this she
-3.4   114.08                     for yourself click on the DIY tab.
-3.3   109.32
-3.2   104.72
-3.1   100.28
-3        96
-2.9    91.88
-2.8    87.92
-2.7    84.12
-2.6    80.48
-2.5       77
-2.4    73.68
-2.3    70.52
-2.2    67.52
-2.1    64.68
-2        62
-1.9    59.48
-1.8    57.12
-1.7    54.92
-1.6    52.88
-1.5       51
-1.4    49.28
-1.3    47.72
-1.2    46.32
-1.1    45.08
-1        44
-0.9    43.08
-0.8    42.32
-0.7    41.72
-0.6    41.28
-0.5       41
-0.4    40.88
-0.3    40.92
-0.2    41.12
-0.1    41.48
0        42
0.1    42.68
0.2    43.52
0.3    44.52
0.4    45.68
0.5       47
0.6    48.48
0.7    50.12
0.8    51.92
0.9    53.88
1        56
1.1    58.28
1.2    60.72
1.3    63.32
1.4    66.08
1.5       69
1.6    72.08
1.7    75.32
1.8    78.72
1.9    82.28
2        86
2.1    89.88
2.2    93.92
2.3    98.12
2.4   102.48
2.5     107
2.6   111.68
2.7   116.52
2.8   121.52
2.9   126.68
3      132
3.1   137.48
3.2   143.12
3.3   148.92
3.4   154.88
3.5     161
3.6   167.28
3.7   173.72
3.8   180.32
3.9   187.08
4      194
4.1   201.08
4.2   208.32
4.3   215.72
4.4   223.28
4.5     231
4.6   238.88
4.7   246.92
4.8   255.12
4.9   263.48
5      272
300

250

200

150

100

50

0
-2         0   2        4   6

t Excel and construct this sheet
lick on the DIY tab.
Graph of the equation y = ax² + bx + c              Instructions for the basic desi
In A2 type x          In B2 type y
Type a in D2, b in D4, c in D6
Type any number in E2, E4, and E6. I suggest 1 to begin w
Name E2 'a' by clicking in E2. In the name box type a and p

Name E4 b and E6 d, yes d not c as you cannot use c as a
If you make a mistake go to the Formulas Tab > Name Man

We need to fill column A with a series of values for x, from
To do this we use the Fill function.
in A3 type - 5 (that's minus 5) (Enter)
On the Home Tab click the arrow box on the right - see pic
Select Series > Series in columns with Step value 0.1 Stop

Name the range A3 to A153 x. We need to start by highligh
To highlight A3 to A153 click in A3 scroll to A153, hold dow
Now type x in the Name box and press Enter.
in B3 enter the formula = a*x^2+b*x+d
Double click on the drag handle to fill to the bottom of the

Highlight A3 to B153
Draw a scatter plot of the points using the Insert tab >Scat
Use the second icon down - Scatter with Smooth Lines

Drag the chart to the top.
Delete grid lines and Series box by clicking on each and hi

To draw the Spinner, you need the Developer Tab in the rib
Under the Office Button , click on Excel Options at the bott
Click in the box saying Show Developer Tab in the Ribbon

Under the Developer Tab click on Insert (under the Toolkit
Select the spinner icon

Using the crosshairs draw out a spinner box in F2
Right click on the spinner; select Format Control
Accept the default settings but place E2 in the cell link box
Try it out

Create spinners for b and c; it is easiest to Copy and Paste

Finally hide the x and y columns by highlighting them, and
Format a, b and c appropriately.
For the version on the first sheet make the background an

Use superscript font to get the ² See the Font Tab on the H
nstructions for the basic design.
In B2 type y           Centre these.

umber in E2, E4, and E6. I suggest 1 to begin with.
by clicking in E2. In the name box type a and press enter.

and E6 d, yes d not c as you cannot use c as a name.
a mistake go to the Formulas Tab > Name Manager and delete the wrong name.

Put the x, from –5 to 10 A3.
fill column A with a series of values forcursor back into in steps of 0.1.
we use the Fill function.
5 (that's minus 5) (Enter)
me Tab click the arrow box on the right - see picture
es > Series in columns with Step value 0.1 Stop value 10. OK

ange A3 to A153 x. We need to start by highlighting A3 to A153.
in A153.
t A3 to A153 click in A3 scroll to A153, hold down the Shift key then click drag handle
in the Name box and press Enter.
the formula = a*x^2+b*x+d
k on the drag handle to fill to the bottom of the column.

ter plot of the points using the Insert tab >Scatter
ond icon down - Scatter with Smooth Lines

lines and Series box by clicking on each and hitting the Delete key.

Spinner, you need the Developer Tab in the ribbon
Office Button , click on Excel Options at the bottom
box saying Show Developer Tab in the Ribbon

Developer Tab click on Insert (under the Toolkit icon)

rosshairs draw out a spinner box in F2
on the spinner; select Format Control
default settings but place E2 in the cell link box, OK.

ners for b and c; it is easiest to Copy and Paste the first one, then change the cell link.

the x and y columns by highlighting them, and making the text white.
b and c appropriately.
sion on the first sheet make the background and text yellow using

cript font to get the ² See the Font Tab on the Home Ribbon.
Graph of the equation y = ax² + bx + c         or y=    32 x² + 17 x +
4000
Change the values of a, b and c
using the scroll bars to see what                        3500

happens.
3000
x      y          a = 32
2500
-5          720    b = 17
2000
-4.9   690.02      c= 5
-4.8   660.68                                          1500
-4.7   631.98
-4.6   603.92
1000
-4.5    576.5
-4.4   549.72
-4.3   523.58                                           500
-4.2   498.08
-4.1   473.22                                             0
-4      449                           -10       -5           0   5
-3.9   425.42
-3.8   402.48
-3.7   380.18
-3.6   358.52 For the finishing touch rewrite the equation above the graph
-3.5    337.5 Click on the cells I1 to M1 to see how I have linked them to a,b and
-3.4   317.12 I have had to name a as ab etc to avoid confusing Excel with two ide
-3.3   297.38
-3.2   278.28
-3.1   259.82
-3      242
-2.9   224.82
-2.8   208.28
-2.7   192.38
-2.6   177.12
-2.5    162.5
-2.4   148.52
-2.3   135.18
-2.2   122.48
-2.1   110.42
-2        99
-1.9    88.22
-1.8    78.08
-1.7    68.58
-1.6    59.72
-1.5     51.5
-1.4    43.92
-1.3    36.98
-1.2    30.68
-1.1    25.02
-1        20
-0.9    15.62
-0.8    11.88
-0.7     8.78
-0.6     6.32
-0.5      4.5
-0.4     3.32
-0.3     2.78
-0.2     2.88
-0.1     3.62
0         5
0.1     7.02
0.2     9.68
0.3    12.98
0.4    16.92
0.5     21.5
0.6    26.72
0.7    32.58
0.8    39.08
0.9    46.22
1        54
1.1    62.42
1.2    71.48
1.3    81.18
1.4    91.52
1.5    102.5
1.6   114.12
1.7   126.38
1.8   139.28
1.9   152.82
2      167
2.1   181.82
2.2   197.28
2.3   213.38
2.4   230.12
2.5    247.5
2.6   265.52
2.7   284.18
2.8   303.48
2.9   323.42
3      344
3.1   365.22
3.2   387.08
3.3   409.58
3.4   432.72
3.5    456.5
3.6   480.92
3.7   505.98
3.8   531.68
3.9   558.02
4      585
4.1   612.62
4.2   640.88
4.3   669.78
4.4   699.32
4.5    729.5
4.6   760.32
4.7    791.78
4.8    823.88
4.9    856.62
5       890
5.1    924.02
5.2    958.68
5.3    993.98
5.4   1029.92
5.5    1066.5
5.6   1103.72
5.7   1141.58
5.8   1180.08
5.9   1219.22
6      1259
6.1   1299.42
6.2   1340.48
6.3   1382.18
6.4   1424.52
6.5    1467.5
6.6   1511.12
6.7   1555.38
6.8   1600.28
6.9   1645.82
7      1692
7.1   1738.82
7.2   1786.28
7.3   1834.38
7.4   1883.12
7.5    1932.5
7.6   1982.52
7.7   2033.18
7.8   2084.48
7.9   2136.42
8      2189
8.1   2242.22
8.2   2296.08
8.3   2350.58
8.4   2405.72
8.5    2461.5
8.6   2517.92
8.7   2574.98
8.8   2632.68
8.9   2691.02
9      2750
9.1   2809.62
9.2   2869.88
9.3   2930.78
9.4   2992.32
9.5    3054.5
9.6   3117.32
9.7   3180.78
9.8   3244.88
9.9   3309.62
10      3375
5

10      15

on above the graph
have linked them to a,b and c.
confusing Excel with two identical names in a workbook.

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 6 posted: 10/19/2011 language: English pages: 52