The Wall Street Journal's 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, 22

B, 9

C, 14

D, 5

Show all the steps in the hypothesis testing process in the solution. That includes stating

hypothesis statements using Greek symbols and in English sentences on what the

hypothesis stands for; the decision on the hypothesis test (the basis for why the

hypothesis is being rejected or not); and state the conclusion in the business problem

context in English sentence of the decision at the end of the hypothesis testing.

Please include excel functions!