Question: please help with the anova part only with excel formulas please like shown in last pic A pharmaceutical research company tests the effectiveness of three


A pharmaceutical research company tests the effectiveness of three new drugs for patients experiencing specific symptons. They obtain a sample of 30 people, divided randomly into three groups of 10 people each. 3 Group 1 takes Drug 1, Group 2 takes Drug 2, and Group 3 takes Drug 3. 4 Each person is then given one of the drugs and asked to record the number of hours before their symptons subside. 5 The scores are shown below. Determine whether there id significant difference between the three drugs. Required: Complete the ANOVA tables below: A1 A B C D E. F G H Required: Complete the ANOVA tables below: \begin{tabular}{|c|c|c|c|c|c|c|} \hline Groups & & Count & Sum & Mean & Variance & SS \\ \hline Drug 1 & & 10 & 150 & 15 & 13.33333333 & 120 \\ \hline Drug 2 & r & 10F & 111 & 11.1 & 18.76666667V & 168.9 \\ \hline Drug 3 & r & 10T & 135V & 13.5r & 14.055555556 & 126.5 \\ \hline \end{tabular} ANOVA HAlpha 0.05 \begin{tabular}{|c|c|c|c|c|c|c|} \hline ANOVA & & & Alpha & & & \\ \hline Sources & SS & df & MS & F & P value & F crit \\ \hline Between Groups & r & r & V & & & \\ \hline Within Groups & r & r & r & & & \\ \hline Total & r & T & r & & & \\ \hline \end{tabular} \begin{tabular}{l|l|l} \hline The drugs & are not & significantly different. \\ \hline \end{tabular} fx= COUNT(B8:B17)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
