3G/4G generally has a more consistent ping rate than wi-fi. Wi-fi can have a lot of flutter, so you could see huge ping spikes.
If I had to guess, it looks like your ISP is the problem. The jump from mid-20 ms pings to >200 is large, so your ISP is probably using their own network or contracted with second tier backbone providers...or their routing tables are a sloppy mess.
The problem does not seem to lie with your local node, but rather the switchover from local to regional nodes.
My ISP (Cable) usually serves each hop at around 15-25 ms. Occasionally, during peak times (4PM - 7PM) my hop times jump to 40-70 ms, but are still reasonably good.
Try doing a tracert to google.com and see if the hop times are similar. If they are still >200 ms after the jump from local to regional nodes, I would either call the ISP or find a new one.
Bookmarks