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!
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.
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.
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.
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 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.
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.
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.
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 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.
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.
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.
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 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.
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.
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.
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
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.
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 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.
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 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
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.
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.
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.
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.
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 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 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
@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 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 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 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 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.
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 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.
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
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.
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 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.
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.
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.
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.
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
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.
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.
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
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!
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.
