LSP 121
Activity 11
Introduction to Probability and Risk
1. (Theoretical vs. Empirical) Toss three coins (at once) 20 times and record the outcomes. You
should record the order of the coins for each of the 20 tosses. (Note: there are coin toss
simulators

LSP 121
Homework #1
Due: One Week From Today
1. You are working at the Ray and have been asked to create a new activity called
Bike the Loop in which students will once a week ride their bikes to an unusual and
historic location somewhere in Chicagos loop

LSP 121
Activity 4
Advanced Queries
Use the Access file Real Estate for each of the following problems. (It can be found on
the QRC website under LSP 121 / LSP 121 Files - Databases. Copy it to your machine.
If it is a zipped/compressed file, you need to

Activity 6 & 7
1.
Statistics
Age at Inauguration
Valid
N
44
Missing
0
Mean
54.64
Median
54.50
Std. Deviation
6.273
Range
27
Minimum
42
Maximum
69
25
50
54.50
75
Percentiles
50.25
57.75
2. The oldest president is Ronald Reagan. Theodore Roosevelt is the yo

LSP 121 Spring 2013-2014 Exam on April 29, 2014
Statistics and Probability Exam Review Sheet
This exam will cover statistics and probability.
There will be statistics and probability problems to solve using the desktop computers in our classroom. You
will

LSP 121
Activity 3
Relational Database and Queries
This activity will give you practice at creating Access tables, performing normalization, and
creating primary and foreign keys.
Given below are the fields for a database for cable television subscribers.

LSP 121
Homework #4: Creating a Database
Part A
Create a database with two tables. The first table has the following fields and data:
ID
101
102
103
104
105
106
Last Name
Smith
Jones
Hart
Ford
Kingsfield
Abba
First Name
Sue
Bob
Sally
Joe
Mary
Bill
Address

LSP 121
Homework 2
Due: One Week From Today
1. Normalize the following set of fields that is, remove the repeating fields and place them into
a separate table with a foreign key. Rewrite the field names under appropriate names for the two
tables. Put the

Gwen Starkman
LSP 121
Individual Assignment #2 Probability and Type I/II Errors
1. Sample Space Size / All Possible Combinations
Make sure that you state your answer in a way that does not lose precision. Show all digits.
a. The Personal Identification Nu

Zack Evanson
LSP 121
Professor Costenbader
April 28th, 2016
Assignment 4 Exponential Models
1. a. A ticket to the Lovehammers concert at Metro was marked up by
95.5%. If the original price was $10, what was the final price including
fees (the marked up pr

LSP 121
Homework 3: Normalization of a Database
Normalize each of the following datasets (remove the repeating fields and place into a
separate table with a foreign key). Rewrite the field names under an appropriate name for
the table. Circle the primary

LSP 121
Individual Assignment #02 Probability and Type I/II Errors
Use this MS-Word document to enter the answers to the following questions.
Submit it to the D2L Dropbox for this assignment.
Show your work, in order to receive at least partial credit.
1.

Access Debugging Checklist
Area
Issue/Tip
Always check whether an error file exists after importing a table
Importing Files from Excel.
Opening Files
When importing Excel files, make sure that correct worksheet is
selected.
Right Click on files in QRC dat

ISP 121
Activity
Introduction to Probability and Risk
1. (Theoretical vs. Empirical) Toss three coins (at once) 20 times and record the
outcomes. You should record the order of the coins for each of the 20 tosses. (Note:
there are coin toss simulators on

LSP 121
Homework #5
Due:
The following data sets give waiting times in minutes of 11 customers at bus terminals in
Atlanta and Boston.
Atlanta: 5.5 6.0 4.5 5.0 7.0 6.5 5.0 7.5 5.5 4.0 8.0
Boston: 5.5 8.0 2.0 5.0 8.5 12.0 1.5 6.5 9.5 10.0 6.0
Find the mean

ISP 121
Activity 8
Introduction to Correlation
All group activities must include a signed statement that all members of your group
participated fully in the assignment. To start you might want to open a new Word
document entitled something like "Group Act

ISP 121
Homework #7new Probability and Risk
1. A local ski sale features eight types of skis, six types of bindings, and seven types
of boots. How many different ski/binding/boot packages are available?
=8*6*7= 336 different ski/binding/boot packages avai

Zack Evanson
Professor Hassan
LSP 121
10/18/16
Midterm
1)
2)
Height:
Statistics
height
N
Valid
Missing
200
0
Mean
5.700
Median
5.700
Range
2.0
Weight:
Statistics
weight
N
Valid
Missing
200
0
Mean
154.36
Median
151.00
Range
147
Weight:
Statistics
weight
N

Zack Evanson
LSP 120
Professor Costenbader
June 7, 2016
Final Exam
Open the LSP120_2016_Final_Exam Excel file and click on CTA Boardings tab which
contains data on the total number of CTA boardings from 1988 to 2014. (20 points
total)
a. Are rail boarding

Jonathan Perez
LSP 121
Homework 5
Due: One Week From Today
1.
Using Excel, is there a correlation between the number of home runs and the batting average for
each player? Paste the XY Scatter graph with the R2 value into your Word document. Give a
sentenc

LSP 121 Mid-Quarter Assessment
Please list your name here Alethea Binion
Remember to save often and copy the answers from Access or Excel into the number and space provided
below
16. 10 points
Season Ticket Holder
LastName Address
City
State
Zip
Ticket
Ja

Jonathan Perez
LSP 121
Homework #4
Due: One Week From Today
1. Find the mean, median, and range for each of the two data sets using SPSS.
Statistics
Green
N
Valid
Brown
15
15
0
0
Mean
7.387
6.113
Median
7.700
5.500
11.0
5.2
Missing
Range
Statistics
Green

Zack Evanson
Maya Brown
Katlyn Donley
LSP 120
Professor Costenbader
5/20/2016
Stage 2 Making Graphs
Project Title Suicide Awareness
Thesis Statement: Before analyzing data, we are setting out to uncover that the suicide rate will
begin to decline again.
S

LSP 121
Week 2
Normalization and Advanced Queries
Database normalization
is the process of organizing the felds and tables of a
relational databaseto
minimizeredundancyand
dependency. Normalization usually involves dividing
large tables into smaller (and

LSP 121
Activity 4
Advanced Queries
Use the Access file Real Estate for each of the following problems. (It can be found on
the QRC website under LSP 121 / LSP 121 Files - Databases. Copy it to your machine.
If it is a zipped/compressed file, you need to

LSP 121
Activity 2
Introduction to Statistics and SPSS (PASW)
Introduction
SPSS (Statistics Package for the Social Sciences) which in its latest version was renamed
PASW is a software package used for conducting statistical analyses, manipulating data,
an

LSP 121
Homework 2
Due: September 19th
1. Normalize the following set of fields that is, remove the repeating fields and place them into
a separate table with a foreign key. Rewrite the field names under appropriate names for the two
tables. Put the initi

LSP 121-405
Homework #2
Due: Thursday, October 1st, 2009 by 11:59 pm
Part A
You will create a database named Eval-Data with two tables to store employee performance
evaluation information. The first table, named Employees, has the following fields and dat

LSP 121
Individual Assignment #4
Algorithms and Computer Programming with VBA
Open a Word document or use this Word document to enter your answers to sections A, B, and C.
A. Algorithm
1. Write the algorithm for setting up to play a card game called Vaark

Mathematical and
Technological Literacy I
Activity 5: Exponential
Modeling
NAME(S): Citlaly Carbajal
SECTION NUMBER:209
1. Suppose a magic genie gives you a choice. He will give you $1000 each day in the
month of March or he will give you 1 on the March 1