Class DML exercises
CIS9340
Spring 2015
Basic DML
Cape-Codd1111_Spring2015.accdb
1.
Write an SQL statement to display SKU and SKU_Description
2.
Write an SQL statement to display unique SKU and SKU_Description data
3.
Write an SQL statement to display uni
Zicklin School of Business Baruch College
Spring 2015
CIS9340 Database Management Systems
QTRA [62935]
Instructor: Howard Kline
E-Mail: howard.kline@baruch.cuny.edu
Office Hours: By appointment via email
Class Schedule: Tue & Thur, 7:30p 8:45p
Dept. of St
Baruch College, May 5, 2009
Prof. L. Tatum
STA 9710
Chapter 5.2 Optimal Allocation
If we have reasonable estimates of the standard deviation of the strata, then we
can decide on our allocation of the sample to the strata using the famous optimal
allocatio
Spincycle is a powerful program written in VBA (Visual Basic for Applications), which is
the Macro language for Microsoft Windows products, including Excel and Word.
In Excel 2003, set the security level to medium to allow the Macro to run. In 2007, go to
Introduction to Big Data
Homepage: http:/www.cs.kent.edu/~jin/BigData/index.html
Whats Big Data?
No single definition; here is from
Wikipedia:
Big data is the term for a collection of data
sets so large and complex that it becomes
difficult to process usi
Baruch College, 4-27-15
Prof. L. Tatum
STA 9710
Chapter 6. Estimation for Proportions: Cluster and Stratified
Section 6.1. The Proportion as Average
The problem of estimating a population proportion is surprisingly similar to the
problem of estimating a p
Baruch College, 4-25-13
Prof. L. Tatum
STA 9710
Chapter 5.4 Optimal Allocation for Stratified Random Sampling for Clusters
In the previous section, we gave equations for the sample variance of the
separate method of ratio estimation for stratified samplin
Baruch College, 4-25-13
Prof. L. Tatum
STA 9710
Chapter 5.3 Stratified Random Sampling for Clusters
As you will recall, the King wished to estimate the total amount of taxes paid by
the households as reported by the taxpayers, themselves. Let us now imagi
Baruch College, 4-25-13
Prof. L. Tatum
STA 9710
Chapter 5.1 Stratified Random Sampling
Imagine that a King wishes to judge the honesty of his tax collectors by
comparing the total amount of taxes reported to him against the amount of taxes paid
according
Baruch College, 4-25-13
Prof. L. Tatum
STA 9710
Chapter 5.1 Stratified Random Sampling
Imagine that a King wishes to judge the honesty of his tax collectors by
comparing the total amount of taxes reported to him against the amount of taxes paid
according
Baruch College, STA 9710, Spring 2015
Prof. L. Tatum
Project Assignment #1
Due Monday, March 30th
Assignment:
Please come up with a preliminary topic for a project, write it down, and turn it in!
Background:
The idea is to pick a topic which would please
Homework Ch 4.1
WilliamMurphy
# STA 9710 HW CH 4.1
# William Murphy
# Problem 1: Refer to SMO data
# (a) check computations ybar_r, sr, se_ybarr
# set the dataset to an R variable
# rename the column headings
smo_data <- read.table("C:\Users\William\Deskt
Baruch College, 3/11/15
Prof. L. Tatum
STA 9710: Midterm Review Questions
1.) What is the technical definition of a random experiment? Hint: it has three primary
characteristics.
2.) What is the technical definition of a random variable?
3.)
(a) We are go
STA 9710, Baruch College, 4-6-15
Prof. L. Tatum
Chapter 4.1 One-Stage Cluster Sampling
Suppose we wished to estimate the average income per capita of a city. One method
would be to take a simple random sample (SRS) based on a sampling frame a list
contain
Baruch College, 2-14-15
Prof. L. Tatum
Hmw #2
Due: Monday, Feb. 23rd
I recommend you review your class notes for the last two classes before working on these
questions, in addition to having read Lecture Notes 2.1. Our goal here is to lay a
foundation for
Baruch College, 3-9-15
Prof. L. Tatum
Chapter 2.3 Simple Random Sampling (without Replacement)
Section 1: The Combinations Function
In the sampling literature, the term Simple Random Sampling (SRS) refers to sampling
without replacement. The term simple m
Baruch College, 2-4-15
Prof. L. Tatum
Chapter 2.1 Characteristics of the Sample Average as Random Variable
We start with a gambling game, the Dollar Game. In this game, a student and a
professor agree to flip a fair coin. If the outcome is heads, the stud
Baruch College, Spring 2015
Prof. L. Tatum
Statistical Sampling for Business
1-24-15
"The requirements of business are more exacting than those of science."
E.W.
Deming
Chapter 1: Statistical Sampling
Section 1.1. Introduction
You have likely heard the ta
Chapter 8:
Discriminant Analysis:
Description of Group
Separation
8.1 Introduction
8.2 Discriminant Function for Two Groups
8.4 Discriminant Analysis for Several Groups
8.5 Standardized Discriminant Function
8.6 Tests of Signicance
8.1 Introduction
Chapter 3:
Random Vector and
Multivariate Data
Random Variable
Let y denote a (univariate) random variable with probability density
function (pdf) f (y) such that f (y) > 0 and f (y) = 1.
Mean: = E(y) =
yf (y)dy (central tendency)
Variance: 2 = Var(y)
STA 9705/70500 Multivariate Statistical Methods
Instructor:
Professor Yu (Ryan) Yue
Department: Statistics and CIS
Office:
VC 11-266
Office Hours: MW 4-5 pm or by appointment
E-mail:
yu.yue@baruch.cuny.edu
COURSE DESCRIPTION
A comprehensive survey of a la