Question: how to do f test in excel 2016?
Answer: On the Data tab, in the Analysis group, click Data Analysis. ...  Select F-Test Two-Sample for Variances and click OK. Click in the Variable 1 Range box and select the range A2:A7. Click in the Variable 2 Range box and select the range B2:B6.