Macintyre Care is a charity providing learning support and care for children, young people and adults with a learning disability or autism in England. Its main business activity according to the UK standard industry classification $(2007)$ is $$residential care activities for the elderly and disabled$.$

Macintyre Care and sector data

Care sector Macintyre Care Price index $($CPIH$)$

Year Turnover $($k$)$ Turnover $($k$)$ Expenses $($k$)$ Rate of change, ONS series L$55$O$,$ base $=2015$ Level, ONS series L$522,$ base $=2015$

$20031,194,370$ n$/$a $27,4821\mathrm{.}476\mathrm{.}7$

$20041,346,734$ n$/$a $27,1791\mathrm{.}477\mathrm{.}8$

$20051,478,581$ n$/$a $28,1832\mathrm{.}179\mathrm{.}4$

$20061,676,397$ n$/$a $31,5072\mathrm{.}581\mathrm{.}4$

$20072,059,213$ n$/$a $34,4022\mathrm{.}483\mathrm{.}3$

$20082,425,576$ n$/$a $40,0633\mathrm{.}586\mathrm{.}2$

$20092,659,626$ n$/$a $44,260287\mathrm{.}9$

$20102,903,53646,36045,4782\mathrm{.}590\mathrm{.}1$

$20113,371,05946,60045,0903\mathrm{.}893\mathrm{.}6$

$20123,740,54948,42346,9182\mathrm{.}696$

$20134,367,93547,84646,0432\mathrm{.}398\mathrm{.}2$

$20144,607,87545,87045,4251\mathrm{.}599\mathrm{.}6$

$20154,782,76345,23245,8830\mathrm{.}4100$

$20165,109,23245,65246,2291101$

$20175,728,18247,84645,1332\mathrm{.}6103\mathrm{.}6$

$20186,097,06153,71452,9102\mathrm{.}3106$

$20196,113,12059,26757,5821\mathrm{.}7107\mathrm{.}8$

$20206,611,35269,04062,7321108\mathrm{.}9$

$20216,765,54267,19964,1382\mathrm{.}5111\mathrm{.}6$

Use this information above about Macintyre Care to complete the following tasks:

Forecast the sector turnover for the next four years using linear regression and show historical as well as forecast values in a graph?

Calculate a $95\%$ prediction interval for this forecast?

Adjust the historical sector turnover for inflation using the consumer price index including housing $($CPIH$)?$

Estimate the growth trend for both turnover and expenses of Macintyre Care using the available data and linear regression?

Based on your analysis: Report and interpret your findings on the average annual growth of Macintyre Care and the sector as a whole?

Compare the growth rate of Macintyre Care$$s turnover to its expenses, indicating whether turnover is growing faster or slower than expenses?

Discuss business implications of your analysis?