Zoom able COM Collaborate Pages The data below shows the annual net income (profit) of Facebook (in $ millions) since 2012 Backg Year 2012 2013 2014 2015 2016 2017 2018 Net Income 53 1,500 2,940 3,688 10,188 15,920 22,112 Headers a Source: sec.gov Hide or Match Page Numb Format 1,2,3 Numbering Continue REQUIRED: Using Excel 1. Find a linear regression line for Facebook's net income using the scatter graph method. (where 2012 = time zero) a. Ensure your graph displays the linear equation b. Ensure your graph displays the R-Squared c. Ensure your graph is well labelled and titled d. Do you think a linear function is appropriate? Why or why not? 2. Repeat step 1 above using a quadratic function 3. Repeat step 1 above using an exponential function 4. Comment on the function that best models Facebook's net income as a function of time a. Using the best model, come up with a table showing the projected annual profits for Facebook for years 2019 to 2030 Start at: Create a new Sections allow and footer, NOTES: 1. You should have a separate Tab for each question (four tabs in total) 2. Be neat and organized 3. Format your data appropriately I 4. If you need help, seek help early 6. Save your work in the format: "Excel HW2 LASTNAME Zoom able COM Collaborate Pages The data below shows the annual net income (profit) of Facebook (in $ millions) since 2012 Backg Year 2012 2013 2014 2015 2016 2017 2018 Net Income 53 1,500 2,940 3,688 10,188 15,920 22,112 Headers a Source: sec.gov Hide or Match Page Numb Format 1,2,3 Numbering Continue REQUIRED: Using Excel 1. Find a linear regression line for Facebook's net income using the scatter graph method. (where 2012 = time zero) a. Ensure your graph displays the linear equation b. Ensure your graph displays the R-Squared c. Ensure your graph is well labelled and titled d. Do you think a linear function is appropriate? Why or why not? 2. Repeat step 1 above using a quadratic function 3. Repeat step 1 above using an exponential function 4. Comment on the function that best models Facebook's net income as a function of time a. Using the best model, come up with a table showing the projected annual profits for Facebook for years 2019 to 2030 Start at: Create a new Sections allow and footer, NOTES: 1. You should have a separate Tab for each question (four tabs in total) 2. Be neat and organized 3. Format your data appropriately I 4. If you need help, seek help early 6. Save your work in the format: "Excel HW2 LASTNAME