This video serves as a great resource and "how to" for calculating mean, median, mode, variance, and standard deviation in Excel. I have a good feeling this demonstration will come in handy as we move forward and examine/conduct more research.
Thank you for sharing this video Dr. Grande. I found this video to be very helpful in quickly calculating mean, median, mode, variance, & standard deviation. This will make it easier rather than trying to calculate all the data on my own.
My thoughts exactly, using excel will make calculating information a million times easier and so much quicker too! Technology. I do wish he got into the set up in general though, like how he set up the chart he is filling out.
This video was a good refresher on how to calculate basic statistical functions using excel. I was able to recall the definitions of the functions relatively quickly and follow along with ease.
I have never seen the mean, median and mode explained in this manner before. This makes calculating a lot easier! The mean is the usual average, while the median is the middle value. The mode is the number that is repeated. The variance is how far a set of numbers are spread and the standard deviation is measure of dispersion in data set.
The video was helpful to refresh my understanding of how to quickly calculate data (mean, median, mode, SD, Variance). I really enjoyed learning of the relationship between the standard deviation (SD) and the variance. It was interesting to learn that the SD is the square root of the variance and that the variance is the square of the SD.
I always enjoy when functions and number flow together in ways that my brain can track and understand. The relationship amongst the standard deviation and variance helps me to comprehend its purpose and function.
I am beyond technologically illiterate, so your videos regarding calculating in excel will be particularly useful tools for me moving forward in this semester. I believe based off of my readings in the textbook that the principle of central tendency can best be illustrated using a bell curve. I find this helpful because I am more of a visual learner.
This makes finding the mean, median, mode, variance, and standard deviation much easier with large data and the explanation of the variance and standard deviation was a nice refresher.
This was a great refresher video on the basics of measures of central tendency. I appreciate that you don't overlook things that could be seen as 'easy.' Very straightforward and I was able to follow along very well!
Math and technology are two things that have always confused me the most. So when I look at statistics I am immedietly intimidated. I really found this video helpful, and I will without a doubt be rewatching it so that I can start putting this to use and become familiar with the concepts.
This was a very informative video and provided a brief yet thorough explanation of the definitions of and how to calculate central tendency. It was a good reminder of how to calculate data.
This video was very easy to follow and provided a great way to calculate these measures. This will be a great resource for me to look back on in the very near future. Thank you.
While I've had experience calculating the mean, median, and mode, I have not done so in Excel and this video was extremely helpful and straightforward in demonstrating the process. I barely remember the variance and standard deviation calculations so this served as a good reminder.
I too had forgotten that the variance and standard deviation where so closely realted. This video was a good refresher of how these measures of central tendency are calualated. It also served as a learning tool on how to calculate them using Excel.
Jacklin Skibicki Agreed! Even though I don't fully understand what "variance" is, at least I know how to calculate it! SD is square root of variance (therefore, variance is the square of SD).
Thanks for this description of central tendency! I always forget how to create a function in Excel. EXCEL 101, I know! But thank you for showing the more statistical functions of Excel. Greatly appreciated and always a good video to go back on should I forget how to calculate central tendency using Excel.
This video was great in helping find measures that are always important when collecting data. The steps and video will be a good resource to use in the future.
The last time I took statistics was over 10 years ago and everything had to be done with a calculator. It's amazing to see all of the things Excel can do!
I chose this video because the measures of central tendency were familiar to me and learning to use excel for these concepts would help me focus on learning excel as opposed to understanding both excel and a new type of statistic. That being said, this video made the process in excel very easy to understand.
This was a very helpful review of mean, median, and mode. The video was easy to follow along with in order to learn how to calculate measures of central tendency using Excel.
I enjoyed learning how to use formulas in Excel to help us understand the mean, median, mode, variance, and standard deviation. This is especially helpful when your someone who struggles with math.
I am familiar with the measures of central tendency, but like others in the comments, I had used a calculator in my past to determine the values. Using Excel and having Excel perform the calculations for you, does make it that much easier or as one of my former instructors would say, "smarter instead of harder."
This video was very helpful as it refreshes my mind of the different central tendency. I liked this video because I understood what you were talking about and learned a few extra things
This was a really helpful little video. I always confuse mode and median for some reason, but this helped me to keep them straight; mode is the most repeated number in the data set, while median is the average between the two middle-most numbers in the data set. In terms of standard deviation and variance, this was informative because I had forgotten exactly how the two were related. Variance is the square of the standard deviation, and SD tells us the difference between the scores and the average or mean score.
Jessica Muzzin Jess, this "little" video was helpful. By having the terms explained so easily helped me follow along and better understand the results.
Thank you Dr. Grande! This video was very informative and was easy to follow. This will be an excellent tool to use when collecting large amounts of data.
This video was a nice refresher of mean, median, mode, and Standard Deviation. I have not had much experience with variance however. The video made the calculations look fairly easy when using an Excel spreadsheet for data sets during social research. I also was not aware that the Standard Deviation is the square root of the Variance.
Melissa Clendaniel Variance was a new concept for me as well. I remember mean, median, and mode from high school, and standard deviation from college, but I don't remember going over variance. It was also nice to know how to calculate those in Excel and not pen and paper.
This information is an added ingredient to my knowledge bank and makes is it quite feasible to make these calculations with relative ease. Thanks Dr. Grande for the video.
Thank you for the video! I can see myself using this function at my job as we use a lot of standardized tests to measure the performance of the clients.
This video was extremely helpful in understanding the mean, mode, and variance. Undergrad was the last time I utilized these concepts therefore a refresher was definitely welcomed. I appreciated the excel formatting used in the video. Using excel made the material much easier to digest. However, calculating the variance is a concept that I will need to work on further.
First of all, I was very happy to see terms that I am familiar with in this class. I do not remember much from my own math classes and retained very little information. Even more than seeing how to use Excel to simply calculate information I was glad that Dr. Grande explained how to use Excel in general. For example, when he explained that starting with "=" means to start a function. I had not known that before.
I am familiar with the terms mean, median, mode, variable, and standard deviation, but I did not know you could do all of those things on Excel. In undergrad, I used SPSS, so it was good to see how these things can be calculated in a different program. I, too, am mostly familiar with doing these things with pencil and paper, so shortcuts are definitely welcome! I appreciate that the video shows how to do it in the system, and then how the system arrived at the number.
I am not very familar with Excel so I found this video to be extremely helpful. I knew that Excel could find the mean and the standard deviation but I did not know that it could calulate the other measuares of central tendency. Good to know!
Mandy Moore Hey Mandy!!! Excel escapes me too! I totally feel your pain. I was unaware that Excel could be used to calculate these core research concepts. Definitely enlightening.
There is some different terminology to remember from this video, but it was nice to see how this was done in excel for when we have to do it. I like seeing how that standard deviation shows us the dispersion of the data easily on this program and overall seeing how to calculate the measures of central tendency was helpful.
Although it is not my formal job duty, I frequently use Excel to calculate mean, median, and mode for data analysis. It was incredible to learn an easier way to come to these calculations with the data.
Dr. Grande- thank you for the information on calculating measures of central tendencies is Excel. I have a hard time setting excel up and you were able to explain it exceptionally.
The measures of central tendency are familiar to me. This video was great because it showed a simple way of calculating measures of central tendency without the use of a calculator. I really enjoyed watching this video; it was very helpful.
Finally something that I am familiar with and have used in the past. The refresher on how to formulate the equations was great. By using Excel this process is made simple.
This video was definitely helpful and I plan on using this in the future with my research or in appraisal class. This video helps me better understand these measures and how to work with them in excel.
I use excel a lot primarily to do spread sheets. Have not used Excel for calculations, but it's a helpful tools to analyze data. This video was good review.
I'm not a "wiz" when it comes to math or statistics so it was interesting to see a tool that can figure out the numbers for me. Though I am familiar with excel, I have not yet applied it to finding mean, median, mode, etc. This video is helpful and I believe I will be putting to use in the future.
Dr. Grande's videos, and this video, help me distill complex concepts in meaningful and useful ways. I know there are general guidelines for cutoff scores when determining if an effect size is large, small, etc. But those scores, like any other calculation, don't have significant meaning until they are evaluated in the context of the overall study. It's just a number, it doesn't have significant meaning until you give it depth (with other knowledge).
This video made sense to me. It was pretty easy to follow along and to see exactly what Dr. Grande was discussing. I can see myself messing up some of the equations/functions you have to input to get the correct results.
Rachel Foster I agree with you. This video was simple and easy to follow. It was good to have this reminder of what each thing means, and instruction of how to get it in Excel.
Rachel Foster It was definitely very easy to follow along with. I could also see myself messing up some of the equations. haha. I'm happy to have an Excel spreadsheet because math certainly is not my strong area.
Rachel Foster Agreed. I followed this video and found the functions useful. Additionally, the equations were easy to remember - thank goodness for that. I know that sometimes Excel formulas are not so straight forward, so I was relieved and pleased to learn that these were.
Rachel Foster This was definitely an easy video to follow! I think Excel makes it easier to calculate mean, median, mode, variance, and sd as opposed to doing it by hand.
Rachel Foster I can also see myself messing up on the equations and functions we may have to input to get the correct results. Entering in the correct data sounds easy, but simple mistakes can be made. But, I think using the excel program as shown above may help to eliminate some of those errors we can make. I am also glad, as you said, that the video was easy to follow.
Thank you for the video Dr.Grande. You mentioned that the variance number is not that "interpretable" and the squared SD is equivalent to that number, so I wonder if it would is used as a tool for accuracy.
Although I have not used mean, median, or mode in excel before, only using paper and pencil, this video was a nice refresher on what they are and how to calculate each measure. I did not remember calculating the variance or even using it so it came in handy to learn about the variance and how to calculate it.
Candace Fernandez I agree, I had never done this in Excel so it was beneficial to see it demonstrated in video. I also don't recall much about calculating the variance so this was helpful!
Candace Fernandez Yes I agree! I am still confused on the variance and standard deviation but this video was super helpful explaining how one can calculate the measures
Candace Fernandez It was nice to have a refresher! I have always used paper and pencil when working on these calculations because I always got confused when working in Excel. It was nice to have it broken down in steps so it will be easier to use.
Danielle Duboski I think in terms of mathematics in research, calculating the mean, median, and mode along with the standard deviation are a lot easier than some of the other mathematical aspects that go along with it. I do think having it done in excel is a lot quicker and allows for much more accuracy and less error in calculations.
Danielle Duboski I found this video to be helpful too. Excel is a great tool to make math simplified. Great examples on how to get the mean, median, and mode. I had forgot which symbol goes between the number series so this was a quick reminder.
I knew that excel is based around using functions, but I thought that I had to create each one I wanted to use. It is nice to learn that there are many functions that are already programmed.
I never thought to break out cells and make a quick reference chart when calculating measures of central tendency. They are fairly easy to do so it is not hard to just pick a cell and get the calculation to use for a chart or to write into a document but labeled cells is a great idea for if the information is questioned, you can show your work. I do wonder what you mean, Dr. Grande, by saying the variance is not easy to interpet. I shall be bringing this question to class.
Yet another quick and easy (easier) calculation to perform with Excel. This method will reveal its importance as we practice assessment score calculations, I'm sure!
This video was definitely easy to follow and to understand! I can see us having to utilize excel in the future and having this knowledge will make inputting and interpreting the data more easily and accurately. This can help with saving time and figuring out multiple calculations of things such as the mean median and mode all at one time.
I found this video to be very helpful because I'm not very good in excel to start. I really liked how it showed how to calculate the variance because this is something I'm not very familiar with.
This video easily explained the terms mean, median, mode , variance and standard deviation. Ii was easy to follow and understand how excel calculates the results. If the variance is hard to interpret then I wonder why it is even calculated. The standard deviation is the square root of the variance and it is better interpreted.
Michelle Robinson I was also wondering why variances are calculated if they are so difficult to interpret. The standard deviation is more applicable and commonly used, so it would make much more sense to me to use SD and leave out the variance when reporting the data.
I had a light bulb moment when watching this video - the standard deviation is the average distance that any particular score is from the mean. That helps me to better understand what the SD is. I imagine I'll be looking back on my notes on this video to quickly reference formulas.
This is another video that I will utilize repeatedly. This is a very good explanation and it does not look that hard to compute, but I am confused with how the range is put into the formula. Was is Ctrl A and then pasted into the formula at the top? I'm going to need to see that part more in depth because it seems like that part is missing for me. I have never really utilized Excel for doing math and functions so that was a little confusing.
This was a very interesting video! I had no idea that you could calculate basic statistics in Excel. In undergrad, we always used SPSS or mostly did it by hand. Of course, that was a long time ago. I wish that I had known about these functionalities in Excel all those years ago.
I am familiar with the mean, median, mode variance and standard deviation from statics class were we had to calculate each of these using a calculator. However, I am not familiar with excel which seems like an easier way to do these calculation. I had forgotten a lot of this information and this video reacquainted with the terms.
Regina Ames The video refreshed me on many of the terms as well. Looking back, I wish I could have just used Excel in statistics class rather than doing everything by hand. It seems much simpler!
I always get so confused and frustrated wen trying to use excel. I found this video to be very helpful because it broke down the steps. I also never knew how to calculate variance so I found that to be helpful as well.
Brittany Vodzak, Excel is rather testy when it comes to statistics. I am more partial to it for spread sheets and chart creation. However, you're right, the videos Dr. Grande makes on Excel are very helpful. I imagine this will be useful to know and understand in the future considering the software is widely used whereas SPSS is not so widely used due to its cost.
This was good. Some of these videos I know I can use, but are often a bit over my head until I can actually put them into practice. This one makes total sense. Todd Grande when specifying which boxes we want to apply to the equation we're looking at (when you specified that you wanted the mean of A1-A30, for example), can we type in those numbers, or do we have to click and drag?
Great video! I thought it was interesting that the standard deviation is the square root of the variance and the variance is the square of the standard deviation
I am familiar with the mean, mode, median, and the standard deviation. One thing that I did not know is that the standard deviation is the square root of the variance. I thought that was pretty cool.
I also was not aware of the mathematical relationship between the Standard Deviation and the Variance. This may be because I have not had as much experience with variance as I have with Standard Deviation so learning that the Standard Deviation is the square root of the Variance was helpful for me.
This video serves as a great resource and "how to" for calculating mean, median, mode, variance, and standard deviation in Excel. I have a good feeling this demonstration will come in handy as we move forward and examine/conduct more research.
Thank you for sharing this video Dr. Grande. I found this video to be very helpful in quickly calculating mean, median, mode, variance, & standard deviation. This will make it easier rather than trying to calculate all the data on my own.
My thoughts exactly, using excel will make calculating information a million times easier and so much quicker too! Technology. I do wish he got into the set up in general though, like how he set up the chart he is filling out.
This video was a good refresher on how to calculate basic statistical functions using excel. I was able to recall the definitions of the functions relatively quickly and follow along with ease.
This was a good refresher of key terms. I appreciate how easy Excel makes the process of finding these numbers.
+Rachel Foster I agree Excel is a great program.
+Rachel Foster This was a good refresher video. I have difficultly understand this material so even videos I have seen before help
I have never seen the mean, median and mode explained in this manner before. This makes calculating a lot easier! The mean is the usual average, while the median is the middle value. The mode is the number that is repeated. The variance is how far a set of numbers are spread and the standard deviation is measure of dispersion in data set.
The video was helpful to refresh my understanding of how to quickly calculate data (mean, median, mode, SD, Variance). I really enjoyed learning of the relationship between the standard deviation (SD) and the variance. It was interesting to learn that the SD is the square root of the variance and that the variance is the square of the SD.
I always enjoy when functions and number flow together in ways that my brain can track and understand. The relationship amongst the standard deviation and variance helps me to comprehend its purpose and function.
I am beyond technologically illiterate, so your videos regarding calculating in excel will be particularly useful tools for me moving forward in this semester. I believe based off of my readings in the textbook that the principle of central tendency can best be illustrated using a bell curve. I find this helpful because I am more of a visual learner.
This makes finding the mean, median, mode, variance, and standard deviation much easier with large data and the explanation of the variance and standard deviation was a nice refresher.
This video was a good reminder of the measures of central tendency. Excel sure does make the calculation a snap.
This was a great refresher video on the basics of measures of central tendency. I appreciate that you don't overlook things that could be seen as 'easy.' Very straightforward and I was able to follow along very well!
Math and technology are two things that have always confused me the most. So when I look at statistics I am immedietly intimidated. I really found this video helpful, and I will without a doubt be rewatching it so that I can start putting this to use and become familiar with the concepts.
This was a very informative video and provided a brief yet thorough explanation of the definitions of and how to calculate central tendency. It was a good reminder of how to calculate data.
This video was very easy to follow and provided a great way to calculate these measures. This will be a great resource for me to look back on in the very near future. Thank you.
Brandie Pendergast I agree looking back on this in the future will be helpful in doing this for class!
While I've had experience calculating the mean, median, and mode, I have not done so in Excel and this video was extremely helpful and straightforward in demonstrating the process. I barely remember the variance and standard deviation calculations so this served as a good reminder.
I too had forgotten that the variance and standard deviation where so closely realted. This video was a good refresher of how these measures of central tendency are calualated. It also served as a learning tool on how to calculate them using Excel.
Jacklin Skibicki Agreed! Even though I don't fully understand what "variance" is, at least I know how to calculate it! SD is square root of variance (therefore, variance is the square of SD).
Thanks for this description of central tendency! I always forget how to create a function in Excel. EXCEL 101, I know! But thank you for showing the more statistical functions of Excel. Greatly appreciated and always a good video to go back on should I forget how to calculate central tendency using Excel.
This video was great in helping find measures that are always important when collecting data. The steps and video will be a good resource to use in the future.
I agree! I had no idea that these functions were even possible in excel. It will definitely be useful in the future courses!
The last time I took statistics was over 10 years ago and everything had to be done with a calculator. It's amazing to see all of the things Excel can do!
I chose this video because the measures of central tendency were familiar to me and learning to use excel for these concepts would help me focus on learning excel as opposed to understanding both excel and a new type of statistic. That being said, this video made the process in excel very easy to understand.
This was a very helpful review of mean, median, and mode. The video was easy to follow along with in order to learn how to calculate measures of central tendency using Excel.
this really refreshed my memory, much like most other people have already mentioned. It's helpful having this information explained thoroughly
Thank you for explaining how excel can be used to calculate the different measures. This video will be a good resource.
I really never knew all the statistical functions in Excel. This class has been very enlightening and I know I will refer back to these videos.
I enjoyed learning how to use formulas in Excel to help us understand the mean, median, mode, variance, and standard deviation. This is especially helpful when your someone who struggles with math.
This seems like a quick and easy way to compute these measures as well as the variance and standard deviation.
I am familiar with the measures of central tendency, but like others in the comments, I had used a calculator in my past to determine the values. Using Excel and having Excel perform the calculations for you, does make it that much easier or as one of my former instructors would say, "smarter instead of harder."
This video was very helpful as it refreshes my mind of the different central tendency. I liked this video because I understood what you were talking about and learned a few extra things
This was a really helpful little video. I always confuse mode and median for some reason, but this helped me to keep them straight; mode is the most repeated number in the data set, while median is the average between the two middle-most numbers in the data set. In terms of standard deviation and variance, this was informative because I had forgotten exactly how the two were related. Variance is the square of the standard deviation, and SD tells us the difference between the scores and the average or mean score.
Jessica Muzzin Jess, this "little" video was helpful. By having the terms explained so easily helped me follow along and better understand the results.
Thank you Dr. Grande! This video was very informative and was easy to follow. This will be an excellent tool to use when collecting large amounts of data.
I agree! I think this is clear, effective and easy to remember for future use!
This video was a nice refresher of mean, median, mode, and Standard Deviation. I have not had much experience with variance however. The video made the calculations look fairly easy when using an Excel spreadsheet for data sets during social research. I also was not aware that the Standard Deviation is the square root of the Variance.
Melissa Clendaniel Variance was a new concept for me as well. I remember mean, median, and mode from high school, and standard deviation from college, but I don't remember going over variance. It was also nice to know how to calculate those in Excel and not pen and paper.
This information is an added ingredient to my knowledge bank and makes is it quite feasible to make these calculations with relative ease. Thanks Dr. Grande for the video.
Thank you for the video! I can see myself using this function at my job as we use a lot of standardized tests to measure the performance of the clients.
This was a refresher for understanding mean, median, mode and variance and standard deviation.
+Michelle Robinson Yes, it was another refresher video. I was grateful to be reminded about variance and standard deviation.
This video was extremely helpful in understanding the mean, mode, and variance. Undergrad was the last time I utilized these concepts therefore a refresher was definitely welcomed. I appreciated the excel formatting used in the video. Using excel made the material much easier to digest. However, calculating the variance is a concept that I will need to work on further.
***** I completely agree that this video made the material much easier to take in and it was refresher!
***** yes i agree
This was a great refresher on standard deviation and variance. I used this in undergraduate studies very helpful!
I wish they offered this in undergrad for me. I definitely wouldn’t feel like I’m walking into some of this blind.
First of all, I was very happy to see terms that I am familiar with in this class. I do not remember much from my own math classes and retained very little information. Even more than seeing how to use Excel to simply calculate information I was glad that Dr. Grande explained how to use Excel in general. For example, when he explained that starting with "=" means to start a function. I had not known that before.
I am familiar with the terms mean, median, mode, variable, and standard deviation, but I did not know you could do all of those things on Excel. In undergrad, I used SPSS, so it was good to see how these things can be calculated in a different program. I, too, am mostly familiar with doing these things with pencil and paper, so shortcuts are definitely welcome! I appreciate that the video shows how to do it in the system, and then how the system arrived at the number.
I am truly amazed at the many ways Excel can be utilized. I would like to try this for myself.
I am not very familar with Excel so I found this video to be extremely helpful. I knew that Excel could find the mean and the standard deviation but I did not know that it could calulate the other measuares of central tendency. Good to know!
Mandy Moore Hey Mandy!!! Excel escapes me too! I totally feel your pain. I was unaware that Excel could be used to calculate these core research concepts. Definitely enlightening.
There is some different terminology to remember from this video, but it was nice to see how this was done in excel for when we have to do it. I like seeing how that standard deviation shows us the dispersion of the data easily on this program and overall seeing how to calculate the measures of central tendency was helpful.
This video helped me to refresh my skills. I liked how easy it was to follow.
Although it is not my formal job duty, I frequently use Excel to calculate mean, median, and mode for data analysis. It was incredible to learn an easier way to come to these calculations with the data.
Dr. Grande- thank you for the information on calculating measures of central tendencies is Excel. I have a hard time setting excel up and you were able to explain it exceptionally.
The measures of central tendency are familiar to me. This video was great because it showed a simple way of calculating measures of central tendency without the use of a calculator. I really enjoyed watching this video; it was very helpful.
I found this video to be helpful in refreshing my memory. I like that it appears so easy when you calculate it in Excel.
Finally something that I am familiar with and have used in the past. The refresher on how to formulate the equations was great. By using Excel this process is made simple.
Lol it does make it feel good when something is even marginally familiar
Bethany Elstrom I agree this was a great refresher!
This video was definitely helpful and I plan on using this in the future with my research or in appraisal class. This video helps me better understand these measures and how to work with them in excel.
I use excel a lot primarily to do spread sheets. Have not used Excel for calculations, but it's a helpful tools to analyze data. This video was good review.
I'm not a "wiz" when it comes to math or statistics so it was interesting to see a tool that can figure out the numbers for me. Though I am familiar with excel, I have not yet applied it to finding mean, median, mode, etc. This video is helpful and I believe I will be putting to use in the future.
Dr. Grande's videos, and this video, help me distill complex concepts in meaningful and useful ways. I know there are general guidelines for cutoff scores when determining if an effect size is large, small, etc. But those scores, like any other calculation, don't have significant meaning until they are evaluated in the context of the overall study. It's just a number, it doesn't have significant meaning until you give it depth (with other knowledge).
This video made sense to me. It was pretty easy to follow along and to see exactly what Dr. Grande was discussing. I can see myself messing up some of the equations/functions you have to input to get the correct results.
Rachel Foster I agree with you. This video was simple and easy to follow. It was good to have this reminder of what each thing means, and instruction of how to get it in Excel.
Rachel Foster It was definitely very easy to follow along with. I could also see myself messing up some of the equations. haha. I'm happy to have an Excel spreadsheet because math certainly is not my strong area.
Rachel Foster Agreed. I followed this video and found the functions useful. Additionally, the equations were easy to remember - thank goodness for that. I know that sometimes Excel formulas are not so straight forward, so I was relieved and pleased to learn that these were.
Rachel Foster This was definitely an easy video to follow! I think Excel makes it easier to calculate mean, median, mode, variance, and sd as opposed to doing it by hand.
Rachel Foster I can also see myself messing up on the equations and functions we may have to input to get the correct results. Entering in the correct data sounds easy, but simple mistakes can be made. But, I think using the excel program as shown above may help to eliminate some of those errors we can make. I am also glad, as you said, that the video was easy to follow.
Thank you for the video Dr.Grande. You mentioned that the variance number is not that "interpretable" and the squared SD is equivalent to that number, so I wonder if it would is used as a tool for accuracy.
Although I have not used mean, median, or mode in excel before, only using paper and pencil, this video was a nice refresher on what they are and how to calculate each measure. I did not remember calculating the variance or even using it so it came in handy to learn about the variance and how to calculate it.
Candace Fernandez I agree variance was the one I least remembered.
Candace Fernandez I agree, I had never done this in Excel so it was beneficial to see it demonstrated in video. I also don't recall much about calculating the variance so this was helpful!
Candace Fernandez Yes I agree! I am still confused on the variance and standard deviation but this video was super helpful explaining how one can calculate the measures
Candace Fernandez It was nice to have a refresher! I have always used paper
and pencil when working on these calculations because I always got confused
when working in Excel. It was nice to have it broken down in steps so it will
be easier to use.
Candace Fernandez I also had only ever found these measures using a pen and paper or calculator. It is good to see there are short cuts!
This was a good refresher for some more of the basic math used in research. I remembered most of it.
Danielle Duboski I think in terms of mathematics in research, calculating the mean, median, and mode along with the standard deviation are a lot easier than some of the other mathematical aspects that go along with it. I do think having it done in excel is a lot quicker and allows for much more accuracy and less error in calculations.
Danielle Duboski I found this video to be helpful too. Excel is a great tool to make math simplified. Great examples on how to get the mean, median, and mode. I had forgot which symbol goes between the number series so this was a quick reminder.
I knew that excel is based around using functions, but I thought that I had to create each one I wanted to use. It is nice to learn that there are many functions that are already programmed.
This video was very easy to follow along to in relation to understanding measurements of central tendency.
I agree, and I think this video is great for beginners learning to navigate calculations in Excel.
I never thought to break out cells and make a quick reference chart when calculating measures of central tendency. They are fairly easy to do so it is not hard to just pick a cell and get the calculation to use for a chart or to write into a document but labeled cells is a great idea for if the information is questioned, you can show your work. I do wonder what you mean, Dr. Grande, by saying the variance is not easy to interpet. I shall be bringing this question to class.
Dr. Grande, thanks for this instructional video. It has been a long time since I have used excel.
This video was easy to follow and very informative.
Yet another quick and easy (easier) calculation to perform with Excel. This method will reveal its importance as we practice assessment score calculations, I'm sure!
This video was definitely easy to follow and to understand! I can see us having to utilize excel in the future and having this knowledge will make inputting and interpreting the data more easily and accurately. This can help with saving time and figuring out multiple calculations of things such as the mean median and mode all at one time.
I too am used to having to use a calculator. It great to have video to learn how to make calculations using Excel
I found this video to be very helpful because I'm not very good in excel to start. I really liked how it showed how to calculate the variance because this is something I'm not very familiar with.
This is very useful information. Information that I knew, but a great refresher considering I haven't done this since high school.
I had basic statistic class almost 20 years ago and in Spanish, so reviewing these concepts and how to calculate them was extremely useful for me too!
Excel appears to be very helpful enabling us to make quick statistical calculations without having to use SPSS.
This video easily explained the terms mean, median, mode , variance and standard deviation. Ii was easy to follow and understand how excel calculates the results. If the variance is hard to interpret then I wonder why it is even calculated. The standard deviation is the square root of the variance and it is better interpreted.
Michelle Robinson I was also wondering why variances are calculated if they are so difficult to interpret. The standard deviation is more applicable and commonly used, so it would make much more sense to me to use SD and leave out the variance when reporting the data.
Michelle Robinson Good question about the variance, I was wondering the same thing.
Great video and very informative on how to use excel.
Interesting to show the relationship between the variance and standard deviation.
Yes Nina, that difference helps in making the required calculations.
I had a light bulb moment when watching this video - the standard deviation is the average distance that any particular score is from the mean. That helps me to better understand what the SD is. I imagine I'll be looking back on my notes on this video to quickly reference formulas.
interesting video, & easy to follow. I liked the explanation of the relationship between the standard deviation & the variance.
This is another video that I will utilize repeatedly. This is a very good explanation and it does not look that hard to compute, but I am confused with how the range is put into the formula. Was is Ctrl A and then pasted into the formula at the top? I'm going to need to see that part more in depth because it seems like that part is missing for me. I have never really utilized Excel for doing math and functions so that was a little confusing.
This was a very interesting video! I had no idea that you could calculate basic statistics in Excel. In undergrad, we always used SPSS or mostly did it by hand. Of course, that was a long time ago. I wish that I had known about these functionalities in Excel all those years ago.
Easy to follow and easy to understand.
I agree I like the simplistic instruction in this is video
Excel is awesome. It is so easy to manipulate things in excel because it's all pretty straight-froward.
Looks pretty straight forward. I'll be interested to see how to make tables and graphs and stuff.
Michael Smith I agree. I'm don't consider myself to be tech-savvy but I have found Excel to be easy to use.
I am familiar with the mean, median, mode variance and standard deviation from statics class were we had to calculate each of these using a calculator. However, I am not familiar with excel which seems like an easier way to do these calculation. I had forgotten a lot of this information and this video reacquainted with the terms.
Regina Ames The video refreshed me on many of the terms as well. Looking back, I wish I could have just used Excel in statistics class rather than doing everything by hand. It seems much simpler!
I always get so confused and frustrated wen trying to use excel. I found this video to be very helpful because it broke down the steps. I also never knew how to calculate variance so I found that to be helpful as well.
Brittany Vodzak, Excel is rather testy when it comes to statistics. I am more partial to it for spread sheets and chart creation. However, you're right, the videos Dr. Grande makes on Excel are very helpful. I imagine this will be useful to know and understand in the future considering the software is widely used whereas SPSS is not so widely used due to its cost.
great video. this excel video was very interesting to watch
This was good. Some of these videos I know I can use, but are often a bit over my head until I can actually put them into practice. This one makes total sense. Todd Grande when specifying which boxes we want to apply to the equation we're looking at (when you specified that you wanted the mean of A1-A30, for example), can we type in those numbers, or do we have to click and drag?
Jeff Pincin You can select the range by selecting the area with a mouse or by typing the range in the function.
I agree that this video was easy to follow and was easy to understand.
This video is good refresher.
Great video! I thought it was interesting that the standard deviation is the square root of the variance and the variance is the square of the standard deviation
He makes it look so easy...
Good refresher video.
I like this video, found it helpful.
Using excel to help calculate scores makes it seem like a piece of cake and makes having to use stats seem less scary.
Super helpful! thanks so much
I am familiar with the mean, mode, median, and the standard deviation. One thing that I did not know is that the standard deviation is the square root of the variance. I thought that was pretty cool.
I also was not aware of the mathematical relationship between the Standard Deviation and the Variance. This may be because I have not had as much experience with variance as I have with Standard Deviation so learning that the Standard Deviation is the square root of the Variance was helpful for me.
Going into appraisal, I am sure this will be useful.
Absolutely Rosa! Great to be reminded of all Excel can do, especially as we get ready to be in the field ourselves.
I understand the mean, mode, and median but I didn't know the standard deviation is the square root of the variance.
Thaanks!!!!
Excel is so helpful and the more I use it, the easier it seems to be. Some of the calculations I still need to work on.