The NORM.DIST and Related Functions in Excel
HTML-код
- Опубликовано: 19 июл 2015
- This video demonstrates how to use the NORM.DIST and related functions in Excel. The NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, and STANDARDIZE functions are explained.
I really appreciate all of the different functions of Excel. I do not think I would be comfortable doing this on my own but I'm glad I have the videos should I ever need them.
+Megan Blackwell I feel the same way. I believe that if I were to try this I would end up with incorrect information. I do appreciate the videos though should I ever attempt to do them
I liked the breakdown that this video gave. It makes things much simpler to grasp when they are broken down step by step.
+Rachel Foster I agree with you. It's easier to follow.
This is laid out very well and that did make it quite easy to follow.
Very thorough, not too difficult to follow, and cohesive. As a visual learner, I really liked the charted representation of the distribution, as well.
I really appreciated how Dr. Grande broke down all of the different functions in Excel. Watching him calculate each function from column to column made a lot more sense than just watching normal PowerPoint slides with definitions. The only thing I would have liked to see along with this Excel sheet is maybe one slide with the formulas written down so I could conceptualize the Excel data more.
I agree, this is like a step by step guide.
+Jessica Muzzin Great idea, Jessica. Having the formulas handy would help me to be better able to grasp the whole process and would be a great reference for future use.
I liked the examples in this video, it helped me better understand the concepts. Dr. Grande explained everything step by step which will help me in the future when using Excel.
I like the fact that many of these formulas and statistical analysis can be calculated in Excel with the ability to keep the statistics in an organized and easy to read document. The video was helpful to learn the differences between the functions with easy and concise step by step instructions.
Jasmine Aviles yes i do like that as well.
Very cool to see how you can find the normal the distribution and compare it to the GPA set! I actually enjoyed this video despite all the formulas!
I liked in this video how each function is explained. This is easier to follow when laid on in this way.
This video was easy to follow and understand the normal distribution of GPA's. The percentage of chance for normal random variable was interesting to learn. There were numerous steps and formulas that I will not remember.
I too thought that relasting it to something that we are familar with such as GPA was helpful to understand how this relates to a real world variable. There were a lot of steps that i wont remember as well. I guess something like this just takes practice to learn.
As a visual learning I found this break down very helpful.
I still don't understand what the probability mass function values represent. The ones under column E.
I had a harder time following this video, but it shows how excel makes calculating data really simple. I would need to watch this video (along with others) a few more times before attempting this on my own but these examples were really helpful.
I was nervous as first because I didn't know what NORM.DIST referred to, but I was happy to learn that it was normal distribution, which is a concept I understand. Again I appreciate coupling information I know about with new material to help me understand the new material better
I like the functions that excel has to offer and this video is helpful in understanding how to normal distribution is calculated.
Very helpful. All of these functions seem to come together in this to show findings of all the data.
This video was interesting. It was technical but I am familiar with Excel so I was able to follow along.
I like how organized the data collection is as well as your step by step instructions and demonstration. I am not very confident in the technical aspects of this, so I would struggle a bit trying this on my own.
+Candace Fernandez I agree! This would be difficult to do on my own. It was a helpful video, but I don't think I would grasp it until trying it myself.
The concept of GPA helped me relate as Dr. Grande manipulated the data in each column.
Interesting video, it gives me a good overview of the Norm Dist. and related functions in Excel. I'm afraid I would need a lot of applied practice to become proficient.
Nice to see how the normal distribution is calculated using excel, a bit technical for me but interesting non the less.
The norm.inv and norm.dist score explanation was helpful in understanding how to interpret the two together. The norm.inv calculation seemed redundant until he talked about wanting to go from a percentage to a score.
I could follow along with this video, but if I was ever going to preform this I would need more training. It was very technical, but it was also very explanatory.
Thanks Sir for excellent information
I am asking can I apply it for huge samples more than 200 samples.
and how can I find uncertanity or interval confedence at 95%
regards
Excel is a very intuitive program which I have used for a number of things, this would take some practice to get accustom to the functions and the language/prompts.
I agree, it would take quite some time and a lot of practice before I felt comfortable enough to do this.
Each of the functions in this video are explained and demonstrated well. However, I don't feel too confident operating excel or calculating this on my own yet. This would definitely require further practice.
I agree with some others that this video was very technical. Although, I did find it helpful I would need to watch it a few times and possibly have more training before attempting to do this.
Melissa, I agree that this video was complex and had multiple functions that would need to take additional time to fully get a grasp on how to perform this function effectively and proficiently. I think this video will be a good one to save for future references. It definitely will come in handy.
I completely agree with you Melissa, the video is very technical and helpful but I would need a lot more work before doing this.
Not being to familiar with Excel this was a bit technical for me. I would have to watch the video again a few times before I would be able to do this on my own. However, i could see how being able to do this would be helpful to really get a good look at the distrubution of a set of data.
+Mandy Moore Yes! a bit overwhelming but a great tool for sets of data.
+Mandy Moore I agree with you. Many of the concepts in this class will require me to see the videos a few times before I feel comfortable doing it on my own.
+Mandy Moore I agree, this was a little confusing for me as well, but I think after reviewing the videos a few times and trying it out step by step on our own, we could grasp the concept.
Like I have said these videos are very helpful in grasping a better understanding of how to get the scores, but until I can actually do it, it really is falling on deaf ears. However, it will be helpful in understanding the information needed for class and quizzes.
There was a lot of formulas in this discussion. It would be nice to have a cheat sheet for these examples. I tried writing them all down, but I am not sure I will recall what each formula is for after watching this video. Each section builds off each other which gets to be confusing.
+Bethany Elstrom A cheat sheet for the formulas would be helpful.
+Bethany Elstrom I agree with you and Michelle; a cheat sheet would be excellent. I've said before, I couldn't do any of this over again without following the video.
l have a better understanding of the different functions.
Excel has some very useful functions for findings areas under the normal distribution. However, using excel is hard for me and any other program like it is hard
+sherrie tilghman I also struggle with excel, but these videos make it really easy to follow.
The concept of GPA helped me relate as Dr. Grande manipulated the data in each column.
+Kimberly Kelly I agree. Seeing examples are very helpful.