I have two scenarios on sheet 1 and 2. I have been asked to perform F-tests on all the data. I have worked out the mean, SD and variance for all the columns. I assumed to do the F-test I get the two ranges from one column in scenario 1 and a the second from scenario 2 (eg total cholesterol from both scenarios) however, my results are completely different from my peers and have all come out as the populations being unequal.

After the F-tests I am required to complete the correct t-tests and make a table of the p values in both scenario one and two. But with the results I have made, there is only one p-value for both scenarios.

Any help would be appreciated as I am quite confused.

clinbiochemdata2023.xlsx