5. How to graph the difference between two complex numbers?
The image above demonstrates a scatter chart that shows two different complex numbers and their difference, in total three different complex values.
Complex numbers in rectangular form a+bi have real and imaginary values which are positive, negative or zero, this makes it possible to use a chart with two dimensions x and y.
The imaginary values on the vertical axis (y) and the real values on the horizontal axis (x).
C1 = -2+2i (light blue)
C2 = 2-4i (green)
C1- C2Â = -4+6i (dark blue)
Subtracting a complex number means that it points the opposite way with the same distance (green). The dark blue complex number is the difference between C1 and C2 .
5.1 Extract real and imaginary numbers from complex numbers
Make sure that each complex number begins with real value 0 and imaginary value 0 on a separate row except the complex number you subtract with (green). The real and imaginary values on the next row, and that there is an empty row between. You can use the IMREAL function and the IMAGINARY function to extract the coordinates from the complex numbers in column B, make sure they are in rectangular form.
Formula in cell C25:
=IMREAL(B25)
Formula in cell D25:
=IMREAL(B25)
Copy these cells and paste to cells C28 and D28 respectively.
Formula in cell B31:
=IMSUB(B25, B28)
The row before complex number 2-4i (row 27) must contain the result from cells C31 and D31.
5.2 Insert scatter chart
Select cell range C24:D31.
Go to tab "Insert" on the ribbon.
Press with mouse on the icon named "Insert Scatter (x,y)", a popup menu appears.
Press with left mouse button on the icon "Scatter with Straight Lines and Markers".
The chart shows up on the worksheet.
Press and hold with left mouse button on the chart border, then drag it to the location you want. Use the "handles" to resize the chart, see the image below.
5.3 Create arrows and change colors
Double-press with left mouse button on with left mouse button on one of the lines on the chart, all lines will be selected and a settings pane shows up.
Press with left mouse button on the "Fill&Line" button.
Press with mouse on "End Arrow type", select an arrow.
Press with mouse on "End Arrow size, pick a size.
Press with left mouse button on twice on a line to select a specific line.
Press with left mouse button on the color button on the settings pane. A popup menu appears.
Pick a color.
Repeat steps 1 to 3 with remaining lines.
There are still three markers on the chart, here is how to remove them.
Select all the lines by press with left mouse button oning on them once.
Go to the settings pane.
Press with left mouse button on "Marker Options".
Select "None".
5.4 Change axis min and max value
Double-press with left mouse button on one of the y-axis to open the settings pane.
Press with left mouse button on the "Axis Options" button.
Change the Bounds and the Units.
Repeat step 1 to 3 with the x-axis.
5.5 Change axis markers and line width
Select the y-axis.
Press with left mouse button on the "Fill & Line" button.
Press with left mouse button on the "Line".
Press with left mouse button on the "Color" button. Press with mouse on black.
Change the width to 1.5
Press with right mouse button on on one of the lines, a popup menu appears.
Press with mouse on "Add Data Labels".
Double-press with left mouse button on one of the data labels, the settings pane shows up.
6. How to calculate the distance between two complex numbers?
The following formula calculates the length between two complex numbers in the complex plane. First, the formula subtracts the second complex number from the first, then it calculates the modulus of the difference.
For example, the first complex number is -2+2i and the second complex number is 4+4i. The difference is -6-2i, the modulus of -6-2i is the square root of 40 which equals approx. 6.32
Formula in cell E2:
=IMABS(IMSUB(C2,C3))
The image above shows the distance between these two points on the complex plane, the distance is the dashed blue line between -2+2i and 4+4i.
Explaining formula in cell E2
Step 1 - Calculate the difference between two complex numbers
The IMSUB function calculates the difference between two complex numbers in x + yi or x + yj text format.
Function syntax: IMSUB(inumber1, inumber2)
IMSUB(C2,C3)
becomes
IMSUB("-2+2i","4+4i")
and returns
"-6-2i"
Step 2 - Calculate the modulus of a complex number
The IMABS function calculates the absolute value (modulus) of a complex number in x + yi or x + yj text format.
Functions for backward compatibility with earlier Excel versions. Compatibility functions are replaced with newer functions with improved accuracy. Use the new functions if compatibility isn't required.
These functions let you sort, lookup, get external data like stock quotes, filter values based a condition or criteria, and get the relative position of a given value in a specific cell range. They also let you calculate row, column, and other properties of cell references.
Functions that let you manipulate text values, substitute strings, find string in value, extract a substring in a string, convert characters to ANSI code among other functions.
More than 300 Excel functions with detailed information including syntax, arguments, return values, and examples for most of the functions used in Excel formulas.
Excel Tables simplifies your work with data, adding or removing data, filtering, totals, sorting, enhance readability using cell formatting, cell references, formulas, and more.
Allows you to filter data based on selected value , a given text, or other criteria. It also lets you filter existing data or move filtered values to a new location.
Lets the user work more efficiently by showing a list that the user can select a value from. This lets you control what is shown in the list and is faster than typing into a cell.
Lets you name one or more cells, this makes it easier to find cells using the Name box, read and understand formulas containing names instead of cell references.
The Excel Solver is a free add-in that uses objective cells, constraints based on formulas on a worksheet to perform what-if analysis and other decision problems like permutations and combinations.
Format cells or cell values based a condition or criteria, there a multiple built-in Conditional Formatting tools you can use or use a custom-made conditional formatting formula.
Lets you quickly summarize vast amounts of data in a very user-friendly way. This powerful Excel feature lets you then analyze, organize and categorize important data efficiently.
VBA stands for Visual Basic for Applications and is a computer programming language developed by Microsoft, it allows you to automate time-consuming tasks and create custom functions.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form