Can someone please help using ONLY the Excel link below?? Use this link to plot:
ID: 3221244 • Letter: C
Question
Can someone please help using ONLY the Excel link below??
Use this link to plot: https://docs.google.com/spreadsheets/d/1KyG8mlW4daOlrZ2TaLUtNNRU5l6w05wCKtj4BSCtyEY/edit?usp=sharing
In an experiment to determine the efficacy of a treatment to suppress tumors in mice the number of tumors counted in the seven mice in the treatment group were 15, 19, 15, 9, 46. 11, and 18. For the seven mice in the control group the tallies were 26, 72, 104, 23, 33, 27, and 36. a) Plot the CDFs of the two data sets on a common set of axes. b) If the investigatrors choose to use a two-sample K-S test to determine the probability that the null hypothesis accounts for these data, should they choose a one-sided or a two-sided test? c) Find the K-S statistic for these data and display it graphically in the plot you made for part d) Find the p value for the observed K-S statistic. e) What conclusion would you draw from these data? Would you publish?Explanation / Answer
Answer
A. Use the same link provided by you to see CDF shown in the scatter plot for both treatment and control vs the actual frequency percentage.
B Use the formula Z= (X- mean)/(std dev/sqrt(n)) on the values obtained in the excel. Compare the P value from alpha to find it is one sided or two sided. If p value is less than alpha we are gonna reject the null, if its greater we will accept the null hypothesis.
C. D. E. Refer the same excel sheet used previously. As you can see in the excel the value of D which is the diffrence in the cumilitive proportion is higher than our critical D where formula for critical D= 1.36/sqrt(sum of Treatment). I.e 14.41% is greater than 11.79% hence we can conclude that statistically we can prefer to use tretment numbers over control group tallies. So yes I would publish.