ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How To Create a User-Interactive Graph of the Normal Distribution in Excel

Updated on October 29, 2010

How To Create a User-Interactive Graph of the Normal Distribution in Excel

Here is an easy-to-follow, step-by-step article showing you how to create a user-interactive graph in Excel of the Normal Distribution. Users will be able to vary the Normal Distribution's two parameters, the mean and standard deviation, and watch those changes be reflected in the Excel graph. This lesson will also show you how to graph the outer tails, for example, the outer 5% tails, a different color. The article includes a video so you can see exaclty how it is done.

Introduction To Creating an Interactive Graph of the Normal Distribution in Excel - Here Is the Final Graph You WIll Create

Here Is the Final Graph You WIll Create
Here Is the Final Graph You WIll Create

If you are doing statistical analysis of your marketing program, you will eventually want to plot some statistically-distributed data in an Excel graph. The most commonly-occurring statistical distribution in nature and, of course, in business, is the normal distribution.

Changing the Parameters Changes the Graph - Here Is the New Graph After Changing the User-Interactive Parameters

Here Is the New Graph After Changing the User-Interactive Parameters
Here Is the New Graph After Changing the User-Interactive Parameters

This article and video will show you how to create a user-interactive graph of the normal distribution in Excel. The user of your graph will be able to vary the two parameters of the Normal Distribution - the mean and standard deviation - and then watch the changes instantly reflected in the Excel graph. Note the differences between the graph above and the graph below as a result of changes in the 2 user inputs of mean and standard deviation.

Video - Show Step-By-Step How To Create User-Interactive Graph in Excel of the Normal Distribution - ( Is Your Sound Turned On? )

The concepts covered in this article really need to be observed in the video for full comprehension. Below is an outline of the major steps appearing in the video that are needed to construct a user-interactive graph in Excel of the Normal Distribution with highlighted outer tails.

Create the X-Axis - Creating the X-Axis and the Two Y Data Columns

Create the X-Axis
Create the X-Axis

You'll notice on the video that when the user varies the mean or standard deviation inputs, it is the X-Axis that changes, not the graph. The graph will always show 3 standard deviations of normal distribution from the mean in both directions. It is the X-Axis increments that will change as a result of changes made by the user to the mean and standard deviation. The initial left-hand column starts at the top at -30 and finishes at the bottom at +30. This creates the basis of the 3 standard deviations of Normal Distribution that will show at all times on each side of the mean, regardless of the mean and standard deviation that the user has input.

2) Create 2 columns that will calculate the Normal Distribution's PDF at each point of the X-Axis - The Two Columns of Y-Axis Data

The Two Columns of Y-Axis Data
The Two Columns of Y-Axis Data

PDF is the Probability Density Function of the Normal Distribution. The data in each of these 2 columns are the Y values of two identical graphs, one sitting on top of the other.

3) Zero out the Y-Values on the outer edge(s) of the 2nd column to create the outer tails - Zeroing Out the 2nd Data Column To Create the Outer Tails

Zeroing Out the 2nd Data Column To Create the Outer Tails
Zeroing Out the 2nd Data Column To Create the Outer Tails

The 2nd column sits directly on top of the 1st column. If you set any the Y-values for that graph to 0, you allow the identical graph directly underneath to show through. For example, if you zero out the outer 2% of the Y-values on top and bottom of the 2nd column, you are allowing the lower graph to show through for the outer 2% of each tail. You are, in effect, graphing the outer 2% of the Normal Distribution by deleting the outer 2% of the tails in the upper graph, letting the different-colored lower graph to show.

4) Set the color of all elements on the Excel chart as you see best. - Setting the Color Elements

Setting the Color Elements
Setting the Color Elements

For example, you might want to change the color of the upper or lower graphs, or the color of the background. You simply left-click on the element that you wish to change the color of and then select the color in the color dialogue box that pops up. The video shows an example of this being done.

And There's the Final User-Interactive Graph of the Normal Distribution With Outer Tails - FInal Interactive Graph

FInal Interactive Graph
FInal Interactive Graph

By Far, The Clearest Graduate-Level Statistics Lessons - All In Excel! ---> Click On Image To See Reviews ! - The Excel Statistical Master eBook - Over 400 P

Excel Statistical Master - Over 400 Pages and Videos of Easy-To-Understand Statistics
Excel Statistical Master - Over 400 Pages and Videos of Easy-To-Understand Statistics

1) It's LOADED With Completed Problems ALL in Excel.

2) All Solved Problems Are REAL-WORLD, BUSINESS Problems.

3) Nothing But SIMPLE Explanations.

4) More Than Half of the Lessons Are Supplemented With VIDEOS To Help You Understand Quicker.

5) Lessons Are All in BITE-SIZE Chunks.

6) The Statistics Are MBA-LEVEL - Over 400 Pages and Videos.

7) All Lessons Are In CLEAR, EASY-TO-FOLLOW FRAMEWORKS.

8) NO USELESS THEORY Is Taught.

9) NO PRIOR STATISTICAL KNOWLEDGE Is Needed.

10) Every Lesson Is Entirely In Excel. NO LOOKING UP ON CHARTS.

11) You Already Know Excel. NO NEW SOFTWARE NECESSARY.

Links To Learn Business Statistics At a More Basic Level - These Lessons Are Easy-To-Follow ! - Business Statistics Made SIMPLE - For Those Who Don't Speak Math

If you are interested in learning business statistics quickly and being able to solve real-world statistics problems, these links are for you.

Your Opinions, Comments, and Questions Are Very Important To Us. We Look Forward To Hearing From You !

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://hubpages.com/privacy-policy#gdpr"

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)