If the correlation is negative perfect, what will be the value of r?

• A) 0
• B) 1
• C) None of these
• D) -1

A statistical measure of the variability of a distribution around its mean is referred to as

• A) The standard deviation
• B) A probability distribution
• C) The expected return
• D) Coefficient of variation

If the dependent variable increases with the independent variable then the coefficient of correlation is

• A) 0 to 1
• B) 0 to -1
• C) 0 to – 0.5
• D) 0 to -2

Increase in the number of passengers at bus terminal on weekend is associated with which component of time series?

• A) None of these.
• B) Trend
• C) Irregular variation
• D) Seasonal variation

The relation between standard deviation and variance is

• A) ${\mathop{\rm var}} = 2\sigma$
• B) $2{\mathop{\rm var}} = \sigma$
• C) ${\mathop{\rm var}} = \sqrt \sigma$
• D) ${\mathop{\rm var}} = {\sigma ^2}$

If the regression line passes through the origin then the ratio of both ‘x’ & ‘y’ intercepts is

• A) None of these
• B) 0
• C) 1:1
• D) Not defined

The correlation between two variables measures the extent to which they are

• A) mutually exclusive
• B) related with respect to effect.
• C) associated
• D) causally related

As the regression line equation is y = ax + b, where b is

• A) The y-intercept
• B) None of these
• C) The x-intercept
• D) The slope

Which of the following regression models would be used, when the rate of change is not the same throughout the curve?

• A) Non-linear
• B) Exponential
• C) Linear
• D) Polynomial

The mean of 3.5, 4.5, 6.5, 7.5 is ---------------

• A) 5.7
• B) 5
• C) 5.5
• D) 5.9

In scatter diagram, correlation is called positive, if ………

• A) The value of the dependent variable decreases as the value of the independent variable increases.
• B) The value of the dependent variable increases as the value of the independent variable increases.
• C) None of the above.
• D) The value of the dependent variable increases as the value of the independent variable decreases.

As the relationship deteriorates from a perfect correlation, what happens to the points on a scatter diagram?

• A) The y-intercept changes.
• B) The slope and y-intercept both change
• C) The slope changes.
• D) They become more scattered.

The repetitive movement around a trend line in a 4- month period is best described by

• A) Secular trend
• B) Irregular variation
• C) Seasonal variation
• D) Cyclical fluctuation

For the excel syntax, SLOPE(known_y’s,known_x’s), if an array or reference argument contains text or empty cells,…………………………..

• A) It will return error #N/A
• B) Those values will be ignored
• C) It will return error #NAME?
• D) It will return error #Value!

If for a scatter diagram, the regression line has a slope less than zero, what does this suggest about the relationship between the variables?

• A) Perfect correlation
• B) Positive correlation
• C) Negative correlation
• D) No correlation

Which of the following correlation coefficients could be statistically significant?

• A) 0.12
• B) 0.34
• C) All of these
• D) –.45

Suppose we developed the following least squares regression equation: Y = 3.5 + 2.1X. Which of the following statements is correct?

• A) X and Y are inversely proportional
• B) The dependent variable increases 2.1 for an increase of 1 in X
• C) The equation crosses the Y-axis at 3.
• D) If X = 5, then Y =15.

Seasonal Variation is calculated as

• A) calculate actual + trend for each period
• B) calculate actual - trend for each period
• C) Trend for each period - calculate actual
• D) none of these

If known_y's and known_x's are empty or have a different number of data points, RSQ returns the

• A) zero value.
• B) #N/A error value.
• C) Slope value.
• D) P-Value

The value of the coefficient of variation (CV) is.

• A) Same unit as data
• B) Unitless
• C) Both unitless and in percentage
• D) In percentage