Voltage amplification of 1kHz wave with transformer

[CaptDon]

Why are you trying to be so scientific about your measurements?? Transformers are weird creatures, the primary will have some
self resonant frequency, the secondary will have some different resonant frequency and the transformer as a whole will have an even different self resonant frequency. Any measurements made at or near those frequencies could be abnormally higher or even lower depending on your drive circuit and if the resonance was series or parallel. You will find that the transformer will present different load impedances at different frequencies and just because your signal generator has a 50 ohm output impedance and you properly terminated it at 50 ohms so that when you set it for 2vpp or .707rms that is the voltage it will produce AT 50 OHMS!!!! If you look at the actual voltage being applied to your transformer it will vary with frequency. Try turning the frequency down to 10hz and see that the transformer practically swamps the sig gen to almost no output. You have spent so much time and effort using science to prove or disprove a turns ratio and have only proven to yourself these methods CAN ONLY APPROXIMATE!!! Accept the fact. You may as well try to prove which is bigger 6 or half a dozen.

[SilverSolder]

[...]
Are such larger variances normal? If so how would you use a transformer "reliably"?

This all depends on the quality of the transformer.

The magnetic circuit in a transformer is not ideal.  The magnetic core material is not ideal, and the shape is not ideal either, causing leakage of magnetism through the air, outside the core. 

The non-ideal behaviour is strongly frequency dependent.


Transformers can be made close to ideal, but now they become big and expensive.  A high quality signal transformer can go from below 1Hz all the way up to nearly 50KHz,  ruler flat.

Like this: