I found the video to be useful in demonstrating how to conduct a pretest and posttest using excel. I find that by watching such videos and demonstrations I am able to gain a better understanding of the material and how to apply it. It was beneficial to learn that when the p-value is lower you reject the null hypothesis because there is a statistically significant difference between the groups and when the p-value is higher you accept the null hypothesis, assuming there is no difference between groups.
I love the clear explantions of what the results of the ANOVA mean. I love that he clearly explains why we would accept of reject the null hypothesis. Such clear and easy to follow directions.
Mandy Moore Mandy, I agree. It's nice to continually hear what the null hypothesis is, where to locate the p-value and how to determine whether or not we reject the null hypothesis.
Well, now I feel silly. I didn't look ahead on the playlist and mentioned wanting a video of describing pretest and posttest data in Excel and here it is! This was easy to follow and understand, and I am so grateful that he mentioned p-values and when to reject (or fail to reject) the null hypothesis. Out of all of the types of measures to use, this type of analysis seems very advantageous and useful!
Dr. Grande did a great job explaining pre and post test in Excel. It is very important to use the data analysis tool in Excel. For some reason this video was much easier to understand as compared to utilizing SPSS.
Even though I do not have any data to work with for my research paper this topic seems very relevant. The explanation of what the difference was, what it stood for, and how to manually calculated were eye opening.
I found this video helpful in understanding how to analyze differences found within research by using a pretest and posttest, and felt that the instructions were clear and straightforward.
This was one of the few videos that I did not have to Google anything to understand what was being explained to be. I have to say it's a good feeling finally beginning to understand these concepts. Having easy access to Excel I will most likely be tinkering with this myself to see first hand how it works.
I appreciate how you go through every step and explain everything clearly. For example when you said .05 or 5%. That is something that probably would have confused me but didn't because you explained it very clearly.
Katherine Beck I noticed how well Dr. Grande explains even the simplest of things, just to make sure that we are fully understanding the videos and the process of inputting our data to get our results.
As my group will be using pretest posttest design for our research paper, this video is highly helpful in breaking down statistics for this particular design. I also liked the inclusion of different "shortcuts" one can use with the program to make assessment quicker and easier!
I found this video very helpful and easier to understand than most of the others. I really appreciated the "review" at the end of the video because it reaffirmed what Dr. Grande had just taught.
This video was explained well. I liked how Dr Grande explains the terms over and over, P value, null hypothesis, this really helps. I understand the ANOVA will show if there is a significant difference between the groups.
Michelle Robinson I liked that Dr. Grande explained the terms, I too found this helpful. I think that is what helped me to understand it so well. I never felt lost while watching this video.
This video was very clear and easy to understand. Since pre and post test analysis are so common it was helpful that there is a video provided on how to analyze on excel.
Jessie Howard This tool is SO useful! I can understand why this is one of the most widely used measures in the field of counseling and social science research methods.
I found this extremely useful in aiding me to decide how to organize my current research project. It is a simple way to analyze data when referencing treatment options.
This is such a simple video to follow and helps to clarify the easy step by step instructions in order to properly analyze the effects of a pretest and post-test.
The effects of pre- and post tests are so intersting! I agree. It's facinsiating to see the difference betwen the two. I love that ANOVA's really so the varaince between variables in an easy to understand way.
This video was clear and explained pretest and posttest very well. Pretest and Posttest is a common design so it is very useful information to know. After watching a lot of these videos, I am definitely understanding Excel and SPSS more.
I feel like I understood this video pretty well, but the summary at the end was really nice and helpful to bring everything together. A lot of the time I need that to make sure I understand everything, or that is my time to ask questions if need be. It was really nice to see how this works in Excel and the process of it.
Thank you for the video Dr. Grande. It is useful to see the how a pretest and post test is conducted in spss and in excel. It helps me understand the technique better seeing both ways and the information found using these tests.
Great reflection. Since most of us will be using a pretest and a postest in our research design assignment, this was helpful to review. This is especially true if we one day hope to go back and complete the actual project.
I chose to watch this video because excel is something that I am familiar with and also because I think that I will have a pretest and posttest as part of my research proposal so knowing how to do this will come in handy. I like that the steps are completely explained and also showed. I also appreciated the summary at the end because it helps to really make all that information understandable and come together in my mind.
This video was very helpful in being able to examine data for pretest and posttest data. I also found this information useful because I am thinking about using a pretest/posttest design for my research proposal. This video did a good job of showing me how easy it can be to populate the data for my research.
I agree Amanda this video is very straight forward and easy to follow. I like how Dr. Grande does the step by step visual explanation which makes it easy to understand
Ha! Last video I commented that it would be nice to see how this process worked in Excel and here it is! This video was very simple and easy to follow. Once the process was completed it was easy to see the difference in the pre and post tests.
Melissa Clendaniel I saw your comment on the last video and thought it was funny that it was the next one. This was one of the more simplier videos to comprehend and follow because it covers concepts that we have already become very familer with.
I liked this video. It was easier to understand oppose to the video with SPSS. Perhaps because I am familiar with this system. All in all Dr. Grande did a good job explaining pre and post tests.
I liked how there was a difference data set in the excel for pre and post testing. It made it a little easier to understand the results I think. Overall a very good video.
This video was extremely helpful when working through the analysis section of my paper. I was able to refer back to it a few times to make sure I was describing the process correctly.
I really like the videos in excel because I think that excel is the program that I will be most likely to use in the future. I also liked that the video was easy to follow for the instructions for analyzing the pre and post test scores.
This video was very easy to follow. For some reason, I find Excel a lot easier to use then SPSS. The formula is very easy to understand and remember. I think this tool is very useful because a lot of research studies require a pretest and posttest so obviously you want to see if there is a difference.
Brittany Vodzak I also find Excel much easier to understand compared to SPSS. It is extremely important to see if there is a variance between the pre and post test.
I watched the pretest and posttest analysis for both SPSS and Excel and Excel appears to be somewhat easier, but I do believe it may be that the SPSS explanation was more in-depth. I do like that data from Excel can be imported into SPSS and vice versa. And I appreciate that you presented the analyses using both.
I did the same thing! I agree that Excel appears to be easier. I think they both helped me with my upcoming research project by showing how I would calculate my data if I were to actually perform my experiment.
It was interesting to learn about such an efficient method of analyzing the differences between the pretest and posttest within the treatment and control group. I thought the ANOVA steps were tricky, but I was impressed with the results of configuring the data with ANOVA. It was a very organized and concise way to read the data.
I was able to easily follow this video and especially appreciated the recap at the end. The ANOVA single factor tests for a statistically significant different between groups (control and treatment groups) which I think is probably a commonly desired analysis in research.
Kimberly Hanna The recap part of the video solidified the information in my mind. Statistics and research are not my strong points. Therefore, I need as much repetition and recapping as possible.
I found this video easy to understand. After watching pretest and post test ANOVA in both excel and spss, I think that I would choose to do it in excel. Seems a bit more straight forward
This is a very straightforward video.Even though you can tell that there was an impact after treatment without running analysis, when running analysis you can get more accurate results. In addition, it gives you the results from ANOVA to determine if there is statistically significant difference.
This video about Pretest and Post test Analysis was easy to understand. I understand now that if the p-value is less than 5% we reject the null hypothesis and if its greater than 5% we accept the null hypothesis. I also was able to add data analysis tools on my data ribbon
Great Video and easy to follow. I liked how there were 3 simple columns with data that was easy to understand. The difference column was interesting to see since I have yet to see this in any of the videos
I found this video to be very helpful. I like that I am able to watch exactly how it is done on the video and that it seems to be an easy step by step process. I was unfamiliar with this until watching this video, but think that I would be able to apply this information.
This is a surprisingly simple test using the ANOVA single factor function. Looking at the sum is actually useful by being able to see just how much each adds up to. Of course, that is not going to give you complete answers but it does help to be able to see the concrete difference between the control scores and the treatment scores. Then this function gives you the p-value which will confirm or deny the null hypothesis.
I am always amazed at everything Excel can do. This is great to know, as so many experiments include pre and post tests. I am sure this is great to know if you are using a pre and post test on your research design.
This was a great example. I was able to follow along without any issues. Is there a need to have the separate worksheet to run the results or can you run them in the main worksheet? I guess I just want to see the information all together and not on 2 different worksheets.
Bethany Elstrom Indeed, this one was rather simple but very informative. True, it seems like you could do this all on the same worksheet. I suppose it would be a matter of preference; it would take up a lot of space on one worksheet to do it all on one but, then again, you can more easily reference on the same sheet.
@DR GRANDE. Thank you for simplifying the process. My current work involved a control group only, and the design is based on a pretest/posttest analysis. Can you explain how to analyse using data from a single group? Thank you
This video was particularly interesting to me because of the research design I am preparing. SPSS was a bit too involved for he research I plan to do. This Excel is a little more simplistic and reasonable.
Susan Wilder Sometimes I feel as though the videos are blending together as well. I have to take a step back and really remember what I am learning about so I don't blur the information. I am glad we can refer to these videos though!
Just a quick question Dr. Todd, should the formula for the difference be C2-B2? Because a positive result here would mean that the students improve their performance. Because in the analysis part you said that the positive sum means good result. Correct me if I'm wrong. Thanks.
Hi Dr I find your videos really helpful. I currently running a study on compensation (comparing pre and post ) and I would like to use SPSS. I would be glad if you could help with the data structure in SPSS.
Hello 🙌 I want to ask something. What if we had positive control and negative control but the number of treatments is half of the total positive and negative controls. can i still use this? Thank you
HI, I enjoyed the video, but I have a question, I have 5 classes and a pre and post-test and want to analyze the difference in the assessment to see if the students had learning gains from the pre-test, I understand how to get the difference but unsure what is my next steps.
In this we have used ANOVA for pre post test analysis. But I want to confirm if we have only two groups can we use ANOVA or we have to use t test. Because ANOVA we use in more than two groups. Please answer
I agree that it was easy to understand as well. I did have trouble following along with the steps to configure data using the ANOVA functions, but I was impressed with the results of the organized data. I will save this video and continue studying the steps used.
Hello, in my case the pretest data of control and treatment group is coming significant different. This is one of the assumptions if we do it in SPSS that Control and treatment pretest data should not be significant different
Hello! Why use an ANOVA instead of a paired T-test? Shouldn't we used a t-test when comparing only 2 variables? And an ANOVA when comparing more than 2? Thank you.
At risk of sounding dumb, why did you use an ANOVA and not a paired t-test for your analysis? I was of the understanding that ANOVA was to be used on 3 or more groups.
I found the video to be useful in demonstrating how to conduct a pretest and posttest using excel. I find that by watching such videos and demonstrations I am able to gain a better understanding of the material and how to apply it. It was beneficial to learn that when the p-value is lower you reject the null hypothesis because there is a statistically significant difference between the groups and when the p-value is higher you accept the null hypothesis, assuming there is no difference between groups.
Thanks Dr. Grande. Excel eliminated the chances of error. It was straight forward and easy to compute the numbers and see the significant differences.
I love the clear explantions of what the results of the ANOVA mean. I love that he clearly explains why we would accept of reject the null hypothesis. Such clear and easy to follow directions.
Mandy Moore Mandy, I agree. It's nice to continually hear what the null hypothesis is, where to locate the p-value and how to determine whether or not we reject the null hypothesis.
Well, now I feel silly. I didn't look ahead on the playlist and mentioned wanting a video of describing pretest and posttest data in Excel and here it is! This was easy to follow and understand, and I am so grateful that he mentioned p-values and when to reject (or fail to reject) the null hypothesis. Out of all of the types of measures to use, this type of analysis seems very advantageous and useful!
Dr. Grande did a great job explaining pre and post test in Excel. It is very important to use the data analysis tool in Excel. For some reason this video was much easier to understand as compared to utilizing SPSS.
***** I agree that the videos in excel are much easier to understand.
I also agree. I think it is easier because we are all more familiar with Excel than SPSS and therefore have experience to be able to measure against.
+Ashley Dorsey I agree. It did seem a little more clear than the video using SPSS.
Even though I do not have any data to work with for my research paper this topic seems very relevant. The explanation of what the difference was, what it stood for, and how to manually calculated were eye opening.
I found this video helpful in understanding how to analyze differences found within research by using a pretest and posttest, and felt that the instructions were clear and straightforward.
Jacklin Skibicki I agree this video was a very easy one to follow and I was able to understand the information given.
This was one of the few videos that I did not have to Google anything to understand what was being explained to be. I have to say it's a good feeling finally beginning to understand these concepts. Having easy access to Excel I will most likely be tinkering with this myself to see first hand how it works.
I appreciate how you go through every step and explain everything clearly. For example when you said .05 or 5%. That is something that probably would have confused me but didn't because you explained it very clearly.
Katherine Beck I noticed how well Dr. Grande explains even the simplest of things, just to make sure that we are fully understanding the videos and the process of inputting our data to get our results.
As my group will be using pretest posttest design for our research paper, this video is highly helpful in breaking down statistics for this particular design. I also liked the inclusion of different "shortcuts" one can use with the program to make assessment quicker and easier!
I agree Chelsea! our group did the same thing and viewing this video was helpful for us when including the necessary information.
I found this video very helpful and easier to understand than most of the others. I really appreciated the "review" at the end of the video because it reaffirmed what Dr. Grande had just taught.
Rachel Foster I agree. I wish all the videos were formatted more like this.
Rachel Foster Very easy to follow. Makes reading the results easier too. I can see the purpose behind this video.
Rachel Foster I too appreciated the review. Dr Grande does that and it seems helpful.
This video was explained well. I liked how Dr Grande explains the terms over and over, P value, null hypothesis, this really helps. I understand the ANOVA will show if there is a significant difference between the groups.
Michelle Robinson I liked that Dr. Grande explained the terms, I too found this helpful. I think that is what helped me to understand it so well. I never felt lost while watching this video.
Michelle Robinson I agree. All of the terms are starting to finally sink in with me so I'm not as confused.
This video was very clear and easy to understand. Since pre and post test analysis are so common it was helpful that there is a video provided on how to analyze on excel.
This data analysis tool is seeming to be a very valuable tool. I understood this video very well. I liked the step-by-step instructions. Very good!
Jessie Howard This tool is SO useful! I can understand why this is one of the most widely used measures in the field of counseling and social science research methods.
I found this extremely useful in aiding me to decide how to organize my current research project. It is a simple way to analyze data when referencing treatment options.
This is such a simple video to follow and helps to clarify the easy step by step instructions in order to properly analyze the effects of a pretest and post-test.
Candace Fernandez agreed! Super straightforward and to the point!
The effects of pre- and post tests are so intersting! I agree. It's facinsiating to see the difference betwen the two. I love that ANOVA's really so the varaince between variables in an easy to understand way.
Candace Fernandez I definitely agree. Having clear instructions really makes a difference in understanding the concepts presented within the video.
I found it easier to follow also. It did provide some clearity
Candace Fernandez agreed candace!
This video was clear and explained pretest and posttest very well. Pretest and Posttest is a common design so it is very useful information to know. After watching a lot of these videos, I am definitely understanding Excel and SPSS more.
I feel like I understood this video pretty well, but the summary at the end was really nice and helpful to bring everything together. A lot of the time I need that to make sure I understand everything, or that is my time to ask questions if need be. It was really nice to see how this works in Excel and the process of it.
Thank you for the video Dr. Grande. It is useful to see the how a pretest and post test is conducted in spss and in excel. It helps me understand the technique better seeing both ways and the information found using these tests.
Great reflection. Since most of us will be using a pretest and a postest in our research design assignment, this was helpful to review. This is especially true if we one day hope to go back and complete the actual project.
I chose to watch this video because excel is something that I am familiar with and also because I think that I will have a pretest and posttest as part of my research proposal so knowing how to do this will come in handy. I like that the steps are completely explained and also showed. I also appreciated the summary at the end because it helps to really make all that information understandable and come together in my mind.
Melissa, I agree! This will be applied to my paper!
I agree too Melissa, very good points!
This video was very helpful in being able to examine data for pretest and posttest data. I also found this information useful because I am thinking about using a pretest/posttest design for my research proposal. This video did a good job of showing me how easy it can be to populate the data for my research.
I agree Amanda this video is very straight forward and easy to follow. I like how Dr. Grande does the step by step visual explanation which makes it easy to understand
Ha! Last video I commented that it would be nice to see how this process worked in Excel and here it is! This video was very simple and easy to follow. Once the process was completed it was easy to see the difference in the pre and post tests.
Melissa Clendaniel I saw your comment on the last video and thought it was funny that it was the next one. This was one of the more simplier videos to comprehend and follow because it covers concepts that we have already become very familer with.
I liked this video. It was easier to understand oppose to the video with SPSS. Perhaps because I am familiar with this system. All in all Dr. Grande did a good job explaining pre and post tests.
Ashlee Todd i agree Ash
I liked how there was a difference data set in the excel for pre and post testing. It made it a little easier to understand the results I think. Overall a very good video.
I agree, Excel seems easier to follow.
This video was extremely helpful when working through the analysis section of my paper. I was able to refer back to it a few times to make sure I was describing the process correctly.
I really like the videos in excel because I think that excel is the program that I will be most likely to use in the future. I also liked that the video was easy to follow for the instructions for analyzing the pre and post test scores.
This video was very easy to follow. For some reason, I find Excel a lot easier to use then SPSS. The formula is very easy to understand and remember. I think this tool is very useful because a lot of research studies require a pretest and posttest so obviously you want to see if there is a difference.
Brittany Vodzak I also find Excel much easier to understand compared to SPSS. It is extremely important to see if there is a variance between the pre and post test.
***** I agree excel is easier to understand than SPSS.
I watched the pretest and posttest analysis for both SPSS and Excel and Excel appears to be somewhat easier, but I do believe it may be that the SPSS explanation was more in-depth. I do like that data from Excel can be imported into SPSS and vice versa. And I appreciate that you presented the analyses using both.
I did the same thing! I agree that Excel appears to be easier. I think they both helped me with my upcoming research project by showing how I would calculate my data if I were to actually perform my experiment.
It was interesting to learn about such an efficient method of analyzing the differences between the pretest and posttest within the treatment and control group. I thought the ANOVA steps were tricky, but I was impressed with the results of configuring the data with ANOVA. It was a very organized and concise way to read the data.
I enjoyed the video. It made these concepts easy to understand, & it was interesting to see how to do this in Excel.
I was able to easily follow this video and especially appreciated the recap at the end. The ANOVA single factor tests for a statistically significant different between groups (control and treatment groups) which I think is probably a commonly desired analysis in research.
Kimberly Hanna The recap part of the video solidified the information in my mind. Statistics and research are not my strong points. Therefore, I need as much repetition and recapping as possible.
I found this video easy to understand. After watching pretest and post test ANOVA in both excel and spss, I think that I would choose to do it in excel. Seems a bit more straight forward
This is a very straightforward video.Even though you can tell that there was an impact after treatment without running analysis, when running analysis you can get more accurate results. In addition, it gives you the results from ANOVA to determine if there is statistically significant difference.
This video about Pretest and Post test Analysis was easy to understand. I understand now that if the p-value is less than 5% we reject the null hypothesis and if its greater than 5% we accept the null hypothesis. I also was able to add data analysis tools on my data ribbon
The video was very informative, easy to follow, and clarified rejecting and accepting the null hypothesis. I learned so much valuable information.
Great Video and easy to follow. I liked how there were 3 simple columns with data that was easy to understand. The difference column was interesting to see since I have yet to see this in any of the videos
Interesting straightforward video how to analyze differences in pretest and posttest data.
This video was easy to follow along with and I am confident I could replicate this on my own.
I found this video to be very helpful. I like that I am able to watch exactly how it is done on the video and that it seems to be an easy step by step process. I was unfamiliar with this until watching this video, but think that I would be able to apply this information.
Another good break down of pretest and posttest analysis and ANOVA.
Michael Smith I agree, Mike. This seems easier to me than using SPSS.
My thoughts exactly. This was a clear and concise explanation of how to utilize pretest and posttest.
This will be helpful for my research proposal because this is the statistical analysis I would use.
This was definitely helpful to watch as I am doing a pre and post-test in my research paper.
I will be using a pretest and post test in my research, so this video was very helpful
This video was very informative and was a great review when writing the methods for my research proposal.
This video was very useful and easy to understand.
This is a surprisingly simple test using the ANOVA single factor function. Looking at the sum is actually useful by being able to see just how much each adds up to. Of course, that is not going to give you complete answers but it does help to be able to see the concrete difference between the control scores and the treatment scores. Then this function gives you the p-value which will confirm or deny the null hypothesis.
thank you for having this video available Dr. Grande
You're welcome.
Dr Grande, you're the best! Thanks.
You’re welcome!
very clear and helpful explanation! God bless you sir
Thank you, I am glad you found the video helpful -
I am always amazed at everything Excel can do. This is great to know, as so many experiments include pre and post tests. I am sure this is great to know if you are using a pre and post test on your research design.
This was a great example. I was able to follow along without any issues. Is there a need to have the separate worksheet to run the results or can you run them in the main worksheet? I guess I just want to see the information all together and not on 2 different worksheets.
Bethany Elstrom Indeed, this one was rather simple but very informative. True, it seems like you could do this all on the same worksheet. I suppose it would be a matter of preference; it would take up a lot of space on one worksheet to do it all on one but, then again, you can more easily reference on the same sheet.
Thanks for this helpful video. should the number of participants in the two sets being compared be of the same and or equal number?
@DR GRANDE. Thank you for simplifying the process. My current work involved a control group only, and the design is based on a pretest/posttest analysis. Can you explain how to analyse using data from a single group? Thank you
I thought this too was mush easier then the pre-test and post-test in SPSS. It's great to have both videos to compair
Thank you so much the video was really helpful
Great video easy to follow.
This video was particularly interesting to me because of the research design I am preparing. SPSS was a bit too involved for he research I plan to do. This Excel is a little more simplistic and reasonable.
good job expelling what the tests measure.
The video was easy to follow along with, as always. Although they are easy to follow along with I feel like they are all starting to blend together.
Susan Wilder Sometimes I feel as though the videos are blending together as well. I have to take a step back and really remember what I am learning about so I don't blur the information. I am glad we can refer to these videos though!
Just a quick question Dr. Todd, should the formula for the difference be C2-B2? Because a positive result here would mean that the students improve their performance. Because in the analysis part you said that the positive sum means good result. Correct me if I'm wrong. Thanks.
same question
This video comes really handy because my proposal includes pretest and posttest analysis.
I felt the same way Roberto, especially since we plan to incorporate pretest and postest analysis in our research design.
Saved my life. Thanks.
You're welcome!
Hello Todd, what if you wanted to control for say, gender , in your anova here? How would you do it?
This is helpful and I think I still prefer the Excel way to the SPSS.
Hi Dr I find your videos really helpful. I currently running a study on compensation (comparing pre and post ) and I would like to use SPSS. I would be glad if you could help with the data structure in SPSS.
Hello 🙌
I want to ask something. What if we had positive control and negative control but the number of treatments is half of the total positive and negative controls. can i still use this?
Thank you
Agreed, Greg I would prefer to use SPSS at this point
HI, I enjoyed the video, but I have a question, I have 5 classes and a pre and post-test and want to analyze the difference in the assessment to see if the students had learning gains from the pre-test, I understand how to get the difference but unsure what is my next steps.
In this we have used ANOVA for pre post test analysis. But I want to confirm if we have only two groups can we use ANOVA or we have to use t test. Because ANOVA we use in more than two groups. Please answer
Easy to understand video!
I agree that it was easy to understand as well. I did have trouble following along with the steps to configure data using the ANOVA functions, but I was impressed with the results of the organized data. I will save this video and continue studying the steps used.
Hello, in my case the pretest data of control and treatment group is coming significant different. This is one of the assumptions if we do it in SPSS that Control and treatment pretest data should not be significant different
Hello! Why use an ANOVA instead of a paired T-test? Shouldn't we used a t-test when comparing only 2 variables? And an ANOVA when comparing more than 2? Thank you.
Hi, so you use A single factor ANOVA or one-way ANOVA, right?
When given a list of data and asked to calculate average pre and post test excel will be great to do the mathematical work
So if I did not have a control and treatment group I guess this is a straight comparison between pre and post test right?
This is quite different than on SPSS. This seems more attainable for the average user.
Helpful Video thank you.
You're welcome, thanks for watching -
At risk of sounding dumb, why did you use an ANOVA and not a paired t-test for your analysis? I was of the understanding that ANOVA was to be used on 3 or more groups.
I also have this question. Please answer, thank you!
Sir if the control and treatment has different number of participants then?
My p value is 1.03766E-08
so that is significant? -reject null hypothesis?
sir i followed the procedure but data analysis tool doesn't appear
Please sir I need your help how can I contact you please
Hello everyone. can anyone do me a favour to analyze pretest and posttest scores in excel if i send data..
voice is low cant hear