+ Reply to Thread
Results 1 to 2 of 2

Requesting suggestions for data visualization? Currently using histograms. File attached.

  1. #1
    Forum Contributor
    Join Date
    03-31-2010
    Location
    Norway
    MS-Off Ver
    Excel 365
    Posts
    632

    Requesting suggestions for data visualization? Currently using histograms. File attached.

    Hi all,

    I'm analyzing various stuff of data and I find that it can be nice to have visualizations to perceive both what's normal and what's happening in the data. Both recently and for "all" history.

    What I have been doing is to basically do a frequency count based on my custom made bins. It might be that my bins could have been a bit smaller on this particular example. Then, I make histograms based on this frequency count. I've set things up such that I can adjust the lookback period in cell B3.

    Is this the way to go about doing this? Are there better ways to visualize this type of data?

    This particular example is the closing price of a stock I'm watching.

    I'm attaching both the file and also a picture.

    Very open to suggestions on how to proceed with all this or if what I'm doing is perhaps not too bad in the end.

    Best regards and thanks!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Requesting suggestions for data visualization? Currently using histograms. File attach

    About the only suggestion I have is on the second chart. I think it would look better as a scatter plot. You can also compute control limits.

    The Average and Standard Deviation work on the last 50 data points. Sigma (Cell B16) determines the upper and lower control limits. In the example it is 1.96 which means that 95% of the values are between the lower and upper control limits. Points outside this range are outliers and should be investigated. What happened that day?

    Other Sigmas yield other margins:
    1.6449 = 90%
    1.4395 = 85%
    1.2816 = 80%

    It all depends on how closely you want to control what's going on. The lower figures will produce more outliers.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-15-2017, 09:24 PM
  2. Requesting Suggestions on UserForms
    By Loski in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2016, 01:35 PM
  3. Requesting Suggestions about Using Excel VBA with Websites
    By :) Sixthsense :) in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2014, 09:19 AM
  4. Need vba code to pop-up window requesting user to locate a file and transferring data over
    By BrandonFromSingapore in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2012, 01:03 AM
  5. Replies: 3
    Last Post: 04-25-2012, 04:55 AM
  6. data visualization
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 05-31-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1