Business economics

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
on the Excel spreadsheet to answer this part of the question.
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
?? = 60060 − 10000?
10000? = 60060 − ??
? = 6.006 −
?? = −33300 + 33300?
33300? = ?? + 33300
? = 1 +
? 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
a) A graphical approach
b) Excel’s solver
c) An algebraic approach

Compare and contrast the various types of market structures which can exist in” rel=”nofollow”>in market economies. What
are the advantages and disadvantages to each type of market structure as far as consumers and busin” rel=”nofollow”>inesses
are concerned? Is one type of market structure unambiguously better than the others?




Sample Solution

find the cost of your paper