Simulating Binomial Distribution Density Function and Distribution Graph Model using Excel Package

Creating and Simulating a Binomial Distribution Density Function and Distribution Graph Model using Excel Package
Teaching and learning and many opportunities for its application have yet to be explored. Spreadsheet software is one of the most-used technologies for collecting, computing, and displaying data. Spreadsheets contain a rectangular array of cells in rows and columns that can hold data. Users can create business models, graphs and charts, and reports for financial, statistical, or other data. Most spreadsheet software allows a user to access real-time data from Web sites and to collaborate across teams and workgroups.
Suppose an experiment has the following characteristics:
 the experiment consists of n independent trials, each with two mutually exclusive outcomes (success and failure)
 for each trial the probability of success is p (and so the probability of failure is 1 – p)
Each such trial is called a Bernoulli trial. Let x be the discrete random variable whose value is the number of successes in n trials. Then the probability distribution function for x is called the binomial distribution, B(n, p), and is defined as follows:

Where, C(n, x) = and n! = n(n–1)(n–2)⋯3∙2∙1 as described in Combinatorial Functions.

This Binomial Distribution Simulation Model is prepared by Aluko Sayo Enoch, as an opportunity to share my love for learning with an entire generation of thinkers and leaders; providing entrepreneurial platform via ICT based on the contemporary Technology
Procedure: You can vary the value of p to generate new q, probability density function and equivalent distribution graph. For more info or comment, log on:
https://alukosayoenoch.wixsite.com/selfcoding/blog
www.unilag.academia.edu/SayoAluko/Papers
https://www.tes.com/teaching-resources/shop/alukosayoenoch
https://www.youtube.com/feed/my_videos