Business economics

Tasks: 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 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. Tasks: 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 Task: 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