Видео

There is no "best" number of bins, and different bin sizes can reveal different features of the data. Since this video was originally for 14 year old students, I just give some general "rules of thumb" that generally work well (the 1-4 items in the text box in the video) when picking bin number and width. This is where the "7" comes from, and work wells for simple data visualizations. Using wider bins in smaller datasets can reduce noise due to sampling randomness; using narrower bins in larger datasets can give you greater precision. At a higher level there are many approaches to calculating bin number and width. One of the most common for the number of bins is simply taking the square root of the number of data points and rounding up. If you want to read more I would suggest en.wikipedia.org/wiki/Histogram#Number_of_bins_and_width.

Yes, that's the problem with drawings sometimes. People make them and forget things. No call out on the fillet, and if you look at the shaded isometric view it has another fillet around the cylinder that is not present in the section view. Then in the video I accidentally leave out the fillet altogether. (Because I was trying to hurry and make the video before class started.) Humans are just mistake prone wetware I guess.

No. In a scatter plot, each data point represents the measured value across two attributes (or variables) at the same time. This is what students are often taught how to make in math classes with (x,y) data values. Dot plots are like histograms, they are useful for showing the distribution of a single scale variable. The data are binned, and all of the points in each bin are displayed and stacked. Dot plots are also sometimes called frequency dot plot, histodot plot, Wilkinson dot plot, or wheat plot depending on the country and age of your teacher.

OSU?

@@Zack-cb3jm Yep

Yes. I originally made this video for one of the classes I teach, so the advice was tailored specifically for them (14-15 years old). I didn't want them to get lost in the Freedman-Diaconis rule, and figured their statistics teacher in 4 years would cover. If I had known this would become my most popular video watched by adult learners, I would have done things a little differently.

Sorry, I'm sure your engineering teacher would be quite upset with me if I just gave you the code. Best of luck!

You should be able to use what you see in the video as a starting place for your design.

Data tab -> Analysis -> Data Analysis. I don't THINK that it is enabled by default so you may have to load the plug-in yourself first. That's more complicated but this link to Microsoft support article will help. You want the "Load and activate the analysis ToolPak" section. support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6

you type "repeat(out however many times you want to repeat the program in here)"