solve the assigned problem,write detailed solution in Excel worksheets.

Problem 4: Standing Tall is a roofing contractor of houses. Roofing normally is Done two months after the start of a house construction. Initially he relied on a simple linear trend regression forecast using just the months of the year and the number of roofing jobs generated. He felt there was something lacking in his forecasts. He decided to get the city hall housing permits per month to check the number of Jobs generated. 1. Set up the simple linear trend regression forecast using months and number of jobs. Is the regression model a good model? Why or why not? 2. Setup another model using months, permits and jobs. Determine if it is a good model. 3. If so, determine the number of jobs generated for January the following year if 330 permits were issued. Month Jobs 1 19 359 2 17 Month Permits 1 323 2 3 396 4 421 5 457 6 472 Jobs 19 17 24 23 28 3 24 4 23 5 28 32 6 32 7 446 7 34 8 407 8 37 374 9 33 9 10 34 37 33 30 27 22 343 10 30 11 11 27 311 277 12 12 22