Lab 7: Data Analysis 10/11/2018
Objective:
The objective of today’s lab is to fix any errors in our data like duplicates, or wrong units and starting our statistical analysis
Purpose:
The purpose of today’s lab is to fix any errors in our data as faulty data can be detrimental to our experiment and our data analysis
Procedure:
1. Copying and Paste Control cell count data
2. Repeat for Treatment Cell Count, and Control and Treatment Vacuole Formation for 5 minutes and 15 minutes. All in individual columns
3. Do descriptive statistics for all columns
4. Type Bin numbers in increments of 5,000
5. Type the second Bin in increments of 5
6. Do histogram for each column Cell counts will have a bin of 5,000 and assay will have a bin of 5
7. Copy and paste histograms in the word document
8. Do F-test Variable 1 being Control Cell Count and Variable 2 being Treatment Cell Count
9. Copy and Paste F-Test Table
10. Do T-test Two-Sample Assuming Unequal Variances using the same 2 variances as the F-test
11. Copy and Paste T-test table
Data:
| F-Test Two-Sample for Variances | ||
| Control Cell Counts cells/ml | Treatment Cell Counts cells/ml | |
| Mean | 12426.47059 | 32222.22222 |
| Variance | 56380793.23 | 215206349.2 |
| Observations | 34 | 36 |
| df | 33 | 35 |
| F | 0.261984804 | |
| P(F<=f) one-tail | 0.000100156 | |
| F Critical one-tail | 0.562597826 | |
| t-Test: Two-Sample Assuming Unequal Variances | ||
| Control Cell Counts cells/ml | Treatment Cell Counts cells/ml | |
| Mean | 12426.47059 | 32222.22222 |
| Variance | 56380793.23 | 215206349.2 |
| Observations | 34 | 36 |
| Hypothesized Mean Difference | 0 | |
| df | 53 | |
| t Stat | -7.163627352 | |
| P(T<=t) one-tail | 1.22968E-09 | |
| t Critical one-tail | 1.674116237 | |
| P(T<=t) two-tail | 2.45936E-09 | |
| t Critical two-tail | 2.005745995 | |
Storage:
All data is stored in a spreadsheet named “Data Analysis” and the procedure is in a word document named “Anthony QTM” both are in the documents folder in my laptop’s hard drive.
Conclusion:
Based on the F-test the variances are unequal with the F value being less than the F critical (one tail) thus rejecting the null hypothesis that Control and Treatment cell count are the same. Based on the T-test (assuming unequal variances) we can infer that the means are significantly different thus rejecting the null hypothesis of the means being the same due to both P values being significantly below 0.05. Right now I don’t see any major flaws in the experiment.