how do i draw this graph in excel?

Question

y = 2x*2 - 10 x 8

(*2 = squared)

Answer 1

Microsoft Excel is not a graphing program, so this will be a mess.



First of all, you should come up with a suitable x-range.



I think x = -1 to x = 6 is good, since the roots are 1 and 4. You can find the roots by simply factoring y = 2(x-4)(x-1).



Now, you need a column of x-values first.



In the first cell of the first column, type -1.



Now, what's the next x value? You need a small step, like 0.1.



So the next one is -0.9. Type that in under the -1.



Then simply highlight both cells, click the bottom right corner of the highlighted region, and drag down. It should make a list of all the numbers -1 through 6, with a step of 0.1.



Now go to the very top of the second column. A1 is your x value, so in B1 you'll need to type:



= 2*A1*A1-10*A1+8



That should give you an entry with value 20. Drag that one down the same distance, so you have two equal columns.



Highlight all the data now (both columns, all rows). Click on the graph icon (it has a bar-chart on it). Select a XY (scatter) graph, and choose the second row, second item (two curves without points). It should read "Scatter with data by smoothed lines without markers." Hit Next.



Hit Next again.



Give the chart a title, labels, etc. if you want them. Hit Next.



Choose where to put the object, and hit Finish.



Here is an example:



http://math.colgate.edu/~kellen/interspace/excel-sucks-for-graphing.xls

Answer 2

First pick a range, say x = 0 - 10



Make two columns (x and y). Note: they must be next to each other, i.e. Column A and B



in the x column:

put 0 in the first cell

put .1 in the second cell

now highlight the two cells and drag the lower right hand corner down untill you reach 10



in the y column :



first cell type: =2*(col1)^2 - 10*(col1) + 8

now double click the lower right hand corner of the first cell. ( all of the cells should fill upto x = 10 should fill with the equation.



Now highlight both columns and press the chart button at the top. If chart button is not on toolbar press inset tab at top and the chart option will be there.



Now select scatter plot, then select The picture that has dots connected with curved lines.







label chart ifyou want too



click nexted then finish.

Answer 3

i'm notably solid with Excel, yet do no longer understand of any way do do this. you are able to set the axis to a logarithmic scale, yet to no longer a ratio ( to the superb of my wisdom). in case you had to bypass to a hell of a great form of artwork, you may make distinctive graphs with diverse scales, turn them into jpg records, drag them into notice...and then crop each and every person all the way down to a sprint skinny vertical sliver, postion all of them section by skill of section in the needed order, then create the x-axis labeling by skill of utilising a "textboix" drawing merchandise floating in front of & under the image slices. yet, that ought to in basic terms be tried in case you're smitten by skill of having this ratio-esque scale visual attraction. solid success. :-)