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
Cet article a éte moissonné depuis la source Czech Digital Mathematics Library
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.