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

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

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

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 Mathematics Questions!