Question: please explain this properly using an excel command Suppose that 35% of all home buyers will do some remodeling to their home within the rst

please explain this properly using an excel command

please explain this properly using an excel command Suppose that 35% of

Suppose that 35% of all home buyers will do some remodeling to their home within the rst ve years of home ownership. Assuming this is true. use the binomial distribution to determine the probability that in a random sample of 20 homeowners. 4 or fewer will remodel their homes. Use the binomial table. 1 Click the icon to View the cumulative binomial distribution table. The probability that 4 or fewer people in the sample indicate that they will remodel their homes is (Round to four decimal places as needed.) 1: Cumulative Binomial Distribution Table n = 15 I p=0.10 p=0.15 p=0.20 p=025 p=0.30 p=0.35 p=0.40 0 0.2059 0.0874 0.0352 0.0134 0.0047 0.0016 0.0005 1 0.5490 0.3 186 0.16711 0.0802 0.03 53 0.0142 0.0052 2 0.8159 0.6042 0.3980 0.2361 0.1268 0.0641"!I 0.02711 3 0.9444 0.822? 0.6482 0.461 3 0.2969 0.1112? 0.0905 4 0.9813 0.9383 0.8358 0.6865 0.5155 0.3519 0.2173 5 0.9978 0.9832 0.9389 0.85 16 0.12 l 6 0.5643 0.4032 6 0.99931 0.9964 0.9819 0.9434 0.8689 0.7548 0.6098 7' 1.0000 0.9994 0.9958 0.982? 0.9500 0.8868 0.7869 8 1.0000 0.9999 0.9992 0.9958 0.9848 0.953\" 8 0.9050 9 1.0000 1.011!) 0.9999 0.9992 0.9963 0.98715 0.9662 10 1.0000 1.0011) 1.0000 0.9999 0.9993 0.9902 0.990? 1] 1.0000 LINN MINI] l .tIlHJ 0.9999 0.9995 0. 9981 12 1.0000 1.0011 1.0203 1 .0300 1.11200 0.9999 0.999? 13 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 14 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 15 113000 1.0000 1.0000 1.0000 1.13000 1.0000 1.0000 n=20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Mathematics Questions!