Problem$-1$:

Write the given data in an Excel file and save it as Read$\_$Excel.xlsx$.$ Write a code to read the data from the Excel file, and store it in matrix variables. Store the header in one array variable and data in another array variable. Rewrite the stored array variables in another Excel file with the name Write$\_$Excel.xlsx$,$ and in the same format as in the read file.

$\backslash$begin$\{$tabular$\}\{|$r$|$r$|$r$|$r$|$r$|$r$|$r$|\}$

$\backslash$hline Xi & $\backslash$multicolumn$\{1\}\{$l$|\}\{$ Yi $\}$ & $\backslash$multicolumn$\{1\}\{$l$|\}\{$ XiYi $\}$ & Xi $\backslash (^\{2\}\backslash )$ & Yi$-$Ymean & Predicted Y & Yi$-$Predicted Y $\backslash \backslash$

$\backslash$hline $1$ & $0\mathrm{.}5$ & $0\mathrm{.}5$ & $1$ & $8\mathrm{.}5762$ & $0\mathrm{.}9107$ & $0\mathrm{.}1686\backslash \backslash$

$\backslash$hline $2$ & $2\mathrm{.}5$ & $5$ & $4$ & $0\mathrm{.}8622$ & $1\mathrm{.}75$ & $0\mathrm{.}5625\backslash \backslash$

$\backslash$hline $3$ & $2$ & $6$ & $9$ & $2\mathrm{.}0408$ & $2\mathrm{.}5892$ & $0\mathrm{.}3472\backslash \backslash$

$\backslash$hline $4$ & $4$ & $16$ & $16$ & $0\mathrm{.}3265$ & $3\mathrm{.}4285$ & $0\mathrm{.}3265\backslash \backslash$

$\backslash$hline $5$ & $3\mathrm{.}5$ & $17\mathrm{.}5$ & $25$ & $0\mathrm{.}0051$ & $4\mathrm{.}2678$ & $0\mathrm{.}5896\backslash \backslash$

$\backslash$hline $6$ & $6$ & $36$ & $36$ & $6\mathrm{.}6128$ & $5\mathrm{.}1071$ & $0\mathrm{.}7971\backslash \backslash$

$\backslash$hline $7$ & $5\mathrm{.}5$ & $38\mathrm{.}5$ & $49$ & $4\mathrm{.}2908$ & $5\mathrm{.}9464$ & $0\mathrm{.}1992\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$