1. Plot annual data on real non-residential in” rel=”nofollow”>investment over time as a contin” rel=”nofollow”>inuous lin” rel=”nofollow”>ine
2. Usin” rel=”nofollow”>ing the Econ Chart add-in” rel=”nofollow”>in, overlay recession bars on your diagram
3. Introduce a trend lin” rel=”nofollow”>ine in” rel=”nofollow”>into your figure
4. Extend the trend lin” rel=”nofollow”>ine beyond the fin” rel=”nofollow”>inal date for a further five years, that is from 2016 to 2020
5. What is the equation of the trend lin” rel=”nofollow”>ine?
6. What are the actual forecasted values for in” rel=”nofollow”>investment in” rel=”nofollow”>in each of the years from 2016 to 2020?
7. Economically in” rel=”nofollow”>interpret and comment on the actual series for non-residential in” rel=”nofollow”>investment in” rel=”nofollow”>in relation to the
recessions shown on your figure. You should use economic reasonin” rel=”nofollow”>ing to answer this question. Use a text box
Make your figures produced in” rel=”nofollow”>in Excel as professional as possible. Professionally produced graphs will receive extra
credit. Graphs which are copied and pasted usin” rel=”nofollow”>ing the “snippin” rel=”nofollow”>ing tool” will receive little or no credit.
Demand and Supply Curves & Excel’s Solver
Q2: The in” rel=”nofollow”>initial equations for a demand and supply system are given below
Demand
?? = 60060 − 10000?
10000? = 60060 − ??
? = 6.006 −
??
10000
Supply
?? = −33300 + 33300?
33300? = ?? + 33300
? = 1 +
??
33300
? is quantity demanded or supplied and ? is price in” rel=”nofollow”>in sterlin” rel=”nofollow”>ing.
Fin” rel=”nofollow”>ind the equilibrium values for quantity demanded and quantity supplied along with equilibrium price for
the set of equations above. Use each of the approaches below and report your fin” rel=”nofollow”>indin” rel=”nofollow”>ings in” rel=”nofollow”>in separate Excel
sheets.
a) A graphical approach
b) Excel’s solver
c) An algebraic approach