when using excel for maths could some one tell me exactly how you type in the formula y=4x^3-3x^2+2x-1 to plot a graph using correct bracketing and symbols? i've already plotted the x line. also could you help with the layout of y=4e'5t cheers just not sure of the bracketing and layout. driving me nuts
2007-01-04 04:41:44 · 6 answers · asked by Anonymous in Science & Mathematics ➔ Mathematics
You type in the formula almost exactly the way you did here.
Drop the 'y' and separate the numbers from the 'x's with multiplication sign (*).
To plot in excel, you're going to need some values for x. Let column A be your x's and column B hold your formula.
If you set cell A1 to some value (-5 for example, since you'll want some negative values to get a full feel for the function) and enter your formula in B1, you have one data point. Copy B1 into B2. Increment your x value by adding some value to A1 (For example, entering =a1+.1 in A2 will increment your x values by 1/10.
Copy A2 and B2.
Highlight a lot of rows (however many you want for your graph) and paste.
Chart the values in your B column while using your A column as your x axis. Adjust the x scale as desired (you don't want to display every x value or it will be unreadable).
2007-01-04 04:49:24 · answer #1 · answered by Bob G 6 · 0⤊ 0⤋
you could might desire to understand all the historic drawings to get the probabilty of specific numbers occuring. Statistically, the percentages of every person huge form coming up in a lottery the place 3 numbers are drawn and the numbers are by way of 40 are a million in 64000. The device is... 40 cubed (40 x 40 x40). This assumes you will possibly desire to have the equivalent huge form assorted situations.
2016-12-15 09:37:21 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Put X into cell B5 then this into C5
=((4*B5)^3)-((3*B5)^2)-((2*B5)-1)
Then you can copy this down to produce a table like this
154
2473
31642
43945
57766
613489
721498
832177
945910
1063081
And you can base your chart on this table.
2007-01-04 04:51:58 · answer #3 · answered by mark 7 · 0⤊ 0⤋
If you have Windows XP, download their free PowerToy calculator. Much better for what you want to do! And it has precision to 512 decimal places.
2007-01-04 04:45:04 · answer #4 · answered by Anonymous · 0⤊ 0⤋
y = (4.x.x.x) - (3.x.x)+ (2.x) - 1
2007-01-07 07:34:21 · answer #5 · answered by lenpol7 7 · 0⤊ 0⤋
use the power(x,y) function
2007-01-04 04:43:58 · answer #6 · answered by snfcricket 3 · 0⤊ 0⤋