Question: Hello! I'm having some trouble with this practice problem. Any help is greatly appreciated. Anova Table Anova: Single Factor SUMMARY Groups Count Sum Average Variance
Hello! I'm having some trouble with this practice problem. Any help is greatly appreciated.
Anova Table


Anova: Single Factor SUMMARY Groups Count Sum Average Variance 1 10 20.76 2.076 0.820049 2 19 46.95 2.471053 2.90881 3 13 20.32 1.563077 0.636623 4 8 11.58 1.4475 0.154193 5 15 24.51 1.634 0.887983 6 16 44.42 2.77625 1.726358 7 19 56.12 2.953684 2.051769 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 32.04742102 6 5.341237 3.456346 0.003976 2.197679 Within Groups 143.716823 93 1.545342 Total 175.764244 99Do various nancial indicators differ signicantly according to type of company? Using the "Excel Databasesxls" le on Blackboard, locate the tab for the Financial Database. Let Type of Company be the independent variable with seven levels (Apparel. Chemical. Electric Power, Grocery, Healthcare Products, Insurance, and Petroleum tor Types 1 ?_ respectively. Perform a oneway ANOVA using Excel with Eamings Per Share as the dependent variable to test if there is a signicant dilference in earnings per share between the 7 types of companies. (hint: you will have to organize the data appropriately to perform the oneway ANOVA in Excel). Perform Fisher's LSD by hand to answer the question: are Earnings Per Share signicantly different for chemical and petroleum companies? Why or why not? Assume a 5% level of signicance. 0 No, the mean difference (0.482) is less than the critical difference. 0 Yes' the mean difference (0.482) is less than the critical difference. 0 Yes, the mean dierenoe (0.908) is less than the critical difference. 0 No, the mean difference (0.908) is less than the critical difference
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
