https://www.yousendit.com/download/TEhXcXltRStCTW1Ga2NUQw = my spreadsheet. Colu
ID: 3650842 • Letter: H
Question
https://www.yousendit.com/download/TEhXcXltRStCTW1Ga2NUQw=
my spreadsheet.
Column J A formula to calculate the frequency percentage for each letter (i.e. the letter frequency divided by the number of ciphertext characters). Verify that the sum of the frequency percentages is 100%.
Manually compare the frequency percentages from Column J with those from the Frequency Distribution Table, to predict the translation factor needed to decrypt the Caesar cipher. Enter the translation factor in cell C1.
Create a table in cells A3 thru C28 containing the letters of the alphabet, their numeric equivalents, and a formula to calculate the translated numeric equivalent (see Lab1).
Enter a formula in cells B31 thru B298 to decrypt the ciphertext message.
Explanation / Answer
J33: =I33/SUM($I$34:$I$58) -autofill to J58 J59:=SUM(J33:J58) the shift is by 1 character not sure what to do in A3-C28, but refer to your Lab1? A3: =code(B3) autofill to A28 C3:=(A3-$C$1)+26 C4: =(A4-$C$1) autofill to C28 with C3's formula C3 is special to take acct of wrapping around to Z B31 through B298 is: =CHAR(CODE(A51)-1) messge: W E T H E P E O P L E O F T H E U N I T E D S T A T E S I N O R D E R T O F O R M A M O R E P E R F E C T U N I O N E S T A B L I S H J U S T I C E I N S U R E D O M E S T I C T R A N Q U I L I T Y P R O V I D E F O R T H E C O M M O N D E F E N C E P R O M O T E T H E G E N E R A L W E L F A R E A N D S E C U R E T H E B L E S S I N G S O F L I B E R T Y T O O U R S E L V E S A N D O U R P O S T E R I T Y D O O R D A I N A N D E S T A B L I S H T H I S C O N S T I T U T I O N F O R T H E U N I T E D S T A T E S O F A M E R I C A
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.