Question: how to do f test in excel?
Answer: F-Test to Compare Two Variances in Excel Step 1: Click the “Data” tab and then click “Data Analysis.” Step 2: Click “F test two sample for variances” and then click “OK.” Step 3: Click the Variable 1 Range box and then type the location for your first set of data.