My estimated regression line is Y = 17 + 4X. The intercept is equal to:

• A) 17
• B) 4
• C) 21
• D) 13

Which of the following can never be negative

• A) Variance but not Standard deviation
• B) None of the given choice
• C) Both standard deviation and Variance
• D) Standard deviation but not Variance

Function RSQ in EXCEL returns the

• A) square of the Pearson product moment correlation coefficient.
• B) Pearson product moment correlation coefficient.
• C) Standard Error of mean.
• D) T-Statistic.

What variation does moving average method eliminate?

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

The method of least squares finds the best fit line that _______ the error between observed & estimated points on the line

• A) Maximizes
• B) Minimizes
• C) Reduces to zero
• D) All the given choices are correct.

In the calculation of range from group data which of the following play important role?

• A) only largest value
• B) both smallest & largest value
• C) cumulative frequency
• D) frequency

In EXCEL, …………….function is used to calculate correlation.

• A) COREL
• B) CORREL
• C) CORRELATION
• D) CORRELE

Which of the following values of the correlation coefficient indicates the strongest relationship between two variables?

• A) 0.5
• B) -0.9
• C) -0.2
• D) 0.7

P-value is the Probability of not getting a sample slope

• A) as low as the calculated value.
• B) equal to the calculated value.
• C) as high as the calculated value.
• D) very significantly different from zero.

The syntax intercept (known x’s, known y’s ) gives

• A) b)x- intercept
• B) a)y- intercept
• C) c)Both (a) and (b) are same
• D) d)None of these

If strength of the association between X and Y is very weak, then r = ?

• A) r = 0
• B) r = - 1
• C) r = 1
• D) r = 2

Which statistical test is commonly used to assess the significance of a correlation coefficient?

• A) t-test
• B) None of these
• C) Chi-square test
• D) Pearson correlation test

The moving averages of the Prices 50, 60, 70, 80 are

• A) 70, 80
• B) 65, 65
• C) 50, 60
• D) 60, 70

The excel syntax, =SLOPE(A1:A6,B1:B5), returns the error #N/A because …………………

• A) there is text in some cells for known y’s and known x’s
• B) there are some cells with zero value for known y’s and known x’s
• C) known y’s and known x’s have different number of data points.
• D) there are some empty cells in known y’s and known x’s

A sample is defined as a

• A) smaller and more manageable representation of a larger group.
• B) same set that contains characteristics of that population.
• C) subset of random error variables.
• D) smaller and more manageable representation of the IT sector.

Intercept function calculates the point at which a line will intersect -------------

• A) the y-axis
• B) Vertical line
• C) Origin
• D) the x-axis

Standard deviation is always calculated from

• A) median
• B) none of these
• C) mean
• D) mode

Which of the following method is used for measuring the trend?

• A) Moving average
• B) Least square method
• C) None of these
• D) Semi average

The following results were obtained from a simple regression analysis:
y = 37.2895 - 1.2024 X
r^2 = .6774 s = .2934
When X (independent variable) is equal to zero, the estimated value of Y (dependent variable) is equal to

• A) 37.2895
• B) 0.6774
• C) 0.2934
• D) -1.2024

In correlation analysis

• A) We consider the intercept with the Y-axis.
• B) None of these
• C) We study the strength of the association between two variables.
• D) We consider several independent variables.