1. Please find the following data representing the previous 13 years of the NASDAQ market price along with the individual stock of Apple (AAPL), which is listed on the NASDAQ exchange, and answer the following (recommend using Excel and upload your file with answers): A) Develop a simple linear equation for the model of AAPL as a function of NASDAQ and include the R2 parameter. B) Plot the function along with the annual prices for AAPL and the NASDAQ composite. C) State the Beta metric for AAPL relative to the NASDAQ market. D) Briefly state your interpretation of these data. Year NASDAQ* AAPL* 2008 2068 5.12 2009 2462 5.80 2010 2983 8.99 2011 3087 12.25 2012 3349 20.67 2013 4366 16.66 2014 5075 23.09 2015 5528 26.63 2016 5588 27.26 2017 7097 38.09 2018 7517 53.23 2019 8383 53.89 2020 11167 111.81 *Please note these prices were quoted in September of each respective year. 1. Please find the following data representing the previous 13 years of the NASDAQ market price along with the individual stock of Apple (AAPL), which is listed on the NASDAQ exchange, and answer the following (recommend using Excel and upload your file with answers): A) Develop a simple linear equation for the model of AAPL as a function of NASDAQ and include the R2 parameter. B) Plot the function along with the annual prices for AAPL and the NASDAQ composite. C) State the Beta metric for AAPL relative to the NASDAQ market. D) Briefly state your interpretation of these data. Year NASDAQ* AAPL* 2008 2068 5.12 2009 2462 5.80 2010 2983 8.99 2011 3087 12.25 2012 3349 20.67 2013 4366 16.66 2014 5075 23.09 2015 5528 26.63 2016 5588 27.26 2017 7097 38.09 2018 7517 53.23 2019 8383 53.89 2020 11167 111.81 *Please note these prices were quoted in September of each respective year