Diploma in Information Technology
Business Statistic with Python
Instructions for CA3 Individual Assignment
信息技术文凭代写 The objective of this assignment is for students to apply statistical concepts on real-world data and write a report on their observation.
Continual Assessment 3 Individual Assignment (40%)
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:
- Organising and Visualising Variables
- Numerical Descriptive Measures
- Use of Statistical Software for Data Analysis (Microsoft Excel)
- Hypothesis Tests
- Simple Linear Regression and Correlation Coefficient
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.
Task 1 信息技术文凭代写
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.
Task 2 信息技术文凭代写
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.
Report format 信息技术文凭代写
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:
- Institution name (and institution logo) of this program.
- Module name, semester and year
- Date of submission
- Student’s name and student ID number
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.
Report Word Limit 信息技术文凭代写
1500 to 2000 words
Report Font and Spacing
Font: Calibri, Black
Font size: 12 and 1 ½ or double spacing.
更多代写：计算机伯明翰网课代上 多邻国代考 英国代写网课历史作业 北美留学生assignment代写词 传媒论文代写 代写英国论文写作
