Lab 9 Excel Data Presentation

Objective: I will compile data visuals based on the previous data collected in preparation for presentation.

Purpose: By creating visuals of the raw data, the audience is able to see the quantitative data in a simpler, more comprehendible manner.

Background: By using the same data as the previous lab I will be able to efficiently create visual presentations of the previously calculated statistical tests. After conducting the research and conducting the statistical tests, a visual presentation is needed to inform the reader of its importance.

Null Hypothesis Cell Count: There is no statistical difference for the treatment and control in cell count presence.

Null Hypothesis Vacuole Formation: There is a statistical difference for the treatment and control samples between the two time intervals of five minutes and fifteen minutes for vacuole formation.

By using the same data as the previous lab I will be able to efficiently create visual presentations of the previously calculated statistical tests.    

Materials:

1.       Excel

2.       Laptop

3.       Statistics background

Safety: computer work, no lab work

Procedure:

1.       Make a bar chart of the data, including starting cell concentration of both control and treatment.

2.       Add axis labels and title

3.       Add standard error bars by using the previously calculated standard error from the statistical tests.

4.       Save your pictures as JPEG

5.       Compile all team visuals onto one document: vacuole formation, speed, direction assays, cell count, optical density. When conducting optical density, remember to find the difference between the PPT+twine and the treatment to find the net density of the treatment. 

6.       Analyze and repeat for all tests. 

 Data Visuals:

Figure A

Figure B

Figure C

Figure D

Figure E

Figure F

Conclusion:

Cell count concentration of Figure A was higher for that of the treatment with propylene which is therefore attributed to the presence of microplastics. Furthermore, the vacuole formation assay of Figure F depicts the same trend of causation. Due to the presence of microplastics, vacuole formation is increased in the treatment due to the abnormal process of phagocytosis. Phagocytosis does not occur normally due to the interference of the microplastics. As for swim speed of Figure D, the treatment has faster speed. The difference for speed is minimal. On the other hand, direction changes of Figure E occur much more frequently in the control as compared to the treatment. Spin changes of Figure B also follow the same trend as directional changes. Figure C shows optical densities (OD600) of both treatment and control. The treatment was subtracted from the PPT to show the net difference of density. The treatment shows a negative density which can possibly be attributed to systematic error unless there is another explanation of a negative density. Furthermore, standard error is shown throughout all graphs as calculated by the statistical tests. The treatment trials during the cell count concentration experience the largest standard error.

Storage:  computer area was properly cleaned following procedure no lab work

Discussion: Using the data visuals, this upcoming week we will present. When presenting, a graph is much more comprehendible as compared to raw data. Using the skills learned in this lab, I will continue including data visual graphs to make more elaborate of how I reached my conclusion. By compiling all of the data together, all my lab partners including myself collaborated very well together to explain their assay through use of their graphs. Further analysis needs to be done on optical density to understand why the treatment is negative. 

Paul Nemer

10 October 2018