# The numbers in bold, I need to know how to solve them through excel, a table,...

###### Question:

The numbers in bold, I need to know how to solve them through excel, a table, and formula. Conditional Formatting v 0 A Clipboard Font Alignment Number Format as Table v Cell Styles Cells 21 v fx =BINOM.DIST(B19, B18,B20, 1) C D E Using this information calculate the probability of x! Binomial distribution n = number in the sample x = number to be tested p = probability of success q=probability of failure 0.4 3 0.5 0.5 0.6 0.4 binomial distribution = BINOM.DIST(X, N, P, 0) cumulative binomial distribution = BINOM.DIST(X,N,P,1) Example 5-14(a) from the text page 199 n= 0.3 binomial distribution = 0.324

#### Similar Solved Questions

##### What should the price of a bond be that has a par value of 1000 dollars,...
What should the price of a bond be that has a par value of 1000 dollars, an annual coupon of 35 dollars, a rate of 4% and a maturity of 10 yrs? Round your answer to the nearest hundredth....
##### How do you multiply 1/(x+9)*(7x^3+49x^2)/(x+7) and state the excluded values?
How do you multiply 1/(x+9)*(7x^3+49x^2)/(x+7) and state the excluded values?...
##### Conduct the following test at the a = 0.05 level of significance by determining (a) the...
Conduct the following test at the a = 0.05 level of significance by determining (a) the null and alternative hypotheses, (b) the test statistic, and (c) the P-value. Assume that the samples were obtained independently using simple random sampling. Test whether pe p2. Sample data are xy = 28, n, = 25...
##### < Homework 2 Problem 9 The figure shows an electron entering a parallel-plate capacitor with a...
< Homework 2 Problem 9 The figure shows an electron entering a parallel-plate capacitor with a speed of 5.65x106 m/s. The electric field of the capacitor has deflected the electron downward by a distance of 0.618 cm at the point where the electron exits the capacitor. (Figure 1) Part A Find the m...
##### Estion 2 Any knowing, intentional, or negligent act by a caregiver or any other person to...
estion 2 Any knowing, intentional, or negligent act by a caregiver or any other person to an older adult is Malpractice Elder abuse Negligence Invasion of privacy...
##### Brothers Harry and Herman Hausyerday began operations of their machine shop (H & H Tool, Inc.)...
Brothers Harry and Herman Hausyerday began operations of their machine shop (H & H Tool, Inc.) on January 1, 2016. The annual reporting period ends December 31. The trial balance on January 1, 2018, follows (the amounts are rounded to thousands of dollars to simplify): Account Titles Debit Cr...
##### Create an outline of your Educational Debate Persuasive Paper
Create an outline of your Educational Debate Persuasive Paper. It should highlight the main points of the paper. Include an annotated bibliography of at least three sources it will use in the paper. Topics to choose from : Should Districts Offer Signing Bonuses to Attract New Teachers? Should All S...
##### Phenylketonuria is the result of a: mutation in a non-competitive inhibitor of the enzyme phenylalanine hydroxylase....
Phenylketonuria is the result of a: mutation in a non-competitive inhibitor of the enzyme phenylalanine hydroxylase. buildup of the sugar lactose. buildup of the amino acid tyrosine. mutation in an activator of the enzyme phenylalanine hydroxylase. mutation that alters the ...
##### 2n 3. Prove that lim n+on+ 1 2.
2n 3. Prove that lim n+on+ 1 2....
##### 2 adding a superfluous move 9 interchanging moves 9
Explain(in words) why these extensive-form games are equivalent 2 adding a superfluous move 9 interchanging moves 9 2 adding a superfluous move 9 interchanging moves 9...
##### Gold Nest Company of Guandong, China, is a family-owned enterprise that makes birdcages for the South...
Gold Nest Company of Guandong, China, is a family-owned enterprise that makes birdcages for the South China market. The company sells its birdcages through an extensive network of street vendors who receive commissions on their sales. The company uses a job-order costing system in which overhead is ...
##### Please break down how to get to this answer X 6.7.29 Use the dot product to...
please break down how to get to this answer X 6.7.29 Use the dot product to determine whether v and w are orthogonal. v = 41, w= -31 Select the correct choice below and fill in the answer box to complete your choice. A. The vectors v and w are not orthogonal because their dot product is - 12'...
##### Electric Force Suppose the charge q on each small sphere is 1.0 HC, the distance a...
Electric Force Suppose the charge q on each small sphere is 1.0 HC, the distance a is 30 cm, and L 50 cm. What is the magnitude of the electric force acting on each charged sphere? Use for the Coulomb constant k,-9.0x 10 Nmc The electric force magnitude isN. (Give the correct number)...
##### An element whose electronic configuration is 1s^(2)2s^(2)2p^6 is chemically bound to TWO atoms of an element whose atomic mass is 32.06*g*mol^-1. What is the compound described?
An element whose electronic configuration is 1s^(2)2s^(2)2p^6 is chemically bound to TWO atoms of an element whose atomic mass is 32.06*g*mol^-1. What is the compound described?...