Please create an Excel file and copy the following table into the spreadsheet. Table1 2014 2015 2016 2017 2018 2019 region 1 region 2 region 3 300 390 480 610 710 450 660 720 870 970 50 320 630 730...

dear tutor please help me im in problem

please solve question well

ill be thankful for lifetime. please get me out of this question

Extracted text: Please create an Excel file and copy the following table into the spreadsheet. Table1 2014 2015 2016 2017 2018 2019 region 1 region 2 region 3 300 390 480 610 710 450 660 720 870 970 50 320 630 730 850 region 4 region 5 530 550 750 950 980 100 490 640 740 Overall CSR Calculate sum for every column Using Excel, create a chat based on the results of your calculations. For this purpose, please copy your data into a small table as shown below. Table 2 2014 2015 2016 2017 2018 2019 Overall SCR


Extracted text: Please calculate your 2019 prognosis for the overall CSR headcount and fill in the last column (2019) of table2. For this purpose, you can use the regression formula you got in the graph. To get the forecast you need to calculate y for x=6, as 2019th is the 6th year in the sequence. You can also use the Forecast function in Excel to get the same forecast numbers. Both ways are correct. Using the same algorithm, please develop the forecast for each region and fill in the last column of table 1. Please make sure you modify the algorithm for region 5, as it was developed a year later. This means you will not include year 2014 in your regression for reg 5.