thank you so much for this video. I successfully completed my assignment after watching this video. This video is very useful for us as students. and I have shared this video to my friends too.
@Kaceyxkaye4 жыл бұрын
Thank you so much for this video, I was struggling with my statistics assignment. You saved the day.. :)
@cutipustotallus3077 жыл бұрын
There are a lot of videos on how to do a frequency distribution but no one teaches how to get the range in x-axis! Thank you so much!
@saltlifo55982 жыл бұрын
You have no idea how I spend time looking for how to edit the Histogram
@naaoomy19993 жыл бұрын
Thank you so much. I was in a terrible for several days. Thank you thank you. You made my day. Allah bless you. 💐
@ntouios3 жыл бұрын
Thank you so much, But may I ask a question that I countered which is some data in the histogram not reflecting raw data accurately. I don't know what goes wrong.
@Sarah-zb4 жыл бұрын
You can tell he is a pro from the sounds of the keys when he clicks 😆 Thanks :)
@KingfisherLtd2 жыл бұрын
Man, that's exactly what I was looking for. You've saved my life🙏
@silvianachandra87217 жыл бұрын
THANK YOU SO MUCH!!! I've been trying to figure out how to do something like this for 4 hours until I found your video! GOD BLESS YOU!!
@alliedpharmacistsinc83225 жыл бұрын
Hi I followed all steps but when I go to Chart Output option and choose an empty cell, it gives me Error message "Input range Contains non - numeric data"
@topworld72365 жыл бұрын
U cant have any non-numeric data inside
@nelsiepansaon80303 жыл бұрын
Thank you it really help me a lot for my Assignment 😁😊 I'm so grateful that you post this video to help the one who needs it God bless 😄
@barbhorne45665 жыл бұрын
Saved my assignment made it so clear and concise BRILLIANT
@parathings Жыл бұрын
Great video thanks. If you list your name, I would be happy to cite your work, Thanks again for making and sharing this video. is there a way to switch the x and y-axis of the histogram? I am new to this so I am not even sure if I am using the right terminology here but I am sure you know what I mean.
@newsletterseek38333 жыл бұрын
Maybe this is a silly question, but why couldn't I create the bins (range) and frequency and get the histogram.
@gabriellefray43944 жыл бұрын
homie is really out here saving lives
@debbiebrown43315 жыл бұрын
I am trying to build a histogram with bin values that span an amount (10-20, 21-30, 31-40...) Every time I try to add the value of 10-20 excel automatically tries to change it to a date. I cannot figure out how to fix that. Suggestions??
@kavyabhaskarreddy15965 жыл бұрын
try 010-20
@judahjohnson99105 жыл бұрын
Add an apostrophe in front of the numbers, for example, '10-20.
@lterlemez5 жыл бұрын
It's not possible to draw a statistically true histogram with given tools in Excel. In order to draw a true histogram in Excel, you'll have to work hard. Here is a clue for you to draw a true histogram in Excel. First, select to columns for your data. Then, use the first column for x values, and the second column for y values. Value entries for these columns are like this (this is for first group, you can do it as this for the other groups): [Group is] 10 - 20 [frequency is] 5 -> firt column values: 10; 10; 20; 20 -> second column values: 0; 5; 5; 0 (this will be the same for following groups, according to the groups' values). Then insert a XY Scatter chart to the sheet and then a series to the chart. Series x values are the first column values and y values are the second column values and then finish entry. Now, your histogram is ready, but you should make some changes on the axes. On the x axis, you should change the Major Grid value according to your group range, and sometimes change axes' crossing point to a proper value. When you finish the changes, you will get a proper, statistically true histogram. If you also want to add frequency polygon to the chart, you can do it in the proper way.
@wanyoikewawamiti6015 жыл бұрын
@@lterlemez, Click on that cell. Go to "Number Format" and select "Text". Re-enter your 1-20. You can ignore the error by clicking on the green drop-down menu on the left. Hopefully this works for you or perhaps someone else have a better way to go about ti.
@Dreamgeography4 жыл бұрын
Very nice presentation , which help to the Researcher..........thanks
@GamerDemonz6 жыл бұрын
I couldnt find the data analysis toolpak
@vaisakhvm1726 Жыл бұрын
Thank you very much. Very useful video!!!
@pauleencastro1174 жыл бұрын
can i put non numerical data in bin range?
@ninjablue20116 жыл бұрын
you saved my freak project, :D
@TheToneBender5 жыл бұрын
When I copy the graph into word, the range changes to 1, 2, 3, 4, etc.
@JosephatKennedy6 жыл бұрын
what is the bin size of each bar?
@vjaquino64494 жыл бұрын
THANK YOU SO MUCH FOR MAKING SUCH A CONCISE AND SIMPLE VIDEO. YOU HELPED ME A TON. WE NEED MORE PPL LIKE YOU. HERE IS TO A TOKEN OF MY APPRECIATION
@david_m1574 жыл бұрын
my professor at University of Illinois is complaining about the spaces between bars. Can anyone help on this? It's for a project.
@Ranmarupinkhaired7 жыл бұрын
may the Lord bless you. THANK YOU SO VERY MUCH
@rahulpriyadarshi93657 жыл бұрын
How to remove "more" from the histogram plot?
@judahjohnson99105 жыл бұрын
Simply delete it from the frequency table. It is that simple
@thetexanlaramee5 жыл бұрын
This video is exactly the help I needed. Thank you.
@kratzzjapp176 жыл бұрын
Absolutely wonderful. This guide was very helpful.
@elainebelew20225 жыл бұрын
in my bins section, my values always go to ")" I am not understanding why this is happening!! This histogram has to be finished so i can complete my final project for quantitive reasoning course! Please help!!!
@elainebelew20225 жыл бұрын
"0" not ")"
@sabuhimikayilov84745 жыл бұрын
best video about histograms
@rjvlogs92325 жыл бұрын
THANKSYOU FOR MAKING THIS KIND OF VIDEOS.ITS REALLY A USEFULLY VIDEOS TO DO MY STATISTICAL PRACTICAL EASY AND COOL. WITH Lovely @AmithRJ 👍😘🤩🙂
@g0415832 жыл бұрын
Didnt help at all, I keep getting an error message after I filing outpout range. "Histogram -Input range contains non-numeric data" over and over again
@kunleomoloju37594 жыл бұрын
Fantastic !! you saved the day
@Amadagagawatch4 жыл бұрын
Thank you for your help.
@thasheelawijesundara90372 жыл бұрын
Thank You Sooo much!
@leonardmaswanganyi75793 жыл бұрын
Thanks
@marksonheart_80736 жыл бұрын
It's help a lot. Thank you.
@nosisahenge92646 жыл бұрын
This is nice how do i share the video
@thisisitchief35966 жыл бұрын
Thank you for this guide
@lukefrankeny13335 жыл бұрын
yo this helped me a ton shout out to you brother
@alwaystoyou1236 жыл бұрын
Wonderful video Brother!
@umnyaosman59496 жыл бұрын
thanks so much that helped me a lot (live saver )
@belayaget6 жыл бұрын
Cant it be done without "Bin"?
@judahjohnson99105 жыл бұрын
I don't think so. If you can, kindly share the steps. I want to learn.
@cheewll4 жыл бұрын
Thank you Good Sir
@andrewnitch4 жыл бұрын
Very good thank you
@shambodatta28784 жыл бұрын
Very useful
@nizar48764 жыл бұрын
Thanks a lot!
@trailokyanathrai15834 жыл бұрын
Thanks.
@RedactedEarth6 жыл бұрын
are you my statistics teacher?
@mustafamohamed84676 жыл бұрын
thank you very much
@lahcenmoussa20656 жыл бұрын
thanks a lot
@lterlemez5 жыл бұрын
It's not possible to draw a statistically true histogram with given tools in Excel. In order to draw a true histogram in Excel, you'll have to work hard. Here is a clue for you to draw a true histogram in Excel. First, select to columns for your data. Then, use the first column for x values, and the second column for y values. Value entries for these columns are like this (this is for first group, you can do it as this for the other groups): [Group is] 10 - 20 [frequency is] 5 -> firt column values: 10; 10; 20; 20 -> second column values: 0; 5; 5; 0 (this will be the same for following groups, according to the groups' values). Then insert a XY Scatter chart to the sheet and then a series to the chart. Series x values are the first column values and y values are the second column values and then finish entry. Now, your histogram is ready, but you should make some changes on the axes. On the x axis, you should change the Major Grid value according to your group range, and sometimes change axes' crossing point to a proper value. When you finish the changes, you will get a proper, statistically true histogram. If you also want to add frequency polygon to the chart, you can do it in the proper way.