Question: solve with excel and please link the file 2. Demonstrate how to use Excel to encrypt or code a message using matrices and their inverse.

solve with excel and please link the file
solve with excel and please link the file 2. Demonstrate how to

2. Demonstrate how to use Excel to encrypt or code a message using matrices and their inverse. Example: The message to be encoded is SEPTEBMER IS HERE The encoded message to be formed using triplets of numbers and the 3x3 matrix A = 0 0 whose inverse is 3 1 51 -2011 A-1 0 0 = -13 1-5 2 0 1 Use the following association of letters and divide the message into triplets of letters: SEP TEM BER ISH ERE A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Now multiply the matrix A times each column vector of the message. You will receive the coded message. To decode the message, form 3x1 column vectors of the numbers in the coded message and multiply on the left by A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!