A
A
aluka20002020-05-14 18:48:49
excel
aluka2000, 2020-05-14 18:48:49

How to plot a function in excel?

Hello! Please help me plot a function in excel!
There is a mathematical formula, it needs to be translated into an excel formula!
5ebd684485c97098351503.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-05-14
@ProgrammerForever

A1:A31 are filled with numbers from -2 to 1 in increments of 0.1
B1:

=если(a1<=0;(1+a1^2)/(корень(1+a1^4));1*a1+((sin(a1))^2)/(2+a1))

In fact , x in the formula is replaced by A1 , the main thing is not to spare the brackets, then there is less chance of making a mistake.
And extend B1 30 cells down.
Then select both columns and insert a scatter chart.
More points - more beautiful graph. It is desirable to enter a pair of points in the vicinity of zero into the x values, because there is a jump. For example -0.00001 and 0.00001

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question