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

please help with the anova part
only with excel formulas please like shown in last pic  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 new drugs for patients experiencing specific symptons. They obtain a

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!