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 356S22 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

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

• What percentage of SU students currently own an Samsung smartphone? (This is the market share of Samsung.)
• Consider now the SU students whose current brand is Samsung smartphone. For this group of students, what percentage will select Samsung as the next brand? (This is the brand loyalty of Samsung.)
• What percentage of students who do not have a smartphone now will like to have Samsung as their next brand?

4(C)Using pivot table and gender as filter, prepare separate brand switching matrices for men and women.

4(d) Using pivot table and class as filter, prepare separate brand switching matrices for (1) seniors, and (2) others (that is, Freshmen, sophomore, and junior, combined)