Double-factor variance analysis without repetition using Excel

Assuming that two factors work together on a single result, it is necessary to cross-examine it to analyze the extent of their impact on the results.

Case: The impact on sales is determined by the location of the store and the form of advertising promotion.

Using variance analysis

Analysis results

The F value of the row is 202>>3.2, and the column's F value is 9.34>3.49. The explanation area is the main factor which affects the sales, the promotion form is the secondary factor.

Double-factor variance analysis without repetition using Excel