Statistics for Financial Decisions Assignment

Learning Outcomes

1. Analyse and present data graphically using spreadsheet software (Excel).

2. Critically evaluate summary statistics against suitable benchmarks.

3. Apply judgement to select appropriate methods of data analysis drawing on knowledge of regression analysis, probability, probability distributions and sampling distributions.

4. Select and apply a range of data analysis tools to inform problem solving and decision making.

5. Conduct quantitative research both individually and as part of a team and articulate and present findings to a wide range of stakeholders, from accounting and nonaccounting backgrounds.

Context:

The short written module assessments allows you to apply your knowledge on the concepts and ideas discussed during the Module. These assessments will also prepare you for the final report.

Instructions:

You are required to apply your knowledge and draw links between the scenario and the learning resources. In your answers, reflect upon and analyse issues of the key discussion points of the module. Your answers should also effectively communicate and demonstrate that key concepts have been reviewed and that you can apply these concepts to the problems posted.

The board is interested in a comparison analysis of a third country as potential market for our Schmeckt Gut products. You are expected to provide this analysis for a country of your choice. Please find below detailed expectations of the board:

1. Download the data of the World Development Indicators from the World Bank.

2. Using this database, select a country of your choice and compare the country's:

a. GDP growth rate (%)

b. Inflation rate (%)

c. GDP per Capita (PPP $)

with those of Industria and the Federated Islands (data provided in the Module content).

Provide a table with the data and develop graphs using applicable EXCEL tools.

3. For the same country, use the World Bank Doing Business Indicators and compare the Indicators for the section 'Paying Taxes' with that of Industria and the Federated Islands. Provide a table and applicable graphs using EXCEL tools.

4. Based on your analysis, make recommendations to the board, which market the Schmeckt Gut company should target first.

Only Part 4, recommendation is required.

Attachment:- Data.rar