IGCSE/GCSE/O & A Level/IB/University Student Forum
General Chat NEW! The Student Forums Chatroom => Technology => Topic started by: ashish on November 27, 2010, 11:17:44 am
-
hello ,
can anyone help me , i don't know how to create graph of an equation in excel !
i have the equation
Y^2 = 2.5x-(0.5*9.81*x^2)
-
Put your x values in column A and your y values in column B
Select columns A and B and invoke the ChartWizard. The chart type you want is XY (Scatter).
If you don't have any values but a function like f(x) = cos(2^x), you have to decide what x range you want to graph and how fine the graph will be, i.e. what is the interval between data points, small interval=smooth graph.
Put the lowest x value in A1, put the interval in D1
in B1 put your formula =COS(2^A1) and drag it down to B2
in A2 put the formula =A1+$D$1.
Then select A2:B2 and drag down until you have enough data for your needs.
THEN invoke the Chart Wizard.
-
tell me if it doesn't work! ;)
-
tell me if it doesn't work! ;)
i didn't get it :(
here is the formula : Y=(10x)-(0.5*9.81*X2)0.5
domain will be between (1-10)
what data should i insert and where?
-
on column A, put the values of the domain
that's is in your case, 1 to 10
now, in column B put the formula
in your case, the formula will be
=(10*A1)-(0.5*9.81*A1^2)^0.5
amusing, you put this formula in the cell B1 and having the first domain in the cell A1
after that, repeat the same thing for other 9 rows. Until you reach the last number of your domain.
and, then select the whole thing and create a chart!
check the images that i'd uploaded.
-
thank you very much +rep
-
Anytime :D