Follow the instructions on the descriptive statistics tab of your chosen dataset. Copy and paste the completed table here: Description: Endurance Times for nine well-trained cyclists, on each
of 3 doses of caffeine (0,5,13 mg)
cyclists were given dose of caffeine and one hour later cycled till exhausted
Variables/Columns
Subject id 1-15
Dose 0, 5, 13
endurance time /* minutes until exhaustion at 80% Wmax on cycle */
Data:
Cyclist id 0mg mg5 mg13
1 43.44 42.47 37.55
2 33.67 85.15 61.53
3 64.25 63.20 71.28
4 46.1 52.10 54.76
5 59.71 66.20 68.35
6 48.75 73.25 69.47
7 42.43 44.50 46.48
8 55.32 57.17 62.35
9 33.26 35.05 36.20
10 41.44 44.47 44.35
11 44.15 48.52 53.46
12 54.34 58.70 64.21
13 58.75 65.25 71.62
14 34.35 47.37 58.03
15 47.87 77.27 65.35
Statistic Group 1 Group 2 Group 3
Mean
Median
Standard deviation
Variance
Range
95% confidence interval of mean
Count
1. Create and insert at least 2 charts that portray your data, for example bar chart showing the difference between the groups, or line graph showing the relationship between two variables.
2. What is your null hypothesis about the data?
3. What is your alternative hypothesis?
4. Choose the appropriate test to run (one-sample z, t-test, ANOVA, linear regression, or chi-square). What test did you choose and why is it appropriate for the dataset?
5. Run the relevant statistical test. Insert your results from the chosen test.
6. Is this test statistically significant? How did you make this determination?
7. What is your statistical conclusion (i. e. are you rejecting or failing to reject the null hypothesis)?
8. What is your experimental conclusion (i. e. what are you concluding about your original hypothesis based on the test that you have conducted)?