ARSI UNIVERSITY

COLLEGE OF BUSINESS AND ECONOMICS

ECONOMICSD EPARTMENT

STATA ASSIGNMENT

GROUP MEMBERS
 NAME. ID NO

1. YONAS KETEMA. 0311/13

2. EPHREM ZENEBE. 0254/13
3. TADESE DEBELE. 0297/13
4. YEABSRA WONDAFEREW. 0308/13
5. DELELEGN GETACHEW 0245/13
 RESEARCH TOPIC

THE IMPACT OF MINIMUM WAGE ON

EMPLOYMENT RATE
 Questionnaire Development
The questionnaire will collect data from employees and employers to
analyze the effect of minimum wage changes on employment rates.
Below is an overview of the necessary sections and questions for data
collection.

Section A: Demographics (All Respondents)

1. Age (Categories):

 Under 18

 18-25

 26-35

 36-45

 46-60

 Over 60
2. Gender:

 Male

 Female

 Other

 Prefer not to say

3. Highest Educational Qualification:

 No formal education

 High school diploma

 Associate degree
  Bachelor’s degree

 Master’s degree

 PhD or higher

4. Employment Status:

 Employed

 Unemployed

 Self-employed

 Retired

5. Location (Optional):
  City (open-ended)

 State/Province (open-ended)

 Country (open-ended)

Section B: Employment Details (Employees &

Employers)

6. Job Title: (Open-ended)

7. Industry:
  Manufacturing

 Retail

 Hospitality

 Services

 Agriculture

 Other (please specify)

8. Type of Employment:

 Full-time

 Part-time

 Temporary/Contract

 Casual work
9. Duration of Employment in Current Role:

 Less than 6 months

 6 months to 1 year

 1 to 3 years

 Over 3 years

10. For Employers: Organization Size:

 Less than 10 employees

  10-49 employees

 50-249 employees

 More than 250 employees

11. For Employers: Has the minimum wage change affected

hiring practices?

 Yes, hire fewer employees

 Yes, hire more employees

 No change

Section C: Wage & Employment Impact (Employees &

Employers)
12. Awareness of Minimum Wage Law Changes:

 Yes

 No

13. For Employees: Has the minimum wage increase impacted

your employment?

 Yes, positively (e.g., increased hours, job security)

 Yes, negatively (e.g., reduced hours, job loss)

 No impact
14. For Employers: Effect of Minimum Wage on Business
Operations:

 Reduced employee hours

 Laid off employees

 No effect

 Other (please specify)

15. For Employees: Wage Level:

 Below minimum wage

 At minimum wage

 Above minimum wage

16. For Employees: Has your standard of living changed due to
the minimum wage increase?

 Improved

 Stayed the same

 Declined

17. For Employers: How have you adapted to the minimum

wage increase?

 Reduced staff

 Reduced hours
  Increased prices of goods/services

 No changes were made

Section D: Perceptions (All Respondents)

18. Do you think the current minimum wage is enough to

cover the cost of living?

 Yes
  No

19. Do you believe raising the minimum wage helps reduce

unemployment?

 Yes

 No

 Unsure

20. What do you believe is an ideal minimum wage that

balances fair wages and employment? (Open-ended)

21. Other factors affecting employment in your area:

 Economic downturns

 Industry demand changes

  Automation/Technology

 Other government policies

Summary for Excel (Stata Ready)

The data gathered from the questionnaire will be structured in a way

that facilitates statistical analysis in Excel and can easily be imported
into Stata for further analysis.

Below is a sample summary of how the data might be structured:

Variable Name Description Variable Type Values

Age Age Category Categorical 1 Under 18, 2 = 18 - 25 3 = 26 - 35 4 = 36 - 45 5 = 46-60,

6 Over 60

gender Gender of Respondent Categorical 1 = Male, 2 Female, 3 Other, 4 Prefer not to say

education Highest Educational Qualification Categorical 1 = No formal education, 2 High school diploma, 3 =
Associate degree, 4 Bachelor's degree, 5 = Master's
degree, 6 PhD or higher

emp_status Employment Status Categorical 1 Employed, 2 Unemployed, 3 Self-employed, 4

Retired

job title Job Title (Open-ended) String

industry Industry Categorical 1 = Manufacturing. 2 Retail, 3 Hospitality, 4 = Services,

5 Agriculture, 6= Other

emp_type Type of Employment Categorical 1 Full-time, 2 4 Casual work Part-time, 3

TemporaryContract,

emp duration Duration of Employmen Categorical 1 Less than 6 months, 26 months to 1 year, 3 = 1 to 3
years, 4 Over 3 years

org_size Organization Size (For Employers) Categorical 1 Less than 10 employees, z = 10 - 49 employees, 3 =
50-249 employees, 4 More than 250 employees

min wage aware Awareness of Minimum Wage Law Categorical 1 Yes, 2 No

Changes

min_wage_impact_emp Minimum Wage Impact on Employment Categorical 1 Positively, 2 Negatively, 3 = No impact

(Employees)

min_wage_impact_org Minimum Wage Impact on Business Categorical 1= Reduced employee hours, 2 = Laid off employees, 3
Operations (Employers) No effect, 4 = Other

wage_level Wage Level (Employees) Categorical 1 Below minimum wage, 2 At minimum wage, 3 =
Above minimum wage, 4 Don't know/Not sure

std of living change Standard of Living Change (Employees) Categorical 1 Significantly improved, 2 Slightly improved, 3 =
Stayed the same, 4 Slightly declined, 5 = Significantly
declined 4 Slightly declined, 5 = Significantly declined

min_wage_adaptation Employer Adaptation to Minimum Categorical 1 Reduced staff, 2 Reduced hours, 3 Increased prices,
Wage Increase 4 No changes

min_wage_sufficiency Minimum Wage Sufficiency Categorical 1 Yes, 2 = No

min wage reduce unemp Minimum Wage Impact on Categorical 1 Yes, 2 = No 3 Unsure
Unemployment