Skip to main content
Erschienen in: Earth Science Informatics 1/2022

02.10.2021 | Software Article

GEOstats: an excel-based data analysis program applying basic principles of statistics for geological studies

verfasst von: Mesut Gündüz, Kürşad Asan

Erschienen in: Earth Science Informatics | Ausgabe 1/2022

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

Statistical evaluation of the data collected from field and laboratory is an important task in the earth sciences. The aim of a geological study is to reveal a scientific result from the earth, but the conclusions must be based on the analytical inferences, as in natural and engineering sciences. Therefore, the importance of data analysis increases depending on the improvement of technological methods in geology. The purpose of data analysis in geology is to examine the rate at which a feature changes within the population. The geological data may be lithological, textural (e.g. grain size and shape), structural (e.g. bedding, fault, foliation, jointing or lineation etc.) and chemical (e.g. major and trace elements, isotope ratios etc.) measurements of the rock, mineral, fossil, soil or water specimens. GEOstats is an excel-based data analysis program that provides graphical and numerical results, and data simulation/statistical modeling (e.g. simple regression analysis, box plot, Q–Q plot, XYZ plot, sample distribution and classification) of samples representing a population for geologists and other researchers as well. The program can perform both simple data analysis (e.g. basic statistical calculations) of numerical results and highly complex multivariate analysis such as cluster analysis, principal component analysis and common factor analysis . GEOstats is also able to carry out the error bars analysis by using relative standard deviation values for different confidence intervals.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Anhänge
Nur mit Berechtigung zugänglich
Literatur
Zurück zum Zitat Abt K (1987) Descriptive data analysis: a concept between confirmatory and exploratory data analysis. Methods Inf Med 26(02):77–88CrossRef Abt K (1987) Descriptive data analysis: a concept between confirmatory and exploratory data analysis. Methods Inf Med 26(02):77–88CrossRef
Zurück zum Zitat Aitchison J (1982) The statistical analysis of compositional data. J R Stat Soc B 44(2):139–177 Aitchison J (1982) The statistical analysis of compositional data. J R Stat Soc B 44(2):139–177
Zurück zum Zitat Aitchison J, Egozcue J (2005) Compositional data analysis: where are we and where should we be heading? Math Geol 37(7):829–850CrossRef Aitchison J, Egozcue J (2005) Compositional data analysis: where are we and where should we be heading? Math Geol 37(7):829–850CrossRef
Zurück zum Zitat Asan K (2020) Whole-rock elemental and Sr-Nd isotope geochemistry and petrogenesis of the Miocene Elmadağ Volcanic Complex, Central Anatolia (Ankara, Turkey). Geosciences 10(9):348CrossRef Asan K (2020) Whole-rock elemental and Sr-Nd isotope geochemistry and petrogenesis of the Miocene Elmadağ Volcanic Complex, Central Anatolia (Ankara, Turkey). Geosciences 10(9):348CrossRef
Zurück zum Zitat Behrens JT (1997) Principles and procedures of exploratory data analysis. Psychol Methods 2(2):131–160CrossRef Behrens JT (1997) Principles and procedures of exploratory data analysis. Psychol Methods 2(2):131–160CrossRef
Zurück zum Zitat Bernard K (2020) Epithermal clast coating inside the rock avalanche-debris flow deposits from Mount Meager Volcanic Complex, British Columbia (Canada). J Volcanol Geotherm Res 402:1–22CrossRef Bernard K (2020) Epithermal clast coating inside the rock avalanche-debris flow deposits from Mount Meager Volcanic Complex, British Columbia (Canada). J Volcanol Geotherm Res 402:1–22CrossRef
Zurück zum Zitat Bernard K, van Wyk de Vries B, Thouret J-C (2019) Fault textures in volcanic debris-avalanche deposits and transformations into lahars: the Pichu Pichu thrust lobes in south Peru compared to worldwide avalanche deposits. J Volcanol Geotherm Res 371:116–136CrossRef Bernard K, van Wyk de Vries B, Thouret J-C (2019) Fault textures in volcanic debris-avalanche deposits and transformations into lahars: the Pichu Pichu thrust lobes in south Peru compared to worldwide avalanche deposits. J Volcanol Geotherm Res 371:116–136CrossRef
Zurück zum Zitat Blott SJ, Pye K (2001) GRADISTAT: a grain size distribution and statistics package for the analysis of unconsolidated sediments. Earth Surf Process Landforms 26:1237–1248CrossRef Blott SJ, Pye K (2001) GRADISTAT: a grain size distribution and statistics package for the analysis of unconsolidated sediments. Earth Surf Process Landforms 26:1237–1248CrossRef
Zurück zum Zitat Chayes F (1960) On correlation between variables of constant sum. J Geophys Res 65(12):4185–4193CrossRef Chayes F (1960) On correlation between variables of constant sum. J Geophys Res 65(12):4185–4193CrossRef
Zurück zum Zitat Cortés JA (2009) On the Harker variation diagrams: a comment on “the statistical analysis of compositional data. where are we and where should we be heading?” by Aitchison and Egozcue (2005). Math Geosci 41:817–828CrossRef Cortés JA (2009) On the Harker variation diagrams: a comment on “the statistical analysis of compositional data. where are we and where should we be heading?” by Aitchison and Egozcue (2005). Math Geosci 41:817–828CrossRef
Zurück zum Zitat Cortés JA, Palma JL, Wilson M (2007) Deciphering magma mixing: the application of cluster analysis to the mineral chemistry of crystal populations. J Volcanol Geotherm Res 165:163–188CrossRef Cortés JA, Palma JL, Wilson M (2007) Deciphering magma mixing: the application of cluster analysis to the mineral chemistry of crystal populations. J Volcanol Geotherm Res 165:163–188CrossRef
Zurück zum Zitat Cox KG, Bell J, Pankhurst R (1979) The interpretation of Igneous Rocks. George Allen & Unwin, London, p 450CrossRef Cox KG, Bell J, Pankhurst R (1979) The interpretation of Igneous Rocks. George Allen & Unwin, London, p 450CrossRef
Zurück zum Zitat Folk RL, Ward WC (1957) Brazos River bar: a study in the significance of grain size parameters. J Sediment Petrol 27:3–27CrossRef Folk RL, Ward WC (1957) Brazos River bar: a study in the significance of grain size parameters. J Sediment Petrol 27:3–27CrossRef
Zurück zum Zitat Fowler AC, Scheu B (2016) A theoretical explanation of grain size distributions in explosive rock fragmentation. Proc R Soc A 472:20150843CrossRef Fowler AC, Scheu B (2016) A theoretical explanation of grain size distributions in explosive rock fragmentation. Proc R Soc A 472:20150843CrossRef
Zurück zum Zitat Hammer Ø, Harper DAT (2006) Paleontological data analysis. Blackwell Publishing, Oxford, p 351 Hammer Ø, Harper DAT (2006) Paleontological data analysis. Blackwell Publishing, Oxford, p 351
Zurück zum Zitat Hammer Ø, Harper DAT, Ryan PD (2001) Past: paleontological statistics software package for education and data analysis. Palaeontol Electron 4:1–9 Hammer Ø, Harper DAT, Ryan PD (2001) Past: paleontological statistics software package for education and data analysis. Palaeontol Electron 4:1–9
Zurück zum Zitat Hosseini ST, Asghari O, Haroni HA (2020) Multivariate anomaly modeling of primary geochemical halos by U-spatial statistic algorithm development: a case study from the Sari Gunay epithermal gold deposit, Iran. Ore Geol Rev 127:3845CrossRef Hosseini ST, Asghari O, Haroni HA (2020) Multivariate anomaly modeling of primary geochemical halos by U-spatial statistic algorithm development: a case study from the Sari Gunay epithermal gold deposit, Iran. Ore Geol Rev 127:3845CrossRef
Zurück zum Zitat Jensen J, Lake LW, Corbett PWM, Goggin D (2000) Statistics for petroleum engineers and geoscientists, 2nd edn. Prentice Hall PTR, Hoboken, p 362 Jensen J, Lake LW, Corbett PWM, Goggin D (2000) Statistics for petroleum engineers and geoscientists, 2nd edn. Prentice Hall PTR, Hoboken, p 362
Zurück zum Zitat Konicki KM, Holman RA (2000) The statistics and kinematics of transverse sand bars on an open coast. Mar Geol 169:69–101CrossRef Konicki KM, Holman RA (2000) The statistics and kinematics of transverse sand bars on an open coast. Mar Geol 169:69–101CrossRef
Zurück zum Zitat Lohmar S, Robin C, Gourgand A, Clavero J, Parada MA, Moreno H, Ersoy O, López-Escobar L, Naranjo J-A (2010) Evidence of magma-water interaction during the 13,800 years BP explosive cycle of the Licán ignimbrite, Villarrica volcano (southern Chile). Andean Geol 34:233–248 Lohmar S, Robin C, Gourgand A, Clavero J, Parada MA, Moreno H, Ersoy O, López-Escobar L, Naranjo J-A (2010) Evidence of magma-water interaction during the 13,800 years BP explosive cycle of the Licán ignimbrite, Villarrica volcano (southern Chile). Andean Geol 34:233–248
Zurück zum Zitat MacLeod N (2007) PalaeoMath 101: Part 12—Groups III: cluster analysis. palaeontology. Newsletter 1–14 MacLeod N (2007) PalaeoMath 101: Part 12—Groups III: cluster analysis. palaeontology. Newsletter 1–14
Zurück zum Zitat Maiz I, Arambarri I, Garcia R, Millan E (2000) Evaluation of heavy metal availability in polluted soils by two sequential extraction procedures using factor analysis. Environ Pollut 110(1):3–9CrossRef Maiz I, Arambarri I, Garcia R, Millan E (2000) Evaluation of heavy metal availability in polluted soils by two sequential extraction procedures using factor analysis. Environ Pollut 110(1):3–9CrossRef
Zurück zum Zitat Mann PS (1995) Introductory statistics, 2nd edn. Wiley, New York, p 784 Mann PS (1995) Introductory statistics, 2nd edn. Wiley, New York, p 784
Zurück zum Zitat Mariño-Paredes J, Morgavi D, Di Vito M, de Vito S, Sandivero F, Dueffels K, Beckmann G, Perugini D (2017) Syneruptive sequential fragmentation of pyroclastics from fractal modeling of grain size distributions of fall deposits: the Cretaio Tephra eruption (Ischia Island, Italy). J Volcanol Geotherm Res 345:161–171CrossRef Mariño-Paredes J, Morgavi D, Di Vito M, de Vito S, Sandivero F, Dueffels K, Beckmann G, Perugini D (2017) Syneruptive sequential fragmentation of pyroclastics from fractal modeling of grain size distributions of fall deposits: the Cretaio Tephra eruption (Ischia Island, Italy). J Volcanol Geotherm Res 345:161–171CrossRef
Zurück zum Zitat Marshall G, Jonker L (2010) An introduction to descriptive statistics: a review and practical guide. Radiography 16:e1–e7CrossRef Marshall G, Jonker L (2010) An introduction to descriptive statistics: a review and practical guide. Radiography 16:e1–e7CrossRef
Zurück zum Zitat Miall AD (1977) Ordinal data and the gamma statistic in geology. J Sediment Res 47(2):794–799 Miall AD (1977) Ordinal data and the gamma statistic in geology. J Sediment Res 47(2):794–799
Zurück zum Zitat Morgenthaler S (2009) Exploratory data analysis. Wiley Interdiscip Rev Comput Stat 1(1):33–44CrossRef Morgenthaler S (2009) Exploratory data analysis. Wiley Interdiscip Rev Comput Stat 1(1):33–44CrossRef
Zurück zum Zitat Nadoll P, Mauk JL, Hayes TS, Koenig AE, Box SE (2012) Geochemistry of magnetite from hydrothermal ore deposits and host rocks of the Mesoproterozoic Belt Supergroup, United States. Soc Econom Geol 107:1275–1292CrossRef Nadoll P, Mauk JL, Hayes TS, Koenig AE, Box SE (2012) Geochemistry of magnetite from hydrothermal ore deposits and host rocks of the Mesoproterozoic Belt Supergroup, United States. Soc Econom Geol 107:1275–1292CrossRef
Zurück zum Zitat Nick TG (2007) Descriptive statistics. In: Ambrosius WT (ed) Topics in biostatistics. Methods in molecular biology™. Humana Press, Totowa, p 528 Nick TG (2007) Descriptive statistics. In: Ambrosius WT (ed) Topics in biostatistics. Methods in molecular biology™. Humana Press, Totowa, p 528
Zurück zum Zitat Reid MK, Spencer KL (2009) Use of principal components analysis (PCA) on estuarine sediment datasets: the effect of data pre-treatment. Environ Pollut 157:2275–2281CrossRef Reid MK, Spencer KL (2009) Use of principal components analysis (PCA) on estuarine sediment datasets: the effect of data pre-treatment. Environ Pollut 157:2275–2281CrossRef
Zurück zum Zitat Reimann C, Filzmoser P, Garrett RG (2002) Factor analysis applied to regional geochemical data: problems and possibilities. Appl Geochem 17:185–206CrossRef Reimann C, Filzmoser P, Garrett RG (2002) Factor analysis applied to regional geochemical data: problems and possibilities. Appl Geochem 17:185–206CrossRef
Zurück zum Zitat Roberts NM, Tikoff B, Davis JR, Stetson-Lee T (2019) The utility of statistical analysis in structural geology. J Struct Geol 125:64–73CrossRef Roberts NM, Tikoff B, Davis JR, Stetson-Lee T (2019) The utility of statistical analysis in structural geology. J Struct Geol 125:64–73CrossRef
Zurück zum Zitat Rollinson H (1992) Another look at the constant sum problem in geochemistry. Mineral Mag 56:469–475CrossRef Rollinson H (1992) Another look at the constant sum problem in geochemistry. Mineral Mag 56:469–475CrossRef
Zurück zum Zitat Roux D (2010) VBA pour Excel—Bibliothèque mathématique avec applications pratiques. Ellipses, London, p 594 Roux D (2010) VBA pour Excel—Bibliothèque mathématique avec applications pratiques. Ellipses, London, p 594
Zurück zum Zitat Scott L, Neumann FH, Brook GA, Bousman CB, Norström E, Metwally AA (2012) Terrestrial fossil-pollen evidence of climate change during the last 26 thousand years in Southern Africa. Quater Sci Rev 32:100–118CrossRef Scott L, Neumann FH, Brook GA, Bousman CB, Norström E, Metwally AA (2012) Terrestrial fossil-pollen evidence of climate change during the last 26 thousand years in Southern Africa. Quater Sci Rev 32:100–118CrossRef
Zurück zum Zitat Shikazono N, Ogawa Y, Utada M, Ishiyama D, Mizuta T, Ishikawa N, Kubota Y (2008) Geochemical behavior of rare earth elements in hydrothermally altered rocks of the Kuroko mining area, Japan. J Geochem Explor 98:65–79CrossRef Shikazono N, Ogawa Y, Utada M, Ishiyama D, Mizuta T, Ishikawa N, Kubota Y (2008) Geochemical behavior of rare earth elements in hydrothermally altered rocks of the Kuroko mining area, Japan. J Geochem Explor 98:65–79CrossRef
Zurück zum Zitat Smith G, Rowley P, Williams R, Giordano G, Trolese M, Silleni A, Parsons DR, Capon S (2020) Grain size variations in ignimbrites and implications for the transport of pyroclastic flows. Nat Commun 11:1–11 Smith G, Rowley P, Williams R, Giordano G, Trolese M, Silleni A, Parsons DR, Capon S (2020) Grain size variations in ignimbrites and implications for the transport of pyroclastic flows. Nat Commun 11:1–11
Zurück zum Zitat Swan ARH, Sandilands M (1995) Introduction to geological data analysis. Blackwell Science, Oxford, p 446 Swan ARH, Sandilands M (1995) Introduction to geological data analysis. Blackwell Science, Oxford, p 446
Zurück zum Zitat Swan ARH, Sandilands M (2012) Practical statistics for geoscientists. Online edition: Practical Statistics for Geoscientists.pdf (anu.edu.au), 180 pp Swan ARH, Sandilands M (2012) Practical statistics for geoscientists. Online edition: Practical Statistics for Geoscientists.pdf (anu.edu.au), 180 pp
Zurück zum Zitat Temur S (2003) Jeolojide veri analizleri. Çizgi Kitapevi Yayınları, Konya, 170 pp Temur S (2003) Jeolojide veri analizleri. Çizgi Kitapevi Yayınları, Konya, 170 pp
Zurück zum Zitat Tukey JW (1977) Exploratory Data Analysis. Pearson, 712 pp Tukey JW (1977) Exploratory Data Analysis. Pearson, 712 pp
Zurück zum Zitat van den Boogaart KG, Tolosana-Delgado R (2008) ”Compositions”: a unified R package to analyze compositional data. Comput Geosci 34:320–338CrossRef van den Boogaart KG, Tolosana-Delgado R (2008) ”Compositions”: a unified R package to analyze compositional data. Comput Geosci 34:320–338CrossRef
Zurück zum Zitat Yu L, Rozemeijer J, Van Breukelen BM, Ouboter M, van Der Vlugt C, Broers HP (2018) Groundwater impacts on surface water quality and nutrient loads in lowland polder catchments: monitoring the greater Amsterdam area. Hydrol Earth Syst Sci 22:487–508CrossRef Yu L, Rozemeijer J, Van Breukelen BM, Ouboter M, van Der Vlugt C, Broers HP (2018) Groundwater impacts on surface water quality and nutrient loads in lowland polder catchments: monitoring the greater Amsterdam area. Hydrol Earth Syst Sci 22:487–508CrossRef
Metadaten
Titel
GEOstats: an excel-based data analysis program applying basic principles of statistics for geological studies
verfasst von
Mesut Gündüz
Kürşad Asan
Publikationsdatum
02.10.2021
Verlag
Springer Berlin Heidelberg
Erschienen in
Earth Science Informatics / Ausgabe 1/2022
Print ISSN: 1865-0473
Elektronische ISSN: 1865-0481
DOI
https://doi.org/10.1007/s12145-021-00710-6

Weitere Artikel der Ausgabe 1/2022

Earth Science Informatics 1/2022 Zur Ausgabe

Premium Partner