Percentage Change, A to B. If A is less then B the result is always positive (a gain), else result is always negative (a loss). Use this formula as it works no matter if A and/or B, is above or below zero. =IF(A1
Thank you Dr Todd, I want to ask about the analysis of paired test for qualitative variable, e.g. patients pre treatment had mild, moderate or severe symptoms and post treatment get (mild, moderate or severe) symptoms with some changes how we could compare them??, great thanks
Wonderful video. New subscriber. However Dr., can you tell me the formula for calculating the percent difference in two numbers? For instance, I can see from some online calculators that the percent difference between 20 and 30 is 40%, but I can't seem to get the formula right. I appreciate your videos.
Hello ! i have a question: if we are calculating the "percentage of change" between 2 percentages should we just subtract them from each other considering they are already percentages ? or also we should use the formula =(post-pre)/pre
Dear Doctor, I want to ask is the use of percentage change from baseline as an outcome in a controlled trial is statistically efficient, If we have two groups how we could compare the percentage change between both groups (treatment vs. Placebo groups), thanks with best regards
Very helpful video! Thoughtful explanation and demonstration! Thanks, Dr. Todd 🤘
Good video. I always find Excel confusing, but I really like its capabilities. I can't imagine calculating this with pen and paper.
Percentage Change, A to B. If A is less then B the result is always positive (a gain), else result is always negative (a loss). Use this formula as it works no matter if A and/or B, is above or below zero. =IF(A1
Thanks a lot Dr Todd, your videos are really good and beneficial, Best regards and good luck
You're welcome - thanks for watching -
Thank you Dr Todd, I want to ask about the analysis of paired test for qualitative variable, e.g. patients pre treatment had mild, moderate or severe symptoms and post treatment get (mild, moderate or severe) symptoms with some changes how we could compare them??, great thanks
Thank you this was a big help, cheers from QLD, Australia
You are welcome, thank you for watching
Great lesson, very helpful and well explained, Thank you!!!
You are welcome, thank you for watching
Wonderful video. New subscriber. However Dr., can you tell me the formula for calculating the percent difference in two numbers? For instance, I can see from some online calculators that the percent difference between 20 and 30 is 40%, but I can't seem to get the formula right. I appreciate your videos.
Hi! Thanks for this tutorial. It certainly helped with what I need!
I am glad you found the video useful - thanks for watching.
Thank you! You saved my life!
Sir what if column "A" having negative number??
This helped a lot thank you!
Hello ! i have a question: if we are calculating the "percentage of change" between 2 percentages should we just subtract them from each other considering they are already percentages ? or also we should use the formula =(post-pre)/pre
Thank you very much - Very Helpful!
Percentage change seems to crucial in predicting a meaningful result.
Dear Doctor, I want to ask is the use of percentage change from baseline as an outcome in a controlled trial is statistically efficient, If we have two groups how we could compare the percentage change between both groups (treatment vs. Placebo groups), thanks with best regards
sir if i have three value one pretest present test and one more, how to find percentage change
awesome
Thank you -
Ace tutorial