$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 $354702229412$

LG $14240112170$

None $586841420182$

Other $81902736153$

Samsung $317021124183$

Grand Totals $5385384952301000$

$4($b$)$ Using the brand switching matrix from $4($a$),$ answer the following:

$$ What percentage of SU students currently own an Apple smartphone? $($This is the market share of Apple.$)$ Answer: $412/1000=41\%$

$$ Consider now the SU students whose current brand is Apple smartphone. For this group of students, what percentage will select Apple as the next brand? $($This is the brand loyalty of Apple.$)$ Answer: $354/1000=86\%$

$$ Consider the students who do not have a smartphone now. What percentage of these students want Apple as their next brand? $182/412=44\%$

$$ Consider the students who have LG now. What percentage of these students want Apple as their next brand? Answer: $70/412=17\%$