Create a Histogram with Excel

[@TheHICH]

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.

[@Kaceyxkaye]

Thank you so much for this video, I was struggling with my statistics assignment. You saved the day.. :)

[@cutipustotallus307]

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!

[@saltlifo5598]

You have no idea how I spend time looking for how to edit the Histogram

[@naaoomy1999]

Thank you so much. I was in a terrible for several days. Thank you thank you. You made my day. Allah bless you. 💐

[@ntouios]

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-zb]

You can tell he is a pro from the sounds of the keys when he clicks 😆 Thanks :)

[@KingfisherLtd]

Man, that's exactly what I was looking for. You've saved my life🙏

[@silvianachandra8721]

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!!

[@alliedpharmacistsinc8322]

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"

[@topworld7236]

U cant have any non-numeric data inside

[@nelsiepansaon8030]

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 😄

[@barbhorne4566]

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.

[@newsletterseek3833]

Maybe this is a silly question, but why couldn't I create the bins (range) and frequency and get the histogram.

[@gabriellefray4394]

homie is really out here saving lives

[@debbiebrown4331]

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??

[@kavyabhaskarreddy1596]

try 010-20

[@judahjohnson9910]

Add an apostrophe in front of the numbers, for example, '10-20.

[@lterlemez]

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.

[@wanyoikewawamiti601]

@@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.

[@Dreamgeography]

Very nice presentation , which help to the Researcher..........thanks

[@GamerDemonz]

I couldnt find the data analysis toolpak

[@vaisakhvm1726]

Thank you very much. Very useful video!!!

[@pauleencastro117]

can i put non numerical data in bin range?

[@ninjablue2011]

you saved my freak project, :D

[@TheToneBender]

When I copy the graph into word, the range changes to 1, 2, 3, 4, etc.

[@JosephatKennedy]

what is the bin size of each bar?

[@vjaquino6449]

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_m157]

my professor at University of Illinois is complaining about the spaces between bars. Can anyone help on this? It's for a project.

[@Ranmarupinkhaired]

may the Lord bless you. THANK YOU SO VERY MUCH

[@rahulpriyadarshi9365]

How to remove "more" from the histogram plot?

[@judahjohnson9910]

Simply delete it from the frequency table. It is that simple

[@thetexanlaramee]

This video is exactly the help I needed. Thank you.

[@kratzzjapp17]

Absolutely wonderful. This guide was very helpful.

[@elainebelew2022]

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!!!

[@elainebelew2022]

"0" not ")"

[@sabuhimikayilov8474]

best video about histograms

[@rjvlogs9232]

THANKSYOU FOR MAKING THIS KIND OF VIDEOS.ITS REALLY A USEFULLY VIDEOS TO DO MY STATISTICAL PRACTICAL EASY AND COOL. WITH Lovely @AmithRJ 👍😘🤩🙂

[@g041583]

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

[@kunleomoloju3759]

Fantastic !! you saved the day

[@Amadagagawatch]

Thank you for your help.

[@thasheelawijesundara9037]

Thank You Sooo much!

[@leonardmaswanganyi7579]

Thanks

[@marksonheart_8073]

It's help a lot. Thank you.

[@nosisahenge9264]

This is nice how do i share the video

[@thisisitchief3596]

Thank you for this guide

[@lukefrankeny1333]

yo this helped me a ton shout out to you brother

[@alwaystoyou123]

Wonderful video Brother!

[@umnyaosman5949]

thanks so much that helped me a lot (live saver )

[@belayaget]

Cant it be done without "Bin"?

[@judahjohnson9910]

I don't think so. If you can, kindly share the steps. I want to learn.

[@cheewll]

Thank you Good Sir

[@andrewnitch]

Very good thank you

[@shambodatta2878]

Very useful

[@nizar4876]

Thanks a lot!

[@trailokyanathrai1583]

Thanks.

[@RedactedEarth]

are you my statistics teacher?

[@mustafamohamed8467]

thank you very much

[@lahcenmoussa2065]

thanks a lot

[@lterlemez]

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.

[@kiandoyle1217]

thank

[@kiandoyle1217]

very help

[@lterlemez]

@@kiandoyle1217 ; guisebbe.wordpress.com/2020/09/11/excel-ile-frekans-serisi-ve-histogram-olusturma-iii/

[@lterlemez]

@@kiandoyle1217 ; guisebbe.wordpress.com/2019/01/09/excel-ile-frekans-serisi-ve-histogram-olusturma-ii/

[@tayyababatool9698]

grazie mille

[@zehraa-fawzi]

Veryy goodddddd

[@ivylee3618]

bless

[@Jason-cq8oz]

nice

[@jonathanromero6468]

omg this was soooo ok

[@ciemchano2659]

Hi sa mga naguguluhan sa statistics -_-

[@steptoeedwall2349]

Donald Trump LOL!

[@BigBangLuv3r]

Thank you!

[@revdckmz]

Thank you!