Question: please come up with original work, will thumbs up and greatly appreciate it. 2014 7.69 2015 Quarter Year Billions 4 2009 4 502 1 2010

2014 7.69 2015 Quarter Year Billions 4 2009 4 502 1 2010 5.695 2 2010 5.671 3 2010 5.176 4 2010 5.078 1 2011 5.914 2 2011 5.596 3 2011 5.204 4 2011 5.206 1 2012 6.31 2 2012 6.037 3 2012 S 551 4 2012 5.226 1 2013 6.476 2 2013 6.454 3 2013 5.932 4 2013 6,103 1 2014 7.733 2 2014 7331 4 2014 7.379 1 2015 9.046 2 8.393 3 2015 7.12 4 7.169 1 2016 8.267 2 8.044 3 2016 7.51 4 2016 7.525 1 2017 8.674 2 2017 8.426 3 10.19 4 2017 10.52 1 2018 12.74 2 2018 1225 3 2018 11.04 4 2018 11.14 1 2019 13.08 2 2019 12.34 3 11.46 4 2019 11.04 1 2020 12.75 2 2020 12.03 3 11.4 4 2020 10.58 1 2021 12.57 2 2021 11.98 3 2021 10.87 2015 2016 2017 2019 2020 5. You are provided with the task to predict your dream company's quarterly revenue for the next two years. Use the quarterly data provided in Excel in Question 5. a. In Excel, make sure you show your calculation steps clearly. In Word, explain your steps verbally b. In Word, write resulting regression model. c. Write your quarterly predictions for the next two years
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
