Quarter Executive5-room 4-room 3-room 2-room 1-room

2007-Q1511140223651908675

2007-Q2854230530912390653

2007-Q3738190128332179656

2007-Q4524166725251945807

2008-Q1453157424151854593

2008-Q2656199728572182656

2008-Q3625217229562296612

2008-Q4405157823361806574

2009-Q1372150624882011645

2009-Q2753271337872860701

2009-Q31058342240623015884

2009-Q47802187332625081205

2010-Q16512047319024711223

2010-Q27682240329626791274

2010-Q36871975296524071665

2010-Q45101477229020361347

2011-Q14561582226618181033

2011-Q24951635236519661164

2011-Q34581415211817961124

2011-Q4484141222241712863

2012-Q14371370222617561003

2012-Q26271594267619741391

2012-Q357815582419184814611

2012-Q44961288212915931232

2013-Q1328962152313621591

2013-Q24151070192216401853

2013-Q3339969167013771722

2013-Q4309784152412511321

2014-Q123072614441285924

2014-Q2274913166914111193

2014-Q330496017351416944

2014-Q430610241779139811810

2015-Q127692516081247772

2015-Q2357121021201518783

2015-Q3362114019351374802

2015-Q4402111319931399823

2016-Q1345102318091220511

2016-Q2421136924731500723

2016-Q3433128322501473741

2016-Q4359118620711326691

2017-Q1342105518571210642

2017-Q24451407252915191001

2017-Q3432142824471400965

2017-Q4480140323681414712

2018-Q1423111118101046662

2018-Q25231559237213821023

2018-Q36101797282817041213

2018-Q4401135023941408822

2019-Q1337114820321225876

2019-Q2471152026521532974

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:

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?

Could you advise for c. what excel function or test I should use?

Is it the Two-Sample t-Test for Assuming equal varinaces or unequal variances or is it the paired t test?