+ Reply to Thread
Results 1 to 2 of 2

Thread: Help with missing data

  1. #1
    Points: 15, Level: 1
    Level completed: 29%, Points required for next Level: 35

    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with missing data




    I am trying so hard to understand this. I am not wanting any answers....I want to learn this on my own. I am attaching an excel sheet. Can somebody please help me understand a few things:
    1) I cannot seem to get a histogram right LOL
    2) How do I figure out missing data and how to decide which method to use.
    3) How do I go about solving this in Excel?
    Any help or resources to understand this brain frying stuff would really, really help!
    Attached Files
    Last edited by Susan1219; 04-25-2014 at 02:05 AM.

  2. #2
    Points: 2, Level: 1
    Level completed: 3%, Points required for next Level: 48

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with missing data


    1 - The most easy way to solve this is to select the numbers you want in Excel and select insert -> Histogram
    2 - The most easy way to see how many missing cells you have is use this formula "=COUNTA(X:X)". However, this formula counts how many cells have a content. Therefore, you can subtract this from your total number of patient / hospitals /or whatsover. Let me know if that's it what you want to know.
    3 - Not sure if I understand your last question. Please ellobarate.

+ Reply to Thread

           




Posting Permissions

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






Advertise on Talk Stats