Hello, please answer the problem in excel format. If you don't mind could you please provide step$-$by$-$step as I am very confused. Thank you very much!

P$($win$),$ P$($draw$),$ P$($loss$)$

Exhibit $10$ lists $20$ matches played over two weekends in $2012$ along with the values of the covariates. Use

multinomial logistic regression to predict the match outcome in all $20$ cases listed in Exhibit $10.$

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

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$

Match $\backslash \backslash$

Number

$\backslash$end$\{$tabular$\}$ & Match b$/$w & HTGD & FGS & RED$\_$

H & RED$\_$A & POINTS$\_$H & POINTS$\_$A & TOTAL$\_$H$\_$P & TOTAL$\_$A$\_$P & $\backslash [$

$\backslash$begin$\{$array$\}\{$c$\}$

$\backslash$mathrm$\{$MATCH$\}\_\{-\}\backslash \backslash$

$\backslash$mathrm$\{$O$\}$

$\backslash$end$\{$array$\}$

$\backslash ]\backslash \backslash$

$\backslash$hline $1$ & Swansea City vs$.$ Everton & $-2$ & $0$ & $0$ & $0$ & $7$ & $7$ & $47$ & $56$ & $0\backslash \backslash$

$\backslash$hline $2$ & Chelsea vs$.$ Stoke City & $0$ & $2$ & $0$ & $0$ & $10$ & $4$ & $64$ & $45$ & $2\backslash \backslash$

$\backslash$hline $3$ & Southampton vs$.$ Aston Villa & $-1$ & $0$ & $0$ & $0$ & $0$ & $4$ & $0$ & $38$ & $2\backslash \backslash$

$\backslash$hline $4$ & West Bromwich Albion vs$.$ Reading & $0$ & $2$ & $0$ & $0$ & $7$ & $1$ & $47$ & $0$ & $2\backslash \backslash$

$\backslash$hline $5$ & West Ham United vs$.$ Sunderland & $-1$ & $0$ & $0$ & $0$ & $7$ & $3$ & $0$ & $45$ & $1\backslash \backslash$

$\backslash$hline $6$ & Wigan Athletic vs$.$ Fulham & $-1$ & $0$ & $0$ & $0$ & $4$ & $6$ & $43$ & $52$ & $0\backslash \backslash$

$\backslash$hline $7$ & Liverpool vs$.$ Manchester United & $0$ & $2$ & $1$ & $0$ & $2$ & $9$ & $52$ & $89$ & $0\backslash \backslash$

$\backslash$hline $8$ & Newcastle United vs$.$ Norwich City & $1$ & $1$ & $0$ & $0$ & $5$ & $3$ & $65$ & $47$ & $2\backslash \backslash$

$\backslash$hline $9$ & Manchester City vs$.$ Arsenal & $1$ & $1$ & $0$ & $0$ & $8$ & $8$ & $89$ & $70$ & $1\backslash \backslash$

$\backslash$hline $10$ & Tottenham Hotspur vs$.$ Queens Park Rangers & $-1$ & $0$ & $0$ & $0$ & $5$ & $2$ & $69$ & $37$ & $2\backslash \backslash$

$\backslash$hline $11$ & Arsenal vs$.$ Chelsea & $0$ & $0$ & $0$ & $0$ & $9$ & $13$ & $70$ & $64$ & $0\backslash \backslash$

$\backslash$hline $12$ & Everton vs$.$ Southampton & $2$ & $0$ & $0$ & $0$ & $10$ & $3$ & $56$ & $0$ & $2\backslash \backslash$

$\backslash$hline $13$ & Fulham vs$.$ Manchester City & $0$ & $1$ & $0$ & $0$ & $9$ & $9$ & $52$ & $89$ & $0\backslash \backslash$

$\backslash$hline $14$ & Norwich City vs$.$ Liverpool & $-2$ & $0$ & $0$ & $0$ & $3$ & $2$ & $47$ & $52$ & $0\backslash \backslash$

$\backslash$hline $15$ & Reading vs$.$ Newcastle United & $0$ & $2$ & $0$ & $0$ & $1$ & $8$ & $0$ & $65$ & $1\backslash \backslash$

$\backslash$hline $16$ & Stoke City vs$.$ Swansea City & $2$ & $1$ & $0$ & $0$ & $4$ & $7$ & $45$ & $47$ & $2\backslash \backslash$

$\backslash$hline $17$ & Sunderland vs$.$ Wigan Athletic & $0$ & $2$ & $0$ & $0$ & $4$ & $4$ & $45$ & $43$ & $2\backslash \backslash$

$\backslash$hline $18$ & Manchester United vs$.$ Tottenham Hotspur & $-2$ & $0$ & $0$ & $0$ & $12$ & $8$ & $89$ & $69$ & $0\backslash \backslash$

$\backslash$hline $19$ & Aston Villa vs$.$ West Bromwich Albion & $0$ & $2$ & $0$ & $0$ & $4$ & $10$ & $38$ & $47$ & $1\backslash \backslash$

$\backslash$hline $20$ & Queens Park Rangers vs$.$ West Ham United & $-2$ & $0$ & $0$ & $0$ & $2$ & $8$ & $37$ & $0$ & $0\backslash \backslash$

$\backslash$hline

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