MATH 211 PROJECT ASSIGNMENT: INTRODUCTION TO CRYPTOGRAPHY INSTRUCTIONS OVERVIEW Two of the Modules include projects that, along with the single Discussion Assignment, are the only parts of the course that are outside of WebAssign. This class was originally created in large measure to support Liberty's popular Cybersecurity program. While most of the course material is quite general, the project assignments each focus in on statistical applications that are at least moderately related to this field. Each project assignment takes a bit of a deeper dive into course topics that are introduced in the WebAssign assignments. In each case, the topics are at least broadly related to the field of Cybersecurity. While these assignments are by no means intended to give realistic current applications in this area, they do illustrate how course topics impact two specific types security- related issues: passwords and encryption. Project assignments demonstrate the relevance of exponential growth, of estimation strategies and of enumerative techniques such as tree diagrams in the analysis of these types of problems. While the first project is quite similar to problems encountered in the second homework and could be completed using hand calculations, the second project assumes that students are able to utilize Excel formulas to work through what would otherwise be a very difficult computational burden. INSTRUCTIONS The data file includes text taken from three books of the Bible (Joshua, Jonah and Philippians) using the ESV translation. While these are all great books, our only interest for this project is how often each letter is used. 1) In the Word file containing the Biblical text, use the "Find feature to identify how many times each letter occurs (i.e. the letter's frequency). Create an Excel spreadsheet to display the number of occurrences of each letter in the English alphabet. (10 points) 2) In the Excel spreadsheet, sum your frequencies to compute the total number of letters in the 3 books (this is sample size n). X n a) In your spreadsheet, use the formula p = to compute the sample proportion of each letter's appearances relative to total number of letters (i.e. the relative frequency of each letter). Use the Excel sorting function to sort the letters in order of their frequencies. (6 points) p b) Use the simple Confidence Interval (CI) formula (p - 1.96 +1.96 to find a 95% CI n on the proportion of how often each letter is used in English text in general. Enter the lower limit in the first Excel column using the formula p -1.96 and the upper limit in the next column using the formula p +1.96 (8 points) n n 3) Identify those letters whose Cls do not overlap with any the CIs of any of the other letters. (For example the CI (0.042, 0.052) overlaps with (0.050, 0.060) because the upper limit of the first CI is greater than the lower limit of the second CI.) List the letters with the non-overlapping Cis and specify how many such letters there are. (6 points) 1 A 1) In the Word file containing the Biblical text, use the "Find" feature to identify how many times each letter occurs (i.e. the letter's frequency). Create an Excel spreadsheet to display the number of occurrences of each letter in the English alphabet. (10 points) B 1174 218 C 292 699 E 1802 F 391 G 278 H 1126 I 946 J 66 K 87 L 635 M 420 N 994 1494 P 210 e 4 1 RSTU > B 884 958 1463 509 V 165 W 352 X 9 Y 434 3