[SOLVED] How to calculate phase and magnitude for each

[Manjuladevi]

Hi Im manjuladevi, Im a researcher on RF and Microwave.
Here, I have tested 1:2 equal power divider.I want to compare measured and simulated datas.
I want to plot it through excel. so, what is the formula to calculate phase and mag?
This is the snap shot that i was attached below:

 

[KlausST]

Hi,

basically this is calculation form carthesian to polar coordinates.
Maybe there is an Excel plugin that can do this more simple.

generally:

Amplitude:
Since Re and Im are orthogonal values of a vector you simply can use pythagoras to get overall amplitude
Amplitude = sqrt(RE^2 + Im^2)
(assuming Re and Im are also amplitude values - and not RMS values)

Angle:
you may use tangens.
Tan(phi) = Im/Re
phi = arcTan(Im/Re)
in degree: Phi_deg = phi * 180/pi()

Mind that tan repeats every 180°. So you have to decide in which quadrant you are.

Klaus