QTM #9

10/19/2017

Purpose: The purpose of this lab activity was to become more acquainted with using Excel and produce a clear and informative graph that conveys the message lying behind our data. The figure must include the data from the entire treatment group and this will be presented for feedback.

Procedure:

1. Make a bar chart (or any other chart that would represent the data better)
   1. Make a table of the treatment and control values.
   2. Find the average values for the control and treatment values and place these numbers in a separate column.
   3. Create a bar graph by clicking on recommended charts.
2. Add axis labels and a title by clicking on chart design and add chart elements.
3. Change the colors of the graph by clicking on change colors.
4. Add Standard Error Bars.
   1. Click on add chart elements – error bars – standard error.
   2. You may have to also perform a new data table to find the standard error.
5. How to add an asterisk to point out significant differences.
   1.  Insert a text box and use the data from the T-Test to determine if we were able to refute the null hypothesis. Because the P-value was less than 0.05, we were able to reject the null hypothesis.
6. Save the work as a picture in the form of a jpeg.
7. Insert into your report.
8. Add a caption to your figure in Word.

The figure above shows the average values for the treatment and control cell counts. The standard deviation, as calculated previously, is also shown in the bar graphs.