How to make a Histogram in Google Sheets

Поділитися
Вставка
  • Опубліковано 5 лют 2025

КОМЕНТАРІ • 32

  • @buffooninator2000
    @buffooninator2000 2 роки тому +5

    biology teacher just assumed we knew how to use google sheets. I appreciate how short the video is; saved me a lot of grief lol. A++ monsieur

  • @ameliasabra
    @ameliasabra 2 роки тому +3

    Thank you so much!! I've been stuck for an hour and you just cleared my problem in a minute. Really appreciate it.

  • @nathannakonieczny1343
    @nathannakonieczny1343 3 роки тому +6

    Thank you. I have an assignment due in 7 hours and I didn't know how to do the stupid bucket size. Much appreciated.

  • @binujajayaseelan1577
    @binujajayaseelan1577 2 роки тому +1

    Thank you so much!! I was stuck with this for like 7hrs😖

  • @Smeoneonyt
    @Smeoneonyt 4 роки тому +8

    Thank you, I couldn't find how to modify the X axis interval size and you just solved my doubt!

  • @liranbaron9329
    @liranbaron9329 Рік тому

    Thank you for putting this together.

  • @foxables_
    @foxables_ 11 місяців тому

    I

  • @hipsterracoon2159
    @hipsterracoon2159 3 роки тому

    Thank you!!! I have Mac Myself so this just was MEANT TO BE

  • @meganharvey1195
    @meganharvey1195 4 роки тому

    Thank you so much! You just don't know how grateful I am to have found this, this morning!

    • @pmrozon
      @pmrozon  4 роки тому

      Awesome! I'm glad this video was helpful!

  • @forgottenwars7773
    @forgottenwars7773 2 роки тому

    This was clutch!

  • @nathan8750
    @nathan8750 4 роки тому +4

    Thanks for this! My project is to organize COVID cases from Oct to Nov and this really helped me out! I can get that extra 2 point credit I need for my grade haha!

  • @tarushsinghal7573
    @tarushsinghal7573 2 роки тому +1

    Is there any way to get rid of the decimals on the x axis and have it be whole numbers?

  • @rafaelcampos4102
    @rafaelcampos4102 4 роки тому +1

    this video helped me a lot!

    • @pmrozon
      @pmrozon  4 роки тому +1

      Awesome! I'm glad it was useful.

  • @AndresRuiz-ej4nt
    @AndresRuiz-ej4nt 2 роки тому

    When I change the bucket size to 10 on the histogram, it creates 2 big columns instead of 10 columns, what could I do to fix this?

  • @MeneMeneTekelParsin
    @MeneMeneTekelParsin 2 роки тому

    My google docs show in a box " NO DATA". How can I change ti?

  • @faith2524
    @faith2524 3 роки тому +1

    how can you make a histogram with multiple sets of data? like for example I have 7 sets of data but need them all on one histogram.

    • @pmrozon
      @pmrozon  3 роки тому +2

      I don't think it's possible. Typically a histogram is a one variable statistic. You make ranges and then you count how many items are in each range. This is only for one variable though. I suppose if you have 7 sets of data you could make 7 histograms. Or you could combine all the data into one list and make a histogram based off that. I'm assuming they sets of data are measuring the same things though.

  • @tejasvitarajawat897
    @tejasvitarajawat897 3 роки тому

    thank you!!

  • @knigsmoooth
    @knigsmoooth 4 роки тому

    I have a bin that is outside of my data range. What do I do?

    • @pmrozon
      @pmrozon  4 роки тому

      What do you mean by bin? Not sure what that means.

    • @knigsmoooth
      @knigsmoooth 4 роки тому

      @@pmrozon the domains at the bottom? I’m making a histogram for student scores 1-5, but I’m getting a domain of 5-5.50. It’s only out if 5. When I change it to 1-5 manually it cuts off the 5-5.50 but it doesn’t keep the same number of students. I lost that data on the graph.

    • @pmrozon
      @pmrozon  4 роки тому

      @@knigsmoooth I'm not totally sure why but I suspect it's because you're working with discrete whole numbers. Lots of times when you graph whole numbers you create bars and the bar that would be at 5 would often be graphed from 4.5 to 5.5. This creates a bar of width 1 that is centred at 5. It doesn't really explain why you're missing a data point though but it might explain why it's going to 5.5.

  • @austinzhu6506
    @austinzhu6506 3 роки тому

    Watched because of school, stayed because math is fun.

  • @haniearisya6889
    @haniearisya6889 4 роки тому +2

    how to change the decimal places

  • @manwhoiscan8439
    @manwhoiscan8439 5 років тому +1

    Cool beans

  • @finlayweston3885
    @finlayweston3885 4 роки тому

    does the numbers have to be least to gretest

    • @pmrozon
      @pmrozon  4 роки тому

      I would have to double check but I don't think so. Google sheets will make the histogram even if it's not in order.

  • @humberthauddorismond2939
    @humberthauddorismond2939 4 роки тому

    Mines keep saying no date

  • @elijosc1963
    @elijosc1963 4 роки тому

    Toasted Cheese