Question: Pleas help me asap, this needs to be in excel my midnight, thank you. The Wall Street Journals Shareholder Scoreboard tracks the performance of 1000

Pleas help me asap, this needs to be in excel my midnight, thank you.

The Wall Street Journals Shareholder Scoreboard tracks the performance of 1000 largest U.S. companies. The performance of each company is rated based on the annual total return, including stock price changes and the re-investment of dividends. Ratings are assigned by dividing all 1000 largest U.S. companies into four groups of equal size Group A (top rating), B (second best rating), C (third best rating), and D (bottom most rating). Shown here are the one- year ratings for a sample of 50 largest U.S. companies. Does the sample data provide evidence that the ratings are equally likely for the largest U.S. companies based on both the p-value and critical-value approaches? Use = .025.

A

B

C

D

22

9

14

5

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!