X3= interest** ALL THE FOLLOWINGS WILL BE DONE iN EXCEL USING MATRiX APPROACH.

X3=
interest** ALL THE
FOLLOWINGS WILL BE DONE iN EXCEL USING MATRiX APPROACH. PLEASE SHOW EACH STEP
IN EXCEL FiLE.Test if there is a structural change in the following years in:
19701971197219731974 and 1975. Do the Chow test
for each year in the following 3 ways. Please write the null hypothesis and
alternative hypothesis in each question.a)
Only b0changesb)
Onlyslope coefficients (b1
b2 and b3 (together)) change.c)
All coefficients (b0 b1 b2 and b3
change) ( The instructor says it would be
easier to make 3 regressions for each question and use F test based on using restricted and unrestricted model.
Please show in each questionwhat is the
X matrix forrestricted and what is
unrestricted model. The instructor wants us to show each step in Excel)
Attachments: