Time Series data on Fiji's Consumer Price Index (CPI) between 2017 - 2020 sourced from the Fiji Bureau of Statistics (FBoS).
Show all working please
Using this data, please answer the following questions:
Establish a regression trend line in the form of Y = a + bX + ? by estimating the values for 'a' and 'b'.
G Housing, Water, Health Transpo Food and Non- Alcoholic Clothing and Furnishings, Hhld Equip. & Division alcoholic Beverages, Footwear Elec., Gas and Beverages Tobacco and Other Fuels Routine Hhid All Maint Items Narcotics 21.7 126.8 50.0 14.1 Weight 1000.0 347.1 105.7 9.8 2.1 4.5 0.4 2.8 Annual 2015 1.4 4.8 27.0 1.2 -5.0 -0.5 4.1 5.9 Average 2016 3.8 31.8 0.2 2.0 0.8 -0.4 2017 3.3 -2.1 3.4 19.4 0.6 2.1 -0.2 -1.3 2018 4.1 18 4.9 5.5 1.0 -0.1 0.9 -0.4 2019 41.4 1.3 -0.6 1.4 -0.4 20 2017 January 6.S 7.1 1.3 2.8 -0.3 February 4.3 42.9 0.6 5.5 3.1 48.4 2.0 0.6 3.4 0.1 March 5.6 2.2 0.5 April 4.1 -3.5 44.2 -0.4 4.5 -0.6 4.5 0.4 0.4 MAY 2.5 -4.8 28.9 -6.0 25.8 -0.3 4.5 0.1 -1.3 June 2.0 2.2 0.4 -1.3 July 2.0 -6.2 30.5 -0.3 August 27.8 -0.8 0.5 1.2 2.0 -5.2 1.9 -4.2 23.6 -0.1 1.9 0.4 -1.2 September 2.1 0.7 October 2.6 -3.7 27.5 -0.9 2.2 -0.3 2.5 0.9 November 25.4 -0.6 -3.0 2.2 0.5 December 2.8 .2.8 26.1 0.7 2.2 0.9 0.6 -6.0 23.5 0.4 2.9 2.0 2018 January 1.6 -2.0 21.4 2.9 -0.7 February 2.3 0.5 March 2.6 0.2 16.4 0.2 2.9 0.0 -0.9 April 4.0 6.1 17.2 0.2 0.1 0.1 -0.4 -0.7 May 5.1 6.4 23.3 0.5 4.6 5.1 22.3 0.6 0.1 0.1 -1.3 June 47 4.1 21.6 0.4 2.3 -0.1 2.4 July 4.3 3.3 20.3 1.4 2.3 August 4.9 18.6 0.9 2.3 0.2 -2.3 September 4.6 7.8 2.6 October 5.2 16.1 1.5 1.0 -2.3 7.2 16.6 0.2 2.6 0.7 -2.1 November 5.1 17.2 0.2 37 10 -2.2 December 4.8 5.1 45 0.4 -3.1 46 2019 January 5.1 7.9 17. 0.7 0.4 -1.1 February 5.1 10.4 16.1 0.1 0.4 0.4 2.0 48 March 4.0 7.7 14.4 13.1 0.5 0.3 -1.2 49 April 2.1 2.0 2.1 4.7 8.0 0.7 0.3 -1.2 50 May 7.8 -0.1 June 2.8 7.3 0.9 0.3 0.7 0.8 0.8 52 July 0.7 3.2 2.1 0.5 0.1 1.2 5.6 0.S 1.1 0.1 0.5 0.8 53 August 1.6 0.1 0.7 0.9 54 September 0.4 3.3 0.0 0.7 0.9 55 October 0.9 1.2 2.3 November 0.3 2.9 2.6 1.0 0.5 56 4.3 19 10 0.1 57 December 0.9 2.8 58 0.2 0.1 59 2020 January -1.9 -1. 1.3 2.4 -0.3 0.0 60 February -3.0 -6.1 0.1 0.6 61 March -2.8 -5.6 0.7 0.8 62 April -1.3 1.0 -8.7 0.3 63 MAY -17 -1.0 64Q L M N P R J K NATIONAL PERIOD IN PREVIOUS YEAR Health Transport Commun Recreation Education Restaurants Miscella- ication & Culture & Hotels beous Goods & Services 75.3 30.5 138.7 44.2 16.1 29.8 14.1 -3.7 0.1 0.6 -1.7 1.5 4.1 2.8 -3.9 -1.5 8.2 -0.8 4.1 -1.6 3.5 0.7 2.9 -0.6 -0.4 1.8 -03 -0.4 0.1 0.0 1.6 0.0 -1.3 2.0 0.2 0.1 13.8 0.2 4.8 0.2 14 -0.4 0.8 -0.4 0.4 -0.3 -0.2 9.0 2.3 -0.3 0.4 -0.2 0.1 0.0 2.7 -0.4 0.1 0.3 -0.3 0.0 0.0 2.8 -0.6 0.5 -0.3 0.0 2.8 -0.5 3.4 0.0 3.2 -03 -02 0.0 2.8 -0.2 0.4 -1.3 3.3 -03 -0.4 0.0 2.2 -0.3 -1.3 1.8 -0.3 -2.1 0.0 3.3 -0.4 -1.2 1.8 -0.3 -1.0 0.0 3.3 -0.5 -0.3 -1.1 0.0 2.9 -0.8 -1.2 1.9 2.0 -0.3 -0.6 0.0 2.9 -0.9 -0.7 -0.6 2.0 -0.2 -0.3 DO 2.9 .0.9 0.2 0.4 3.0 1.0 0.6 1.8 2.0 1.5 0.0 0.5 0.0 1.0 -0.6 .0.7 14 0.1 0.2 0.0 2.4 -0.4 0.0 1.4 0.1 0.1 0.0 2.3 0.0 36 0.1 0.2 0.0 2.3 0.0 0.9 0.5 0.7 0.2 0.0 2.3 -0.5 -0.7 -13 0.7 0.2 0.0 2.2 -03 0.0 -2.4 2.4 0.0 1.1 -2.3 2.4 0.3 0.0 1.1 0.1 -23 2.4 0.1 0.4 1.1 0.3 -2.3 3.3 0.1 0.4 ).0 1.1 0.3 -2.1 3.3 0.1 0.3 1.1 0.5 -2.2 3.4 0.1 0.2 1.0 0.7 -3.1 0.5 0.1 0.4 0.0 0.6 -1.1 0.9 -15.2 0.3 0.6 0.5 -2.0 0.9 -15.2 0.4 5.2 -0.1 0.3 0.0 -0.3 -15.2 0.4 5.2 -0.1 -0.2 -15.2 0.2 5.2 0.2 0.0 -1.2 -0.1 -0.2 -15.2 0.0 5.2 0.3 0.2 0.S 0.3 -15.0 0.0 5.2 0.3 0.S 0.8 0.4 -15.0 0.0 5.2 0.3 1.1 0.3 1.8 0.9 0.4 -15.0 0.0 5.2 0.9 -0.9 -15.0 0.1 5.2 0.3 2.8 0.5 0.0 -15.0 0.1 5.2 0.3 3.7 -15.0 5.2 0.9 3.7 0.1 -0.5 1.1 -15.0 0.0 5.2 1.9 4.5 59 0.1 4.4 0.2 0.0 1.9 4.9 60 0.0 0.0 61 0.6 4.1 0.1 -0.1 0.0 1.4 is in i 0.0 0.0 62 0.8 3.4 0.9 0.0 0.9 63 0.3 -0.4
