Đã hoàn thành

A Statistical Analysis and Professional & Ministerial report for my personal blog

Part A: In a theoretically ‘ideal’ labour market, applicants with same productive attributes (e.g. education attainment, working experience) should be equally paid when hired by any organization. The existence of private-MNC and private-SME pay gap for individuals with similar productive characteristics thus has implications for efficiency and equity in the labour market. For instance, this implies that employees in the private-MNC sector receive rents at the cost of tax payers, and the private-SME sector activities may be crowded out as it becomes hard to retain talents.

You have been appointed by the Ministry of Manpower to analyse the private-MNC and private-SME pay gap in Singapore/Malaysia. The data are drawn from the 2018/2019 survey. Using the MS Excel tools, provide the ministry with an analysis of the MNC-SME pay gap. You may assume the officers at the ministry have a good understanding of basic statistics. In addition, the ministry would like you to prepare a ministerial brief to illustrate the key findings of your analysis to the Minister for Manpower.

Answer each of the following questions, showing your analysis in detail (Excel), and use it in your report. Use the 5% significance level and the 95% confidence level where relevant.

1. Focusing on the variable wage for the MNC sector employees only for this question: as shown in several lectures there are two distinct methods of calculating summary or descriptive statistics using Excel. This question requires you to use both methods. First use Excel Data Analysis Tool Pack (the descriptive statistics option) to calculate and interpret the summary statistics. Second use Excel to calculate all descriptive statistics documented in your report. These calculations should be carefully laid out in Excel and should NOT use any hard-wired Excel statistical functions e.g. Average, Median, Mode, STDEV et al. You can use the Excel sort command, the sum command, and any other non-statistical Excel commands.

2. Repeat step 1 above for the variable wage for the SME sector employees.

3. Draw a histogram of the wage distribution for the MNC and SME sector employees respectively. Interpret the graphs carefully.

4. What are the main differences in demographic and social-economic characteristics between employees in the MNC and SME sector? Aid your answer with appropriate tables/graphs.

5. Propose a statistical method to estimate the mean hourly wage rate for all MNC sector employees and all SME sector employees, respectively. Clearly label your diagram and indicate any assumptions made and explain carefully.

6. A media report claims that the mean hourly wage rate for all MNC sector employees in was $ 49. Do you agree? Perform a hypothesis test at the 5% significance level. Clearly label your diagram and indicate any assumptions made. Explain carefully if any potential errors in your decision making.

7. Since the answer to Question 5 above suggests a higher mean hourly wage rate in the MNC/SME sector, an office in the ministry hence concludes that the population mean hourly wage rates are not equal between two sectors. Do you agree? Propose a statistical method to examine if the population mean hourly wage rates are equal for the MNC and SME sector. Clearly indicate any assumptions made.

8. Should the Minister be concerned if the population mean hourly wage rate is higher in the MNC sector? Propose at least two(2) policies for the ministry to address this issue.

Part B-1 Professional Report should be max 12 pages

Part B-2: Write a ministerial brief of no more than 200 words containing no more than 3 graphs on the MNC-SME pay gap and any other interesting findings that would be of policy relevance to the Minister. Draw on the relevant evidence you have gathered from your analysis, as well as other information/evidence not covered here but you believe is useful. Your brief should summarize your results from part A in a non-technical way and provide relevant conclusions.

Kĩ năng: Excel, Nhập liệu, Viết báo cáo, Viết kĩ thuật

Xem nhiều hơn: statistical analysis india industry problem report, project report financial market statistical analysis, project report statistical analysis cc, write report spss statistical analysis, statistical analysis report, report statistical analysis using minitab, report writing statistical analysis, statistical analysis report excel, format statistical analysis report, write statistical analysis report, statistical analysis project report excel, statistical analysis report psychology, statistical analysis report sample, i need a statistical analysis done, how to write a statistical analysis, how to write a statistical analysis section, how to write a statistical analysis report, why do researchers need a statistical analysis of their data, why do researchers need a statistical analysis of their data before declaring their results?

Về Bên Thuê:
( 1 Nhận xét ) Singapore, Singapore

ID dự án: #32278860

Được trao cho:

saba106

I am an expert statistician, research writer and data analyst with more than four years of experience. I have full command on Excel analysis, proficient in SPSS, STATA ,R LANGUAGE AND PYTHON. I am expert in sentiment a Thêm

$90 SGD trong 1 ngày
(2 Đánh Giá)
1.9

16 freelancer chào giá trung bình$118 cho công việc này

topacademics

I will provide you quality report writing. I am a PhD writer with 10 years of experience. I have worked on several similar projects of report writing, and can deliver professional report writing to tight deadlines. You Thêm

$100 SGD trong 1 ngày
(992 Nhận xét)
8.6
topacademictutor

A Statistical Analysis and Professional & Ministerial report for my personal blog I have 13 years of experience in the Writing Industry and I can provide you with “SUPREME QUALITY WORK” within your “GIVEN DEADLINE” wi Thêm

$30 SGD trong 1 ngày
(1169 Nhận xét)
8.0
assignsolver

A Statistical Analysis and Professional & Ministerial report for my personal blog I have read and understood all your project details and I feel my self the best candidate to complete this project with 100% accuracy. Thêm

$30 SGD trong 1 ngày
(703 Nhận xét)
7.4
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Thêm

$250 SGD trong 5 ngày
(34 Nhận xét)
6.4
HelpingHut

A Statistical Analysis and Professional & Ministerial report for my personal blog After reading your project details, I feel, I am the best option for you to fulfill this project with 100% perfection. I am working in Thêm

$30 SGD trong 1 ngày
(458 Nhận xét)
6.8
ARTICLEYOUWANT

A Statistical Analysis and Professional & Ministerial report for my personal blog Hello! I am Anusha, an analytical, goal-oriented PhD-level professional with a keen attention to detail. I am recognized for clarity and Thêm

$50 SGD trong 1 ngày
(74 Nhận xét)
6.0
SolutionMart

A Statistical Analysis and Professional & Ministerial report for my personal blog I am a supreme writer who has full command over Academic Writing including; SWOT, PESTEL, Porter Five Forces Analysis, 7Ps, summaries, Thêm

$30 SGD trong 1 ngày
(74 Nhận xét)
4.9
josephkirkmaling

Hello, I have read your need for a statistics and professional ministerial report. I am a data entry, excel, technical and report writing expert with three years of remote experience, and six years of work experience Thêm

$300 SGD trong 7 ngày
(6 Nhận xét)
4.6
(14 Nhận xét)
3.7
sheikhneha738

I do my work with full responsibility and I do my work with full dedication and hard work, if you want you can believe me

$140 SGD trong 7 ngày
(0 Nhận xét)
0.0
dutta98

I am expert of this projects. I have many years experience in data entry,technical writing,excel word.

$140 SGD trong 5 ngày
(0 Nhận xét)
0.0
arslanmahais43

I am a new freelancer. But I have good skills. Last 4 year I worked with data entry. I have a high skilled in Excel,Data Entry, Pdf to Excel, PDF to word,Copy paste, MS word. I will complete your work very carefully an Thêm

$140 SGD trong 7 ngày
(0 Nhận xét)
0.0
RJrishax

I am a professional data entry operator working as a freelancer . I have good typing speed and ability to complete your task/project within time line. I have 2 years of experience working as a data entry with excellent Thêm

$140 SGD trong 7 ngày
(0 Nhận xét)
0.0
Adarsh93898

I am best candidate for the work because I know that about this project . I done your work on time so I am best for the project

$140 SGD trong 7 ngày
(0 Nhận xét)
0.0
Adilnajar

confident that I will thrive in this position, seeing that I have all the skills that you are looking for. Having worked as a sales and marketing agent, I'm well versed with the job requirements.

$140 SGD trong 7 ngày
(0 Nhận xét)
0.0