# MAT 211 ASU By Ulrich Exam 2

There are 150 examination points on this EX2, worth 15 CPs.

Make sure to appropriately rename the workbook by replacing Name in the filename with your last name plus immediate first initial, and change nothing else (as we have been doing).  However, if you do not appropriately rename the file, you will automatically lose 15% of your points.  Hence, it is in your best interests to let me look at your file before you submit it if you have any questions, including the filename.

Make sure to also follow my formatting instructions.  As stated in the GEN101 activities and documents:

ñIf you correctly format the cells but have a wrong answer, some partial credit is likely, but

ñIf you incorrectly format the cells, then it won’t matter whether you performed the calculations correctly: It’s wrong!

Again, feel free to email should you have any questions; please remember to identify your course in the email subject line, and to also attach a current copy of your examination.

Make sure to NOT type in any values where calculations are required, which is just about everywhere.  I will let you know when you may type in a value, if applicable.

ñIF you type a value directly into any cell not authorized by me, then you will lose ALL points for that worksheet

The diagram at the right represents what proportion of a company’s customers each fiscal quarter transition to another company for its products and services.  Obviously, some customers stay with each company, these are denoted by the shaded cells along the One-Step Transition Matrix’s main diagonal.

Any proportions remaining coming out of each company are customers that stay with that company.

You MUST calculate each company’s customer loyalty % by selecting the values along Column S.

Set up the One-Step transition matrix based on the graphic and the instructions immediately above; make sure to finish shading in the matrix’s cells.  Then find the steady state matrix, after which you will be able to answer this question: In the long run, which company will most probably maintain the greatest market share?