Question: How do i calculate this in excel? If x = 0, P(0) = 4 C 0 (0.20) 0 (0.80) 4-0 = 0.4096 . If x

How do i calculate this in excel?

  • If x = 0, P(0) = 4C0(0.20)0(0.80)4-0 = 0.4096.
  • If x = 1, P(1) = 4C1(0.20)1(0.80)4-1 = 0.4096.
  • If x = 2, P(2) = 4C2(0.20)2(0.80)4-2 = 0.1536.
  • If x = 3, P(3) = 4C3(0.20)3(0.80)4-3 = 0.0256.
  • If x = 4, P(4) = 4C4(0.20)4(0.80)4-4 = 0.0016.

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!

Q:

For each of the following complex operations, write a sequence of PIC 16F1829 instructions not C codethat performs an equivalent operation 4 (continued Remember, you can assume that 8-bit variables...

Q:

Learning Objective: This assignment is designed to gain additional proficiency in the use of MS Excel Statistical Functions and other functions. For this assignment, you will upload your Excel file...

Q:

Almendarez Corporation is considering the purchase of a machine that would cost $110,000 and would last for 4 years. At the end of 4 years, the machine would have a salvage value of $16.000. By...

Q:

The number of hours 10 students spent studying for a test and their scores on that test are shown in the table. Is there enough evidence to conclude that there is a significant linear correlation...

Q:

Messier 10e_cha_Mini_case_Analytics (1) - Excel X ? - Hector Bonilla General Percent 2 Autosum A7 Bad Normal X 5 HILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Xit Anal Narrow 10 - Wrap Text...

Q:

\f\f\fTopic Assignment Grading Course: Name Topic Yours Name Professor's Name [optional] University 1 Topic Question 2. A president, vice president and a treasurer are to be chosen in a student club...

Q:

Math 104A Homework #4 Instructor: Lihui Chai 1. Write a code to compute a natural spline S(x) which interpolates a collection of given points (x0 , y0 ), (x1 , y1 ), ..., (xn , yn ) where x0

Q:

MATH 106 Week 8 LEO Discussion Topic Exercises Version: 2015-1 Linear Programming 1. Graphically solve the following: Maximize , subject to: f 6x y 2. x y 8 3x y 0 y 0 Solve the given linear...

Q:

option analysis involves gathering significant amounts of information 4. Estimating the inputs using the Black-Scholes option pricing model in the option Aa Aa analysis of the investment timing...

Q:

Please explain, I'm so lost! Determine the Packaging and Loading costs in cell packlist! F3. a) Write an Excel formula to determine the packaging and loading costs for this item based on its box size...

Q:

The energy of most probable macrostate of a system consisting of six identical bosons, each of which can occupy any of three non-degenerate energy levels 0, e and 2 e. is e. The value of beta is_

Q:

West Company acquired 60 percent of Solar Company for $300,000 when Solars book value was $400,000. The newly comprised 40 percent noncontrolling interest had an assessed fair value of $200,000. Also...

Q:

Let x = 3 . 9 9 9 9 9 . Sum a geometric series to find the value of x .

Q:

The apparent answer would be for railways to construct more track and purchase additional operational equipment in order to manage the increasing volume of traffic. Investment in railways should take...

Q:

7. What is the extent (percentage) of errors detected in the information collected?

Q:

8. What are the costs of collecting the information?

Q:

6. How great is the time-lag between when an event occurs until we get information about it?