$.(3+4+3+3=13$ points$)$ You have to prepare the answer to this question using Excel and the data given in the worksheet Problem $4$ in the Excel file $$Data for $754$S$24$ Assignment $1.$

A sample of $1000$ Syracuse University students was collected to examine smart phone usage and purchase intentions. In particular, each student has reported which brand of smart phone he$/$she currently owns $($that is$,$Current Brand$)$ and which brand he$/$she would most likely purchase the next time he$/$she desires to purchase a new phone $($that is$,$Next Brand$).$

$4($a$)$ Using the pivot table command in Excel, prepare a brand switching matrix. Either fill in the table below, or copy and paste the matrix from Excel.

Next Brand

Current Brand Apple LG None Other Samsung Grand Totals

Apple

LG

None

Other

Samsung

Grand Totals