Resources

Resource Image

Database Construction and Sampling

Author(s): D. Timothy Gerber1, David M. Reineke1

University of Wisconsin

126 total view(s), 81 download(s)

0 comment(s) (Post a comment)

Summary:
Creating your own database is an excellent way for students to learn the trials and tribulations of data collection and management. Construction of three simple databases using a spreadsheet is described here and basic summary statistics areā€¦

more

Creating your own database is an excellent way for students to learn the trials and tribulations of data collection and management. Construction of three simple databases using a spreadsheet is described here and basic summary statistics are provided.

Licensed under CC Attribution-NonCommercial-ShareAlike 4.0 International according to these terms

Version 1.0 - published on 16 Aug 2024 doi:10.25334/JKJW-C871 - cite this

Overview

Creating your own database is an excellent way for students to learn the trials and tribulations of data collection and data management. It provides an opportunity to discuss etheical issues in data collection as well as data integrity. Furthermore, students will see that data in the real world does not always present itself as neatly as it appears in textbooks Web-based databases, but that it needs to be organized, carefully labeled, and proofread.

Simple Database Construction Using Local Sources of Data

To best understand how information is organized in a database, students need to see firsthand how they are constructed. Construction of three simple databases using a spreadsheet is described here and basic summary statistics are provided for each. Recommendations for building simple databases using a computer spreadsheet and the statistical analysis of its data are given.

Citation

Researchers should cite this work as follows:

Fundamental Mathematical Concepts

Developed By

Developed by
Sir Francis Galton

Victorian polymath: geographer, meteorologist, tropical explorer, founder of differential psychology, inventor of fingerprint identification, pioneer of statistical correlation and regression, convinced hereditarian, eugenicist, proto-geneticist, half-cousin of Charles Darwin and best-selling author.