Here is a calculator you will find useful...
?
I like my peak signals between -30 and -40 dBm. In general more attenuation than you think necessary produces the best signals. I use a total of 70-80dB attenuation testing 1-5 Watt direct inputs.?
?
You're going to spend a lot on any attenuator that can handle 50 watts! Good luck!