40. FILE (Use Excel) Adidas revenues (in millions of ) in Asia and Latin America for the...

Question:

40. FILE (Use Excel) Adidas revenues (in millions of €) in Asia and Latin America for the years 2005 through 2009 are shown in the accompanying table; the data, labeled Adidas Revenues, are also available on the text website.

2005 2006 2007 2008 2009 Asia 1,523 2,020 2,254 2,662 2,614 Latin America 319 499 657 893 1,006 SOURCE: Adidas Online Annual Reports.

a. Specify the competing hypothesis in order to test whether the variance in revenues is greater in Asia than in Latin America.

b. Use Excel to calculate the relevant test statistic.

c. Use Excel's F.TEST function to calculate the p-value.

d. At α = 0.05 what is your conclusion?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: