Tutorial 3 Ans
Tutorial 3 Ans
Tutorial 3 Ans
1.
A company which has been operating for 12 years has experienced vary rapid growth. The
company wish to predict the number of employees required in future years if growth continues at
the same rate. Data is available for some statistical analysis.
Assume that the relationship is of the form:
Y^ i=B1 + B 2 X i i=1,..,12
where X is year of operation and Y is the number of employees The disturbance terms, e i, are assumed
to be normally and independently distributed with zero mean and constant variance σ . Preliminary
2
analysis of the sample data with 12 observations produces the following sample information:
n n n
∑ x i y i=6539 ∑ x 2i =143 ∑ y 2i =343984
1 1 1
n
X =6.5 Y=450 .83 ∑ e 2i =44973
1
n
∑ X 2i =650
1
Lower case letters indicate that the variables are measured as deviations from their respective
sample means i.e xi = Xi - X .
Use the above sample information to answer all the following questions. Show explicitly all calculations.
a) Calculate estimates, b1 and b2, for the unknown coefficients, B1 and B2.
Using the formulae for OLS (you are not expected to prove these) we have that, using deviations of the
variables from their means:
b2: for each extra year, expect number of employees to increase by 45.73 on average.
d) Perform a test to investigate if B2 is greater than 30 at the 5% significance level. Interpret this result.
H0: B2 ≤ 30
H1: B2 > 30
Compare t with the critical value of t obtained from the Student Tables with 12-2 degrees of
freedom.
e) Compute the 95% confidence interval for the intercept. Interpret this result.
i.e
se(b1) = 41.27
so CI
f) Compute the value of R2 for the estimated regression. Briefly explain what the estimated value of R2
means.
86.93% of variation in number of employees is explained by variation in year of operation. This is a very
good fit.
g) Perform a test of the overall fit of the model, i.e. a joint test for the significance of the estimated
coefficients.
H0: R2 = 0
H1: R2 > 0
df1 = 1; df2 = 10
5% value for F1,10=4.96, 1% value for F1,6 = 10.00
Reject H0: R2=0 in favour of alternative H1: R2>0 at 5% level because F= 66.51 > F1,10 =4.96 at 5%
Can also reject H0: R2=0 in favour of alternative H1: R2>0 at 1% level because F= 66.51 > F1,10 =10.00 at
1%
Conclude that there is explanatory power in the model at both 1% and 5% significance levels.
h) Predict the number of employees needed in year 14 if growth continues at the same rate. Calculate a
99% prediction interval for the prediction.
employees
Se(Y0) =