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.
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.
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.
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??
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.
@@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.
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"
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!!!
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
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.
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.
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!
You have no idea how I spend time looking for how to edit the Histogram
Thank you so much for this video, I was struggling with my statistics assignment. You saved the day.. :)
Thank you so much. I was in a terrible for several days. Thank you thank you. You made my day. Allah bless you. 💐
You can tell he is a pro from the sounds of the keys when he clicks 😆
Thanks :)
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!!
Man, that's exactly what I was looking for. You've saved my life🙏
homie is really out here saving lives
Saved my assignment made it so clear and concise BRILLIANT
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 😄
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.
Thank you very much. Very useful video!!!
Very nice presentation , which help to the Researcher..........thanks
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
you saved my freak project, :D
This video is exactly the help I needed. Thank you.
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.
best video about histograms
Absolutely wonderful. This guide was very helpful.
may the Lord bless you. THANK YOU SO VERY MUCH
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??
try 010-20
Add an apostrophe in front of the numbers, for example, '10-20.
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.
@@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.
Thank You Sooo much!
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"
U cant have any non-numeric data inside
Thank you for your help.
Maybe this is a silly question, but why couldn't I create the bins (range) and frequency and get the histogram.
Fantastic !! you saved the day
I couldnt find the data analysis toolpak
THANKSYOU FOR MAKING THIS KIND OF VIDEOS.ITS REALLY A USEFULLY VIDEOS TO DO MY STATISTICAL PRACTICAL EASY AND COOL. WITH Lovely @AmithRJ 👍😘🤩🙂
Thanks
When I copy the graph into word, the range changes to 1, 2, 3, 4, etc.
How to remove "more" from the histogram plot?
Simply delete it from the frequency table. It is that simple
It's help a lot. Thank you.
Thank you for this guide
yo this helped me a ton shout out to you brother
Wonderful video Brother!
what is the bin size of each bar?
my professor at University of Illinois is complaining about the spaces between bars. Can anyone help on this? It's for a project.
Very good thank you
thanks so much that helped me a lot (live saver )
Thanks a lot!
Very useful
Thank you Good Sir
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!!!
"0" not ")"
Thanks.
Thank you!
can i put non numerical data in bin range?
are you my statistics teacher?
thank you very much
Veryy goodddddd
grazie mille
bless
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
thanks a lot
This is nice how do i share the video
Cant it be done without "Bin"?
I don't think so. If you can, kindly share the steps. I want to learn.
nice
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.
thank
very help
@@kiandoyle1217 ; guisebbe.wordpress.com/2020/09/11/excel-ile-frekans-serisi-ve-histogram-olusturma-iii/
@@kiandoyle1217 ; guisebbe.wordpress.com/2019/01/09/excel-ile-frekans-serisi-ve-histogram-olusturma-ii/
omg this was soooo ok
Hi sa mga naguguluhan sa statistics -_-
Donald Trump LOL!
Thank you!