Analysis of Re-Sale Flat Applications: 3-room vs 4-room

A research report shows that there is a trend that more people prefer to live in 4-room or bigger HDB flats. To investigate whether this finding is true, you have collected the quarterly number of re-sale flat applications from Quarter 1 of 2007 to the recent Quarter 2 of 2019. The data is given in the Excel data file “BUS105_GBA_resale”. Please conduct some of your own research and use the Excel software to answer the following:

(a) Use relevant numerical measures and graphical representations to have some preliminary observations of the 3-room and 4-room re-sale flat applications.

(b) Show 95% confidence intervals for the average number of 4-room and 3-room re-sale flat applications, respectively. Discuss whether you can conclude that there are more 4-room re-sale flat applications than the 3-room re-sale flat applications.

(c) Apply an appropriate test of hypothesis to determine if there are more 4-room re-sale flat applications than the 3-room re-sale flat applications.

(d) Summarise your analysis and findings regarding the research question whether there is a trend that more people prefer to live in 4-room or bigger HDB flats. The word limit is 300 words. Please indicate the word count at the end of your answer.

If you have a free hand to study this research question starting from data collection to analysis, how would you conduct the project? Solve this question by conducting more research and statistical analysis.