Get my FREE cheat sheets for Public Health, Epidemiology, Research Methods and Statistics (including transcripts of these lessons) here: www.learnmore365.com/courses/public-health-epidemiology-research-methods-and-statistics-resource-library
Thank you for supporting those who really need. This is a good start for those who don't have excel filles to exercise to improve their skills and analyzing statistical data
You're very welcome! It's truly important for us to support each other, especially when it comes to sharing resources that can enhance our skills and knowledge.
Thanks for the message Catherine! Glad you liked the video. Christmas was lovely here (thanks for the happy wishes). I hope that 2017 is off to a great start for you!
Love your videos and just subscribed to the channel. I have a question for you and I hope you do assume I have the best intentions with it. Why did you choose the picture of two black children in a mud hut as the image for your Global Health channel? I ask this because a lot of people and international organizations use similar images as if poor black children, probably African are the only example of what is wrong in Global Health. Why do we not see images of white men suffering from the effects of smoking tobacco or obesity as images of the challenges we face in Global Health? Or better yet images of thriving, healthy looking individuals who are the epitome of what we are aiming for? As an African woman in the Public Health field I think unbalanced images lead to stereotypes which contribute to some of the systemic problems in Global health, race , immigrant, refugee relations and so forth. As people working globally sometimes we can't resist the urge to put that picture of the most dire circumstance we have come across so that others can know we are helping people in need, but we need to balance those out otherwise we create some unintended consequences.
Thanks for the very interesting comment Rukudzo. You make a very valid point about the use of stereotypical images that perpetuate a very one demential view of global health. In the case of the picture on my channel page, that is a picture that I took and there is a story behind it which is important to me. When working as the Director of Elimination of Mother to Child Transmission at CHAI, I visited a this family in which there were two brothers, one born HIV positive and the other HIV negative (the two children in the photo). They are a family that I've followed over the years (both children are doing well - the HIV positive child is on ARVs). On the day that the photo was taken, those of us that were there bought a cow for the mother. It was a time in my life when the day-to-day work that I did was very different and closer to the front line of global health issues. I guess that the photo reminds me of that time and keeps me focussed. I'll make a video about that photo sometime. Anyway - thanks for your feedback.
thanks for the tutorial! quick question - I (thought?) that I was following along as it worked out fine when I used weeks like in the example but the count formula would not work when i was using dates (12-May; 13-May). The =countif(day,A2) gave me zeros for all the dates - what was I doing wrong (I labeled my column "day" as instructed). thanks!
Hi there - Thanks for the question. Its hard to say without actually seeing your spreadsheet but something that you might want to look at is the format of the data (sometimes dates are formatted as "dates" and sometimes as "text" (that just looks like a date)). Make sure that both columns (everything in "day" and A2...) are both in the same format. Hope that helps.
For the love of all that is holy, please turn off the music. I could not even finish this. And I really want to learn it. The background is actually foreground and is one of the most distracting things I've ever listened to. I was wondering if it was some kind of test to see if we could think while it was blaring. Sometimes I could not hear your voice at all. Please repost without the music. Thank you.
Get my FREE cheat sheets for Public Health, Epidemiology, Research Methods and Statistics (including transcripts of these lessons) here: www.learnmore365.com/courses/public-health-epidemiology-research-methods-and-statistics-resource-library
How do you remove the gaps at 7:41?
Thank you for supporting those who really need. This is a good start for those who don't have excel filles to exercise to improve their skills and analyzing statistical data
You're very welcome! It's truly important for us to support each other, especially when it comes to sharing resources that can enhance our skills and knowledge.
I loved that Greg! I use a fraction of those functions you showed. What a helpful clip. Thank you. Hope you had a very happy Christmas
Thanks for the message Catherine! Glad you liked the video. Christmas was lovely here (thanks for the happy wishes). I hope that 2017 is off to a great start for you!
Love your videos and just subscribed to the channel. I have a question for you and I hope you do assume I have the best intentions with it. Why did you choose the picture of two black children in a mud hut as the image for your Global Health channel? I ask this because a lot of people and international organizations use similar images as if poor black children, probably African are the only example of what is wrong in Global Health. Why do we not see images of white men suffering from the effects of smoking tobacco or obesity as images of the challenges we face in Global Health? Or better yet images of thriving, healthy looking individuals who are the epitome of what we are aiming for? As an African woman in the Public Health field I think unbalanced images lead to stereotypes which contribute to some of the systemic problems in Global health, race , immigrant, refugee relations and so forth. As people working globally sometimes we can't resist the urge to put that picture of the most dire circumstance we have come across so that others can know we are helping people in need, but we need to balance those out otherwise we create some unintended consequences.
Thanks for the very interesting comment Rukudzo. You make a very valid point about the use of stereotypical images that perpetuate a very one demential view of global health. In the case of the picture on my channel page, that is a picture that I took and there is a story behind it which is important to me. When working as the Director of Elimination of Mother to Child Transmission at CHAI, I visited a this family in which there were two brothers, one born HIV positive and the other HIV negative (the two children in the photo). They are a family that I've followed over the years (both children are doing well - the HIV positive child is on ARVs). On the day that the photo was taken, those of us that were there bought a cow for the mother. It was a time in my life when the day-to-day work that I did was very different and closer to the front line of global health issues. I guess that the photo reminds me of that time and keeps me focussed. I'll make a video about that photo sometime. Anyway - thanks for your feedback.
Yeah... I agree ... imaging black people has an image for malnutrition and a particular religion has the reason for terrorism...too bad...
thanks for the tutorial! quick question - I (thought?) that I was following along as it worked out fine when I used weeks like in the example but the count formula would not work when i was using dates (12-May; 13-May). The =countif(day,A2) gave me zeros for all the dates - what was I doing wrong (I labeled my column "day" as instructed). thanks!
Hi there - Thanks for the question. Its hard to say without actually seeing your spreadsheet but something that you might want to look at is the format of the data (sometimes dates are formatted as "dates" and sometimes as "text" (that just looks like a date)). Make sure that both columns (everything in "day" and A2...) are both in the same format. Hope that helps.
Thank you. This is very useful content for my MPH. The music is a bit distracting, though. :)
Sorry about that. Thanks for the feedback! Glad you find it useful
Amazing your explanation .Can you provide some data set for more execises
Thank you for the kind words! I'm glad you found the explanation helpful.
Thanks, Sir. God Bless You
I guess age wasn't discussed (used)? but assume you do the same thing with the sex category? Thanks for the reply.
where on earth can I access the spreadsheet?!
Wonder why this is in my recommended right now.....
Superbly done. Can I get excel sheet for practice.
so doc you use an histogram. why then a lot of people show a cumulative graph? does it make sense?
I really enjoyed the classes i am just asking if you can share excel templates so i can practice more
I'm thrilled to hear you enjoyed the classes! Thanks for the suggestion, I'll look into that
How do you remove the gaps
How to make median for dengue case?
Thank you very much for the content, but I found background music to be irritating
clear and very helpful. Thank you!
You are most welcome Amina - glad you liked it.
Excellent
Amazing!
Nice video , though background music is quite pesky
For the love of all that is holy, please turn off the music. I could not even finish this. And I really want to learn it. The background is actually foreground and is one of the most distracting things I've ever listened to. I was wondering if it was some kind of test to see if we could think while it was blaring. Sometimes I could not hear your voice at all. Please repost without the music. Thank you.
You are too fast with your lessons. I had to rewind multiple times. Not nice
very funny....
You are talking way to fast mate and the music is totally unnecessary
Thanks for the feedback. You are right (will try to slow down). :)