green activity

Question 2) In a 2016 study conducted by the Oxford University Business School examined the cost and cost-overruns associated with past Olympic Games and they concluded that "... or a city and nation to decide to stage the Olympic Games is to decide to take on one of the most costly and financially most risky type of megaproject that exists..." With respect to the Winter Olympic Games, the following data on cost overruns was presented Venue Grenoble Lake Placid Cost Overrun Year 1968 1980 1984 1988 1992 1994 1998 2002 2006 2010 2014 181 324 118 65 137 277 56 24 80 13 289 Sara Albertville Lillehammer Nagano Salt Lake C Torino Vancouver Sochi By hand, use Least Squares Analysis to construct a second order polynomial for approximating the above data. a. b. Using the derived polynomial from part a), predict what will be the cost overrun in 2026 c. Write a computer program, using VBA, to construct a natural cubic spline that passes through the points in the above table. Use your spline function to predict what will be the cost overrun in 2026. Note, in order to solve the needed system of equations,you can use any method you choose including one of the programs that you wrote in question 1 If the predicted cost overruns for 2026 are different in part b) and c) comment on which one you think is a more reliable estimate d