In: Statistics and Probability
QUESTION 9
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 Prenisolone. Now the researchers want to use a t-test to see if the data show any differences between the treatments.
H subscript 0: There is no difference in the bone density between the two treatment groups
H subscript A: The prednisolone treatment group bone density is greater than the prednisone treatment group.
Now you're going to determine the t-test probability P subscript open parentheses t close parentheses end subscript using a t-test formula in a spreadsheet. To do this in Google Sheets, the formula is a little more detailed. Note: we are looking for t-test probability, not the t-test value. The t-test probability is based on alpha equals 0.05 where we reject the null if it's alpha or below.
a) Is this a one-tailed or two-tailed test? (you'll want this information for the formula that you will use). Also, for the formula, assume unequal variance between treatment groups (specify type 3 t-test in your spreadsheet software). calculate the t-test probability.
b) Copy and paste your calculated t-test probability here (to at least 3 significant figures):
c) Based on the t-test probability you would the null hypothesis. (reject, fail to reject)
d) Is it likely that the bone density of the prednisolone treatment group is greater than the prednisone treatment group?
I will rate for sure, Thank you so much. Please help me I need help with this question
Rep # | Prednisone g cm-3 |
Prednisolone g cm-3 |
1 | 0.44 | 0.44 |
2 | 0.41 | 0.46 |
3 | 0.49 | 0.4 |
4 | 0.4 | 0.4 |
5 | 0.44 | 0.37 |
6 | 0.41 | 0.39 |
7 | 0.41 | 0.36 |
8 | 0.44 | 0.46 |
9 | 0.42 | 0.44 |
10 | 0.49 | 0.44 |
11 | 0.44 | 0.46 |
12 | 0.4 | 0.48 |
13 | 0.44 | 0.46 |
14 | 0.44 | 0.44 |
15 | 0.45 | 0.47 |
16 | 0.44 | 0.46 |
17 | 0.44 | 0.49 |
18 | 0.49 | 0.4 |
19 | 0.44 | 0.44 |
20 | 0.41 | 0.38 |
21 | 0.44 | 0.48 |
22 | 0.47 | 0.47 |
23 | 0.4 | 0.49 |
24 | 0.42 | 0.48 |
25 | 0.41 | 0.46 |
26 | 0.41 | 0.42 |
27 | 0.45 | 0.43 |
28 | 0.44 | 0.43 |
29 | 0.44 | 0.44 |
30 | 0.44 | 0.44 |