The objective of this assignment is for students to apply statistical concepts on real-world data and write a report on their observation.
The objective of this assignment is for students to apply statistical concepts on real-world data and write a report on their observation. Students must ensure that their observation is supported by valid sources.
This assignment will make use of what you have learnt in:
The assignment should be submitted in a report format along with a Microsoft Excel file with the spreadsheets created for the following two tasks.
Read the following article on “AI and Digitalisation in Real Estate Sector”.
In the introduction section of your final report, you need to describe how the two tasks can be related to AI and digitalization of the new economy.
Refer to T-1 and T2 dataset of CA3.xls.
As a social scientist, you are studying the issue surrounding the declining population growth rate in Singapore. Data relating to the number of registration of marriage was collected.
(a)Construct relevant tables and plot a 10-year(2010 – 2020) time series chart that shows the trend in the number of marriage in Singapore. What can we conclude about the growth rate of marriage in Singapore, especially for the Chinese and the inter-ethnicity marriage. What useful information can be derived from the charts about the marriage trend in the last 10 years, especially in the last 2 years?
(b)Produce a scatter plot with best fit linear trend line. What is the linear regression equation? Describe what you think are the factors underpinning this trend? Briefly describe three (3) possible social consequences that may happen in 5-10 years time if this social phenomenon were not addressed.
Refer to Public and Private dataset of CA3.xls.
In a well-functioning labor market, individuals with same productive attributes (e.g. education attainment, working experience) should be equally paid. The existence of public-private “pay gap” for individuals with similar productive characteristics thus has deep implications for efficiency and equity in the labour market.
Use the 5% significance level and the 95% confidence level where relevant.
(a)Describe and compare the distribution of the wage of public and private employees. (Hint: with respect to the Centre of Location, Data Spread and Shape).
(b)Construct a histogram of the wage distribution for the public and private sector employees respectively. Interpret the graphs carefully.
(c)What are the main differences in demographic and social-economic characteristics between employees in the public and private sector? Aid your answer with appropriate tables/graphs, and provide your comments.
(d)Propose and execute a statistical method to estimate the mean hourly wage rate for allpublic sector employees and all private sector employees, respectively.
(e)A media report claims that the mean hourly wage rate for all public sector employees 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.
(f)Since the summary data suggests a higher mean hourly wage rate in the public sector, a union lobbyist concludes that the population mean hourly wage rates are not equal between two sectors. Do you agree? Propose and execute a statistical method to examine if the population mean hourly wage rates are equal for the public and private sector.
1.The report should have a cover page, content page, introduction, write-up on the task, conclusion, references and appendices
2.The cover page should include:
3.Each question should be a separate section
4.The references should be presented in Harvard format and should have at least THREE (3) references.