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) | 1.3k views
1 answer
1 answer
asked May 5, 2013 in Statistics Answers by anonymous | 1.6k views
1 answer
1 answer
asked Mar 3, 2013 in Statistics Answers by anonymous | 775 views
1 answer
asked Jan 21, 2013 in Statistics Answers by anonymous | 791 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!
87,550 questions
99,628 answers
2,417 comments
439,710 users