Amazon's time trend. In this part of the assignment, you will analyze the effect of time on
Fantastic news! We've Found the answer you've been seeking!
Question:
Amazon's time trend.In this part of the assignment, you will analyze the effect of time on Amazon'squarterlyrevenue.Youwillbuildtworegressionsmodelinwhichtimeistheonlyindependentvariable.
- Linear trend model:the linear trend model is a simple linear regressionwith quarterly revenue(variableQR)asthedependentvariable,andtime(variablePeriod)astheonlyindependentvariable.
- Exponential trend model:the exponential trend model seeks to capture exponential growth overtime.Themodelisasimplelinearregressionwiththenaturallogarithmofquarterlyrevenue(variableLnQR) as the dependent variable, and time (variablePeriod) as the only independent variable. NoteherethatthevariableLnQRisnotinthedatasetandneedstobecreated.
Tocreatethenewvariable,followthefollowingsteps:
- IncellI1typethenewvariablenameLnQR.
- IncellI2computethenaturallogarithmofthequarterlyrevenueforthefirstperiod(Excelformula=LN(G2)andpressenter.
- DoubleclickonthebottomrightcornerofcellI2tocopyandpastetheformulatoallremainingperiods.
- Amazon quarterlyrevenue(1point)
Consider the linear trend model (dependent variable:QR, independent variable:Period), and use it toforecast Amazon's quarterly revenues for the fourth quarter of 2021. What is the forecast estimate inmillionofUSdollars?
| Date | Fiscal Year | Fiscal Quarter | Year and Quarter | Ticker Symbol | Company Name | QR | Period |
| 03/31/2001 | 2001 | 1 | 2001Q1 | AMZN | AMAZON.COM INC | 700.356 | 1 |
| 06/30/2001 | 2001 | 2 | 2001Q2 | AMZN | AMAZON.COM INC | 667.625 | 2 |
| 09/30/2001 | 2001 | 3 | 2001Q3 | AMZN | AMAZON.COM INC | 639.281 | 3 |
| 12/31/2001 | 2001 | 4 | 2001Q4 | AMZN | AMAZON.COM INC | 1,115.171 | 4 |
| 03/31/2002 | 2002 | 1 | 2002Q1 | AMZN | AMAZON.COM INC | 847.422 | 5 |
| 06/30/2002 | 2002 | 2 | 2002Q2 | AMZN | AMAZON.COM INC | 805.605 | 6 |
| 09/30/2002 | 2002 | 3 | 2002Q3 | AMZN | AMAZON.COM INC | 851.299 | 7 |
| 12/31/2002 | 2002 | 4 | 2002Q4 | AMZN | AMAZON.COM INC | 1,428.610 | 8 |
| 03/31/2003 | 2003 | 1 | 2003Q1 | AMZN | AMAZON.COM INC | 1,083.559 | 9 |
| 06/30/2003 | 2003 | 2 | 2003Q2 | AMZN | AMAZON.COM INC | 1,099.912 | 10 |
| 09/30/2003 | 2003 | 3 | 2003Q3 | AMZN | AMAZON.COM INC | 1,134.456 | 11 |
| 12/31/2003 | 2003 | 4 | 2003Q4 | AMZN | AMAZON.COM INC | 1,945.772 | 12 |
| 03/31/2004 | 2004 | 1 | 2004Q1 | AMZN | AMAZON.COM INC | 1,530.349 | 13 |
| 06/30/2004 | 2004 | 2 | 2004Q2 | AMZN | AMAZON.COM INC | 1,387.341 | 14 |
| 09/30/2004 | 2004 | 3 | 2004Q3 | AMZN | AMAZON.COM INC | 1,462.475 | 15 |
| 12/31/2004 | 2004 | 4 | 2004Q4 | AMZN | AMAZON.COM INC | 2,540.959 | 16 |
| 03/31/2005 | 2005 | 1 | 2005Q1 | AMZN | AMAZON.COM INC | 1,902.000 | 17 |
| 06/30/2005 | 2005 | 2 | 2005Q2 | AMZN | AMAZON.COM INC | 1,753.000 | 18 |
| 09/30/2005 | 2005 | 3 | 2005Q3 | AMZN | AMAZON.COM INC | 1,858.000 | 19 |
| 12/31/2005 | 2005 | 4 | 2005Q4 | AMZN | AMAZON.COM INC | 2,977.000 | 20 |
| 03/31/2006 | 2006 | 1 | 2006Q1 | AMZN | AMAZON.COM INC | 2,279.000 | 21 |
| 06/30/2006 | 2006 | 2 | 2006Q2 | AMZN | AMAZON.COM INC | 2,139.000 | 22 |
| 09/30/2006 | 2006 | 3 | 2006Q3 | AMZN | AMAZON.COM INC | 2,307.000 | 23 |
| 12/31/2006 | 2006 | 4 | 2006Q4 | AMZN | AMAZON.COM INC | 3,986.000 | 24 |
| 03/31/2007 | 2007 | 1 | 2007Q1 | AMZN | AMAZON.COM INC | 3,015.000 | 25 |
| 06/30/2007 | 2007 | 2 | 2007Q2 | AMZN | AMAZON.COM INC | 2,886.000 | 26 |
| 09/30/2007 | 2007 | 3 | 2007Q3 | AMZN | AMAZON.COM INC | 3,262.000 | 27 |
| 12/31/2007 | 2007 | 4 | 2007Q4 | AMZN | AMAZON.COM INC | 5,672.000 | 28 |
| 03/31/2008 | 2008 | 1 | 2008Q1 | AMZN | AMAZON.COM INC | 4,135.000 | 29 |
| 06/30/2008 | 2008 | 2 | 2008Q2 | AMZN | AMAZON.COM INC | 4,063.000 | 30 |
| 09/30/2008 | 2008 | 3 | 2008Q3 | AMZN | AMAZON.COM INC | 4,265.000 | 31 |
| 12/31/2008 | 2008 | 4 | 2008Q4 | AMZN | AMAZON.COM INC | 6,703.000 | 32 |
| 03/31/2009 | 2009 | 1 | 2009Q1 | AMZN | AMAZON.COM INC | 4,889.000 | 33 |
| 06/30/2009 | 2009 | 2 | 2009Q2 | AMZN | AMAZON.COM INC | 4,652.000 | 34 |
| 09/30/2009 | 2009 | 3 | 2009Q3 | AMZN | AMAZON.COM INC | 5,448.000 | 35 |
| 12/31/2009 | 2009 | 4 | 2009Q4 | AMZN | AMAZON.COM INC | 9,520.000 | 36 |
| 03/31/2010 | 2010 | 1 | 2010Q1 | AMZN | AMAZON.COM INC | 7,131.000 | 37 |
| 06/30/2010 | 2010 | 2 | 2010Q2 | AMZN | AMAZON.COM INC | 6,566.000 | 38 |
| 09/30/2010 | 2010 | 3 | 2010Q3 | AMZN | AMAZON.COM INC | 7,560.000 | 39 |
| 12/31/2010 | 2010 | 4 | 2010Q4 | AMZN | AMAZON.COM INC | 12,947.000 | 40 |
| 03/31/2011 | 2011 | 1 | 2011Q1 | AMZN | AMAZON.COM INC | 9,857.000 | 41 |
| 06/30/2011 | 2011 | 2 | 2011Q2 | AMZN | AMAZON.COM INC | 9,913.000 | 42 |
| 09/30/2011 | 2011 | 3 | 2011Q3 | AMZN | AMAZON.COM INC | 10,876.000 | 43 |
| 12/31/2011 | 2011 | 4 | 2011Q4 | AMZN | AMAZON.COM INC | 17,431.000 | 44 |
| 03/31/2012 | 2012 | 1 | 2012Q1 | AMZN | AMAZON.COM INC | 13,185.000 | 45 |
| 06/30/2012 | 2012 | 2 | 2012Q2 | AMZN | AMAZON.COM INC | 12,834.000 | 46 |
| 09/30/2012 | 2012 | 3 | 2012Q3 | AMZN | AMAZON.COM INC | 13,806.000 | 47 |
| 12/31/2012 | 2012 | 4 | 2012Q4 | AMZN | AMAZON.COM INC | 21,268.000 | 48 |
| 03/31/2013 | 2013 | 1 | 2013Q1 | AMZN | AMAZON.COM INC | 16,070.000 | 49 |
| 06/30/2013 | 2013 | 2 | 2013Q2 | AMZN | AMAZON.COM INC | 15,704.000 | 50 |
| 09/30/2013 | 2013 | 3 | 2013Q3 | AMZN | AMAZON.COM INC | 17,091.000 | 51 |
| 12/31/2013 | 2013 | 4 | 2013Q4 | AMZN | AMAZON.COM INC | 25,587.000 | 52 |
| 03/31/2014 | 2014 | 1 | 2014Q1 | AMZN | AMAZON.COM INC | 19,741.000 | 53 |
| 06/30/2014 | 2014 | 2 | 2014Q2 | AMZN | AMAZON.COM INC | 19,340.000 | 54 |
| 09/30/2014 | 2014 | 3 | 2014Q3 | AMZN | AMAZON.COM INC | 20,578.000 | 55 |
| 12/31/2014 | 2014 | 4 | 2014Q4 | AMZN | AMAZON.COM INC | 29,329.000 | 56 |
| 03/31/2015 | 2015 | 1 | 2015Q1 | AMZN | AMAZON.COM INC | 22,717.000 | 57 |
| 06/30/2015 | 2015 | 2 | 2015Q2 | AMZN | AMAZON.COM INC | 23,184.000 | 58 |
| 09/30/2015 | 2015 | 3 | 2015Q3 | AMZN | AMAZON.COM INC | 25,358.000 | 59 |
| 12/31/2015 | 2015 | 4 | 2015Q4 | AMZN | AMAZON.COM INC | 35,747.000 | 60 |
| 03/31/2016 | 2016 | 1 | 2016Q1 | AMZN | AMAZON.COM INC | 29,128.000 | 61 |
| 06/30/2016 | 2016 | 2 | 2016Q2 | AMZN | AMAZON.COM INC | 30,404.000 | 62 |
| 9/30/2016 | 2016 | 3 | 2016Q3 | AMZN | AMAZON.COM INC | 32,714.000 | 63 |
| 12/31/2016 | 2016 | 4 | 2016Q4 | AMZN | AMAZON.COM INC | 43,741.000 | 64 |
| 3/31/2017 | 2017 | 1 | 2017Q1 | AMZN | AMAZON.COM INC | 35,714.000 | 65 |
| 6/30/2017 | 2017 | 2 | 2017Q2 | AMZN | AMAZON.COM INC | 37,955.000 | 66 |
| 9/30/2017 | 2017 | 3 | 2017Q3 | AMZN | AMAZON.COM INC | 43,744.000 | 67 |
| 12/31/2017 | 2017 | 4 | 2017Q4 | AMZN | AMAZON.COM INC | 60,453.000 | 68 |
| 3/31/2018 | 2018 | 1 | 2018Q1 | AMZN | AMAZON.COM INC | 51,042.000 | 69 |
| 6/30/2018 | 2018 | 2 | 2018Q2 | AMZN | AMAZON.COM INC | 52,886.000 | 70 |
| 09/30/2018 | 2018 | 3 | 2018Q3 | AMZN | AMAZON.COM INC | 56,576.000 | 71 |
| 12/31/2018 | 2018 | 4 | 2018Q4 | AMZN | AMAZON.COM INC | 72,383.000 | 72 |
| 03/31/2019 | 2019 | 1 | 2019Q1 | AMZN | AMAZON.COM INC | 59,700.000 | 73 |
| 06/30/2019 | 2019 | 2 | 2019Q2 | AMZN | AMAZON.COM INC | 63,404.000 | 74 |
| 09/30/2019 | 2019 | 3 | 2019Q3 | AMZN | AMAZON.COM INC | 69,982.000 | 75 |
| 12/31/2019 | 2019 | 4 | 2019Q4 | AMZN | AMAZON.COM INC | 87,436.000 | 76 |
| 03/31/2020 | 2020 | 1 | 2020Q1 | AMZN | AMAZON.COM INC | 75,452.000 | 77 |
| 06/30/2020 | 2020 | 2 | 2020Q2 | AMZN | AMAZON.COM INC | 88,912.000 | 78 |
| 09/30/2020 | 2020 | 3 | 2020Q3 | AMZN | AMAZON.COM INC | 96,145.000 | 79 |
| 12/31/2020 | 2020 | 4 | 2020Q4 | AMZN | AMAZON.COM INC | 125,555.000 | 80 |
| 3/31/2021 | 2021 | 1 | 2021Q1 | AMZN | AMAZON.COM INC | 108,518.000 | 81 |
| 6/30/2021 | 2021 | 2 | 2021Q2 | AMZN | AMAZON.COM INC | 113,080.000 | 82 |
| 9/30/2021 | 2021 | 3 | 2021Q3 | AMZN | AMAZON.COM INC | 110,812.000 | 83 |
Expert Answer:
First lets calculate the necessary sums sum X 1 2 3 83 8383 12 3486 sum Y 700356 667625 ... View the full answer
Posted Date:
