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.
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.
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, professors are often pressed for time to squeeze a lot of material, I have the same problem myself, thanks for the thoughtful comment
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.
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?
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?
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?
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 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.
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.
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, professors are often pressed for time to squeeze a lot of material, I have the same problem myself, thanks for the thoughtful comment
glad I could help and thanks for the nice comment
this is the best way to explain sir, I was struggling with this from the last couple of days. You are good
I am glad we could help. Come back soon.
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 for the excel lesson. You made learning how to calculate weighted averages easy!!
no problem, thanks for watching
Seriously, so much more help. My prof teaches things so fast... I have a hard time keeping up!!!!
you're welcome, thanks for the nice comment
Thank you! An excelent detailed explanation of weighted average. You saved my ass from getting an C.
for using the program I have over 200 tutorials on my channel
Thanks for the comment and thanks for the F4 tip for all viewers
multiplying by decimals that add up to 1 is essentially the same as dividing
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.
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?
we specialize in saving your behind here, thanks for commenting
I am glad I could help... come back soon
Thanks for the nice and easy explanations.
My audience is a mixture of all peoples from all walks of life, mostly humble and wanting to learn, thanks for the comment
glad to be of service, be sure to check out my channel for more Excel and other math and software tutorials you may need.
You are a life saver!! This was exactly what I needed!!! Thanks!!!
just glad I could help
Wouldn't sumproduct be easier than using all those cells in our arguments?
no prob, happy it helped
Mannnnn this is so helpful for me thanks soooo much
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?
Awsome, you just saved my life!
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?
Glad I could be of help/
Thanks so much! I was able to do it nice and easy!
Thanks for the help! Oh, by the way... You sound sound like Paul Stanley from KISS lol
THANK YOU i LOVE YOU i NEED THIS VIDEO SO BAD FOR MY ASSIGNMENT THANK YOU SO MUCH
perfectly explained
excellent video
Thank you!! :)
Thanks. That helped allot.
Thank you
Great! easy to understand:)
Thank you!!
Thank you!
tyvm you made my cis assignment so much easier xD
right back atchya
You can also lock the cells by pressing simply F4.... 😑
Thanks:)
=SUMPRODUCT WILL DO THIS FOR YOU
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.
dude, overkill on the led arrows at the end....
Did you fart during this video?