Calculating Descriptive Statistics Using Excel

This video describes how to calculate descriptive statistics using Microsoft Excel.

Пікірлер: 153

  • @ashleymogle2700
    @ashleymogle27005 жыл бұрын

    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.

  • @chelseareeve36
    @chelseareeve365 жыл бұрын

    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.

  • @briannagoitiandia9833
    @briannagoitiandia98337 жыл бұрын

    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.

  • @reneemendez4287
    @reneemendez42879 жыл бұрын

    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.

  • @daniellemaldonado631
    @daniellemaldonado6319 жыл бұрын

    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.

  • @johnfruits3544
    @johnfruits35445 жыл бұрын

    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.

  • @jackiedeleonardis1153
    @jackiedeleonardis11535 жыл бұрын

    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.

  • @cherylchance904
    @cherylchance9047 жыл бұрын

    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.

  • @tyonnabrooks748
    @tyonnabrooks7486 жыл бұрын

    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.

  • @robertodonati1037
    @robertodonati10377 жыл бұрын

    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

  • @rhondabaileyyy
    @rhondabaileyyy6 жыл бұрын

    This video broke down data analysis and inputting into excel so easily. I love the step by step directions.

  • @scottmartin7764
    @scottmartin77648 жыл бұрын

    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

  • @cardinalgrad11
    @cardinalgrad118 жыл бұрын

    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!

  • @tamarabakergibbons5715
    @tamarabakergibbons57155 жыл бұрын

    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.

  • @ShoreMeetsFarm
    @ShoreMeetsFarm5 жыл бұрын

    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!

  • @wardellwhittaker859
    @wardellwhittaker8596 жыл бұрын

    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.

  • @chelseydavis4989
    @chelseydavis49899 жыл бұрын

    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!

  • @kassietrala378
    @kassietrala3785 жыл бұрын

    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.

  • @kristiewatunya2699
    @kristiewatunya26995 жыл бұрын

    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.

  • @deniseswindell2175
    @deniseswindell21755 жыл бұрын

    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.

  • @sarahburrous7374
    @sarahburrous73748 жыл бұрын

    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.

  • @clairejuszczak6748
    @clairejuszczak67488 жыл бұрын

    It has been several years since I have used excel for statistics, so this served as a wonderful reminder. Thanks for the informative video.

  • @alexandrajones3178
    @alexandrajones31788 жыл бұрын

    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

  • @meganblackwell8600
    @meganblackwell86009 жыл бұрын

    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!

  • @shekeyiabaker8060
    @shekeyiabaker80608 жыл бұрын

    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.

  • @veronicabetz9452
    @veronicabetz94526 жыл бұрын

    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.

  • @wandamixon5360

    @wandamixon5360

    6 жыл бұрын

    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.

  • @brittanyhoffman8068
    @brittanyhoffman80685 жыл бұрын

    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.

  • @johnharrisjr2808
    @johnharrisjr28086 жыл бұрын

    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

  • @amandavalentino8182
    @amandavalentino81825 жыл бұрын

    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.

  • @jasmiraross2802
    @jasmiraross28027 жыл бұрын

    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.

  • @mirandat1087
    @mirandat10878 жыл бұрын

    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.

  • @RyanPclifton
    @RyanPclifton5 жыл бұрын

    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.

  • @laurynmoffa
    @laurynmoffa5 жыл бұрын

    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.

  • @lizconnor1820
    @lizconnor18207 жыл бұрын

    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.

  • @brandiependergast5865
    @brandiependergast58656 жыл бұрын

    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.

  • @thecorgisquad9861
    @thecorgisquad98619 жыл бұрын

    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.

  • @michellerobinson968

    @michellerobinson968

    9 жыл бұрын

    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.

  • @simonehenry469
    @simonehenry4699 жыл бұрын

    calculations can get tricky, but this video did a great job illustrating how it is done

  • @angelinastanton7996
    @angelinastanton79966 жыл бұрын

    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.

  • @rebeccafalter2206

    @rebeccafalter2206

    6 жыл бұрын

    I agree. I think all of the further explanations and comparisons are so important in understanding the results of the data.

  • @wardellwhittaker859

    @wardellwhittaker859

    6 жыл бұрын

    I agree. Definitely one of my favorite videos that I will reference often.

  • @cassieperoulis4881
    @cassieperoulis48818 жыл бұрын

    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.

  • @elyshamason4018
    @elyshamason40185 жыл бұрын

    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.

  • @johnchristinadarwin8477
    @johnchristinadarwin84775 жыл бұрын

    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.

  • @RiversideUSA
    @RiversideUSA5 жыл бұрын

    Thank you sir. My very first time to learn how to do stat in Excess. Easy to follow for beginners.

  • @cassiemclaughlin9489
    @cassiemclaughlin94898 жыл бұрын

    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.

  • @corinne7324

    @corinne7324

    7 жыл бұрын

    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.

  • @rebeccafalter2206
    @rebeccafalter22066 жыл бұрын

    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.

  • @lllschreiber
    @lllschreiber8 жыл бұрын

    I look forward to referencing this video when I am working on this in my research. It makes it sound very clear.

  • @brittanyvodzak9198
    @brittanyvodzak91989 жыл бұрын

    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!

  • @rachelfoster5463

    @rachelfoster5463

    9 жыл бұрын

    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.

  • @brittbell15
    @brittbell158 жыл бұрын

    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!

  • @angiegrimes7265

    @angiegrimes7265

    8 жыл бұрын

    I too found this video pretty easy to follow. Comparing the two data was informative and I can see how it could be useful

  • @toniettemorda9077
    @toniettemorda90779 жыл бұрын

    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

  • @stevieporter3399
    @stevieporter33998 жыл бұрын

    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.

  • @katiependergast4145
    @katiependergast41458 жыл бұрын

    Will definitely use this video as a reference when I need to use Excel to calculate descriptive statistics in counseling research.

  • @wandamixon5360
    @wandamixon53606 жыл бұрын

    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.

  • @MichaelSmith-jd5ki
    @MichaelSmith-jd5ki9 жыл бұрын

    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.

  • @suzgen7323
    @suzgen73236 жыл бұрын

    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.

  • @jillbeck6917
    @jillbeck69176 жыл бұрын

    A very instructive, step by step video that I am sure I will be referencing.

  • @nakeshatucker6844
    @nakeshatucker68448 жыл бұрын

    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.

  • @kimberlydixon8760
    @kimberlydixon87609 жыл бұрын

    I thought this video really helped me to understand the table and provided easy step by step instructions.

  • @kiaracb06
    @kiaracb065 жыл бұрын

    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

  • @ashleydorsey6745
    @ashleydorsey67459 жыл бұрын

    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.

  • @JoeDirt-el2fr
    @JoeDirt-el2fr6 жыл бұрын

    This was a thorough explanation, I have a better understanding of stats and also how to use excel

  • @melissaclendaniel9811
    @melissaclendaniel98119 жыл бұрын

    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.

  • @rhondabaileyyy

    @rhondabaileyyy

    6 жыл бұрын

    I agree that the strategies used in this video could save time.

  • @jazzynovy5400
    @jazzynovy54009 жыл бұрын

    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.

  • @CandyKaneLane
    @CandyKaneLane9 жыл бұрын

    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.

  • @jacklinskibicki6098

    @jacklinskibicki6098

    9 жыл бұрын

    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!

  • @toniettemorda9077

    @toniettemorda9077

    9 жыл бұрын

    Candace Fernandez Yes! I liked the kurtosis and skewness data since that is new to me as well.

  • @sherrietilghman2745

    @sherrietilghman2745

    9 жыл бұрын

    I understand I am not very familiar with excel either, but step by step instructions do it for me too.

  • @jazzynovy5400

    @jazzynovy5400

    9 жыл бұрын

    Candace Fernandez Skewness and kurtosis were new terms to me. It was interesting to see and better understand them in the video.

  • @remigiusdemby7433

    @remigiusdemby7433

    7 жыл бұрын

    Candice, I find myself in a similar situation but this instruction has contributed to my gradual understanding of how to go about the calculation.

  • @aliciazahn1718
    @aliciazahn17189 жыл бұрын

    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.

  • @jpincinjr

    @jpincinjr

    9 жыл бұрын

    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

  • @katherinebeck593

    @katherinebeck593

    9 жыл бұрын

    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.

  • @amandachaffin6636
    @amandachaffin66368 жыл бұрын

    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.

  • @desireeyoung9203

    @desireeyoung9203

    8 жыл бұрын

    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.

  • @alainavangelder5327
    @alainavangelder53279 жыл бұрын

    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.

  • @rebeccameece013
    @rebeccameece0139 жыл бұрын

    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.

  • @meganblackwell8600

    @meganblackwell8600

    9 жыл бұрын

    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!

  • @joseliz8762
    @joseliz87625 жыл бұрын

    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

  • @michalmak176
    @michalmak1768 жыл бұрын

    Thank you. Your video was very helpful.

  • @kimberlykelly386
    @kimberlykelly3869 жыл бұрын

    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!

  • @kimberlykelly386

    @kimberlykelly386

    9 жыл бұрын

    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."

  • @jpincinjr
    @jpincinjr9 жыл бұрын

    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.

  • @ashleydorsey6745

    @ashleydorsey6745

    9 жыл бұрын

    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.

  • @caseybraaksma6251
    @caseybraaksma62518 жыл бұрын

    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.

  • @jhoward1129
    @jhoward11299 жыл бұрын

    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.

  • @lachapara1978
    @lachapara19788 жыл бұрын

    You just saved me from failing my statistics class....Thank you so very much!!!!

  • @dawnzink1747
    @dawnzink17478 жыл бұрын

    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.

  • @tommyfisher-klein8768

    @tommyfisher-klein8768

    8 жыл бұрын

    +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.

  • @tammywitzke6642
    @tammywitzke66428 жыл бұрын

    This video did a good job describing data analysis by using the step by step process. I found it most helpfull.

  • @shekeyiabaker8060

    @shekeyiabaker8060

    8 жыл бұрын

    I agree Tammy the step by step process truly does help for describing data analysis.

  • @katherinebeck593
    @katherinebeck5939 жыл бұрын

    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.

  • @jacklinskibicki6098
    @jacklinskibicki60989 жыл бұрын

    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.

  • @mandabear52289

    @mandabear52289

    9 жыл бұрын

    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.

  • @reginaames3038

    @reginaames3038

    9 жыл бұрын

    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.

  • @carolkirby9558
    @carolkirby95588 жыл бұрын

    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.

  • @krystleclear14
    @krystleclear147 жыл бұрын

    I liked going through each statistic with an explanation.

  • @reginaames3038
    @reginaames30389 жыл бұрын

    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.

  • @aliciazahn1718

    @aliciazahn1718

    9 жыл бұрын

    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.

  • @ariadnaaguero-roman5525
    @ariadnaaguero-roman55259 жыл бұрын

    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.

  • @virginiamurrey9139
    @virginiamurrey91396 жыл бұрын

    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!

  • @suzgen7323

    @suzgen7323

    6 жыл бұрын

    Virginia - This video was detailed without being overwhelming. I agree that it is a great resource for review.

  • @angelinastanton7996

    @angelinastanton7996

    6 жыл бұрын

    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.

  • @thefunABK
    @thefunABK3 жыл бұрын

    Thank you Sir. It really helped.

  • @susanwilder7616
    @susanwilder76169 жыл бұрын

    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.

  • @reneemendez4287

    @reneemendez4287

    9 жыл бұрын

    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.

  • @monielled3562
    @monielled35627 жыл бұрын

    Thanks! This helped with my mid-term

  • @DrGrande

    @DrGrande

    7 жыл бұрын

    I'm glad you found the video useful. Thanks for watching.

  • @mandabear52289
    @mandabear522899 жыл бұрын

    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.

  • @kimberlykelly386

    @kimberlykelly386

    9 жыл бұрын

    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.

  • @brittanyvodzak9198

    @brittanyvodzak9198

    9 жыл бұрын

    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!

  • @E2M5I0L4Y

    @E2M5I0L4Y

    9 жыл бұрын

    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.

  • @Mjthfdj

    @Mjthfdj

    9 жыл бұрын

    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.

  • @evierod1732
    @evierod17324 жыл бұрын

    OMG, Perfect, thank you ever so much

  • @kar2194
    @kar21945 жыл бұрын

    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

  • @michellerobinson968
    @michellerobinson9689 жыл бұрын

    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.

  • @thecorgisquad9861

    @thecorgisquad9861

    9 жыл бұрын

    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.

  • @bethanyelstrom3566

    @bethanyelstrom3566

    9 жыл бұрын

    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.

  • @bethanyelstrom3566
    @bethanyelstrom35669 жыл бұрын

    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.

  • @susanwilder7616

    @susanwilder7616

    9 жыл бұрын

    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.

  • @daniellemaldonado631

    @daniellemaldonado631

    9 жыл бұрын

    Bethany Elstrom Excel appears to be user friendly and it makes it seem like calculating statistics is easy.

  • @jpincinjr
    @jpincinjr9 жыл бұрын

    Todd Grande How do we know if we should be using sample or population data for these calculations?

  • @MyDonh
    @MyDonh8 жыл бұрын

    i concur Brit. It was easier to understand the whole process with the step by step instructions.

  • @tyonnabrooks748

    @tyonnabrooks748

    6 жыл бұрын

    I agree that processing is quicker, when learning step-by-step.

  • @JoeDirt-el2fr

    @JoeDirt-el2fr

    6 жыл бұрын

    don wilson agreed the thorough explanation was very helpful

  • @remigiusdemby7433
    @remigiusdemby74337 жыл бұрын

    I am not quite familiar with this type calculation using excel, however this video is very helpful for people like me.

  • @sherrietilghman2745
    @sherrietilghman27459 жыл бұрын

    Kurtosis was a term I never heard before, and how it is interpreted in correlation to the mean.

  • @ronaldrobertson6212
    @ronaldrobertson62123 жыл бұрын

    GREAT PRESENTATION

  • @MrsBobDylan
    @MrsBobDylan7 жыл бұрын

    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.

  • @monicaperry13

    @monicaperry13

    7 жыл бұрын

    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.

  • @amandagerrick5407

    @amandagerrick5407

    7 жыл бұрын

    I also agree, Jillian. This example was easier to comprehend in comparison to SPSS because I am more familiar with excel.

  • @karaannsullivan2363

    @karaannsullivan2363

    7 жыл бұрын

    I agree with you all, as well. I'm more comfortable and better acquainted with Excel. It make more sense to me.

  • @ninastreet4630

    @ninastreet4630

    7 жыл бұрын

    I also agree. By being more familiar with Excel it is easier to understand the information given.

  • @rachelfoster5463
    @rachelfoster54639 жыл бұрын

    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.

  • @jhoward1129

    @jhoward1129

    9 жыл бұрын

    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.

  • @melissaclendaniel9811

    @melissaclendaniel9811

    9 жыл бұрын

    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.

  • @alainavangelder5327

    @alainavangelder5327

    9 жыл бұрын

    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.

  • @rebeccameece013

    @rebeccameece013

    9 жыл бұрын

    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.

  • @ariadnaaguero-roman5525

    @ariadnaaguero-roman5525

    9 жыл бұрын

    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.

  • @danielleduboski9831
    @danielleduboski98319 жыл бұрын

    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.

  • @CandyKaneLane

    @CandyKaneLane

    9 жыл бұрын

    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!

  • @danielleduboski9831

    @danielleduboski9831

    9 жыл бұрын

    Candace they are helping but my brain still doesn't want to hear it! LOL but slowly getting better

  • @E2M5I0L4Y
    @E2M5I0L4Y9 жыл бұрын

    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.

  • @princessmehvish1415
    @princessmehvish14155 жыл бұрын

    how can I use this calculating descriptive statistics using excel on the questionnaire !??