Histogram in Excel using Pivot Tables | Frequency Distribution | Quantitative raw data

This video shows how to construct a frequency histogram in Microsoft Excel using Pivot Tables.
Class intervals: Lower Limit “to under” Upper Limit
Bar Chart & Pie Chart in Excel: • Bar chart & Pie chart ...
Boxplot in Excel: • Boxplots in Excel | Si...
Histogram in Excel using Data Analysis: • How to Construct a His...

[@nikkiweas7560]

Thank you so much! I was struggling until I saw this video. Easy to follow!

[@joshemman]

You're welcome, Nikki.

[@danielstark8356]

Super helpful! Thank you!

[@teodorazhivkova8132]

Thank you, exactly what I was looking for... so hard to find something helpful and valuable on the net

[@joshemman]

Glad it was helpful!

[@ShubhamPlays]

Thank you so much such a great simple and accurate video.

[@yahyemohamedjimale1208]

Thanks joshua for your best lesson videos.
from somalia

[@joshemman]

Glad to hear from you , Yahye, all the way from Somalia.✊

[@arjun9847]

Thank you

[@1981hosni]

شكرا من مصر

[@joshemman]

Glad to see you watched from Egypt, Ahmed.🙏

[@davidvelasquez4771]

Thank you super helpful

[@joshemman]

You're welcome, David.

[@tale_and_bake6153]

Thank you 👏🏼 the video was very helpful. Please how to i determine the frequency or class limit for a very large data set

[@aishahmohdnoor8500]

Thanks and excellent. Can you prepare for simple linear regression?

[@joshemman]

Sure. I'll work on it Aishah.

[@joshemman]

See if this helps: ruclips.net/video/Uqt3x0i-nlg/видео.html

[@Elbucaros]

How to do this in %?

[@joshemman]

To change the frequencies to percents, at any point after 1:05,
Right-click in the frequency (Count of Data) column.
Click “Show Values As”
Select “% of Grand Total”