Excel Creating A Frequency Distribution Table

This video shows how to create a frequency distribution table with frequencies, midpoints, class boundaries, relative frequencies, and cumulative frequencies.
Histogram: • Excel Creating A Histo...
Ogive: • Excel Creating An Ogive
Box Plot: • Excel Creating a Box Plot
Stem and Leaf Plot: • Excel Creating a Stem ...
Pareto Chart: • Excel Creating a Paret...
Pie Chart: • Excel Creating a Pie C...

[@undefined2554]

1:13 - MINIMUM
2:07 - MAXIMUM
2:37 - Number Of Date
5:19 - Class Width
8:33 - 9:21- intervals
11:38 - Frequency
15:22 - Class Boundaries
16:56 - Relative Frequencies

[@sandrazapata9482]

Wow! I am so glad I found your video. This will save my life on my final test! God bless you!

[@crowsmathclass]

Thank you. Glad it helped. Good luck on your test.

[@joshuaducheny7544]

Thank you so much. You deserve more likes than this. This not only helped me with the specific assignment I was on but it helped me with understanding how excel works.

[@catcat9616]

So true! Is the way he explained the topic but also his tone of voice! He sounds like a good teacher with loads of patience! Loved it! I was able to complete my assignment slowly and the right way. Thank You!

[@kevinorbruno5264]

honestly after watching hours of other videos, this right here is everything in one place!

[@crowsmathclass]

Thank you. Glad it helped.

[@billywilliam7747]

Steve, great thanks for your patience and clarity 👍👍

[@crowsmathclass]

You’re welcome.

[@mackenzieroseb]

Thank you so much! Wouldn’t have been able to complete my assignment without this video! You made it so simple!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@amoszahir7346]

you probably dont care at all but does anyone know a tool to log back into an Instagram account?
I was stupid forgot the account password. I would love any help you can offer me!

[@jaycekoda6056]

@Amos Zahir Instablaster :)

[@johnmarimigallon9274]

Thank you man! You just saved me from understanding complex functions!

[@crowsmathclass]

You’re welcome. Glad it helped.

[@langelihlemsipha5750]

your work on this video is way too great... thank you...

[@crowsmathclass]

Thank you. Glad it helped.

[@sehar2508]

My concepts are much more clear now. Thank you ☺️

[@crowsmathclass]

You’re welcome.

[@shikhajoshi5746]

Thank you for this. You just saved my semester

[@crowsmathclass]

You’re welcome. Glad it helped.

[@afiqahistar3863]

Thank you sooo muchhh,this really help me a lot,omg,I almost stress myself by doing one by one the value💆‍♀️,Im so grateful to find this video,may god bless you✨

[@crowsmathclass]

Thank you. Glad it helped.

[@cheesemac8314]

You are a national treasure. Thank you so much.

[@crowsmathclass]

Thank you. Glad it helped.

[@jasminecats1370]

Oh wow, thank you so much. This definitely just made life easier for me.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@reyruiz7763]

Woooooww Sir I am so thankfull with you. Finally some one who think about details thanks a lot💪👍

[@crowsmathclass]

You’re welcome.

[@Malkm1n]

Thanks for the help. I have a professor that is no help and you basically just helped me complete my whole assignment

[@crowsmathclass]

That’s great. Glad it helped. Good luck in your class.

[@justinpease1918]

thank you very much for this I'm awful with technology and excel especially but this made a lot of sense

[@crowsmathclass]

Glad it helped

[@ashutoshanilgudi7823]

Thanks a lot! And I love your Texan accent!!

[@crowsmathclass]

You’re welcome. Thank you for the comment.

[@dolandendra_trumpodi]

@@crowsmathclass You're welcome!❤️😊

[@mani5084u]

Very well explained, thanks for that $ trick!

[@crowsmathclass]

Thank you. Glad it helped.

[@KyngofJewel]

Thank you for this 😊

[@crowsmathclass]

You are welcome. Glad it helped.

[@mariakimirop1854]

Thank you so much, this's so clear

[@crowsmathclass]

You’re welcome.

[@mohamadehtheshams2527]

Thank You so much ❤❤

[@crowsmathclass]

You’re welcome.

[@ivlivs.c3666]

Lifesaver! Thank you so much!

[@crowsmathclass]

You’re welcome.

[@pugaykamay]

Thank you very much! This is exactly what I was looking for, very helpful!

[@crowsmathclass]

You're welcome. Glad it helped.

[@og_chan7323]

thank you good sir!

[@crowsmathclass]

You’re welcome.

[@austineotieno4243]

thanks...this was awesome

[@crowsmathclass]

Austine Otieno You are welcome. Glad it helped.

[@frankvalenti8350]

wonderful !! Thank sir

[@crowsmathclass]

Glad it was helpful

[@MP-yy6vz]

Holy smokes, thank you for this.

[@crowsmathclass]

You’re welcome. Glad it helped.

[@yoyok5853]

Thank you!

[@crowsmathclass]

You’re welcome.

[@smiling_crumbles6409]

😮 whoa really great

[@crowsmathclass]

Thank you.

[@michellederheim8345]

thank you!

[@crowsmathclass]

You’re welcome.

[@mrvinnie8110]

Cheers ,used this for an assignment

[@crowsmathclass]

Glad it helped.

[@iandevo6442]

helpful video

[@crowsmathclass]

Thank you.

[@sabinewerk1027]

For a moment i thought you are Brad Pitt! your voice is similar

[@biplavpoudel]

How do I find median and quartiles from frequency distribution table using Excel? I know how to find median of individual data but finding median of discrete and continuous data is something I don't have any clue on.

[@daan9211]

Hi my midpoint first midpoint is 1414,57. Does my class bounderies also need to be calculated with lower -. 5 upper +. 5 or do i need to do -. 57 and +. 57?

[@crowsmathclass]

You add and subtract half the gap of your class intervals. Notice the gap between my intervals is one. So half that is .5.

[@himang345able]

I am not sure what is going on with the frequency formula you've applied. I'm getting an error saying 'formula omits a adjective cells' which in return is not giving the values for the frequency for remaining data.
Someone please help thank you in advance.

[@roseaneke6745]

Hey Mr crow do you know how to do Cuppoint grouping in Excel?

[@crowsmathclass]

rose aneke You can go to the about page of my RUclips channel and click on my email address.

[@onereflection2055]

Hey Steve thanks, wish I could shake your hands

[@crowsmathclass]

You’re welcome. Glad it helped.

[@piumandal145]

I use the process same way as shown here but frequency not coming for all class
I select all cell which I wanted find frequency. Can you please help me. I try this for last 3 hours.

[@devkamal3762]

GOD:)

[@thomassymens7281]

is interval the same as low and high class limits

[@crowsmathclass]

Yes

[@roseaneke6745]

how can i contact you personally

[@caiez147]

2020 here

[@prashantp679]

TOOO MUCH SLOW YOU