Question 2

https://www.aas.com.sg/resources/coe/coe-prices.html

There are 2 COE bidding results per month.

Refer to the website[1] of Automobile Association of Singapore (AAS) and extract the past COE bidding prices for Category A cars from January 2021 to December 2021 as your sample size[2]. Discuss the trend of the COE prices for Category A cars in the year 2021 and explain ANY TWO (2) possible reasons for the current trend.

Given that COE prices are normally distributed with a population mean of $45,000 and a population standard deviation of $4,500, conduct a Hypothesis Test at a 5% significance level to comment and validate on the VALIDATION POINT B as stated in the case (Please show all necessary formulae, workings and Excel outputs).