Again, I appreciated the step-by-step instructions on how to utilize the excel programming. When I first took a data & statistics class I was extremely disheartened because math has never been my favorite. However, I can appreciate that although you still teach us how to do some of the calculations by hand, the real emphasis is on being able to take the data and interpret what it means.
Not having used Excel in quite a while, this video was highly informative and to-the-point in explaining how to obtain descriptive statistics. I also enjoyed learning how to calculate scores for more than one sample.
This video made organizing and creating descriptive statistics seem like the simplest thing in the world. Honestly, before this class I only used Excel for creating schedules or lists, but this was amazing. I am not very good at math and knowing there is a add-on for Excel to help calculate all that information in an instant. I am definitely saving this video for the future. I think till will end up being a life-saver.
This really makes it seem easy. I remember in undergrad having to do this and struggling with putting all the numbers together. With Dr. Grande explaining it and watching him compute it in Excel make sense to me. I am really liking Excel and what it is capable of doing.
I appreciate the knowledge of simply knowing how to set up the excel sheet. Often times if we don't see a tab right away (such as data analysis) we may be led to assume that one doesn't exist when in fact we were just not made aware of where to go to access it. This was very helpful in assisting us in setting up the page accurately.
This video helped me to understand how useful tool Excel can be when you know how to use it properly and do calculations. It was very clearly explained. Thank you so much Dr Grande
I have not run descriptive statistics since my undergraduate studies. I always find it interesting how having all of that information can create such a helpful visual of the data sample. This video, among the others will be great to have as a reference moving forward!
I appreciated the definitions provided for the group 1 table/list. Thank you for going into detail with what sample variance is and how to calculate a sample standard deviation. You explain things in a simple manner, which is great for effective learning.
I like how not only does this video show how to run the descriptive statistics altogether but I like how the video also explains how to find statistics on their own such as showing how to do the function for standard deviation.
Thanks Dr. Grande for explaining each descriptive stat. Excel seems very user friendly as well, just plug in exactly what you're looking for and it is calculated. In a previous stat class we had to calculate all of the scores by hand to show we understood and then we could use a program.
I like how this video breaks down each descriptive statistic. There is the quick way and there are other ways of calculating Standard Error and Standard Deviation. This seems much easier than SPSS, probably because I know excel much better. The terms were broken down. Much easier to understand and follow this video. Very helpful. Thank you.
This video was so helpful! I followed along with my own set of random numbers ("data") and found it not only helpful, but more memorable and kind of enjoyable. I will definitely be using these videos as reference tools!
Again, the videos you offer can be very helpful when needing to better understand Excel and the various ways it can be used from a statistical-research approach.
I found this video useful not only to explain how to use the data analysis set, but also as a review of what some of the terms mean. I have never heard (or don't remember) the term kurtosis. The explanation for each term was appreciated. The set seems like a great shortcut rather than calculating each one individually
I found it very interesting to have you get into standard error and the things that effect it. I also thought it was really nifty to have you explain how the standard error could be calculated without the use of excel.
The step by step instructions on how to calculate descriptive statistics using the data set in excel was helpful. It was very interesting to see how this can be used to calculate more than one data set at a time.
Creating the function in each cell is something that was confusing to me before, and I am glad you went over it. I definitely will have to refer back to this video in the future. I did not know how much excel could do!
This is very helpful when sorting qualitative data. Until this day I never utilized two different sheets in Excel so it was nice to see how it could be utilized.
Dr. Grande- Thank you for this information on how to use descriptive statistics in Excel. Excel is often hard to understand, this is a great tool to use and go back to when having to gather this data.
This video is straight forward and informative. I found it interesting that you have to divide the standard deviation by the square root of the sample size to figure out the standard error
This looks like a great supplemental resource to SPSS for statistical analysis. I've only done descriptive statistical analysis by hand before so this is a welcome resource for me. I love the step by step instructions and explanations for each statistic.
In comparison to the other videos, you showed us how you set up. I can also appreciate the definitions and functions that you incorporated while breaking down each row/category. The slowfulness in the tone of your voice is great for note taking.
This video was helpful in providing the steps one by one to follow. It also reminded me that I need to practice with excel much more so I can memorize these steps without having to refer back to a video such as this!
The explanations of each meaning based on the results of the scoring in this case was very helpful. Again, it helps me to begin to understand the research that I read and how to decipher the results that are published.
Thank you for the video Dr. Grande. This video is very beneficial for me in that I can see step by step instructions on how to calculate the descriptive statistics. This video makes calculating descriptive statistics a little less intimidating.
So I have to admit Dr. Grande you make this process seem simple especially for someone like myself who has struggled with excel and working statistics. Having a literal step by step use of where to go and what to click is very helpful.
This is a great resource for how to run descriptive statistics in excel. I was not aware of how to make the data analysis option appear up in the window panel at the top, so that was helpful as well. From what I remember from SPSS, picking which kind of statistical test you wanted, whether it be descriptive or correlational, or simply making a histogram of the data set you are working with is similar to the excel. I really like how the descriptive table listed all of the different variables (mean, median, sum, alpha, etc.) in such an orderly and neat fashion as well.
Jessica Muzzin Jess, this video is a good resource. I found it easy to follow and liked that the variables were listed. I liked that two groups were compared and I could see them side by side.
I felt this video was very informative. I also appreciate the way terms and definitions were explained throughout the video. This seems like it will be a very useful tool in my future with data calculations. Thank you.
This series of videos are very helpful. I haven't used Excel in years or used it to do this type of calculations, and this step-by-step process made it easy for me to comprehend.
Bonnie, I agree that this video is helpful. I recalled these terms, but not how to set-up the calculations. I can see how useful this is in research and counseling.
i found this video useful as a lot of the research I have read about in many of my courses have revolved around descriptive statistics in which there are not many variables. However, until this point, I was unsure of how to best calculate and compare these types of statistics. This video gives a detailed and descriptive look at how to do this quickly and I can see myself using these tools frequently in doing research of my own.
I find Excel to be more of a resource I would use rather than SPSS. This video makes the use of excel much easier to follow than anticipated. Such a beneficial means to calculate statistical information.
Dr. Grande, thank you very much for this informative video. This will help me immensely when I begin conducting the statistics for my research assignment! This information also helps me understand a few more statistics such as kurtosis and skewness.
It has been a long time since I have used excel for statistics, but this was a good review and I think I will be coming back to this video when I need to do something like this.
This was an interesting video. I have never heard of skewness and kurtosis in statistics before. It was nice to learn what that is all about when measuring a group in a research set. Excel has some many functions. Thanks for sharing this
I am very grateful for the step by step instructions on how to use excel in relation to statistics! I am very foreign to all of this and this video is of great assistance!
This video was definitely great and very helpful with learning how to not only compute descriptive statistics but also understand them. They explanation of the differences with standard error and standard deviation is always good to know so you can understand the results the best you can.
The more I expose myself to Excel, I feel like it will be helpful to calculate statistics. I look forward to one day, input actual data and see what happens. This video was very helpful.
I found this video to be so valuable and also one of my favorites. I like how this shows a quick way to calculate data in excel. I also loved that Dr. Grande explained all of the terms and definitions when going through each formula. I think this would be a great way to compare or contrast the experimental vs. control group's results of a study.
This video was informative. First, the way to set-up the analysis was explained. Next, the meaning of the descriptives, such as the standard error and kurtosis were explained. Finally, it is interesting to see how the difference in group 2 scores (visible in the descriptives) showed a normal distribution.
Similar to the pervious video I liked how Dr. Grande took the time to explain how to use Excel. I never knew you could use Excel for so many different calculations. I still definitely be using these videos as tools!
Brittany Vodzak I agree! For those of us who are not as familiar with Excel, it is great that Dr. Grande breaks it down and explains the basics for us.
I had no idea the capability Excel had in calculating statistics. I had only ever used Excel in my business courses in undergrad and understood that it was very resourceful, but was unaware that it could be used in counseling research. Excel is easily accessible and cost effective. After watching this video, I now understand a lot more about Excel and the way that I could use in my future endeavors. It will be an adjustment for me to use Excel because I am used to SPSS, but this video will make it easier.
Cassie, I too was surprised at how much you can do with excel. When I was in my undergrad I had to purchase SPSS for one of my Behavioral Science courses and If I would have known I could do all of this statistical work with excel I would have never purchased the SPSS. Excel is a great investment and very useful to have.
I appreciate the clear and concise layout of this video. The video was easy to follow and the excel spreadsheet seemed user friendly. Excel escapes me however I am gaining a better understanding of its purpose in relation to measurements in research. The names kurtosis was unfamiliar.
I have used excel for years in its basic form for spread sheets and graphing. I had no idea it did the statistics, great reference for the near future and career future.
+Dawn Zink I agree 100% with Dawn. I use excel all the time and for varying reason however I never had to run statistics for a project before. This video is going to be help not only for this class but in my professional life as well.
I recall doing this a long time ago in Research Methods 1. Despite not being a fan of Excel, I do like this little tool. It was great to get an overview of the stats generated in this video. I'm sure I'm not alone in saying many of these were not at the forefront of my memory. This is a great way to get all of the descriptive statistics and, even if you do not need them all, it is good to run all of these just in case something stands out.
Even though some of the information presented here went over my head, I was pleased that I did remember a portion from earlier statistics classes. I liked the tools in Excel used in this video to calculate a variety of statistics. The template used laid all of the calculations and results out for the user and could really save a lot of time. Additionally, I liked the mention of positive and negative skews as a mental refresher of the terms.
Again, I was unaware that all of these functions were available in Excel. This is great! Although I got a little caught up in the formulas, they were not too hard and I think that this will be very useful going forward. I will have to reference this video but still, it is very usable.
I love learning new things about Excel. It has great functionality. I'm glad to have this video, it's a great resource on how to do some great things with Excel.
It really is so cool how excel allows you to calculate data so quickly and be able to compare it between groups. I am interested in starting to use this to play around with some actual data to compare.
Amanda, this video made me want to start playing around with Excel as well. It is amazing how useful Excel can be in saving us time when doing calculations.
The guide for using the excel Data analysis wizard was helpful, simple to follow. The review of the output was the same. The additional explanation of Standard Error and Standard Deviation is clear to understand the difference that one is compared to the true population mean and the other is disbursement from the sample mean.
Hi, thank you for sharing the video. i find it helpful knowing that this type of information can be drawn using excel when compared to an expensive program like spss
It was interesting to learn how to calculate and group the statistics together in a nice concise and readable table. I am unfamiliar with this level of extensive calculations but this video was easy to follow and learn the steps.
This video showed a fast and easy way to calculate the descriptive statistics of not only one group, but two. It is so much easier than using a calculator. I was required to do so. It has been a long time since I took statistics. I am familiar with some of the terms, but the others I have never heard of. The video was very interesting to watch; I like how the process was communicated.
There are a lot of different steps to follow when calculating the descriptive statistics using excel and I found myself thinking that I would get confused with how many different steps and entries there are to follow. Seeing this video was nice because I now know how it needs to be done to do it correctly. I may have to refer back to this video when I need to do this on my own.
The step by step instructions are easy to follow, allowing us to understand how each part of this table works. I am unfamiliar with working with excel and calculating descriptive statistics, and this video made it easy for me to follow and comprehend. The different names such as skewness and kurtosis along with the definitions of what they look like helped me to better understand a table when looking at it.
Candace Fernandez Yes, I agree this video was somewhat easy to comprehend, especially for someone who is so unfamiliar with these concepts and calculations. I also thought that providing the definitions to some of the terms was extremely helpful in better understanding the video!
There's a lot more Excel can do than I ever thought. Those Kurtosis and Skewness things were new to me. Everything seems pretty useful, except for largest/smallest and minimum/maximum are the same thing... It's surprisingly easy to make Excel calculate these statistics.
Jeff Pincin Hey Jeff!!! I had no idea Excel performed these functions. Excel seems vital in calculating statistical data. I concur, kurtosis and skewness were unfamiliar terms. Great insight Jeff.
Great, easy-to-follow explanation of both how to use Excel to quickly calculate the descriptive statistics and what the statistics are showing. This is a lot to remember but, similar to the previous video, my notes on this will be helpful in the future I'm sure. Pretty straightforward explanation of the standard error, kurtosis, and skewness, too!
Kimberly Hanna Also should add that this is helping me understand what a normal distribution is, too. The closer the kurtosis and skewness numbers are to zero, the closer it is to a "normal distribution."
This video definitely gave me a better understanding of descriptive statistics, how to calculate and compare them, and what the terms mean. I am fairly unfamiliar with these calculations, and excel, yet found this video easy to follow.
I'm what I like to call Excel illterate so I was nervous about using it to calculate statistics but I found this video extremely easy to follow. I can now say with confidence that I could calculate these statistics in Excel.
The steps became clear in the side by side group analysis best for me. Again a refresh in terms but mostly great to see how quick data and results can be when they are put into excel. Like most tools it becomes easier and better to understand with practice but a visual guide works best for me. Still unsure about the convince level percentage?! I do like plugging numbers in and receiving somewhat error free results.
Very informative video, the one term I do not recall learning is kurtosis. I like the instructions on how to set up the table for your descriptive data analyses. I also like the information about sample size, as sample size increases standard error of mean deceases, which explains the importance of sample size.
Regina Ames I, too, found it helpful to go over the sample size and standard error and how they affect one another. It makes sense once you hear it but it is not something that just automatically comes to mind, no matter how many stats classes one has to take.
This video on calculating descriptive statistics using excel has been very helpful. It is very clear/ understandable and would very useful in research. This is a great tool and example!
I struggle greatly with statistics and numbers, but I did like this video. I will definitely save the video because it showed me how to use many formulas and understand important terms used in research.
Is this tool pack something that comes with every Excel? I wonder if it is something that you have to buy separately, or maybe it is just on newer years of Excel. Anyway, I like having step-by-step instructions. Being familiar with only basic usages of Excel myself, these new parts are a little bit beyond my scope of understanding. I like how it ends up looking once everything is put in. It is clear and concise. This all seems relatively straightforward and easy to find what you are looking for. I had also forgotten that mode is not the most useful statistic to use when the sample size is small. I like this video because it is more user friendly for people who do not already have a solid background in statistics.
I really enjoyed this video, well as much as one can enjoy statistics. I did not know that Excel at the Data Analysis tool. This video will definitely come in handy.
Susan Wilder My thoughts exactly. This was an excellent video showing the other capabilities Excel has to offer us. I did not know that Excel was capable of making anything other than lists.
I found this video to be very helpful! I was not even aware that Excel had the Descriptive Statitics pack. It was also a great reminder of how the mode is not a good statistic to use when you have a small sample size. I also wouldn't have thought to include the name when indicating the cells to use for the statistics.
Mandy Moore I agree, Mandy! This is all still pretty Greek to me but I can see how this tool pack could come in handy to quickly run a bunch of these statistics at once, rather than keying in each formula.
Mandy Moore I definitely did not know that Excel had all these different functions! I never really thought about how the mode would not be a good statistic to use when working with a small sample size so that is definitely good to know!
Mandy Moore I had forgotten that it is dangerous to use the mode with a small sample size, but seeing the two groups' results next to each other was a drastic reminder.
Brittany Vodzak I agree, I never considered the sample size in terms of calculating the mode. Dr. Grande hit on a good point. It's interesting to know that number can drastically change based on the size. Definitely something I will remember.
I, like Shekeyia, find Excel a bit more user friendly. Add to that, I already use a number of functions in Excel. But I am self taught, these additional functions and the very specific instruction within the program was enormously helpful. I am anxious to try some of these new features.
This video reminded me about the skew: If it's negative the tail is to the left and if it's negative the tail extends to the right. It would be helpful if a bell curve was shown to explain the skew.
This video makes calculating stats look so easy. I will use this as a resource because I will not remember how/what to change. It was good to know that the skewness as well as the kurtosis should be close to "0" in a standard normal distribution.
Michelle Robinson Excel makes it look so easy, but I was glad Dr. Grande showed how to create the function. It was easy to set this tool up on my ribbon and I could see this being beneficial in the future. I liked how two items can be compared to each other side by side.
I did not have this tool set up in Excel. I was able to add it easily. I found the output of information to be helpful. I like that Excel makes it fast and easy, but I also found it useful when you showed how to create the function in the data cells.
I think I like this more than the SPSS. I understand it a little more. The video was good at explaining step by step what to do and it was easy to understand.
I agree, Jillian. I think this is a little bit easier to understand than SPSS. The step by step instructions were definitely helpful, and I think it was helpful that Dr. Grande showed how to compare two groups.
Hi Dr, I found there are two ways of calculating 95% interval, and I have no idea which is the right one.. 1. Being what you have described, using mean +&- the Confidence Level, and you get the range between 45.449 - 54.11 2. Mine is using (2 * Standard deviation) +&- mean, and I get the range between 25.93 and 73.93 Using your data in group 1 at 9:09, Please help
Hey more math! If I ever need to do research for real I will hire someone. I get most of what is being said in these videos, but I'm not quite there. It is helpful to see how it compares everything. This video was easy to follow and would be fairly easy to use for my own applications however.
Danielle Duboski I agree, I am not a math fan at all and I tend to get a little confused, however the videos do a great job at breaking things down into a much more simple form that makes it easy to follow. I am able to see how such calculations can relate to research that we are doing ourselves. The videos make it slightly less scary to tackle that's for sure!
I think Excel is going to be our favorite tool this semester. It makes things easier and takes much less time than doing the calculations by hand. My only concern is knowing what to insert to create the correct "formula" or "equation" for the statistics.
Rachel Foster I wonder if we are actually going to be using Excel at all, or if we are just going to learn about it as if we are going to use it. I agree that is does make things easier if you can figure out/remember how to do it in Excel! I guess we would just come back to reference these videos.
I believe you may be right about that. The program does seem to make a lot of complex material easy to utilize quickly. However I know for myself, because I am not advanced on my knowledge of using Excel, I would need to use the tools described in the video for myself before I would be able to truly comprehend some of the concepts.
Rachel Foster Again, I couldn't agree more that Excel will become a favorite tool. It absolutely reduces the time and error of calculating formulas by hand. I also am concerned about remembering all of these formulas, however, at least I know I can reference these videos.
Rachel Foster I also think that Excel is a great tool to use and it makes doing calculations much easier than doing it by hand! I share that concern with you about knowing what to insert and doing it properly can pose a problem for me. If I make one mistake in computing the numbers it could throw the hole formula and equation off, so will need to be very aware.
I agree that excel can be very useful to calculate. Exactly i think that this would be useful for a person studying statistics, but formula is something that they would need to be aware of.
I learned standard error and standard deviation cannot be used interchangeably. If I understood correctly, standard error is the likelihood that something is to be from the mean, and standard deviation is how far something is dispersed from the mean.
Again, I appreciated the step-by-step instructions on how to utilize the excel programming. When I first took a data & statistics class I was extremely disheartened because math has never been my favorite. However, I can appreciate that although you still teach us how to do some of the calculations by hand, the real emphasis is on being able to take the data and interpret what it means.
Not having used Excel in quite a while, this video was highly informative and to-the-point in explaining how to obtain descriptive statistics. I also enjoyed learning how to calculate scores for more than one sample.
This video made organizing and creating descriptive statistics seem like the simplest thing in the world. Honestly, before this class I only used Excel for creating schedules or lists, but this was amazing. I am not very good at math and knowing there is a add-on for Excel to help calculate all that information in an instant. I am definitely saving this video for the future. I think till will end up being a life-saver.
This really makes it seem easy. I remember in undergrad having to do this and struggling with putting all the numbers together. With Dr. Grande explaining it and watching him compute it in Excel make sense to me. I am really liking Excel and what it is capable of doing.
I appreciate the knowledge of simply knowing how to set up the excel sheet. Often times if we don't see a tab right away (such as data analysis) we may be led to assume that one doesn't exist when in fact we were just not made aware of where to go to access it. This was very helpful in assisting us in setting up the page accurately.
This video helped me to understand how useful tool Excel can be when you know how to use it properly and do calculations. It was very clearly explained. Thank you so much Dr Grande
I have not run descriptive statistics since my undergraduate studies. I always find it interesting how having all of that information can create such a helpful visual of the data sample. This video, among the others will be great to have as a reference moving forward!
I appreciated the definitions provided for the group 1 table/list. Thank you for going into detail with what sample variance is and how to calculate a sample standard deviation. You explain things in a simple manner, which is great for effective learning.
I like how not only does this video show how to run the descriptive statistics altogether but I like how the video also explains how to find statistics on their own such as showing how to do the function for standard deviation.
Thanks Dr. Grande for explaining each descriptive stat. Excel seems very user friendly as well, just plug in exactly what you're looking for and it is calculated. In a previous stat class we had to calculate all of the scores by hand to show we understood and then we could use a program.
I like how this video breaks down each descriptive statistic. There is the quick way and there are other ways of calculating Standard Error and Standard Deviation. This seems much easier than SPSS, probably because I know excel much better. The terms were broken down. Much easier to understand and follow this video. Very helpful. Thank you.
I use Excel a lot, so knowing how to do descriptive statistics in the program and seeing how quickly it calculates everything is really great to know.
This video broke down data analysis and inputting into excel so easily. I love the step by step directions.
This video was so helpful! I followed along with my own set of random numbers ("data") and found it not only helpful, but more memorable and kind of enjoyable. I will definitely be using these videos as reference tools!
It has been several years since I have used excel for statistics, so this served as a wonderful reminder. Thanks for the informative video.
Again, the videos you offer can be very helpful when needing to better understand Excel and the various ways it can be used from a statistical-research approach.
I found this video useful not only to explain how to use the data analysis set, but also as a review of what some of the terms mean. I have never heard (or don't remember) the term kurtosis. The explanation for each term was appreciated. The set seems like a great shortcut rather than calculating each one individually
I found it very interesting to have you get into standard error and the things that effect it. I also thought it was really nifty to have you explain how the standard error could be calculated without the use of excel.
The step by step instructions on how to calculate descriptive statistics using the data set in excel was helpful. It was very interesting to see how this can be used to calculate more than one data set at a time.
Creating the function in each cell is something that was confusing to me before, and I am glad you went over it. I definitely will have to refer back to this video in the future. I did not know how much excel could do!
This is very helpful when sorting qualitative data. Until this day I never utilized two different sheets in Excel so it was nice to see how it could be utilized.
Dr. Grande- Thank you for this information on how to use descriptive statistics in Excel. Excel is often hard to understand, this is a great tool to use and go back to when having to gather this data.
This video is straight forward and informative. I found it interesting that you have to divide the standard deviation by the square root of the sample size to figure out the standard error
I knew that Excel could calculate formulas and I could do some basic stuff myself but this is so simple! The break down makes it easy to follow along.
This looks like a great supplemental resource to SPSS for statistical analysis. I've only done descriptive statistical analysis by hand before so this is a welcome resource for me. I love the step by step instructions and explanations for each statistic.
In comparison to the other videos, you showed us how you set up. I can also appreciate the definitions and functions that you incorporated while breaking down each row/category. The slowfulness in the tone of your voice is great for note taking.
This video was helpful in providing the steps one by one to follow. It also reminded me that I need to practice with excel much more so I can memorize these steps without having to refer back to a video such as this!
I am awful when it comes to Excel and the step by step descriptions make it so easy to follow!. Great video this was very helpful
The explanations of each meaning based on the results of the scoring in this case was very helpful. Again, it helps me to begin to understand the research that I read and how to decipher the results that are published.
Dr. Grande, thanks for showing us how to work between two separate sheets of data. I look forward to utilizing this reference in the future.
Will definitely use this video as a reference when I need to use Excel to calculate descriptive statistics in counseling research.
Thank you for the video Dr. Grande. This video is very beneficial for me in that I can see step by step instructions on how to calculate the descriptive statistics. This video makes calculating descriptive statistics a little less intimidating.
So I have to admit Dr. Grande you make this process seem simple especially for someone like myself who has struggled with excel and working statistics. Having a literal step by step use of where to go and what to click is very helpful.
This is a great resource for how to run descriptive statistics in excel. I was not aware of how to make the data analysis option appear up in the window panel at the top, so that was helpful as well. From what I remember from SPSS, picking which kind of statistical test you wanted, whether it be descriptive or correlational, or simply making a histogram of the data set you are working with is similar to the excel. I really like how the descriptive table listed all of the different variables (mean, median, sum, alpha, etc.) in such an orderly and neat fashion as well.
Jessica Muzzin Jess, this video is a good resource. I found it easy to follow and liked that the variables were listed. I liked that two groups were compared and I could see them side by side.
Thank you sir. My very first time to learn how to do stat in Excess. Easy to follow for beginners.
I felt this video was very informative. I also appreciate the way terms and definitions were explained throughout the video. This seems like it will be a very useful tool in my future with data calculations. Thank you.
This series of videos are very helpful. I haven't used Excel in years or used it to do this type of calculations, and this step-by-step process made it easy for me to comprehend.
Bonnie, I agree that this video is helpful. I recalled these terms, but not how to set-up the calculations. I can see how useful this is in research and counseling.
i found this video useful as a lot of the research I have read about in many of my courses have revolved around descriptive statistics in which there are not many variables. However, until this point, I was unsure of how to best calculate and compare these types of statistics. This video gives a detailed and descriptive look at how to do this quickly and I can see myself using these tools frequently in doing research of my own.
I find Excel to be more of a resource I would use rather than SPSS. This video makes the use of excel much easier to follow than anticipated. Such a beneficial means to calculate statistical information.
I look forward to referencing this video when I am working on this in my research. It makes it sound very clear.
Dr. Grande, thank you very much for this informative video. This will help me immensely when I begin conducting the statistics for my research assignment! This information also helps me understand a few more statistics such as kurtosis and skewness.
It has been a long time since I have used excel for statistics, but this was a good review and I think I will be coming back to this video when I need to do something like this.
This was an interesting video. I have never heard of skewness and kurtosis in statistics before. It was nice to learn what that is all about when measuring a group in a research set. Excel has some many functions. Thanks for sharing this
I am very grateful for the step by step instructions on how to use excel in relation to statistics! I am very foreign to all of this and this video is of great assistance!
I too found this video pretty easy to follow. Comparing the two data was informative and I can see how it could be useful
This video was definitely great and very helpful with learning how to not only compute descriptive statistics but also understand them. They explanation of the differences with standard error and standard deviation is always good to know so you can understand the results the best you can.
The more I expose myself to Excel, I feel like it will be helpful to calculate statistics. I look forward to one day, input actual data and see what happens. This video was very helpful.
calculations can get tricky, but this video did a great job illustrating how it is done
I found this video to be so valuable and also one of my favorites. I like how this shows a quick way to calculate data in excel. I also loved that Dr. Grande explained all of the terms and definitions when going through each formula. I think this would be a great way to compare or contrast the experimental vs. control group's results of a study.
I agree. I think all of the further explanations and comparisons are so important in understanding the results of the data.
I agree. Definitely one of my favorite videos that I will reference often.
This video was informative. First, the way to set-up the analysis was explained. Next, the meaning of the descriptives, such as the standard error and kurtosis were explained. Finally, it is interesting to see how the difference in group 2 scores (visible in the descriptives) showed a normal distribution.
Similar to the pervious video I liked how Dr. Grande took the time to explain how to use Excel. I never knew you could use Excel for so many different calculations. I still definitely be using these videos as tools!
Brittany Vodzak I agree! For those of us who are not as familiar with Excel, it is great that Dr. Grande breaks it down and explains the basics for us.
I had no idea the capability Excel had in calculating statistics. I had only ever used Excel in my business courses in undergrad and understood that it was very resourceful, but was unaware that it could be used in counseling research. Excel is easily accessible and cost effective. After watching this video, I now understand a lot more about Excel and the way that I could use in my future endeavors. It will be an adjustment for me to use Excel because I am used to SPSS, but this video will make it easier.
Cassie, I too was surprised at how much you can do with excel. When I was in my undergrad I had to purchase SPSS for one of my Behavioral Science courses and If I would have known I could do all of this statistical work with excel I would have never purchased the SPSS. Excel is a great investment and very useful to have.
I appreciate the clear and concise layout of this video. The video was easy to follow and the excel spreadsheet seemed user friendly. Excel escapes me however I am gaining a better understanding of its purpose in relation to measurements in research. The names kurtosis was unfamiliar.
I have used excel for years in its basic form for spread sheets and graphing. I had no idea it did the statistics, great reference for the near future and career future.
+Dawn Zink I agree 100% with Dawn. I use excel all the time and for varying reason however I never had to run statistics for a project before. This video is going to be help not only for this class but in my professional life as well.
A very instructive, step by step video that I am sure I will be referencing.
I recall doing this a long time ago in Research Methods 1. Despite not being a fan of Excel, I do like this little tool. It was great to get an overview of the stats generated in this video. I'm sure I'm not alone in saying many of these were not at the forefront of my memory. This is a great way to get all of the descriptive statistics and, even if you do not need them all, it is good to run all of these just in case something stands out.
Alicia Zahn These are good. I never had a research class, so hopefully these stay in my mind for a while. Although I'm sure they'll fade away lol
I agree! I only had an experimental psych class and that was not heavily based on the research itself more understanding of studies and the articles.
Even though some of the information presented here went over my head, I was pleased that I did remember a portion from earlier statistics classes. I liked the tools in Excel used in this video to calculate a variety of statistics. The template used laid all of the calculations and results out for the user and could really save a lot of time. Additionally, I liked the mention of positive and negative skews as a mental refresher of the terms.
I agree that the strategies used in this video could save time.
I am not the best at using excel so having this step by step information for collecting data is very resources to have as a reference
Again, I was unaware that all of these functions were available in Excel. This is great! Although I got a little caught up in the formulas, they were not too hard and I think that this will be very useful going forward. I will have to reference this video but still, it is very usable.
I thought this video really helped me to understand the table and provided easy step by step instructions.
I love learning new things about Excel. It has great functionality. I'm glad to have this video, it's a great resource on how to do some great things with Excel.
It really is so cool how excel allows you to calculate data so quickly and be able to compare it between groups. I am interested in starting to use this to play around with some actual data to compare.
Amanda, this video made me want to start playing around with Excel as well. It is amazing how useful Excel can be in saving us time when doing calculations.
The guide for using the excel Data analysis wizard was helpful, simple to follow. The review of the output was the same. The additional explanation of Standard Error and Standard Deviation is clear to understand the difference that one is compared to the true population mean and the other is disbursement from the sample mean.
This was a thorough explanation, I have a better understanding of stats and also how to use excel
Hi, thank you for sharing the video. i find it helpful knowing that this type of information can be drawn using excel when compared to an expensive program like spss
It was interesting to learn how to calculate and group the statistics together in a nice concise and readable table. I am unfamiliar with this level of extensive calculations but this video was easy to follow and learn the steps.
This video showed a fast and easy way to calculate the descriptive statistics of not only one group, but two. It is so much easier than using a calculator. I was required to do so. It has been a long time since I took statistics. I am familiar with some of the terms, but the others I have never heard of. The video was very interesting to watch; I like how the process was communicated.
There are a lot of different steps to follow when calculating the descriptive statistics using excel and I found myself thinking that I would get confused with how many different steps and entries there are to follow. Seeing this video was nice because I now know how it needs to be done to do it correctly. I may have to refer back to this video when I need to do this on my own.
Rebecca Meece I will have to refer back to this video as well, but it was very easy to follow along with and I'm glad we have it as a tool!
The step by step instructions are easy to follow, allowing us to understand how each part of this table works. I am unfamiliar with working with excel and calculating descriptive statistics, and this video made it easy for me to follow and comprehend. The different names such as skewness and kurtosis along with the definitions of what they look like helped me to better understand a table when looking at it.
Candace Fernandez Yes, I agree this video was somewhat easy to comprehend, especially for someone who is so unfamiliar with these concepts and calculations. I also thought that providing the definitions to some of the terms was extremely helpful in better understanding the video!
Candace Fernandez Yes! I liked the kurtosis and skewness data since that is new to me as well.
I understand I am not very familiar with excel either, but step by step instructions do it for me too.
Candace Fernandez Skewness and kurtosis were new terms to me. It was interesting to see and better understand them in the video.
Candice, I find myself in a similar situation but this instruction has contributed to my gradual understanding of how to go about the calculation.
Thank you. Your video was very helpful.
I liked going through each statistic with an explanation.
You just saved me from failing my statistics class....Thank you so very much!!!!
There's a lot more Excel can do than I ever thought. Those Kurtosis and Skewness things were new to me. Everything seems pretty useful, except for largest/smallest and minimum/maximum are the same thing... It's surprisingly easy to make Excel calculate these statistics.
Jeff Pincin Hey Jeff!!! I had no idea Excel performed these functions. Excel seems vital in calculating statistical data. I concur, kurtosis and skewness were unfamiliar terms. Great insight Jeff.
Great, easy-to-follow explanation of both how to use Excel to quickly calculate the descriptive statistics and what the statistics are showing. This is a lot to remember but, similar to the previous video, my notes on this will be helpful in the future I'm sure. Pretty straightforward explanation of the standard error, kurtosis, and skewness, too!
Kimberly Hanna Also should add that this is helping me understand what a normal distribution is, too. The closer the kurtosis and skewness numbers are to zero, the closer it is to a "normal distribution."
This video did a good job describing data analysis by using the step by step process. I found it most helpfull.
I agree Tammy the step by step process truly does help for describing data analysis.
This video definitely gave me a better understanding of descriptive statistics, how to calculate and compare them, and what the terms mean. I am fairly unfamiliar with these calculations, and excel, yet found this video easy to follow.
I'm what I like to call Excel illterate so I was nervous about using it to calculate statistics but I found this video extremely easy to follow. I can now say with confidence that I could calculate these statistics in Excel.
Mandy Moore Yes it was a great video however I would still need to have step by step instructions in order to do this on my own.
The steps became clear in the side by side group analysis best for me. Again a refresh in terms but mostly great to see how quick data and results can be when they are put into excel. Like most tools it becomes easier and better to understand with practice but a visual guide works best for me. Still unsure about the convince level percentage?! I do like plugging numbers in and receiving somewhat error free results.
Kurtosis is a concept that is completely new to me. Excel is a very powerful tool, I thought only spss performed some of these functions.
OMG, Perfect, thank you ever so much
Very informative video, the one term I do not recall learning is kurtosis. I like the instructions on how to set up the table for your descriptive data analyses. I also like the information about sample size, as sample size increases standard error of mean deceases, which explains the importance of sample size.
Regina Ames I, too, found it helpful to go over the sample size and standard error and how they affect one another. It makes sense once you hear it but it is not something that just automatically comes to mind, no matter how many stats classes one has to take.
This video on calculating descriptive statistics using excel has been very helpful. It is very clear/ understandable and would very useful in research. This is a great tool and example!
Virginia - This video was detailed without being overwhelming. I agree that it is a great resource for review.
I struggle greatly with statistics and numbers, but I did like this video. I will definitely save the video because it showed me how to use many formulas and understand important terms used in research.
Thanks! This helped with my mid-term
I'm glad you found the video useful. Thanks for watching.
Is this tool pack something that comes with every Excel? I wonder if it is something that you have to buy separately, or maybe it is just on newer years of Excel. Anyway, I like having step-by-step instructions. Being familiar with only basic usages of Excel myself, these new parts are a little bit beyond my scope of understanding. I like how it ends up looking once everything is put in. It is clear and concise. This all seems relatively straightforward and easy to find what you are looking for. I had also forgotten that mode is not the most useful statistic to use when the sample size is small. I like this video because it is more user friendly for people who do not already have a solid background in statistics.
I really enjoyed this video, well as much as one can enjoy statistics. I did not know that Excel at the Data Analysis tool. This video will definitely come in handy.
Susan Wilder My thoughts exactly. This was an excellent video showing the other capabilities Excel has to offer us. I did not know that Excel was capable of making anything other than lists.
I found this video to be very helpful! I was not even aware that Excel had the Descriptive Statitics pack. It was also a great reminder of how the mode is not a good statistic to use when you have a small sample size. I also wouldn't have thought to include the name when indicating the cells to use for the statistics.
Mandy Moore I agree, Mandy! This is all still pretty Greek to me but I can see how this tool pack could come in handy to quickly run a bunch of these statistics at once, rather than keying in each formula.
Mandy Moore I definitely did not know that Excel had all these different functions! I never really thought about how the mode would not be a good statistic to use when working with a small sample size so that is definitely good to know!
Mandy Moore I had forgotten that it is dangerous to use the mode with a small sample size, but seeing the two groups' results next to each other was a drastic reminder.
Brittany Vodzak I agree, I never considered the sample size in terms of calculating the mode. Dr. Grande hit on a good point. It's interesting to know that number can drastically change based on the size. Definitely something I will remember.
I, like Shekeyia, find Excel a bit more user friendly. Add to that, I already use a number of functions in Excel. But I am self taught, these additional functions and the very specific instruction within the program was enormously helpful. I am anxious to try some of these new features.
This video reminded me about the skew: If it's negative the tail is to the left and if it's negative the tail extends to the right. It would be helpful if a bell curve was shown to explain the skew.
Thank you Sir. It really helped.
This video makes calculating stats look so easy. I will use this as a resource because I will not remember how/what to change. It was good to know that the skewness as well as the kurtosis should be close to "0" in a standard normal distribution.
Michelle Robinson I'm glad he mentioned the bit about kurtosis and skewness as well; I had forgotten that those values should be close to zero.
Michelle Robinson Excel makes it look so easy, but I was glad Dr. Grande showed how to create the function. It was easy to set this tool up on my ribbon and I could see this being beneficial in the future. I liked how two items can be compared to each other side by side.
I am not quite familiar with this type calculation using excel, however this video is very helpful for people like me.
I did not have this tool set up in Excel. I was able to add it easily. I found the output of information to be helpful. I like that Excel makes it fast and easy, but I also found it useful when you showed how to create the function in the data cells.
Bethany Elstrom I also went into Excel and checked to see if it was enabled. Then I played around with it a little. It is a handy little tool.
Bethany Elstrom Excel appears to be user friendly and it makes it seem like calculating statistics is easy.
I think I like this more than the SPSS. I understand it a little more. The video was good at explaining step by step what to do and it was easy to understand.
I agree, Jillian. I think this is a little bit easier to understand than SPSS. The step by step instructions were definitely helpful, and I think it was helpful that Dr. Grande showed how to compare two groups.
I also agree, Jillian. This example was easier to comprehend in comparison to SPSS because I am more familiar with excel.
I agree with you all, as well. I'm more comfortable and better acquainted with Excel. It make more sense to me.
I also agree. By being more familiar with Excel it is easier to understand the information given.
i concur Brit. It was easier to understand the whole process with the step by step instructions.
I agree that processing is quicker, when learning step-by-step.
don wilson agreed the thorough explanation was very helpful
GREAT PRESENTATION
Kurtosis was a term I never heard before, and how it is interpreted in correlation to the mean.
Todd Grande How do we know if we should be using sample or population data for these calculations?
Hi Dr, I found there are two ways of calculating 95% interval, and I have no idea which is the right one..
1. Being what you have described, using mean +&- the Confidence Level, and you get the range between 45.449 - 54.11
2. Mine is using (2 * Standard deviation) +&- mean, and I get the range between 25.93 and 73.93
Using your data in group 1 at 9:09,
Please help
Hey more math! If I ever need to do research for real I will hire someone. I get most of what is being said in these videos, but I'm not quite there. It is helpful to see how it compares everything. This video was easy to follow and would be fairly easy to use for my own applications however.
Danielle Duboski I agree, I am not a math fan at all and I tend to get a little confused, however the videos do a great job at breaking things down into a much more simple form that makes it easy to follow. I am able to see how such calculations can relate to research that we are doing ourselves. The videos make it slightly less scary to tackle that's for sure!
Candace they are helping but my brain still doesn't want to hear it! LOL but slowly getting better
I think Excel is going to be our favorite tool this semester. It makes things easier and takes much less time than doing the calculations by hand. My only concern is knowing what to insert to create the correct "formula" or "equation" for the statistics.
Rachel Foster I wonder if we are actually going to be using Excel at all, or if we are just going to learn about it as if we are going to use it. I agree that is does make things easier if you can figure out/remember how to do it in Excel! I guess we would just come back to reference these videos.
I believe you may be right about that. The program does seem to make a lot of complex material easy to utilize quickly. However I know for myself, because I am not advanced on my knowledge of using Excel, I would need to use the tools described in the video for myself before I would be able to truly comprehend some of the concepts.
Rachel Foster Again, I couldn't agree more that Excel will become a favorite tool. It absolutely reduces the time and error of calculating formulas by hand. I also am concerned about remembering all of these formulas, however, at least I know I can reference these videos.
Rachel Foster I also think that Excel is a great tool to use and it makes doing calculations much easier than doing it by hand! I share that concern with you about knowing what to insert and doing it properly can pose a problem for me. If I make one mistake in computing the numbers it could throw the hole formula and equation off, so will need to be very aware.
I agree that excel can be very useful to calculate. Exactly i think that this would be useful for a person studying statistics, but formula is something that they would need to be aware of.
Thank you - think i have got it!!
I'm glad you found the video useful. Thanks for watching.
I learned standard error and standard deviation cannot be used interchangeably. If I understood correctly, standard error is the likelihood that something is to be from the mean, and standard deviation is how far something is dispersed from the mean.