How to create figures in Excel: Survey/questionnaire results/data | APA Style graphs

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024

Комментарии • 124

  • @Hemdeeii
    @Hemdeeii Год назад +1

    the simplicity, gentleness and explicitly. I live this man!

  • @palomavarela5372
    @palomavarela5372 4 года назад +4

    Many thanks, you saved my life. I'm writing my dissertation and your videos were a blessing. A warm hug from a grateful grandmother.

  • @allthingsmarine
    @allthingsmarine 3 года назад +2

    I didn't know that Excel tutorials could be so relaxing, until yours! Thank you!

  • @stephengallery4442
    @stephengallery4442 5 лет назад +8

    This is the best series of videos I have seen regarding excel and pivot tables. You are a great teacher!

  • @curtisjones748
    @curtisjones748 2 года назад +1

    Thank you so very much for the tutorial on using pivot table. I have tried watching other tutorial but yours is the best. the pace, explanation and examples is so easy to follow. You are the best teacher. Thanks again

    • @kentlofgren
      @kentlofgren  2 года назад +1

      Thanks! I try to make the kind of educational videos that I would like to see myself :-)

  • @KeG-vq8cd
    @KeG-vq8cd 2 месяца назад

    I have been doing data analysis for over two years using short cuts. I must say that you're good at this sir ❤

  • @felixtuya
    @felixtuya 4 года назад +7

    Fantastic..informative and enjoyable..i missed the cat though.

  • @anastasiamartinez550
    @anastasiamartinez550 6 лет назад +2

    Thank you sooooooooooo much. At my internship they have me doing different types of sheets all day. I am so grateful for this video.

  • @LW1Tok
    @LW1Tok 2 года назад +1

    Thanku so much sir. I really enjoy your calm voice and the way you simply explain things. Thanku again so much.

  • @trollMan246
    @trollMan246 7 лет назад +3

    Fantastic video presentation. I'm a novice when it comes to Excel. The way you calmly and carefully explain and point out everything is amazing! I know I can use Excel now to compile the data from my recent survey. Thanks.

  • @beautifulbellarose1250
    @beautifulbellarose1250 10 дней назад

    Thank you soooo much for this tutorial. I am a week behind in submitting my data for one of my assignments due to not knowing how to get started. It is for my Capstone research paper the last one before I graduate on 12-14-2024. Blessings

  • @kadeshjamaica9046
    @kadeshjamaica9046 5 лет назад +4

    Everyone has said it but I have to add my bit. This is the best series of teaching videos I have seen in a long while. The pace is calm, no techy jargon, illustrations make sense. Thank you sooo much. Do you have a video for side by side comparison?

  • @gypsyd9431
    @gypsyd9431 5 лет назад +1

    Such a pleasant, calm and easy demonstration to follow. Thank you very much for sharing.

  • @roseross4770
    @roseross4770 7 лет назад +1

    Thank you so much, I had all this data and could't figure out how to sort it out. You are a life saver ! I love the cat a lovely addition to a stressful situation thank you

  • @carissima2011
    @carissima2011 4 года назад +1

    Fantastic video. I've learnt so much about how I can use Excel to do comprehensive data analysis. Thanks!

  • @licorice200
    @licorice200 7 лет назад +1

    These videos very very helpful! I used them both to create my survey results for a work project. THANK YOU!!!!

  • @manjunathks4011
    @manjunathks4011 4 года назад +2

    Thank you so much Sir. This was really helpful to me. I'm carrying a research of primary data entry. This was indeed a saviour for me and your guidance was the best source of grabbing the knowledge.

  • @98hagger
    @98hagger 6 лет назад +1

    Very well explained without using the complex technical jargon, excellent.

  • @mukhtarmohamed1742
    @mukhtarmohamed1742 2 года назад +1

    I learn a lot of things which improve my working style Thank you.

  • @arthura5409
    @arthura5409 4 года назад +1

    Thank you Kent! Very supportive video !

  • @thepeak8066
    @thepeak8066 7 лет назад

    Sir, you are the best, you are a hero for many students and researchers.
    Thank you so much :)

  • @gladysmanyika9352
    @gladysmanyika9352 2 года назад

    thank you, the video was posted six years ago but was very helpful for me today, be blessed.

  • @elsritsma
    @elsritsma 6 лет назад +3

    Thank you very much from me and my grades, the cat is a lovely addition to the video

  • @tohianyangen7805
    @tohianyangen7805 2 года назад +1

    THANK YOU SO MUCH FOR HELPING ME WITH MY DATA ANALYSIS IN RESEARCH..

  • @sakshisrivastava2146
    @sakshisrivastava2146 4 года назад

    You're best. Your videos made this analysis learning very very smooth and easy for me Thank you so much!

  • @leedu9085
    @leedu9085 6 лет назад +1

    Great tutorial video, makes data coding & analysis simple, thanks Kent, love the cat.

  • @vasuki86
    @vasuki86 5 лет назад +1

    Thank you so much. Its really great. Language is easily understandable

  • @shikaramesh18
    @shikaramesh18 7 лет назад

    It was really helpful sir. I used to do the tally sheet analysis which was a tedious task. But this is wonderful. Thank you so much.

  • @debseyler9775
    @debseyler9775 3 года назад +1

    Thank you SO much for this - it was a HUGE help!!! Really appreciate it!!!! Such detail. It was awesome!!!!

  • @hardikachoudhary7404
    @hardikachoudhary7404 7 месяцев назад

    Thank you so much. This video helped me a lot with my socio-economic survey project report.

  • @tamerakkad9129
    @tamerakkad9129 3 года назад +1

    Really best explanation, many thanks

  • @taherashur2858
    @taherashur2858 6 лет назад

    I found it very useful, Kent congrats for your method of explanation and good luck

  • @narendranathmahato7881
    @narendranathmahato7881 3 года назад +1

    Thank You. You explained it very nicely

  • @fathiamousse4704
    @fathiamousse4704 5 лет назад +1

    Thank you! This was very helpful and easy to understand.

  • @andreavallemarques1537
    @andreavallemarques1537 5 лет назад +1

    Thank you so much for this video, really good and easy to follow.

  • @dani28MSc
    @dani28MSc 4 года назад

    Thanks a million for posting this super useful tutorials, as they will help on my data analytics and marketing masters I am trying to finish during my lockdown. Once more, thanks a lot. (Cute pretty cat you have;)!! ).
    Dan
    xx

  • @AB-qf2er
    @AB-qf2er 4 года назад

    This is a valuable information and so clearly depicted by you, thankyou. 🙂

  • @christinadaffre8900
    @christinadaffre8900 6 лет назад +9

    BUT HOW DID HE CATEGORIZE THE OPEN-ENDED QUESTIONS!!?

  • @hammedish
    @hammedish 2 года назад

    Thanks you sir for the tutorial, it really helped. Kudos to you sir.

  • @adadmohamedcherif3697
    @adadmohamedcherif3697 6 лет назад +1

    Thank very very much for this video Mr. Kent, your cat is wonderfull.

  • @tunujain8977
    @tunujain8977 5 лет назад +1

    Very good tutorial

  • @vasiaparpouna3437
    @vasiaparpouna3437 7 лет назад +1

    Thank you very much. This was indeed really helpful!

  • @thebrownniga
    @thebrownniga 9 лет назад +2

    Thank you so much , this helped a lot for my class

    • @kentlofgren
      @kentlofgren  9 лет назад +3

      You're welcome! Good luck with your project/assignment.

  • @twahirabasi9765
    @twahirabasi9765 4 года назад

    Thank you so much man, this is really gold

  • @amzleite
    @amzleite 7 лет назад

    Awesome explanation! Thanks a lot.

  • @Patrizia817
    @Patrizia817 8 лет назад +1

    I need to transfer my scores from a written pre and post survey to excel. I am using a likert scale for my answers. Your video was very informative, and easy to follow, but it's more for multiple choice, yes? what do you suggest for likert scale, and how do I show pre and post side to side in order to measure impact.

  • @thebiblepiano1866
    @thebiblepiano1866 8 лет назад +2

    Thanks alot for this lesson! very helpful!

    • @kentlofgren
      @kentlofgren  7 лет назад

      Thx. My video is a bit slow, but viewers can always increase the speed via RUclips's settings for each video. Also, in this video, my voice is a little weak. I remember that I had a cold. That problem is difficult to correct via RUclips's settings though :-)

  • @danielrulander7332
    @danielrulander7332 6 лет назад +1

    With this method I used it to analyze data from a mountain bike trail demographic and community impact research project and it had amazing results. Even potentially getting published in my local paper. Thank you for saving my ass haha

  • @sandrataranhike6813
    @sandrataranhike6813 5 лет назад +2

    This is helpful; thank you! I have a question though: what is the solution when one of the coded fields was not selected by any participants (so it does not show in the data) and hence isn't shown on the pivot table but I want it to show that there were 0 participants in that field (e.g. if age 10-12 is coded as 1 but no participants were aged 10-12, how do I still show that as a 0 on my pivot table and chart?)

  • @tobifighter6877
    @tobifighter6877 5 лет назад +1

    Good Job mate.

  • @arifaaktar3286
    @arifaaktar3286 5 лет назад +1

    Thank you sir.can you please upload a complete video on analyzing data in frontier 4.1 software(from downloading the software to interpretation)

  • @kellyam5548
    @kellyam5548 7 лет назад

    I will have to get back to this and revise. Thanks for the video

  • @swerdak
    @swerdak 8 лет назад +1

    Thanks for the video, so helpful

  • @foziabasheer9011
    @foziabasheer9011 6 лет назад +1

    thank you so much this video helped me a lot

  • @mubinakhan8391
    @mubinakhan8391 6 лет назад +1

    very helpful sir.... kindly guide me how to represent healtcare survey data using statistical formula.... or rather which formula should I use for healthcare data.

  • @cbcboxing.
    @cbcboxing. 8 лет назад +1

    Fantastic video helped me a lot with my project much appreciated!! Was just wondering how can I find out the valid percentage and cumulative percentage of my figure?? Thanks

  • @nithagowtham
    @nithagowtham 6 лет назад +1

    thanks for the video.. but can u tell me.. if the same data is exported to SPSS... how the Multiple answers to be fed...when every option is considered as separate question as yes/no answers in excel? e.g.. like q2a, q2b, q2c.... in this video. kindly help.

  • @darinejohn377
    @darinejohn377 5 лет назад +1

    Thank you so much so helpful

  • @nandinimishra4609
    @nandinimishra4609 3 года назад +1

    thank you sir ....please can u suggest how can i learn data entry and coding i am a nursing student and have to do coding of quaestions of patient survey but i am not able to do coding of open ended responses.

  • @nancyavalon4150
    @nancyavalon4150 5 лет назад +1

    Thank you for this, Kent. So well done! One question having to do with first ENTERING date in the cells: If a respondent skips a question and puts in no response, should you leave all cells blank in that question, or must you assign a value for "no response" or "left blank"? It would be easier to leave it blank, if I can.

    • @nancyavalon4150
      @nancyavalon4150 5 лет назад +1

      I researched further and found that it's OK to leave all responses in a multi-choice question BLANK if the respondent skipped that question entirely.

  • @patrickmusyoki6413
    @patrickmusyoki6413 6 лет назад +1

    Very informative

  • @raachelk96
    @raachelk96 6 лет назад +1

    Hi Kent, thanks for this video! When you create your pivot table - if you have 7 answers to your questions which you code 1-7, but no one puts an answer in for what you would have coded as '3' is there a way to represent this on your pivot table and then in your graph? I can't figure it out! Thanks!

    • @GlennnnnS
      @GlennnnnS 6 лет назад

      Did you ever figure out how to do this? Want to know it too..

  • @fionabudge5578
    @fionabudge5578 7 лет назад

    This is great and so easy to follow, thank you! I have one question though - please keep in mind I am excel illiterate! I tried to enter results of a check list created for an evaluation I conducted - some activities evaluated were based on an action plan and the activities were ranked according to how well they were conducted, answer options were: 0 (Not applicable) 1 Very well 2) Well 3) Moderate 4) Poor 5) Very poor - when inserting my pivot table only options 2, 3 & 4 appear - yet one person answered 1 - how do I ensure my the table created shows all options given? Even if a rank was not given I would like the option to show in the table

  • @Mr7777777226
    @Mr7777777226 7 лет назад +1

    Very very very helpful

  • @denisehuggins6162
    @denisehuggins6162 3 года назад

    Hello, thanks for the detailed video. It's very helpful. I have a survey question that lists the "order of importance" where I have asked the recipient to put in order from 1-4 their choice. How do I enter that data to make a pivot table to show which is the best choice to least choice?

    • @kentlofgren
      @kentlofgren  3 года назад

      Don't know how to make it with the aid of a pivot table. This type of question also has another problem: what about those participants that only list 2 or 3 (not all 4)? Tricky, indeed. One way around this, could be to count the number of 1:s for each of the for things. Then make a bar char with four bars, one for each thing. And then let the total count for each thing govern the height of each bar. Just a thought. Good luck with your project.

  • @jugglingballs6929
    @jugglingballs6929 4 года назад +1

    Thank you.

  • @utubemania9079
    @utubemania9079 6 лет назад +2

    Thanks you so much sir.

  • @editorabatista6524
    @editorabatista6524 4 года назад

    Thank you for your careful explanations. Is there not a way to make Excel default to your cosmetic preferences instead of taking the time to apply them every single time you generate a new chart?

    • @kentlofgren
      @kentlofgren  4 года назад

      Good questions! Yes, right-click on your masterpiece, and chose Save As Template, I think it is. Good luck! Saves a ton of time. Should have included that in my video... well, well, maybe in the next one ;-)

  • @xanderkaufman5162
    @xanderkaufman5162 7 лет назад

    VERY helpful Thank you!!!!

  • @muddassirali8878
    @muddassirali8878 8 лет назад +1

    how I can develop database in excel for my 130 questions.please guide

  • @panagiotiskioulepoglou3635
    @panagiotiskioulepoglou3635 3 года назад +1

    Very informative, though i disagree with your percentiles for various reasons one of which being that 48+35+16 =! 100

  • @mohinipadayachee4483
    @mohinipadayachee4483 7 лет назад +1

    Hi Kent, on your pivot table in the video the word "data" appears on mine the word "table one" appears. I am not getting the correct results. Why is this happening?

  • @bhupendermehera55
    @bhupendermehera55 5 лет назад +1

    Can I ask one question plz help me

  • @sumayyabanna8443
    @sumayyabanna8443 8 лет назад

    I'm sharing your videos with my students to do coding and some analysis of data survey. How about testing hypothesis and p-value ?

  • @my_nutrioclinic197
    @my_nutrioclinic197 3 года назад

    Love ur video
    Can u plz teach for open ended questions and also for nutritional status related data and household survey data where too many respondents from one household

  • @gluepeter
    @gluepeter Год назад

    Hey this video series has been super helpful for my research, thanks!
    However, I was hoping someone might be able to tell me how to code open ended responses where responses might fit into 2 or more distinct categories.
    To give an example analogous to the video, say 1 respondent mentions both 'fun' and 'rewarding' but I do not want to simply categorise the response as being only one or the other.

  • @byntaernest2324
    @byntaernest2324 4 года назад

    This is a very helpful video. However, my sum is totally inaccurate and I am trying to figure out why is this

  • @ETinVegas
    @ETinVegas 8 месяцев назад +1

    THANK YOUI!!!!

    • @kentlofgren
      @kentlofgren  7 месяцев назад

      You're welcome. Good luck with your projects.

  • @paulinecusap1824
    @paulinecusap1824 3 года назад +1

    Good Day Sir! Can I ask how did you interpret "No" on the checkboxes Q2? Is it the same graph as the Yes or you shouldn't do one anymore?

    • @kentlofgren
      @kentlofgren  3 года назад +1

      Do you mean at time 18:30 in this video above?

    • @paulinecusap1824
      @paulinecusap1824 3 года назад +1

      @@kentlofgren It's about 7:30 in the video, sir.

    • @paulinecusap1824
      @paulinecusap1824 3 года назад +1

      @@kentlofgren you made a graph for q2a, q2b and q2c for "Yes" category. Do I still need to make a graph for q2a, q2b and q2c for "No" Category?

    • @kentlofgren
      @kentlofgren  3 года назад +1

      In this video (at 7:50 an forward) I create a graph with three bars, and all bars show the number of "Yes". I think it is much cleaner (and nicer) to just make a graph with Yes :-) But of course, if you talk to other researchers, perhaps they say it is wrong. As you know, there is often many ways to present data. In summary, I don't think you still need to make a graph for the No-replies.

    • @paulinecusap1824
      @paulinecusap1824 3 года назад +1

      @@kentlofgren thank you so much! 😊

  • @rosagold662
    @rosagold662 7 лет назад +1

    Hi can i use this method in term of frequency of distribution?

  • @aicha7213
    @aicha7213 8 лет назад

    thanks,very helpful

  • @TristanMulhall
    @TristanMulhall 7 лет назад +1

    I click and column and the option does not appear... it asks me to put in cell numbers. Very frustating! I've coded all my work and run into a dead end.

  • @emmanuelatukpor
    @emmanuelatukpor 7 лет назад

    this is very good

  • @malibongwentushelo3342
    @malibongwentushelo3342 Месяц назад

    Wow...🎉🎉🎉

  • @maggymm7302
    @maggymm7302 7 лет назад

    in swahili language we say Asante sana.

  • @hafsabousaoud6310
    @hafsabousaoud6310 7 лет назад

    When i click 'layout there is no option for" axix titles" coming up?

  • @ravin5451
    @ravin5451 11 дней назад

    Very Thank

  • @palomavarela5372
    @palomavarela5372 4 года назад

    BTW, do you have anything on creating graphs from Likert?

    • @kentlofgren
      @kentlofgren  4 года назад +1

      Sorry, I have no films on that topic at the moment.

  • @laurenkatiecooper4284
    @laurenkatiecooper4284 7 лет назад +1

    When i click 'insert' there is no option for a pivot table coming up?

    • @kentlofgren
      @kentlofgren  7 лет назад +1

      Hi! You must have version 2007, 2010, 2013 or 2016 for this to work. (I think pivot tables where introduced with Excel version 2007.) And sometimes the PivotTable function is hard to find. For example, in old Excel versions you must first click the menu tab called "Menus", and then click the "Data" menu, and then go down and select "PivotTable".

    • @laurenkatiecooper4284
      @laurenkatiecooper4284 7 лет назад

      Thank you! :)

  • @jorelllegaspi5943
    @jorelllegaspi5943 7 лет назад

    Why does the "Grand Total" appear as part of the data when I create a chart?

  • @davidmendy2879
    @davidmendy2879 6 лет назад +1

    thanks

  • @934rex
    @934rex Год назад

    🔥🔥🔥🔥🔥🔥🔥🔥🔥

  • @niranjanamaheswari
    @niranjanamaheswari 2 года назад +1

    5:00

  • @radiogurlie25
    @radiogurlie25 Месяц назад

    Doooes it havee 2 be daat neaat? 😢

    • @kentlofgren
      @kentlofgren  Месяц назад

      Don't worry too much. Just focus on two key things: First, keep your figures and tables clean by avoiding any redundant information. Second, ensure consistency in their appearance-same font, font size, and overall design across the board. That will make your work look professional, and you should be good to go, unless you have a very picky supervisor or boss.
      ;-)

  • @MrUtuber29
    @MrUtuber29 6 лет назад +2

    This analysis would be so much better and easy in SPSS.

    • @JimCampbell777
      @JimCampbell777 6 лет назад +3

      The price quotes I see are about $2,200 for student edition of SPSS software. If that is the case, a lot of different ways of doing things would be better is you simply use $2,200 software. Most people, like myself, don't have an extra $2,200 and would prefer to continue doing things related to our jobs using the software we already have installed on our computers.

    • @twahirabasi9765
      @twahirabasi9765 4 года назад

      Would you take time and SPSS things for the readers free of charge? Thank you

  • @anuragjha6825
    @anuragjha6825 4 года назад

    where is the cat? I clicked on this video just for the cat.