﻿ 信息技术文凭代写 Business Statistic代写 - CS代写, Python代写

2022-01-26 11:48 星期三 所属： CS代写 浏览：172

## Instructions for CA3 Individual Assignment

### 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”.

https://www.straitstimes.com/tech/how-ai-and-digitalisation-are-changing-the-real-estate-sector-in-singapore

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.

### 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.