UI STAT 5400  Computing in Statistics (8 pages)
Previewing pages 1, 2, 3 of 8 page document View the full content.Computing in Statistics
Previewing pages 1, 2, 3 of actual document.
View the full content.View Full Document
Computing in Statistics
0 0 57 views
 Pages:
 8
 School:
 University of Iowa
 Course:
 Stat 5400  Computing in Statistics
Computing in Statistics Documents

5 pages

8 pages

5 pages

4 pages

8 pages

8 pages

2 pages

5 pages

4 pages

4 pages

Lab session 2 Elementary data analysis in R
4 pages

9 pages

100 pages

Comparison Between Wilcoxon and Least Squares Regression Methods
11 pages

100 pages

Comparison Between Wilcoxon and Least Squares Regression Methods
11 pages

3 pages

4 pages

Lab session 3 Elementary data analysis in R
4 pages

3 pages

Customer Database Management System in Retail Business
10 pages

14 pages

5 pages

6 pages

3 pages

One approach to handling missing data
9 pages

4 pages

Simulation Study For The Comparison of TTest and the WilcoxonTest
10 pages

Using Linux and the text editor
3 pages

8 pages

6 pages

4 pages

Queries and SQL More on Data Integrity
4 pages

Structure of Linux environment
5 pages

5 pages

4 pages

Lab session 1 Using Linux and the text editor
3 pages

4 pages

Simulation  Quantiles of Large Datasets Using Liu & Su Method
8 pages

3 pages

4 pages

4 pages

Analysis of Clinical Trial Data
15 pages

10 pages

4 pages

4 pages

3 pages

9 pages

5 pages

3 pages

3 pages

Structure of Linux environment
5 pages

5 pages

5 pages

3 pages

8 pages

6 pages

6 pages

Review of Bayesian Concepts and Intro to MCMC
8 pages

4 pages

4 pages

4 pages

Data validation and description Proc format
8 pages

5 pages
Sign up for free to view:
 This document and 3 million+ documents and flashcards
 High quality study guides, lecture notes, practice exams
 Course Packets handpicked by editors offering a comprehensive review of your courses
 Better Grades Guaranteed
Unformatted text preview:
1 22S 166 Computing in Statistics 2 ideally should follow this model today s lecture deals with two related topics efficient storage of data applies to setting up datafiles for use by SAS or any other analysis system some aspects of relational database software such as Microsoft Access Intro to relational database concepts Lecture 15 Oct 12 2009 Material drawn in part from www citilink com jgarrick vbasic database rdbms html and http www citilink com jgarrick vbasic database fundamentals html Kate Cowles 374 SH 335 0727 kcowles stat uiowa edu Introduction to relational database concepts database a system for storing data relational database model has become the de facto standard for the design of databases both large and small storage of data for use in statistical analysis 3 What is a relational database 4 Basic concepts relational database stores all its data in tables Primary and Foreign Keys table is a set of rows and columns Referential Integrity set has no predefined sort order for its elements record is database terminology for a row or observation field or attribute is database terminology for a column or variable Queries Normalization 5 6 Flat files how not to store complex data Example customer order entry system simplest model for a database a single table which includes fields for each element you need to store You re managing the data for a company with a number of customers each of which will be placing multiple orders Each order can have one or more items you have probably worked with flat file databases at least in the form of spreadsheets waste storage space and are problematic to maintain 7 8 Data that we wish to record for each component of the application Problems with a flat file for representing this data Customers Customer Number Company Name Address City State ZIP Code Phone Number Orders Order Number Order Date PO Number Order Line Items Item Number Description Quantity Price Each time an order is placed you ll need to repeat the customer
View Full Document