Overview
Please download the excel sheet with the class data: attached below
Follow along in the excel sheet to calculate averages, standard deviation, and confidence intervals. Graph the averages(means) along with their confidence intervals. Then, answer the following questions in a text box on your excel sheet:
- What was your hypothesis?
- Does the data support your hypothesis? In other words, what were the results of the experiment? To answer this, look at your graph. Is there a significantdifference between Drug A and Drug B (do the confidence intervals overlap or not overlap)? Did Drug A have a significant effect? Did Drug B have a significant effect? (Do the confidence intervals extend past 0 or not?)
- If the data does not show significance, why might this be? Was our sample size too small? Did we have trouble consistently counting wiggles?
Please upload your calculations, graph, graph caption (adds context, does not interpret), and question answers as an excel file named Yournamecelegans.xxls.