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.

In most statistics textbooks, you will find cumulative binomial probability

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

1 Expert Approved Answer
Step: 1 Unlock

a For n 5 using formula for data table in cells F29O38 BINOMDIST F31 F29 G30 TRUE 5 Cu... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

463-S-D-R-V (200).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!