Spreadsheet: 487494d1478107394-index-match-functions-2nd-round-research-test
Sheet: Q3

 | You are looking at macroeconomic data for France since 31/12/2007.
 | Using the data below:
 | a. | Chart France's budget balance since 2007 and describe in 1 sentence the trends that you see
 | b. | Calculate France's budget deficit relative to GDP on a rolling 12 month basis since 2008 and produce a chart that is :
 |  | detailing a compelling title in a professional format (name y and x-axis, unit of measure, gridlines, labels, legend, font, etc..)
 | c. | Is France today in breach of The Maastricht criteria, and if so, does it matter?
 |  | Macroeconomic -indicator: | France Budget Balance | France Nominal GDP
 |  | Value: | EUR billion | EUR million
 |  | Unit of measure: | Year-To-Date (YTD) | Quarter on Quarter
 |  | 2007-12-31 00:00:00 | -38.181 | 494674
 |  | 2008-01-31 00:00:00 | -3.477 | 494674
 |  | 2008-02-29 00:00:00 | -16.473 | 494674
 |  | 2008-03-31 00:00:00 | -13.029 | 499748
 |  | 2008-04-30 00:00:00 | -30.533 | 499748
 |  | 2008-05-31 00:00:00 | -31.041 | 499748
 |  | 2008-06-30 00:00:00 | -17.33 | 500224
 |  | 2008-07-31 00:00:00 | -29.437 | 500224
 |  | 2008-08-31 00:00:00 | -46.037 | 500224
 |  | 2008-09-30 00:00:00 | -34.346 | 499892
 |  | 2008-10-31 00:00:00 | -53.515 | 499892
 |  | 2008-11-30 00:00:00 | -59.166 | 499892
 |  | 2008-12-31 00:00:00 | -56.847 | 494653
 |  | 2009-01-31 00:00:00 | -4.298 | 494653
 |  | 2009-02-28 00:00:00 | -22.929 | 494653
 |  | 2009-03-31 00:00:00 | -33.197 | 484826
 |  | 2009-04-30 00:00:00 | -56.804 | 484826
 |  | 2009-05-31 00:00:00 | -61.557 | 484826
 |  | 2009-06-30 00:00:00 | -63.232 | 482921
 |  | 2009-07-31 00:00:00 | -81.483 | 482921
 |  | 2009-08-31 00:00:00 | -96.412 | 482921
 |  | 2009-09-30 00:00:00 | -94.245 | 483242
 |  | 2009-10-31 00:00:00 | -116.919 | 483242
 |  | 2009-11-30 00:00:00 | -126.657 | 483242
 |  | 2009-12-31 00:00:00 | -129.847 | 488287
 |  | 2010-01-31 00:00:00 | -7.318 | 488287
 |  | 2010-02-28 00:00:00 | -18.104 | 488287
 |  | 2010-03-31 00:00:00 | -24.601 | 492293
 |  | 2010-04-30 00:00:00 | -49.001 | 492293
 |  | 2010-05-31 00:00:00 | -55.055 | 492293
 |  | 2010-06-30 00:00:00 | -47.346 | 497354
 |  | 2010-07-31 00:00:00 | -76.463 | 497354
 |  | 2010-08-31 00:00:00 | -100.596 | 497354
 |  | 2010-09-30 00:00:00 | -105.75 | 501659
 |  | 2010-10-31 00:00:00 | -130.709 | 501659
 |  | 2010-11-30 00:00:00 | -141.102 | 501659
 |  | 2010-12-31 00:00:00 | -150.763 | 505958
 |  | 2011-01-31 00:00:00 | -5.818 | 505958
 |  | 2011-02-28 00:00:00 | -16.873 | 505958
 |  | 2011-03-31 00:00:00 | -17.097 | 512064
 |  | 2011-04-30 00:00:00 | -39.604 | 512064
 |  | 2011-05-31 00:00:00 | -43.954 | 512064
 |  | 2011-06-30 00:00:00 | -39.499 | 512742
 |  | 2011-07-31 00:00:00 | -59.095 | 512742
 |  | 2011-08-31 00:00:00 | -70.95 | 512742
 |  | 2011-09-30 00:00:00 | -62.715 | 515462
 |  | 2011-10-31 00:00:00 | -81.644 | 515462
 |  | 2011-11-30 00:00:00 | -88.288 | 515462
 |  | 2011-12-31 00:00:00 | -90.185 | 518280
 |  | 2012-01-31 00:00:00 | -9.478 | 518280
 |  | 2012-02-29 00:00:00 | -18.256 | 518280
 |  | 2012-03-31 00:00:00 | -19.041 | 519474
 |  | 2012-04-30 00:00:00 | -42.661 | 519474
 |  | 2012-05-31 00:00:00 | -48.319 | 519474
 |  | 2012-06-30 00:00:00 | -39.897 | 520100
 |  | 2012-07-31 00:00:00 | -63.759 | 520100
 |  | 2012-08-31 00:00:00 | -70.984 | 520100
 |  | 2012-09-30 00:00:00 | -61.664 | 522707
 |  | 2012-10-31 00:00:00 | -89.098 | 522707
 |  | 2012-11-30 00:00:00 | -96.867 | 522707
 |  | 2012-12-31 00:00:00 | -88.165 | 524533
 |  | 2013-01-31 00:00:00 | -10.226 | 524533
 |  | 2013-02-28 00:00:00 | -20.333 | 524533
 |  | 2013-03-31 00:00:00 | -20.622 | 525174
 |  | 2013-04-30 00:00:00 | -49.614 | 525174
 |  | 2013-05-31 00:00:00 | -51.789 | 525174
 |  | 2013-06-30 00:00:00 | -43.552 | 529336
 |  | 2013-07-31 00:00:00 | -59.003 | 529336
 |  | 2013-08-31 00:00:00 | -66.723 | 529336
 |  | 2013-09-30 00:00:00 | -56.884 | 529544
 |  | 2013-10-31 00:00:00 | -81.077 | 529544
 |  | 2013-11-30 00:00:00 | -85.049 | 529544
 |  | 2013-12-31 00:00:00 | -75.435 | 531749
 |  | 2014-01-31 00:00:00 | -9.397 | 531749
 |  | 2014-02-28 00:00:00 | -17.971 | 531749
 |  | 2014-03-31 00:00:00 | -14.992 | 533235
 |  | 2014-04-30 00:00:00 | -45.569 | 533235
 |  | 2014-05-31 00:00:00 | -42.66 | 533235
 |  | 2014-06-30 00:00:00 | -42.782 | 533858
 |  | 2014-07-31 00:00:00 | -63.395 | 533858
 |  | 2014-08-31 00:00:00 | -67.765 | 533858
 |  | 2014-09-30 00:00:00 | -57.239 | 535747
 |  | 2014-10-31 00:00:00 | -80.26 | 535747
 |  | 2014-11-30 00:00:00 | -87.055 | 535747
 |  | 2014-12-31 00:00:00 | -85.686 | 538528
 |  | 2015-01-31 00:00:00 | -6.326 | 538528
 |  | 2015-02-28 00:00:00 | -16.264 | 538528
 |  | 2015-03-31 00:00:00 | -14.28 | 542736
 |  | 2015-04-30 00:00:00 | -41.651 | 542736
 |  | 2015-05-31 00:00:00 | -42.239 | 542736
 |  | 2015-06-30 00:00:00 | -41.418 | 542386
 |  | 2015-07-31 00:00:00 | -56.287 | 542386
 |  | 2015-08-31 00:00:00 | -60.774 | 542386
 |  | 2015-09-30 00:00:00 | -48.814 | 545829
 |  | 2015-10-31 00:00:00 | -71.711 | 545829
 |  | 2015-11-30 00:00:00 | -78.285 | 545829
 |  | 2015-12-31 00:00:00 | -72.148 | 550133
 |  | 2016-01-31 00:00:00 | -5.163 | 550133
 |  | 2016-02-29 00:00:00 | -12.15 | 550133
 |  | 2016-03-31 00:00:00 | -9.01 | 555911
 |  | 2016-04-30 00:00:00 | -32.816 | 555911
 |  | 2016-05-31 00:00:00 | -38.933 | 555911
 |  | 2016-06-30 00:00:00 | -38.793 | 555160
 |  | 2016-07-31 00:00:00 | -50.736 | 555160
 |  | 2016-08-31 00:00:00 | -50.736 | 555160