Q9: please answer all the parts to this question with each answer clearly indicating which answer is for which part and please make sure to round to the right decimal places. Prednisone is a corticosteroid used to treat many inflammatory diseases such as asthma, ulcerative colitis, arthritis, or acne. However, prolonged use of the drug can cause patients to develop osteoporosis, low bone density. Recently a new drug, prednisolone has been developed that acts as anti-inflammatory with fewer side effects. To compare the drugs impact on bone density a study was done in which two groups of cats received equivalent doses of prednisone or prednisolone for an equivalent time period. At the end of the treatment period the bone density of both groups was measured. Each measurement represents an individual cat that was given either prednisone or prednisolone. Now the researchers want to use a t-test to see if the data show any differences between the treatments. Ho: There is no difference in the bone density between the two treatment groups HA: The prednisolone treatment groups bone density is greater than the prednisone treatment group. Now you're going to determine the t-test probability P(t) using the t-test formula in a spreadsheet. Copy the data over to Excel and perform all calculations in Excel. Note: We are looking for t-test probability, NOT the t-test value. The t-test probability is based on alpha = 0.05, where we reject the null if it's alpha is below. DATA FOR EXPERIMENT 1: Rep # Prednisone g cm-3 Prednisolone g cm-3 1 0.44 0.54 2 0.36 0.51 3 0.39 0.4 4 0.4 0.5 5 0.33 0.37 6 0.46 0.39 7 0.41 0.36 8 0.34 0.51 9 0.32 0.55 10 0.39 0.44 11 0.34 0.46 12 0.4 0.58 13 0.33 0.51 14 0.44 0.55 15 0.45 0.57 16 0.43 0.46 17 0.34 0.49 18 0.39 0.5 19 0.43 0.44 20 0.36 0.38 21 0.34 0.48 22 0.37 0.47 23 0.4 0.49 24 0.32 0.48 25 0.41 0.51 26 0.46 0.42 27 0.35 0.43 28 0.43 0.43 29 0.34 0.54 30 0.33 0.54
Q9: please answer all the parts to this question with each answer clearly indicating which answer is for which part and please make sure to round to the right decimal places.
Prednisone is a corticosteroid used to treat many inflammatory diseases such as asthma, ulcerative colitis, arthritis, or acne. However, prolonged use of the drug can cause patients to develop osteoporosis, low bone density. Recently a new drug, prednisolone has been developed that acts as anti-inflammatory with fewer side effects. To compare the drugs impact on bone density a study was done in which two groups of cats received equivalent doses of prednisone or prednisolone for an equivalent time period. At the end of the treatment period the bone density of both groups was measured. Each measurement represents an individual cat that was given either prednisone or prednisolone. Now the researchers want to use a t-test to see if the data show any differences between the treatments.
Ho: There is no difference in the bone density between the two treatment groups
HA: The prednisolone treatment groups bone density is greater than the prednisone treatment group.
Now you're going to determine the t-test probability P(t) using the t-test formula in a spreadsheet. Copy the data over to Excel and perform all calculations in Excel.
Note: We are looking for t-test probability, NOT the t-test value. The t-test probability is based on alpha = 0.05, where we reject the null if it's alpha is below.
DATA FOR EXPERIMENT 1:
Rep # | Prednisone g cm-3 |
Prednisolone g cm-3 |
1 | 0.44 | 0.54 |
2 | 0.36 | 0.51 |
3 | 0.39 | 0.4 |
4 | 0.4 | 0.5 |
5 | 0.33 | 0.37 |
6 | 0.46 | 0.39 |
7 | 0.41 | 0.36 |
8 | 0.34 | 0.51 |
9 | 0.32 | 0.55 |
10 | 0.39 | 0.44 |
11 | 0.34 | 0.46 |
12 | 0.4 | 0.58 |
13 | 0.33 | 0.51 |
14 | 0.44 | 0.55 |
15 | 0.45 | 0.57 |
16 | 0.43 | 0.46 |
17 | 0.34 | 0.49 |
18 | 0.39 | 0.5 |
19 | 0.43 | 0.44 |
20 | 0.36 | 0.38 |
21 | 0.34 | 0.48 |
22 | 0.37 | 0.47 |
23 | 0.4 | 0.49 |
24 | 0.32 | 0.48 |
25 | 0.41 | 0.51 |
26 | 0.46 | 0.42 |
27 | 0.35 | 0.43 |
28 | 0.43 | 0.43 |
29 | 0.34 | 0.54 |
30 | 0.33 | 0.54 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps