Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 differenceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started