using some data to build a business
The statement said that an opinion poll was conducted in South Africa and Kenya to find out what obstacles might be encountered if a business were opened in those countries.
It gives a database of 6 questions and the answers to them and you have to analyze them to decide if you can open a business in a country.
I chose South Africa.
Below is the request and the suggestions made by them, which I also followed.
Your tasks:
1. Analyze the data.
A. Explore the data provided to understand the information requested by your organization.
b. Select the questions you want to analyze to provide the necessary information (there must be no less than six factors).
c. Analyze the data for the selected questions using the appropriate summary statistics.
d. Highlight interesting findings.
e. Make recommendations to your organization about the potential impact of these factors on your organization’s operations / success.
2. Present your work as a report in Word.
Suggested steps:
• Familiarize yourself with data using Excel features such as sorting, filtering, pivoting, etc.
• Extract the required data from the supplied Excel file.
• Choose specific issues that you would like to analyze in more detail.
• Perform a visual examination of the data by drawing appropriate graphs.
• Calculate some standard statistics (for example, average, median, mode, etc.).
• Perform additional analyzes that you deem appropriate to address the tasks
Excel contains the collected database and a tab called Key where the questions are placed on certain columns and each with predefined answers:
– Q1: During this fiscal year, did this unit own or share a generator?
– Yes;
– Not;
– I don’t know (spontaneously).
– Q2: In the fiscal year, what percentage of this unit’s electricity came from a generator that the unit owned or shared?
The answers are 0 to 100 percent.
– Q3: Does this unit compete with unregistered or informal units?
Oh yes;
o – No;
o – I don’t know (spontaneously).
o – Gol.
– Q4: Permanent full-time worker at the end of the last financial year
The answers are numbers of workers
– Q5: Permanent full-time worker at the end of three financial years ago
The answers are worker numbers
– Q6: What were the total annual sales for this unit?
Amounts of money, that is, numbers.
For each answer there is a scale of values, from 1 to 5, ie from no obstacle to very severe obstacle.
5 stairs Likert
No obstacle equals 1
Minor obstacle is equal to 2
Moderate obstacle is equal to 3
The major obstacle is equal to 4
Very severe obstacle is equal to 5
:
So we have to arrange the data and make or statistics for each question and analyze the survey data.
To make it easy for us, we processed data, meaning we put the questions on each column as written in Key and replaced them with values from 1 to 5 instead of No obstacles to Very severe obstacle.
The main idea of each question is to count the answers and categorize them as follows:
– From 1 to 3, ie from no obstacle to moderate obstacle.
– From 4 to 5, ie from the biggest obstacle to the very severe obstacle.
For each question we chose the data and made statistics (tab Q1 and tab Q-statistics).
You will copy everything from Q – statistics into Word and write some more ideas.
So for each column from ‘c30a’ to ‘l30b’ I counted how many are 1, how many are 2, etc.
Then I made the sum from 1 to 3 and from 4 to 5.
I did it for every question and every answer.
Then as a summary I summed up all the columns from ‘c30a’ to ‘l30b’ for each category: from 1 to 3 and from 4 to 5 (in this category I also gathered the answers Don’t know…
At the end I put all the questions in a table and you can conclude from the numbers that you can open the business in South Africa