10/11/18

Objectives/Goals: The objectives of this lab were to get an accurate excel sheet for the class data, compile our own relevant data into a new spreadsheet, and run the various stats for both the control and treatment groups in the cell counts and swim speed assay. The goals were to learn basic statistic skills in Excel, compile data, and interpret the results.

Materials: The materials did not involve lab equipment; however, the class used Excel spreadsheets to organize the data.

Procedure:

1. Download class data excel sheet
2. Use class data to organize the total cell count and swim speed data into a new excel sheet
3. Label appropriate excel cells on new excel sheet
4. Fill in data from class copy to new sheet (w/formatting, transposing, etc)
5. Create descriptive statistics charts for each column
6. Figure out the correct bins for all columns
7. Create a histogram for each column
8. Create an F-test chart for both cell counts and swim speeds
9. Create T-test charts for both cell counts and swim speeds

Data:

Observations: Most of the data between the control and treatment groups look similar. The main differences were in the t-test for the cell counts. According to the current data, the treatment has had no significant impact on the tetrahymena.

Storage: The only storage that occurred in this lab was the storage of data on the computers.

Conclusion/Future Goals: Overall, the data/statistics calculations went well. I was able to easily follow the statistics guide to get the necessary calculations. I have concluded that the null hypothesis can be accepted for the swim speed, but I am unsure if it can be rejected for the cell counts (given that the p value for the cell counts is less that .05). In the future, I would like to be more confident in interpreting the data and coming up with accurate conclusions in results.