Assignment - WBES data analysis
Learning outcome 1: Identify data requirements and the appropriate data collection instruments required for effective business decision making
Learning outcome 2: Conduct appropriate analysis and clearly communicate findings to a stated audience
You have been provided with an edited subset of survey data collected by some international organisations like the World Bank Enterprise survey (WBES), Transparency International etc. The data set provides some variables on economic situation as well as obstacles facing business organization. Your organisation (a manufacturing firm) is considering opening a branch each in THREE African countries.
Your research department has asked you to analyse the data set for ALL the countries and advice the company on the preferred countries to set these branches in their order of perceived relevance. They are interested in assessing the impact of these variables on business activities.
Your tasks:
1. Analyse data .
a. You should present a brief description of the company's product.
b. Explore the data provided in order to gain an understanding of the information required by your organisation.
c. Analyse the data using appropriate summary statistic.
d. Highlight interesting findings.
e. Make recommendations to your organisation about the possible countries to set these branches.
2. Present your work in the form of a report in Word.
Suggested steps:
• Familiarise yourself with the data by using Excel's facilities like sorting, filtering, etc.
• Extract the required data from the Excel file provided.
• Conduct a visual examination of the data by plotting appropriate charts.
• Calculate some standard statistics (e.g., mean, median, mode, etc.).
• Conduct additional analysis that you feel is appropriate to address the tasks
• Demonstrate competence in a range of skills in Excel including charting and use of functions
• Select appropriate techniques to explore and summarise a given dataset
• Highlight and communicate results to the relevant audience