Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practicing Statistics Guided Investigations For The Second Course

Authors: Shonda Kuiper, Jeff Sklar

1st Edition

9780321586018

Students also viewed these Mathematics questions

Question

What is statistical inference?

Answered: 1 week ago