Do it on Excel,

Portfolio Question One - Cost estimation lantcity is a large nursery and retail store specializing in house and garden lants and supplies. Jean Raouth, the assistant manager, is in the process of udgeting monthly supplies expense for 2019. She assumes that in some way upplies expense is related to sales, either in units or in dollars. She has ollected these data for sales and supplies expenses for June 2016 through December 2018, and has estimated sales for 2019. Data Supplies $ Date June-16 July-16 August-16 September-16 October-16 November-16 December-16 January-17 February-17 March-17 April-17 May-17 June-17 July-17 August-17 September-17 October-17 November-17 December-17 January-18 February-18 March-18 April-18 May-18 June-18 July-18 August-18 September-18 October-18 November-18 December-18 January-19 February-19 March-19 April-19 May-19 June-19 July-19 August-19 September-19 October-19 November-19 December-19 2,745 3,200 3,232 2,199 2,321 3,432 4,278 2,310 2,573 2,487 2,484 3,384 2,945 2,758 3,394 2,254 2,763 3,245 4,576 2,103 2,056 3,874 2,784 2,345 2,912 2,093 2,873 2,563 2,384 2,476 3,364 Sales (Units) Sales Dollars) 354 $ 20,090 436 $ 21,900 525 $ 28,780 145 $ 18,560 199 $ 21,680 543 $ 21,520 1,189 $ 24,630 212 $ 19,990 284 $ 21,900 246 $ 18,940 278 $ 21,340 498 $ 32,100 424 $ 28,500 312 $ 22,650 485 $ 24,350 188 $ 18,930 276 $ 22,320 489 $ 30,040 1,045 $ 33,090 104 $ 21,950 167 $ 20,450 298 $ 23,010 398 $ 23,450 187 $ 18,150 334 $ 20,940 264 $ 19,340 333 $ 20,540 143 $ 19,770 245 $ 18,570 232 $ 21,890 1,122 $ 34,330 180 $ 16,000 230 $ 20,000 190 S 19,000 450 $ 24,000 350 $ 23,000 350 $ 23,000 450 $ 25,000 550 $ 30,000 300 $ 25,000 300 $ 25,000 450 $ 32,000 950 $ 39,000 Required Develop the regression that Jean should use based on the data and evaluate the reliability and precision of the regression you have chosen .. What are the predicted monthly figures for supplies expense for 2019