MAT343v12: Applied Linear Algebra: SP18 OL

Random Numbers

Show me that you know how to build a couple of encryption matrices using the RANDBETWEEN macro with values between -71 and 16. To the right of this text box, I want you to generate a 99 matrix space (your choice of shading) and fill that in with RANDBETWEEN values (see PA2.5). Then, under that, you will copy from your RANDBETWEEN matrix two more 99 matrices, but only paste values (again, PA2.5). Make sure to shade all matrices (make sure values are legible!). You will have three possible encryption matrices here, the first still containing the Excel macro, the latter two not.

Winnie

Shift	263	5960	4730	8903	9641	1226	5396	5133	9857	2011
13	-4281	-6789	-3384	-3232	-6584	-7270	-3130	-4494	-7116	-6555
-129	5467	1827	3280	3563	3004	2481	3351	4044	1766
7278	7489	8091	7635	10080	10644	7047	4784	11003	7573
-608	1575	1026	2930	7381	-2961	1112	2807	7003	773
221	1172	-600	-411	317	301	-240	797	257	1376
¯ Decrypt below here in this shaded space ¯
Decoding
Character	D-Value	Character	Encryption A	¯ Decode below here in this shaded space ¯
a	1	a	-6	-7	-1	5	-6	-3
b	2	b	5	-3	-3	-7	-2	-10
c	3	c	3	2	5	-6	-4	3
d	4	d	1	-8	2	-3	-1	-2
e	5	e	5	-1	-4	-10	-4	2
f	6	f	2	-3	-6	5	5	0
g	7	g
h	8	h	Encryption B
i	9	i	5	-3	2	-9	-5	4
j	10	j	4	6	-3	-4	0	0
k	11	k	-2	-9	-10	5	3	-5
l	12	l	-7	-2	-4	-8	0	3
m	13	m	1	0	3	-4	-5	-10
n	14	n	3	-2	6	0	1	3
o	15	o
p	16	p
q	17	q
r	18	r
s	19	s
t	20	t
u	21	u
v	22	v
w	23	w
x	24	x
y	25	y
z	26	z
0	27	0
1	28	1
2	29	2
3	30	3
4	31	4
5	32	5
6	33	6
7	34	7
8	35	8
9	36	9
!	37	!
?	38	?
#	39	#
$	40	$
%	41	%
&	42	&
:	43	:
;	44	;
.	45	.
'	46	'
"	47	"
^	48	^
,	49	,
""	50	""

At the right of this text box is a coded and encrypted message. The original message was coded via the below lexicon key. After being encoded, the values were shifted by the amount shown at the immediate right  The coded and (+) shifted message was then twice encrypted, first by [Encryption A] and then by [Encryption B]. Your first task is to decrypt the message in the given shaded space. Then decode the message and finish by typing the phrase below where indicated. It is preferred that you decrypt the message in the single violet-shaded matrix at the right. However, if you would rather use 1-2 additional matrices for your inverted matrices' multiplications, you may do so below the green-shaded cells; just remember to shade and label these matrices. Regardless, the final shift must be done in the violet-shaded cells' region. Message 

Grafix

x
y
0	1	x
1	0	y
0	2	x
1	0	y
x	y
1	1
1	3
2	6
4	5
3	2
-1	0	x
0	1	y
1	0	x
0	0	y
0	0	x
0	1	y
0	-1	x
-1	0	y
-1	0	x
0	-1	y
1	1	x
1	1	y
Make sure to do these together in the same operation and as in the sequence defined ®	1	0	´	1	3	x
2	1	0	1	y
­
Define below what would be an easier way to perform this last sequenced operation with just one matrix
¯
­
Do NOT just type in the values!

1 1 2 4 3 1 3 6 5 2

Consider the coordinates and figure shown below this text box  Start by transposing the coordinates given to the matrix structure shown right Then perform each of the given transformations via the matrices defined in Columns L & M, placing the results under Columns O-S to the right of each transformation matrix. Follow by plotting each of the results (see PA2.6); add an appropriate figure similar (does not have to be the same) to what we show below (again, see PA2.6). Make sure to resize the graphs so that they are neither too large nor too small; you may stagger them so all fit near their respective matrices. When you are done, SAVE!

1 1 2 4 3 1 3 6 5 2

1 1 2 4 3 1 3 6 5 2

1 1 2 4 3 1 3 6 5 2

1 1 2 4 3 1 3 6 5 2