You are a life saver!!!! I am working on this assignment for class and I couldn't figure out how to find the answer and this explanation made it so clear and easy to understand!!! THANK YOU THANK THANK YOU. The assignment is very similar to your explanation. The only difference is there are 4 test scores.
Very nice explanation. Also in case no one else mentioned it, F4 is the shortcut key to lock a cell or range of cells. If you keep pressing F4 you can toggle through the different locks. I'm sure you know, just passing along for others. Cheers.
Thank you for posting this. I was at a stand still. I had the concept but not the exact formula. I can now move on and have a glass of wine instead of continuing on stressing. God bless.
glad I could help, professors are often pressed for time to squeeze a lot of material, I have the same problem myself, thanks for the thoughtful comment
I watched your video to see how this is done, however when I do it on my worksheet I get 4 numbers 8120% (different worksheet than yours) My instructor didn't cover this very well. What can I be doing wrong?
So say I want to look back at previous performance against a "plan". I could simply use a moving average over the last say 4 weeks to get a good look at what has been going on in recent history. Right...BUT, what if the "plan"during those previous weeks had some hard weeks and some easy weeks? Could I then use the same weighted average for each of those weeks? More weight would be given to the hard weeks and less weight would be given to the easy weeks. Would that make my 4-week moving "weighted" average more accurate?
Hi, Your presentation is very impressive. I love how you dealt with this in the presentation. However, I want to set up a gradebook as follows for two students using the weighted percentage method. Any help would be most welcomed. Here are the actual scenarios: FIRST student obtained grades for three pieces of assignments as follow: 9/10 (1), 80/100 (1) and 30/50 (1). These were input in excel as follows: C2=10, D2=100, E2=50; C4=9, D4=80, E4=30. The total assignment weight is (3). Therefore, the formula I used to calculate the overall assignment % weight is =SUM((C4/C2*100)+(D4/D2*100)+(E4/E2*100))/H4, which gave a result of 76.67%/77%...perfect. SECOND student got the following grades for the same three pieces of assignments: Abs/10 (1), 50/100 (1) and 25/50 (1). The grades were input in excel as follows: C2=10, D2=100, E2=50; C5=Abs, D5=50, E5=25. The total assignment weight is now (2) . My problem now is trying to use a formula to calculate the student's overall assignment % weight without the student getting a ZERO using a percentage weight (20%) for all three assignments for both students. Thanks again for the assistance.
I have this scenario: Principal 5,000,000 Semiannual payments 10 months to mature from now next payment will be in December 2014 for 2,500,000 Maturity date June 2015. Based on this, how can I calculate WAL?
Very clear explanations! You are being more easily understandable than anyone else in my mother tongue. Thanks.
You are a life saver!!!! I am working on this assignment for class and I couldn't figure out how to find the answer and this explanation made it so clear and easy to understand!!! THANK YOU THANK THANK YOU. The assignment is very similar to your explanation. The only difference is there are 4 test scores.
OMG! I'm 50 in a class of 22 year-olds who get math. Thanks for turning me into one of them! I LOVE YOU!
Very nice explanation. Also in case no one else mentioned it, F4 is the shortcut key to lock a cell or range of cells. If you keep pressing F4 you can toggle through the different locks. I'm sure you know, just passing along for others. Cheers.
glad I could help and thanks for the nice comment
Thank you for posting this. I was at a stand still. I had the concept but not the exact formula. I can now move on and have a glass of wine instead of continuing on stressing. God bless.
Seriously, so much more help. My prof teaches things so fast... I have a hard time keeping up!!!!
I am glad we could help. Come back soon.
You are a life saver!! This was exactly what I needed!!! Thanks!!!
glad I could help, professors are often pressed for time to squeeze a lot of material, I have the same problem myself, thanks for the thoughtful comment
Thank you for the excel lesson. You made learning how to calculate weighted averages easy!!
no problem, thanks for watching
I am glad I could help... come back soon
you're welcome, thanks for the nice comment
Thanks for the nice and easy explanations.
Awsome, you just saved my life!
this is the best way to explain sir, I was struggling with this from the last couple of days. You are good
Thanks for the comment and thanks for the F4 tip for all viewers
Mannnnn this is so helpful for me thanks soooo much
excellent video
just glad I could help
Thanks. That helped allot.
you may be inputting your percents as whole number and then converting to format->percent. Instead input .8120 then format to a percent.
THANK YOU i LOVE YOU i NEED THIS VIDEO SO BAD FOR MY ASSIGNMENT THANK YOU SO MUCH
Thanks so much! I was able to do it nice and easy!
Thank you! An excelent detailed explanation of weighted average. You saved my ass from getting an C.
Thank you
for using the program I have over 200 tutorials on my channel
Thank you!
Great! easy to understand:)
perfectly explained
multiplying by decimals that add up to 1 is essentially the same as dividing
Glad I could be of help/
we specialize in saving your behind here, thanks for commenting
no prob, happy it helped
Thank you!! :)
glad to be of service, be sure to check out my channel for more Excel and other math and software tutorials you may need.
Thanks:)
My audience is a mixture of all peoples from all walks of life, mostly humble and wanting to learn, thanks for the comment
Thank you!!
I watched your video to see how this is done, however when I do it on my worksheet I get 4 numbers 8120% (different worksheet than yours) My instructor didn't cover this very well. What can I be doing wrong?
Wouldn't sumproduct be easier than using all those cells in our arguments?
So say I want to look back at previous performance against a "plan". I could simply use a moving average over the last say 4 weeks to get a good look at what has been going on in recent history. Right...BUT, what if the "plan"during those previous weeks had some hard weeks and some easy weeks? Could I then use the same weighted average for each of those weeks? More weight would be given to the hard weeks and less weight would be given to the easy weeks. Would that make my 4-week moving "weighted" average more accurate?
Hi,
Your presentation is very impressive. I love how you dealt with this in
the presentation. However, I want to set up a gradebook as follows for
two students using the weighted percentage method. Any help would be
most welcomed.
Here are the actual scenarios:
FIRST student obtained grades for three pieces of assignments as follow:
9/10 (1), 80/100 (1) and 30/50 (1). These were input in excel as
follows: C2=10, D2=100, E2=50; C4=9, D4=80, E4=30. The total assignment
weight is (3). Therefore, the formula I used to calculate the
overall assignment % weight is
=SUM((C4/C2*100)+(D4/D2*100)+(E4/E2*100))/H4, which gave a result of
76.67%/77%...perfect.
SECOND student got the following grades for the same three
pieces of assignments: Abs/10 (1), 50/100 (1) and 25/50 (1). The
grades were input in excel as follows: C2=10, D2=100, E2=50; C5=Abs,
D5=50, E5=25. The total assignment weight is now (2) . My problem now is
trying to use a formula to calculate the student's
overall assignment % weight without the student getting a ZERO using a
percentage weight (20%) for all three assignments for both students.
Thanks again for the assistance.
tyvm you made my cis assignment so much easier xD
right back atchya
Thanks for the help! Oh, by the way... You sound sound like Paul Stanley from KISS lol
I have this scenario:
Principal 5,000,000
Semiannual payments
10 months to mature from now
next payment will be in December 2014 for 2,500,000
Maturity date June 2015.
Based on this, how can I calculate WAL?
=SUMPRODUCT WILL DO THIS FOR YOU
You can also lock the cells by pressing simply F4.... 😑
thank you now i can do my HW : D w ease......e
Should tell more how to use the program, not how to do math.
Did you fart during this video?
dude, overkill on the led arrows at the end....