You will need to get two regressions as you will need to determine which one is the more appropriate regression to use. You must evaluate both regressions using a minimum of R-squared comparison. Additional statistical comparisons can be used if you so wish, but the key variable I am looking for is the R-squared.

Must be done Using Excel only.

Portfolio Question One - Cost estimation Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the assistant manager, is in the process of budgeting monthly supplies expense for 2019. She assumes that in some way supplies expense is related to sales, either in units or in dollars. She has collected these data for sales and supplies expenses for June 2016 through December 2018, and has estimated sales for 2019. Data Supplies Date Expense June-16 S 2,745 July-16 3,200 August-16 3,232 September-16 2,199 October-16 2,321 November-16 3,432 December-16 4,278 January-17 2,310 February-17 2,573 March-17 2,487 April-17 2,484 May-17 3,384 June-17 2,945 July-17 2,758 August-17 3,394 September-17 2,254 October-17 2,763 November-17 3,245 December 17 4,576 January-18 2,103 February-18 2,056 March-18 3,874 April-18 2,784 May-18 2,345 June-18 2,912 July-18 2,093 August-18 2,873 September-18 2,563 October 18 2,384 November 18 2,476 December-18 3.364 January-19 February-19 March-19 April-19 May-19 June-19 July-19 August 19 September-19 October 19 November-19 December-19 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 $ 19,000 24,000 350 $ 23,000 350 $ 23,000 450 $ 25,000 30,000 300 $ 25,000 25,000 32,000 950 $ 39,000 A A A A A A Required 1. Develop the regression that Jean should use based on the data and evaluate the reliability and precision of the regression you have chosen 2. What are the predicted monthly figures for supplies expense for 2019? Portfolio Question One - Cost estimation Plantcity is a large nursery and retail store specializing in house and garden plants and supplies. Jean Raouth, the assistant manager, is in the process of budgeting monthly supplies expense for 2019. She assumes that in some way supplies expense is related to sales, either in units or in dollars. She has collected these data for sales and supplies expenses for June 2016 through December 2018, and has estimated sales for 2019. Data Supplies Date Expense June-16 S 2,745 July-16 3,200 August-16 3,232 September-16 2,199 October-16 2,321 November-16 3,432 December-16 4,278 January-17 2,310 February-17 2,573 March-17 2,487 April-17 2,484 May-17 3,384 June-17 2,945 July-17 2,758 August-17 3,394 September-17 2,254 October-17 2,763 November-17 3,245 December 17 4,576 January-18 2,103 February-18 2,056 March-18 3,874 April-18 2,784 May-18 2,345 June-18 2,912 July-18 2,093 August-18 2,873 September-18 2,563 October 18 2,384 November 18 2,476 December-18 3.364 January-19 February-19 March-19 April-19 May-19 June-19 July-19 August 19 September-19 October 19 November-19 December-19 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 $ 19,000 24,000 350 $ 23,000 350 $ 23,000 450 $ 25,000 30,000 300 $ 25,000 25,000 32,000 950 $ 39,000 A A A A A A Required 1. Develop the regression that Jean should use based on the data and evaluate the reliability and precision of the regression you have chosen 2. What are the predicted monthly figures for supplies expense for 2019