Intro to Statistics
LSP 121
LSP 121
Math and Tech
Literacy II
Introduction to
Descriptive Statistics
Greg Brewster
DePaul University
Topics
What is Statistics
Descriptive Statistics
Measures of Central Tendency
Measures of Dispersion
SPSS
Descriptive Stat
LSP 121-405
In-Class Activity 6
Statistics That Deceive Simpsons Paradox
20 points
Due by Saturday, Oct. 24th at 11:59 PM
You can hand in paper or Word document
Name: _ANSWERS_
Air travelers would like their flights to arrive on time. Airlines collect dat
LSP 121-405
In-Class Exercise #7
Risks and Test Errors
20 points
Due by Thursday, Oct. 29th at 11:50 AM
ANSWERS
1. In 1953, French economist Maurice Allais studied how people assess risk and expected
values. He asked a large group of people to select eith
Intro to Statistics
LSP 121
LSP 121
Math and Tech
Literacy II
More
Descriptive Statistics
Greg Brewster
DePaul University
Topics
More Descriptive Statistics
Percentiles
Categorical vs. Numeric Variables
Quartiles
Crosstabs
SPSS Predictive Analysis Softwar
Stats &
Probability
LSP 121
LSP 121
Math and Tech
Literacy II
Stats Wrapup
Intro to Probability
Greg Brewster
DePaul University
Topics
Statistics Wrapup
Binning Variables
Statistics that Deceive
Intro to Probability
Events
Sample spaces
Empirical probabil
Relational
Databases
LSP 121
LSP 121
Math and Tech
Literacy II
Relational Databases,
Normalization and Simple Queries
Greg Brewster
DePaul University
Todays Topics
Relational Databases
Reasons to have multiple tables
Relationships
Normalization
Reasons
Si
Correlation
LSP 121
LSP 121
Math and Tech
Literacy II
Intro to Correlation
Greg Brewster
DePaul University
Topics
Comparing values of two variables
Crosstabs
Scatter plots
Correlation
Show frequencies of variable pairs
Show graph of variable values
Provid
Reports
LSP 121
LSP 121
Math and Tech
Literacy II
Reports
Greg Brewster
DePaul University
Todays Topics
Access Forms
Filling Form Combo Box items with Table data
Access Reports
Design and Use
Thanks to Mary Jo Davidson and Curt White for some of the
mater
Queries and
Forms
LSP 121
LSP 121
Math and Tech
Literacy II
Queries and Forms
Greg Brewster
DePaul University
Todays Topics
M:M Relationships
Review: what they are
Example: creating the intermediate table
More on Queries
Other Types - Select, Update, Appe
Introduction to Database Systems (Access 2007)
By Curt M. White
Associate Professor
School of Computing
DePaul University
Introduction
A database program, such as Microsoft Access, is a program that stores and retrieves
records of information. For example
Simple Databases
LSP 121
LSP 121
Math and Tech
Literacy II
Simple Databases
Greg Brewster
DePaul University
Todays Topics
Elements of a Database
Importing data from a spreadsheet
into a database
Sorting, Finding and Filtering data
Thanks to Mary Jo Davids
LSP 121-405
Optional Homework #5
Due: Tuesday, November 17th, 2009 by 11:50 AM
No late submissions accepted
50 points
ANSWERS
Die 1
Die 2
3
+
2
Sum
=
5
You lose $1!
Rolls:
17
Winnings:
Avg Gain/Loss per Roll:
New
Game
$13.00
$0.76
Roll
Dice
Pseudo Code fo
Database Sizing
and Conversions
LSP 121
LSP 121
Math and Tech
Literacy II
Database Sizing & Transmission
Greg Brewster
DePaul University
Todays Topics
Database Data
Bits, bytes, binary numbers, hexadecimal numbers
Range of values stored in a data field
AS
More Probability
LSP 121
LSP 121
Math and Tech
Literacy II
More Probability
Greg Brewster
DePaul University
Topics
More Probability
Combining Probabilities
AND multiply probabilities
OR add probabilities
Average trials to success
At Least Once calculation
Misuse of statistics - Wikipedia, the free encyclopedia
Page 1 of 7
Misuse of statistics
From Wikipedia, the free encyclopedia
A misuse of statistics occurs when a statistical argument asserts a falsehood. In some cases, the misuse may be accidental. In o
Loops
LSP 121
LSP 121
Math and Tech
Literacy II
Loops
Greg Brewster
DePaul University
Topics
Loops
The FOR loop
The WHILE loop
Repeats a set of statements a fixed number of times
Repeats a set of statements until a condition is false
Strategies for Writin
Intro to
Programming
LSP 121
LSP 121
Math and Tech
Literacy II
Computer Programming
Excel Macros and VBA
Greg Brewster
DePaul University
Topics
Computer Programming
What Programs do
Algorithms
Excel Macros
Recording Keystrokes
Behind the Scenes: Visual Ba
LSP 121-405
Probability/Statistics Exam Review
Exam during class time on Tuesday, November 3
The exam will be closed book, closed notes except that you are allowed to bring in one 8.5 x
11 sheet of paper with whatever you want written on it. You will have
LSP 121-405
Programming Exam Review
Exam is Tuesday, November 24, 11:45 AM 2:00 PM
The exam will be closed book, closed notes except that you are allowed to bring in one 8.5 x
11 sheet of paper with whatever you want written on it. You will have access to
Probability - Printer-friendly - MSN Encarta
Page 1 of 2
Print
Probability
Article View
On the File menu, click Print to print the information.
Probability
Probability, also theory of probability, branch of mathematics that deals with measuring or determi
More VBA
LSP 121
LSP 121
Math and Tech
Literacy II
More VBA
Greg Brewster
DePaul University
Topics
More Visual Basic
Variables
Naming Rules
Implicit vs. Explicit Types
Variable Lifetime Static variables
User Defined Functions
IF statements
Conditions
Bran
Risk and Error
Types
LSP 121
LSP 121
Math and Tech
Literacy II
Risk and Error Types
Greg Brewster
DePaul University
Topics
Risk
Impacts of Adverse Events
Probabilities of Adverse Events
Insurance
Test Results
Test Accuracy and Errors
Probabilities of:
Typ
Introduction
LSP 121
LSP 121
Math and Tech
Literacy II
Autumn Quarter 2009
Greg Brewster
DePaul University
Todays Topics
Course Goals and Overview
Computer Basics and Organization
Course Topics
MTL II covers at least the following topics:
Database concept
LSP 121-405
Optional Homework #5
Due: Tuesday, November 17th, 2009 by 11:50 AM
No late submissions accepted
50 points
Die 1
3
Die 2
+
2
Sum
=
5
You lose $1!
Rolls:
17
Winnings:
Avg Gain/Loss per Roll:
New
Game
$13.00
$0.76
Roll
Dice
This is an optional ho
LSP 121-405
Homework #3
Due: Thursday, October 22nd, 2009 by 11:59 pm
50 points
Homework #3
You will need to use the SPSS PASW software program to solve the following problems. This software
is only available in the DePaul labs.
You can also access it via
LSP 121-405
In-Class Activity 1
ANSWERS
Student Name(s): Answers
Answer the following questions by t yping into this Word file, save the resulting file and submit it
as assignment In-Class Activity #1 on the COL web site by Sept. 19th. You may do this
ass
LSP 121-405
In-Class Activity 5
Working with PASW
20 points
Due by Saturday, Oct. 17th 11:59 pm
Introduction
PASW (Predictive Analytics SoftWare) is a software package from SPSS, Inc., used for
conducting statistical analyses, manipulating data, and gener
LSP 121-405
Database Exam Review
Exam during class time on Tuesday, October 6
The exam will be closed book, closed notes except that you are allowed to bring in one 8.5 x
11 sheet of paper with whatever you want written on it. You will have access to your
LSP 121-405
In-Class Activity 4
20 points
Due by Thursday, Oct. 1st at 11:50 AM
ANSWERS
Answers to the following questions can be written by hand and submitted on this paper or typed
into a Word document and submitted on the COL site. In either case, answ