Question 1

Counts for categorical variable are often expressed as percentages of the total.

Accepted Answer

A) True 
 B)False

Question 2

The most common data format is

Accepted Answer

A)  long 
B)  short 
C)  stacked 
D)  unstacked 
A)  long 
B)  short 
C)  stacked 
D)  unstacked

Question 3

Strongly related variables have a relationship close to zero if the relationship is nonlinear.

Accepted Answer

A) True 
 B)False

Question 4

If the standard deviation of X is 15,the covariance of X and Y is 94.5,the coefficient of correlation r = 0.90,then the variance of Y is 7.0.

Accepted Answer

A) True 
 B)False

Question 5

Changing the location of fields in a pivot table is known as

Accepted Answer

A)  slicing 
B)  dicing 
C)  sorting 
D)  pivoting 
A)  slicing 
B)  dicing 
C)  sorting 
D)  pivoting

Question 6

The four areas of a pivot table are

Accepted Answer

A)  Crosstabs,Fields,Rows,Columns 
B)  Data,Count,Contingency,Percentage 
C)  Filters,Rows,Columns,Values 
D)  Sort,Rows,Columns,Count 
A)  Crosstabs,Fields,Rows,Columns 
B)  Data,Count,Contingency,Percentage 
C)  Filters,Rows,Columns,Values 
D)  Sort,Rows,Columns,Count

Counts for categorical variable are often expressed as percentages of the total.

The most common data format is

Strongly related variables have a relationship close to zero if the relationship is nonlinear.

If the standard deviation of X is 15,the covariance of X and Y is 94.5,the coefficient of correlation r = 0.90,then the variance of Y is 7.0.

Changing the location of fields in a pivot table is known as

The four areas of a pivot table are

Introduction to Data Analysis and Decision Making

Describing the Distribution of a Single Variable

Probability and Probability Distributions

Normal, Binomial, Poisson, and Exponential Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Importing Data Into Excel

Analysis of Variance and Experimental Design

Statistical Process Control

Filters

Exam 3: Finding Relationships Among Variables

Counts for categorical variable are often expressed as percentages of the total.

The most common data format is

Strongly related variables have a relationship close to zero if the relationship is nonlinear.

If the standard deviation of X is 15,the covariance of X and Y is 94.5,the coefficient of correlation r = 0.90,then the variance of Y is 7.0.

Changing the location of fields in a pivot table is known as

The four areas of a pivot table are

Introduction to Data Analysis and Decision Making

Describing the Distribution of a Single Variable

Probability and Probability Distributions

Normal, Binomial, Poisson, and Exponential Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Importing Data Into Excel

Analysis of Variance and Experimental Design

Statistical Process Control

Filters