Excel Cumulative Frequency and Relative Frequency

  Рет қаралды 237,083

Cody Tabbert

Cody Tabbert

11 жыл бұрын

If you're elated and want to tip me for helping create these videos, I'd love it very much!
paypal.me/codytabbert
or
www.venmo.com/u/codytabbert
Thank you!
***********************************
This video quickly shows how to calculate Cumulative Frequency and Relative Frequency in Excel!

Пікірлер: 42
@shivampardeshi9977
@shivampardeshi9977 3 жыл бұрын
Bro you are too good 👍🏻👍🏻 I wonder what stopped you from posting more content. In 2021 and still relatable as hell 🙏
@Juniperus_Godegara
@Juniperus_Godegara 11 жыл бұрын
You don''t know how much you helped me with this video! Thank you!
@TheBhuddah336
@TheBhuddah336 6 ай бұрын
Thank you for creating these videos. They are incredibly helpful.
@davidb7945
@davidb7945 7 жыл бұрын
My math problem was this exact context, MSL. It was weird to find an example of the exact problem I was stuck on! Awesome!
@soic9690
@soic9690 4 жыл бұрын
My professor linked this video to help with homework
@codytabbert
@codytabbert 11 жыл бұрын
Happy to hear you found it helpful!
@vanessag1914
@vanessag1914 10 жыл бұрын
I am very appreciative!!! You are awesome!
@kavirga
@kavirga 10 жыл бұрын
Thank you thank you I can't say it enough!!
@joshuaspringer129
@joshuaspringer129 9 жыл бұрын
FYI - I would've recommended (for cumulative) - in cell d4, you should've just done "=sum(d3+c4)" then drug them down. Would save alot of time instead of re-typing sum over and over :).
@joshuaspringer129
@joshuaspringer129 9 жыл бұрын
Although great information!
@rathianushka24
@rathianushka24 5 жыл бұрын
it wont work
@zpxckirl
@zpxckirl 3 жыл бұрын
oh my god thank you, this def saved a lot more time
@darhliyahh3694
@darhliyahh3694 Жыл бұрын
Thank you for this ❤
@ljvwright
@ljvwright 10 жыл бұрын
Thanks Man, helped me out a lot
@hazelbpink
@hazelbpink 10 жыл бұрын
Thank you Cody!
@jaggergege7791
@jaggergege7791 5 жыл бұрын
Omg that makes so much sense!!!!
@codytabbert
@codytabbert 9 жыл бұрын
Thanks Joshua - best to be efficient! I will add that to the video. Thanks!
@abineshsundaram7664
@abineshsundaram7664 4 жыл бұрын
What did you do at 1.05 to fill remaining boxes?? Because dragging it does not give correct values..
@honorthelegend1
@honorthelegend1 4 жыл бұрын
This was a great help!!!
@lornalalduhsaki164
@lornalalduhsaki164 2 жыл бұрын
Thank you for helping me catch up classes I've bunked.XD
@jleath5408
@jleath5408 11 жыл бұрын
I love you. thank you. thank you. thank you.
@CharlesDouglasJr
@CharlesDouglasJr 11 ай бұрын
What did you do at 1:05 to speed up the process of filling in the cells with your formula?
@codytabbert
@codytabbert 10 ай бұрын
I just paused the recording and finished it. I should have done another method though. Enter 20 in D3. then in D4 make the function: = C4+D3 hit enter, and drag that down. This way it will add the columns up in order and you won't have to do what I did.
@akshatbajpai8304
@akshatbajpai8304 3 ай бұрын
Thank You🙏
@megansebastian4212
@megansebastian4212 4 жыл бұрын
Thank you!!
@DJFireboyy
@DJFireboyy 2 жыл бұрын
ur a legend brother
@elshroomness
@elshroomness 10 жыл бұрын
I have a question. Why did you add a $ dollar sign when you were calculating the relative frequency?
@codytabbert
@codytabbert 9 жыл бұрын
The dollar sign is used to keep pointing at a certain cell. If I were to drag down to fill the information, and not have the $ sign, it would not maintain pointing at the cell I wanted. It would move downwards by 1 for each cell I drag down and the calculation would not work.
@thelabminer2048
@thelabminer2048 3 жыл бұрын
Thanks! This helped a lot with my test
@codytabbert
@codytabbert 3 жыл бұрын
Glad it helped!
@ishfaqawan5103
@ishfaqawan5103 5 жыл бұрын
please some body tell me i have one quantity spouse 1000meters and every day we add different quantity spouse i add 300m it will become 1300m but 1300 should be same if i remove 300 and add 200 so it have to show cumulatime 1500m , is it possible....?
@JASMINESACHDEVA-gw2fk
@JASMINESACHDEVA-gw2fk 3 ай бұрын
wow thanks
@queenshai7607
@queenshai7607 4 жыл бұрын
Is there a way to speed up the process of adding sums instead of doing it one by one?
@codytabbert
@codytabbert 4 жыл бұрын
yes - rather than doing the sum, just have the first one filled in for cumulative frequency. say in spot D3. Then assign D4 = D3+C4 once you do that if you click and drag that cell down, it will add up the previous cell with the new frequency in it's row. don't need to do like I did. Hope that helps
@queenshai7607
@queenshai7607 4 жыл бұрын
Cody Tabbert it worked! Thank you SO much!
@iio23ii
@iio23ii 10 жыл бұрын
Thnx mann :)
@selvarajarumugam4085
@selvarajarumugam4085 9 жыл бұрын
thanks lot
@DrumInc
@DrumInc Жыл бұрын
Emotional
@EmeraldBayMovies
@EmeraldBayMovies 4 жыл бұрын
This is definitely the long way to do this...
@codytabbert
@codytabbert 4 жыл бұрын
Never said it was the quickest. Thanks for the comment!
@GhanshyamSingh-cl8zf
@GhanshyamSingh-cl8zf 5 жыл бұрын
👿👿👿👿
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 168 МЛН
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 43 МЛН
Spot The Fake Animal For $10,000
00:40
MrBeast
Рет қаралды 134 МЛН
How To Make a Cumulative Relative Frequency Table
5:04
The Organic Chemistry Tutor
Рет қаралды 398 М.
Ogive (Cumulative Frequency Graph) using Excel's Data Analysis
3:16
Joshua Emmanuel
Рет қаралды 140 М.
Relative Frequency Histogram in Excel
16:54
Joan Brown
Рет қаралды 81 М.
Statistics - How to make a cumulative relative frequency distribution
4:39
MySecretMathTutor
Рет қаралды 512 М.
How To Create A Frequency Table & Histogram In Excel
6:32
Steven Bradburn
Рет қаралды 400 М.
Factorials or permutations in StatCrunch or Excel
2:48
Student Success Commons
Рет қаралды 215
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 168 МЛН