Question
Follow along in the excel sheet to calculate averages, standard deviation, and confidence intervals. Graph the averages along with their confidence intervals. Then, answer the
Follow along in the excel sheet to calculate averages, standard deviation, and confidence intervals. Graph the averages along with their confidence intervals. Then, answer the following questions in a text box on your excel sheet:
1. What was your hypothesis?
2. Does the data support your hypothesis? In other words, what were the results of the experiment? Did Drug A have a significant positive or negative effect? Did Drug B have a significant positive or negative effect? (Significance = the confidence intervals do not extend past 0)
3. If the data does not show significance, why might this be?
4. (In reference to experiment video) Do you think it's an issue that Robyn knew which side of the slide was the control and which side contained the drug? Could this influence results?
A B C D E F G H K Drug A Control A Drug A-Control A Drug B Control B Drug B-Control B Drug A Effect Drug B Effect 40.2 22.4 33.7 26.3 mean mean 7.6 9.9 18.9 8 SD SD 0 6.2 15 9 n n 15.1 18.1 19.4 20.6 SE SE 10.5 20.5 41.2 13.57 2*SE (95% Confidence Interval) 2"SE(95% Confidence Interval) 5.5 2 49.8 18.5 mean+2*SE (gives upper confidence limit) 22.5 mean+2*SE (gives upper confidence limit) 25 36.1 21.9 mean-2*SE (gives lower confidence limit) 12.6 mean-2"SE (gives lower confidence limit) 23.3 28.5 24.9 10 3 15 23.9 22.1 11 0 11 35.5 16.9 12 13 Graph 14 mean 2*SE 15 Drug A Effect 16 Drug B Effect 17 18 19 20Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started