How To Use ANOVA IN Excel to Improve Click-Through Rate in a Pay-Per-Click campaign. This Video Will Show You Exactly How to Perform Two-Factor ANOVA With Replication in Excel to Determine Whether the Headlines, the Ad Text, or the Interaction Between the Two Has an Effect on the Click-Through Rate of Ads Within an Ad Group of a Pay-Per-Click Campaign on Google AdWords and on Yahoo Search.