Thanks a lot! My gf needed a very simple chart to show how her 12 years old students where doing on participation, most of them were really getting behind with the quarenteen.
glad the video was helpful. Parents are finding out or should be finding out what it's like for teachers and can't really expel them :-) All the best to you and your family stay safe, and stay home.
@@aniket54710 ah, this is strange. In the online version the series itself is simply an option in the properties pane (if you double click on the chart, on the right it shows something like 'Series 1', but it seems that fill patterns are not included in office 365 (see for example techcommunity.microsoft.com/t5/excel/format-cell-fill-pattern-style-not-displaying-online/m-p/3053800). Unfortunately I wouldn't know how to fix this then 😞
Probably a definition issue here. Do you have an example of what you would consider a dot-plot? I'm using the definition of 'The Concise Encyclopedia of Statistics' (Dodge, 2008), and to quote the Oxford Dictionary of Statistics: "an alternative to a bar chart or line graph when there are very few data values. Each value is recorded as a dot, so that the frequencies for each value can easily be counted" (p. 129). Perhaps you are looking for a scatterplot? That would fit with the APA Dictionary of Statistics and Research Methods where the dot plot entry is referred to the scatterplot entry. Or do you perhaps mean a Cleveland Dot-Plot which is sometimes, or perhaps the symmetric dot plot as referred to by Wilkinson (Dot Plots, The American Statistician, 1999, 53(3), 276-281). Or something else? Curious to know and learn :-)
@@stikpet A dot plot shows a continuous scale on the independent axis, along with dots/frequency on specific events. A bar chart will fill an entire discrete group on the independent axis. All you've done is add a bubble or dot effect to your bars.
Thanks for getting back on this. Just noticed that Wikipedia mentions indeed that a Dot Plot is used for a continuous scale on the independent axis and what I have done they call a Cleveland Dot Plot. However the Cleveland dot plot is actually a dot plot the way I draw it, but then only the top dot (Cleveland, Graphical Perception, 1978). So I am not sure what their source is that a dot-plot is only used for continuous scale, but it probably comes from somewhere. Also strange, that the Encyclopedia and Oxford dictionary I mentioned refer to a dot plot as an alternative for a bar-chart, and a bar-chart is used for discrete data. It appears there are two different interpretations/definitions on what a dot-plot is (actually three since the APA dictionary finds it the same as a scatterplot, but that seems very rare). So we are both right, depending on the definition used. I'll make a comment on this in the description. To make this work for a dot-plot in 'your' definition, would it work to first determine the width of the dots (which would then be the bin-sizes), then determine the frequency for each of those bins, draw the dot plot as shown in this video, and set the gap width to 0? Will need to look into this, and perhaps make another video on it in the future. Again, thanks for the feedback. Learned something new today :-) EDIT: added some info in the description and specified the title of the video with 'for discrete data'.
@@stikpet It's statistical theory. A dot-plot is a data distribution of a continuous random variable. If you are using bins, which a bar chart does, then it's not continuous. There's nothing more to say about it.
Indeed it is statistical theory. Again the Oxford Dictionary of Statistics defines a dot plot as: "an alternative to a bar chart or line graph when there are very few data values. Each value is recorded as a dot, so that the frequencies for each value can easily be counted" (p. 129). So it clearly mentions 'an alternative to a bar chart'. As you pointed out yourself a bar chart is not continuous, so then a dot plot couldn't be an alternative for a bar-chart. If you choose to uphold another definition than the Oxford Dictionary of Statistics, then indeed my video does not show a dot-plot, but I don't consider your definition as the only correct one.
Bruh this saved me I was stuggling with my assessment, subbed
Glad it helped. Thanks for the sub and good luck with your research/analysis.
Thanks a lot! My gf needed a very simple chart to show how her 12 years old students where doing on participation, most of them were really getting behind with the quarenteen.
glad the video was helpful. Parents are finding out or should be finding out what it's like for teachers and can't really expel them :-) All the best to you and your family stay safe, and stay home.
Thank you for helping my daughter with her 12th grade homework.
glad my video helped the younger generation as well :-)
super helpful for my grade 11 maths assignment. thanks!
Thank you so much you have no idea how much this helped thank you
Glad it helped!
thank you
your a smart man
Thx for the help
glad it helped.
Great trick!
thanks, glad it helped
Top!
I can see format series option in new version of excel
You probably meant 'can't see', but I just checked with Excel 2021 and should still work. What in the video is not showing exactly for you?
The option of format data series its not showing in office 365
@@aniket54710 ah, this is strange. In the online version the series itself is simply an option in the properties pane (if you double click on the chart, on the right it shows something like 'Series 1', but it seems that fill patterns are not included in office 365 (see for example techcommunity.microsoft.com/t5/excel/format-cell-fill-pattern-style-not-displaying-online/m-p/3053800). Unfortunately I wouldn't know how to fix this then 😞
Its but this helped me so thankss
1:57 thats purple not pink
oops, you're right. Not a big problem though I guess for the purpose of the video. Hope it the video still helped.
That's not a dot plot, it's a bar chart
Probably a definition issue here.
Do you have an example of what you would consider a dot-plot?
I'm using the definition of 'The Concise Encyclopedia of Statistics' (Dodge, 2008), and to quote the Oxford Dictionary of Statistics: "an alternative to a bar chart or line graph when there are very few data values. Each value is recorded as a dot, so that the frequencies for each value can easily be counted" (p. 129).
Perhaps you are looking for a scatterplot? That would fit with the APA Dictionary of Statistics and Research Methods where the dot plot entry is referred to the scatterplot entry. Or do you perhaps mean a Cleveland Dot-Plot which is sometimes, or perhaps the symmetric dot plot as referred to by Wilkinson (Dot Plots, The American Statistician, 1999, 53(3), 276-281).
Or something else? Curious to know and learn :-)
@@stikpet A dot plot shows a continuous scale on the independent axis, along with dots/frequency on specific events. A bar chart will fill an entire discrete group on the independent axis. All you've done is add a bubble or dot effect to your bars.
Thanks for getting back on this.
Just noticed that Wikipedia mentions indeed that a Dot Plot is used for a continuous scale on the independent axis and what I have done they call a Cleveland Dot Plot. However the Cleveland dot plot is actually a dot plot the way I draw it, but then only the top dot (Cleveland, Graphical Perception, 1978). So I am not sure what their source is that a dot-plot is only used for continuous scale, but it probably comes from somewhere.
Also strange, that the Encyclopedia and Oxford dictionary I mentioned refer to a dot plot as an alternative for a bar-chart, and a bar-chart is used for discrete data.
It appears there are two different interpretations/definitions on what a dot-plot is (actually three since the APA dictionary finds it the same as a scatterplot, but that seems very rare). So we are both right, depending on the definition used. I'll make a comment on this in the description.
To make this work for a dot-plot in 'your' definition, would it work to first determine the width of the dots (which would then be the bin-sizes), then determine the frequency for each of those bins, draw the dot plot as shown in this video, and set the gap width to 0? Will need to look into this, and perhaps make another video on it in the future.
Again, thanks for the feedback. Learned something new today :-)
EDIT: added some info in the description and specified the title of the video with 'for discrete data'.
@@stikpet It's statistical theory. A dot-plot is a data distribution of a continuous random variable. If you are using bins, which a bar chart does, then it's not continuous. There's nothing more to say about it.
Indeed it is statistical theory. Again the Oxford Dictionary of Statistics defines a dot plot as: "an alternative to a bar chart or line graph when there are very few data values. Each value is recorded as a dot, so that the frequencies for each value can easily be counted" (p. 129). So it clearly mentions 'an alternative to a bar chart'. As you pointed out yourself a bar chart is not continuous, so then a dot plot couldn't be an alternative for a bar-chart.
If you choose to uphold another definition than the Oxford Dictionary of Statistics, then indeed my video does not show a dot-plot, but I don't consider your definition as the only correct one.
I no subscribe cause bad
Dear Liem. What was 'bad' for you in the video, then I could try to improve it for next time.
@@stikpet Nah fam dont worry he just a hater it cool he fine your video is EPIC