Box-ploty v MS Excelu a jejich možné využití ve výuce
Učitel matematiky, Tome 23 (2015) no. 4, pp. 206-214
A set of statistical data can be presented using various characteristics (mean, mode, median, quartiles, variance, etc.) and various graphical means, too. The paper analyzes the advantages and disadvantages of various tools and their suitability and possible use in teaching. Namely, it disscuses the meaning of box-plots and provides guidance on how to create these charts using MS Excel program tools.
A set of statistical data can be presented using various characteristics (mean, mode, median, quartiles, variance, etc.) and various graphical means, too. The paper analyzes the advantages and disadvantages of various tools and their suitability and possible use in teaching. Namely, it disscuses the meaning of box-plots and provides guidance on how to create these charts using MS Excel program tools.
@article{UM_2015_23_4_a1,
author = {Mo\v{s}na, Franti\v{s}ek},
title = {Box-ploty v {MS} {Excelu} a jejich mo\v{z}n\'e vyu\v{z}it{\'\i} ve v\'yuce},
journal = {U\v{c}itel matematiky},
pages = {206--214},
year = {2015},
volume = {23},
number = {4},
language = {cs},
url = {http://geodesic.mathdoc.fr/item/UM_2015_23_4_a1/}
}
Mošna, František. Box-ploty v MS Excelu a jejich možné využití ve výuce. Učitel matematiky, Tome 23 (2015) no. 4, pp. 206-214. http://geodesic.mathdoc.fr/item/UM_2015_23_4_a1/
[1] Cihlář, J.: Krabicový graf (box-and-whisker graf) a jeho využití pro analýzu dat. (2008). Excel Asistent Magazín, 5(1), 2-21. Dostupné z http://www.dataspectrum.cz/excelmag/download/eam0108.pdf
[2] Charamza, P., Hanousek, J.: Moderní metody zpracování dat: Matematická statistika pro každého. (1992). Praha: Grada.
[3] Robová, J.: Základy statistiky na grafickém kalkulátoru. (2004). Matematika-fyzika-informatika, 13(9), 555-563.
[4] Swoboda, H.: Moderní statistika. (1977). Praha: Svoboda.
[5] Tukey, J. W.: Exploratory data analysis. (1977). Reading: Addison-Wesley.