I think the problem that most of us were having is the distinction of the "connector" and the "signal." These are substantially different things. An RCA connector and an F connector could both be attached to a coaxial style cable and send composite video.
Now that I think you have this clear we can address your question more accurately.
A RF modulator will take an audio signal (usually L+R or mono audio on RCA style jacks) and a video signal (typically composite video--also on an RCA style jack) and modulate those signals so they can be sent on a single (coaxial) style cable. This would then be plugged into a F connector style input on a TV, VCR, monitor, etc. that could separate the signal back into audio and video.
Either use the RF modulator at the SEND end and run coaxial cable to your TV, etc. Or, run audio and video cables and have it converted at the RECEIVE end (although I'm not sure why you'd want to do this.)
This should have answered your question in its entirety.
Good luck,
B.