graph

Document Sample
graph Powered By Docstoc
					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