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.