How to plot three graphs with p=0.25 in Excel binominal formula
in Statistics Answers by

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

1 Answer

I guess you want to use Excel to plot a binomial distribution where the probability is p=0.25. Excel will plot a graph for non-cumulative and cumulative distribution. You use the BINOMDIST statistical function, which has 4 parameters:   number of successes (x axis); total number of trials, n; the probability, p; whether cumulative or not.

You set these up in a table for Excel to use to do the plots, with a fixed cell for the probability and columns for the number of successes and the corresponding values to contain the results of applying BINOMDIST. 

The question asks for three graphs, so what could they be? The BINOMDIST function has 4 parameters, and the question supplies only one. So we can use Excel to plot graphs where the other parameters are different. We can change the number of trials; we can choose whether cumulative or non-cumulative; we can change the range of successes. So we set up three tables. The first table has fixed cells for n, p and cumulative=FALSE, and values in a column from 0 to n for the number of successes to be plotted; second table has the same but cumulative=TRUE; the third has a different n and successes column and cumulative can be either TRUE or FALSE. You would specify the continuous curve type of graph for Excel to plot the data as a curve and the result would show the typical bell-shaped binomial distribution curve for the non-cumulative distribution and the hill-shaped curve for the cumulative. To use the graphs, you read off for each x value (number of successes required) the percentage or fraction of the expected results. You would also title the graph, label its axes and show that p=0.25 is the active probability. Excel will allow you to customise how you want the graphs to look.

[Non-cumulative means the exact number of successes expected in a given number of trials; cumulative means at least or at most the specified number of successes in a given number of trials.]

by Top Rated User (1.1m points)

Related questions

1 answer
asked Jan 29, 2015 in Statistics Answers by VLanham Level 1 User (420 points) | 876 views
1 answer
1 answer
asked May 5, 2013 in Statistics Answers by anonymous | 1.1k views
1 answer
1 answer
asked Mar 3, 2013 in Statistics Answers by anonymous | 598 views
1 answer
asked Jan 21, 2013 in Statistics Answers by anonymous | 632 views
Welcome to MathHomeworkAnswers.org, where students, teachers and math enthusiasts can ask and answer any math question. Get help and answers to any math problem including algebra, trigonometry, geometry, calculus, trigonometry, fractions, solving expression, simplifying expressions and more. Get answers to math questions. Help is always 100% free!

Most popular tags

algebra problems solving equations word problems calculating percentages math problem geometry problems calculus problems math fraction problems trigonometry problems rounding numbers simplifying expressions solve for x order of operations probability algebra pre algebra problems word problem evaluate the expression slope intercept form statistics problems factoring polynomials solving inequalities 6th grade math how to find y intercept equation of a line sequences and series algebra 2 problems logarithmic equations solving systems of equations by substitution dividing fractions greatest common factor square roots geometric shapes graphing linear equations long division solving systems of equations least to greatest dividing decimals substitution method proving trigonometric identities least common multiple factoring polynomials ratio and proportion trig identity precalculus problems standard form of an equation solving equations with fractions http: mathhomeworkanswers.org ask# function of x calculus slope of a line through 2 points algebraic expressions solving equations with variables on both sides college algebra domain of a function solving systems of equations by elimination differential equation algebra word problems distributive property solving quadratic equations perimeter of a rectangle trinomial factoring factors of a number fraction word problems slope of a line limit of a function greater than or less than geometry division fractions how to find x intercept differentiation exponents 8th grade math simplifying fractions geometry 10th grade equivalent fractions inverse function area of a triangle elimination method story problems standard deviation integral ratios simplify systems of equations containing three variables width of a rectangle percentages area of a circle circumference of a circle place value solving triangles parallel lines mathematical proofs solving linear equations 5th grade math mixed numbers to improper fractions scientific notation problems quadratic functions number of sides of a polygon length of a rectangle statistics zeros of a function prime factorization percents algebra 1 evaluating functions derivative of a function equation area of a rectangle lowest common denominator solving systems of equations by graphing integers algebra 2 diameter of a circle dividing polynomials vertex of a parabola calculus problem perpendicular lines combining like terms complex numbers geometry word problems converting fractions to decimals finding the nth term range of a function 4th grade math greatest to least ordered pairs functions radius of a circle least common denominator slope unit conversion solve for y calculators solving radical equations calculate distance between two points area word problems equation of a tangent line multiplying fractions chemistry binomial expansion place values absolute value round to the nearest tenth common denominator sets set builder notation please help me to answer this step by step significant figures simplifying radicals arithmetic sequences median age problem trigonometry graphing derivatives number patterns adding fractions radicals midpoint of a line roots of polynomials product of two consecutive numbers limits decimals compound interest please help pre-algebra problems divisibility rules graphing functions subtracting fractions angles numbers discrete mathematics volume of a cylinder simultaneous equations integration probability of an event comparing decimals factor by grouping vectors percentage expanded forms rational irrational numbers improper fractions to mixed numbers algebra1 matrices logarithms how to complete the square mean statistics problem analytic geometry geometry problem rounding decimals 5th grade math problems solving equations with variables solving quadratic equations by completing the square simplifying trigonometric equation using identities
87,446 questions
99,048 answers
2,422 comments
4,780 users