$\backslash$table$[[$Year$,$Quarter,$\backslash$table$[[$Period$],[$t$]],\backslash$table$[[$Demand$],[$D$]],\backslash$table$[[$Deseasonalized$],[$Demand$]],\backslash$table$[[$Seasonal$],[$Factor$],[$S$]]],[1,2,1,9224,,],[1,3,2,13545,,],[1,4,3,25235,,],[2,1,4,36324,,],[2,2,5,12346,,],[2,3,6,19635,,],[2,4,7,25743,,],[3,1,8,39976,,],[3,2,9,14134,,],[3,3,10,14999,,],[3,4,11,34123,,],[4,1,12,43232,,],[4,2,13,,,],[4,3,14,,,],[4,4,15,,,]]$

Problems: Show all work to receive credit

Problem $1($Worth $13$ percent$)$

Excel shows a linear regression of

$19,521+720t$ use this

Fill in All the missing information