Given below are annual data for total assets for Johnson & Johnson and UnitedHealth Group for the period 2010-2020, as of December 31st of each year.

PLEASE INCLUDE FORMULAS

Perform the following analysis:

Given below are annual data for total assets for Johnson & Johnson and UnitedHealth Group for the period 2010-2020, as of December 31st of each year. Perform the following analysis: 1 25pts Calculate ARITHMETIC and GEOMETRIC AVERAGE GROWTH RATE in assets for each company using an array function. Show average growth rates in percent (%) with two decimals! 2 10pts Use an IF statement to show which company had higher compound annual growth rate in assets over the period 2010-2020? What was that growth rate? Provide answers in the green space on the right. 3 10pts Graph the trend in assets for each company using SPARKLINE charts. 4 15pts Graph asset values for both companies in one chartusing two different chart types in the same chart. One chart can be a column chart and the other a scatter chart with years on the X axis. Place an appropriate chart title, axes titles and a legend on the graph. Make sure that the legend identifies the companies. 5 Label and format all results such that they are easy to read and identify 60pts Note: you can add as many rows or columns to the data presented below as you find necessary. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Arithmetic Average Growth Rate Geometric Average Growth Rate Total Assets in S million Johnson & UnitedHealth Johnson Group 102.908 63,063 113,664 67.889 121,347 80.885 132,683 81.882 130.358 86,382 133,411 111,254 141,208 122,810 157,303 139,058 152,954 152.221 157,728 173.889 174,894 197.289 Given below are annual data for total assets for Johnson & Johnson and UnitedHealth Group for the period 2010-2020, as of December 31st of each year. Perform the following analysis: 1 25pts Calculate ARITHMETIC and GEOMETRIC AVERAGE GROWTH RATE in assets for each company using an array function. Show average growth rates in percent (%) with two decimals! 2 10pts Use an IF statement to show which company had higher compound annual growth rate in assets over the period 2010-2020? What was that growth rate? Provide answers in the green space on the right. 3 10pts Graph the trend in assets for each company using SPARKLINE charts. 4 15pts Graph asset values for both companies in one chartusing two different chart types in the same chart. One chart can be a column chart and the other a scatter chart with years on the X axis. Place an appropriate chart title, axes titles and a legend on the graph. Make sure that the legend identifies the companies. 5 Label and format all results such that they are easy to read and identify 60pts Note: you can add as many rows or columns to the data presented below as you find necessary. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Arithmetic Average Growth Rate Geometric Average Growth Rate Total Assets in S million Johnson & UnitedHealth Johnson Group 102.908 63,063 113,664 67.889 121,347 80.885 132,683 81.882 130.358 86,382 133,411 111,254 141,208 122,810 157,303 139,058 152,954 152.221 157,728 173.889 174,894 197.289