Purpose:

In this lab, we worked on creating a results graph that will be presented in class next week.  We went over what makes a good graph, and we also discussed what was expected of our rough draft due next week.  This lab furthered our practice of making graphs, and it taught us how to use and manipulate our data to make the graphs that would demonstrate our results data.

Procedure:

• First use your data from data analysis to create a new chart with the means of the C-24 and TRMT-24.  Hi-light your data and create a chart that will best fit your data.  The mean for C-24 was 37417.8 and the mean for TRMT-24 was 23051.
• Next, to title your x and y axis click on your graph go to chart elements and click axis title.  Name your x-axis Types of Treatment and your y-axis Cells/Ml.
• Make sure you that you give your graph a descriptive title such as Average Effects of NH4Cl on Tetrahymena.
• Next, create an error bar by clicking on your graph and going to add chart element.  Then, go to error bars and select more error bar options.  On the right of the screen select custom error at the bottom of the column.  In both the positive and negative slots, insert both standard error values that you got from your descriptive analysis.
• Next, select the bars and select a color that will ensure that the columns are distinct.  Make sure that viewers are easily able to see the error bar.
• Once your graph is made, you may change your graph design in order to make it the most descriptive for your data.
• Once you are finished with your chart, save it as a JPEG.

Results:

The graph above demonstrates that the average cells/ml of the control group of Tetrahymena with 175mM of H2O was significantly larger than the average cells/ml for the treatment group with 175mM of NH4Cl on Tetrahymena.  This evidence supports that 175mM of NH4Cl has a detrimental effect on Tetrahymena.

Conclusion:

This lab enabled us to become more familiar with our data, and it gave us more experience with drafting a results chart.  This draft chart is something that will be presented to the class next week and used in our final paper.  This activity provided practice with analyzing statistical data and coming up with conclusions.