Question: In most statistics textbooks, you will find cumulative binomial probability tables in the format shown below. These can be created using spreadsheets using the Binomial
In most statistics textbooks, you will find cumulative binomial probability tables in the format shown below. These can be created using spreadsheets using the Binomial template and Data | Table commands.
.png)
a. Create the above table.
b. Create a similar table for n = 7.
0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 0 0.5905 0.3277 0.1681 0.0778 0.0313 0.0102 0.0024 0.0003 0.0000 1 0.9185 0.7373 0.5282 0.3370 0.1875 0.0870 0.0308 0.0067 0.0005 x 2 0.9914 0.94210.8369 0.6826 0.5000 0.3174 0.1631 0.0579 0.0086 3 0.9995 0.9933 0.9692 0.9130 0.8125 0.6630 0.4718 0.2627 0.0815 4 1.0000 0.9997 0.9976 0.9898 0.9688 0.9222 0.8319 0.6723 0.4095
Step by Step Solution
3.38 Rating (170 Votes )
There are 3 Steps involved in it
a For n 5 using formula for data table in cells F29O38 BINOMDIST F31 F29 G30 TRUE 5 Cu... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
463-S-D-R-V (200).docx
120 KBs Word File
