We need two things to specify:
(1) Bin of estimate - if bin of estimate is low will produce nice and smoother line.
(1) X and Y limit, this depends upon the equations and the portion of the curve you want to see.
X^2 *Y^2 =1
By solving the quation, we get:
X = (1/Y^2)^-2
Please note operators in Excel:
Also order of operation is Brackets, Exponents, Division, Multiplication, Addition, Subtraction.
Let's calculate values creating formula in Excel:
The formula for the first cell becomes:
Here the bin is set to 0.1 and range of X values from -4 to -4.
Data series ready, just plot scatter plot with smoothed line: