Final

Question 1

Binomial Distribution

Answer 1

• is a discrete function
• includes dbinom,rbinom,pbinom,qbinom
• must have a fixed number of trials
• trials must be independent
• must be able to define our outcomes as success/failure

Question 2

dbinom

Answer 2

• dbinom(x,size,prob)
• can be used to find probability
• P(X=K)

Question 3

pbinom

Answer 3

pbinom( q,size,prob)
P(X<=K), will return the P

Question 4

rbinom

Answer 4

rbinom(n,size,prob)

Question 5

qbinom

Answer 5

qbinom(q,size,prob)
P(X<=K), will return the K

Question 6

Normal Distribution

Answer 6

• is continuous
• centered at the mean with standard deviation on either side

Question 7

pnorm

Answer 7

• pnorm(value,mean,sd)
• only computes the area to the left
• pnorm finds the area/probability (we are given Zo)

Question 8

qnorm

Answer 8

-Finding Zo given a probability
- only works to the left similar to pnorm

Question 9

rnorm

Answer 9

• rnorm(# of values, mean,sd)
• randomly generates values within the set parameters

Question 10

dnorm

Answer 10

-creates PDF (probability density function)
- returns the height of any given value

Question 11

Standard Deviation for Uniform Distribution

Answer 11

(b-a)/sqrt12

Question 12

dunif

Answer 12

dunif(c,min=a,max=b)
1/(b-a)
- will be 0 if c<a>b
- will be 1/(b-a) if a<c<b
dunif() != P(X=k)</a>

Question 13

Join

Answer 13

• joins are created using the foreign key
• need to select the data columns then say on what you will be joining them on

Question 14

Super Key

Answer 14

• is like a superset from which other keys can be derived
• there can be null values
• column names can be combined to create keys

Question 15

Candidate Key

Answer 15

• Minimal super key
• EX) [ID] would be a superkey and candidate key but [ID,Name] would not be because ID can be used alone and Name is not necessary
• can have null values

Question 16

Primary Key

Answer 16

• A primary key must also be a candidate key (chosen from the candidate key list)
• A primary key can be comprised of multiple fields
• A primary key must also be a super key
• should rarely or never change

Question 17

Foreign Key

Answer 17

• A foreign key can be null
• A foreign key can be compromised of multiple fields
• deals with 2 different tables

Question 18

Join Formula

Answer 18

SELECT (column, column),
FROM (table_name SPACE
create_variable)
JOIN (other_table_name
SPACE create_variable)
ON (variable.column)=.
(othervariable.column)

Question 19

Function to see the tables

Answer 19

dbListTables(insert database name)

Question 20

Function to see the columns in table

Answer 20

dbListFields(database_name, ‘table_name’)

Question 21

SQL

Answer 21

Structured Query Language

Question 22

Aliasing

Answer 22

• when brackets [] are used in a query to change the apperance of a column name

Question 23

SQL Statement Order

Answer 23

Select, From, Where, Group By, Having, Order By, Limit

Question 24

Binomial Distribution: Variance Formula

Answer 24

= np(1-p)

Question 25

Binomial Distribution: Mean/Expected Value

Answer 25

np

Question 26

Binomial Distribution: Standard Deviation

Answer 26

sqrt(variance)

Question 27

Uniform Distribution: Expected Value

Answer 27

(b+a)/2

Question 28

Uniform Distribution: Variance Formula

Answer 28

(b-a)^2/12

Question 29

Uniform Distribution: Standard Deviation

Answer 29

sqrt(variance)

Question 30

Normal Distribution: Expected Value

Answer 30

mean