The data file includes the text of 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.   Here is the amount of occurences I found for each letter using the find feature A=1810 B=323 C=442 D=1097 E=2845 F=609 G=416 H=1689 I=1381 J=134 K=143 L=935 M=586 N=1503 O=2237 P=379 Q=5 R=1362 S=1407 T=2235 U=703 V=257 W=513 X=17 Z=6 2) In the Excel spreadsheet, sum your frequencies to compute the total number of letters in the 3 books (this is n).  a) In your spreadsheet, use the formula to compute the sample proportion of each letter’s appearances relative to total number of letters (i.e. find the relative frequency of each letter). Use the Excel sorting function to sort the letters in order of their frequencies.   b) Use the simple Confidence Interval (CI) formula to find a 95% CI on the proportion of how often each letter is used in English text in general. Enter the lower bound in the first Excel column (using   ) and the upper bound in the next column (using  ).

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
100%

The data file includes the text of 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.  

Here is the amount of occurences I found for each letter using the find feature

A=1810

B=323

C=442

D=1097

E=2845

F=609

G=416

H=1689

I=1381

J=134

K=143

L=935

M=586

N=1503

O=2237

P=379

Q=5

R=1362

S=1407

T=2235

U=703

V=257

W=513

X=17

Z=6

2) In the Excel spreadsheet, sum your frequencies to compute the total number of letters in the 3 books (this is n). 

  1. a) In your spreadsheet, use the formula to compute the sample proportion of each letter’s appearances relative to total number of letters (i.e. find the relative frequency of each letter). Use the Excel sorting function to sort the letters in order of their frequencies.  
  2. b) Use the simple Confidence Interval (CI) formula to find a 95% CI on the proportion of how often each letter is used in English text in general. Enter the lower bound in the first Excel column (using   ) and the upper bound in the next column (using  ).  
The data file includes the text of 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.
2) In the Excel spreadsheet, sum your frequencies to compute the total number of letters in the 3
books (this is 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. find the relative frequency of each letter).
Use the Excel sorting function to sort the letters in order of their frequencies.
b) Use the simple Confidence Interval (CI) formula ( p – 1.96,
p + 1.96
to find a 95%
CI on the proportion of how often each letter is used in English text in general. Enter the lower
bound in the first Excel column (using p – 1.96
" ) and the upper bound in the next column
bd
(using p + 1.96.
n
Transcribed Image Text:The data file includes the text of 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. 2) In the Excel spreadsheet, sum your frequencies to compute the total number of letters in the 3 books (this is 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. find the relative frequency of each letter). Use the Excel sorting function to sort the letters in order of their frequencies. b) Use the simple Confidence Interval (CI) formula ( p – 1.96, p + 1.96 to find a 95% CI on the proportion of how often each letter is used in English text in general. Enter the lower bound in the first Excel column (using p – 1.96 " ) and the upper bound in the next column bd (using p + 1.96. n
Expert Solution
Step 1

Given information:

A 1810
B 323
C 442
D 1097
E 2845
F 609
G 416
H 1689
I 1381
J 134
K 143
L 935
M 586
N 1503
O 2237
P 379
Q 5
R 1362
S 1407
T 2235
U 703
V 257
W 513
X 17
Z 6
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

I only want to know how to input the formulas into an excel spreadsheet for both step 2 and 3.  Every time that I try it, it goes haywire.  I know it can be done, I am just not getting it all done on the same sheet as I think I am supposed to do.

HELP

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman