FILE (Use Excel) Adidas revenues (in millions o f ) in Asia and Latin America for the

Question:

FILE (Use Excel) Adidas revenues (in millions o f €) in Asia and Latin America for the years 200 5 through 20 0 9 are sh o w n in th e accom panying table; th e 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 w hether 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?

P-399

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

Step by Step Answer:

Answer rating: 100% (QA)

Answered By

Asim farooq

I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening. My Expert Service Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities

4.40+ 65+ Reviews 86+ Question Solved

Related Book For book-img-for-question