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

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
Get step-by-step solutions from verified subject matter experts
