Final QMB Unit 5-6

Regression analysis was applied between sales (in $1000) and advertising (in $100) and the following regression function was obtained.

$62080

Using the linear model, forecast for period 5 is

12.5

Shown below is a portion of a computer output for regression analysis relating y (dependent variable) and x (independent variable). Compute the coefficient of determination

0.1807

The coefficient of determination resulting from a particular regression analysis was 0.85. What was the correlation coefficient, assuming a positive linear relationship?

0.922

If the coefficient of correlation is 0.4 the percentage of variation in the dependent Variable explained by the estimated regression equation

16%

The trend projection for time period 18 is

197.6

The slope of linear trend equation b1 is

2.0

The intercept for linear regression model b0 is

2.5

Use a=0.2 to compute the exponential smoothing values for month 7

7.836

Which of the following forecasting methods puts the least weight on the most recent time series value?

Exponential smothing with a=.2

In regression analysis, the varible that is being predicted

Is the dependent variable

Application of the least squares method results in values of the y-intercept and the slope that minimizes the sum of the squared deviations between the

Observed values of the dependent variable and the predicted value of the dependent variable.

Perform a t test and determine whether or not x and y are related. Use a=.05

Reject Ha, therefore the competitor's price and sales are related.

In a regression analysis if r2=1 then

SSE must be equal to zero

A company has recorded data on the weekly sales for it product (y) and the unit price of the competitor's product (x). The data resulting from a random sample of 7 weeks follows. Use excel's regression tool to answer the following questions:

Since the P-value 0.009385 <0.5 reject Ha

A group of observations measured at successive time intervals is known as

a time series

A parameter of the exponential smoothing model which provides the weight given to the most recent time series value in the calculation of the forecast value is known as the

smoothing constant

What is the estimated regression equation?

y=3.5818+41.6031x