Thanks sir for all your effort in making this video, it is more than what I hoped for. I have been working with excel this week as a mean for statistical calculations. MS excel served me well for that purpose. The idea of fitting a normal bell curve into a histogram is more out of my curiosity. I will follow the steps demonstrated for my experimentation with excel.
This is an easier/exact bell: Click any column, Right Click, Select Data, Add, Title: Normal, Select numbers under Frequency Cells next to chart made, Ok, Ok, Click any Orange Colum, Right Click, Change Chart Type, Click Normal button, Select Scatter w/ Smoot Lines under X Y (scatter) menu, check box next to cell you just changed only, OK, Click on Number made on right hand side of chart, Delete. end
so when i add the data of the normal distribution it just doesn't get added to the histogram. the red bars don't show up. Edit i figured it out. you used a column graph to make your histogram while i used the histogram. if you do histogram you can't add a second data set.
@@BurkeyAcademy Words cannot describe my pleasure and many thanks to you sir. Although, it's helpful I am using a pivot table for frequency distribution and I cannot do the same as you did. Sir may you give me a little of your time via zoom to describe my problem exactly ?! That would be helpful for my FYP.
Adding the Normal series didn't appear to do anything to the graph, it didn't add the additional columns. Is there something that needs to be done to add the data to the viewable portion of the graph?
Something a colleague did recently might have happened to you- she accidentally made the data for the normal series with values between 0 and 1, which was too small to be seen on the graph with the other data that had much larger values. This might be something to check.
This is an easier/exact bell: Click any column, Right Click, Select Data, Add, Title: Normal, Select numbers under Frequency Cells next to chart made, Ok, Ok, Click any Orange Colum, Right Click, Change Chart Type, Click Normal button, Select Scatter w/ Smoot Lines under X Y (scatter) menu, check box next to cell you just changed only, OK, Click on Number made on right hand side of chart, Delete. end
(I meant to say std. dev. is 34.13.) I saw the google sheet, but could you do a video? Am I right in the logic: Find the fraction of sigma, then find amount of data above that?
Why wouldn't you normalize the binned RNG'd observations by multiplying each frequency by 1000 / # meal price observations? Then you wouldn't need a secondary axis.
ps only reason I ask is that I'm following this guide and my Excel is telling me that "STDEV" is only accessible on earlier versions of Excel so I'm having to use "STDEV.S" instead!
This video is probably 4 years old, so no. I'll have to check it out. Re: changing the command for stdev, yes I have seen that... And it is ridiculous how Excel would change a command that has been the same for 25 years!
My favorite, all around statistical, graphing, and everything else package is R. It takes a little while to learn, but once yoy do, you can do ANYTHING. Plus, it is absolutely free. Here is an intro video about how you can start learning R within R itself: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6azsCcyJ-lM.html If you'd like me to make a video showing how to make a histogram and add a normal curve in R, let me know!
It isn't too difficult. Tell me more about what you'd like to see, and I can show you. But basically, you'd pretend you had say, 10,000 observations, and calculate how many you would expect there to be in different bins.
Let's say I want to fit 40 items to a normal curve, with a mean of 50, and std dev of 84.13 (I know it's a large std dev, so it will put some items below 0, and some above 100). I've already calculated it by hand, but I would like to double check with software.
This "software" (Excel) isn't going to do anything differently than you would do by hand. There are lots of ways to approach this theoretically. One would be to decide on some number of bins and calculate the expected number out of 40 in each bin. The other way that makes the most sense to me would be to calculate "order statistics". This means, if we were to select 40 values from this distribution a infinite number of times, on average, where would the smallest be? And the next smallest, etc. Let me know how you'd like to proceed, and I can try to help. Cheers!
What if you have 40 items, and want to find ten classes (deciles) of data? For instance, I was looking for number of items equal or over 60. I decided 60 is 10 more than 50, 1-sigma is 34.13 more, so 60 is .293-sigma, right? I got 15.32 items as the answer, but how do you do it with Excel?