Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

First start the section with a short paragraph to introduce the regression analysis that's to be presented. I have selected 3 variables(Household Net Worth, Price

First start the section with a short paragraph to introduce the regression analysis that's to be presented.

I have selected 3 variables(Household Net Worth, Price Index, GDP) that I believe can be correlated with my company's revenue data. These variables are the independent variables Xs. The selection is based on your understanding and intuition. Please answer the questions using Mintab and pics I have attached.

image text in transcribedimage text in transcribedimage text in transcribed
Date Revenue observation_date Household Net worth observation_date Price Index observation_date GDP 1990-03-30 3019.0 1990-01-01 21521478.0 1990-01-01 65.0457 1990-01-01 5890.835 1990-06-29 3076.0 1990-03-30 21752807.0 1990-03-30 65.7180 1990-03-30 5974.665 1990-09-28 3099.0 1990-06-29 21513666.0 1990-06-29 66.3045 1990-06-29 6029.504 1990-12-31 3105.0 1990-09-28 21963685.0 1990-09-28 66.8052 1990-09-28 6023.332 1991-03-29 2996.0 1990-12-31 22589532.0 1990-12-31 67.4723 1990-12-31 6054.867 1991-06-28 3081.0 1991-03-29 22608903.0 1991-03-29 67.9335 1991-03-29 6143.612 1991-09-30 3104.0 1991-06-28 22857434.0 1991-06-28 68.4321 1991-06-28 6218.425 1991-12-31 3099.0 1991-09-30 23436274.0 1991-09-30 68.8026 1991-09-30 6279.296 1992-03-31 3019.0 1991-12-31 23505308.0 1991-12-31 69.0978 1991-12-31 6380.798 1992-06-30 3149.0 1992-03-31 23563597.0 1992-03-31 69.5392 1992-03-31 6492.299 1992-09-30 3167.0 1992-06-30 23868839.0 1992-06-30 69.8687 1992-06-30 6586.548 1992-12-31 3254.0 1992-09-30 24467107.0 1992-09-30 70.3425 1992-09-30 6697.553 1993-03-31 3163.0 1992-12-31 24804703.0 1992-12-31 70.7416 1992-12-31 6748.182 1993-06-30 3220.0 1993-03-31 25068991.0 1993-03-31 71.1720 1993-03-31 6829.594 1993-09-30 3290.0 1993-06-30 25417993.0 1993-06-30 71.6005 1993-06-30 6904.222 1993-12-31 3317.0 1993-09-30 25852224.0 1993-09-30 71.9731 1993-09-30 7032.844 1994-03-31 3373.0 1993-12-31 26002615.0 1993-12-31 72.3228 1993-12-31 7136.259 1994-06-30 3394.0 1994-03-31 26182739.0 1994-03-31 72.6827 1994-03-31 7269.847 1994-09-30 3415.0 1994-06-30 26530278.0 1994-06-30 73.0763 1994-06-30 7352.255 1994-12-30 3609.0 1994-09-30 26782212.0 1994-09-30 73.4789 1994-09-30 7476.661 1995-03-31 3450.0 1994-12-30 27352510.0 1994-12-30 73.9002 1994-12-30 7545.296 1995-06-30 3564.0 1995-03-31 27911844.0 1995-03-31 74.2249 1995-03-31 7604.923 1995-09-29 3261.0 1995-06-30 28566831.0 1995-06-30 74.5777 1995-06-30 7706.531 1995-12-29 3265.0 1995-09-29 29225945.0 1995-09-29 74.9462 1995-09-29 7799.493 1996-03-31 3208.0 1995-12-29 29868930.0 1995-12-29 75.3509 1995-12-29 7893.146 1996-06-30 3224.0 1996-03-31 30340234.0 1996-03-31 75.6378 1996-03-31 8061.535 1996-09-30 7377.0 1996-06-30 30628517.0 1996-06-30 75.8510 1996-06-30 8159.043 1996-12-31 7405.0 1996-09-30 30983429.0 1996-09-30 76.2362 1996-09-30 8287.078 1997-03-31 7416.0 1996-12-31 31411622.0 1996-12-31 76.7099 1996-12-31 8402.060 1997-06-30 7708.0 1997-03-31 32833702.0 1997-03-31 76.9168 1997-03-31 8551.940 1997-09-30 7374.0 1997-06-30 33935595.0 1997-06-30 77.1926 1997-06-30 8691.756 1997-12-31 7696.0 1997-09-30 34384612.0 1997-09-30 77.4487 1997-09-30 8788.320 1998-03-31 7651.0 1997-12-31 36185139.0 1997-12-31 77.5749 1997-12-31 8889.732 1998-06-30 7928.0 1998-03-31 36749561.0 1998-03-31 77.7373 1998-03-31 8994.738 1998-09-30 7910.0 1998-06-30 35841024.0 1998-06-30 78.0280 1998-06-30 9146.521 1998-12-31 8077.0 1998-09-30 38248426.0 1998-09-30 78.2719 1998-09-30 9325.6501999-03-31 7967.0 1998-12-31 38921820.0 1998-12-31 78.6626 1998-12-31 9447.103 1999-06-30 14510.0 1999-03-31 40138456.0 1999-03-31 78.9271 1999-03-31 9557.005 1999-09-30 14660.0 1999-06-30 39897452.0 1999-06-30 79.2125 1999-06-30 9712.280 1999-12-31 15260.0 1999-09-30 43022193.0 1999-09-30 79.5753 1999-09-30 9926.101 2000-03-31 14530.0 1999-12-31 44373672.0 1999-12-31 80.1833 1999-12-31 10031.031 2000-06-30 16770.0 2000-03-31 43992270.0 2000-03-31 80.6373 2000-03-31 10278.340 2000-09-30 16530.0 2000-06-30 44600255.0 2000-06-30 81.1599 2000-06-30 10357.445 2000-12-31 16870.0 2000-09-30 43667437.0 2000-09-30 81.5969 2000-09-30 10472.285 2001-03-31 16270.0 2000-12-31 42809902.0 2000-12-31 82.1090 2000-12-31 10508.121 2001-06-30 16910.0 2001-03-31 44105845.0 2001-03-31 82.6889 2001-03-31 10638.384 2001-09-30 17000.0 2001-06-30 42676651.0 2001-06-30 82.9598 2001-06-30 10639.486 2001-12-31 17010.0 2001-09-30 44237025.0 2001-09-30 83.2105 2001-09-30 10701.317 2002-03-31 16430.0 2001-12-31 44896200.0 2001-12-31 83.4768 2001-12-31 10834.445 2002-06-30 16750.0 2002-03-31 43939003.0 2002-03-31 83.7883 2002-03-31 10934.752 2002-09-30 17110.0 2002-06-30 42554629.0 2002-06-30 84.1623 2002-06-30 11037.057 2002-12-31 16910.0 2002-09-30 43750793.0 2002-09-30 84.6173 2002-09-30 11103.834 2003-03-31 16490.0 2002-12-31 43973087.0 2002-12-31 85.1385 2002-12-31 11230.078 2003-06-30 16830.0 2003-03-31 45876817.0 2003-03-31 85.4120 2003-03-31 11370.653 2003-09-30 17060.0 2003-06-30 46905688.0 2003-06-30 85.8844 2003-06-30 11625.137 2003-12-31 17200.0 2003-09-30 49260553.0 2003-09-30 86.2920 2003-09-30 11816.827 2004-03-31 17060.0 2003-12-31 51602486.0 2003-12-31 87.0445 2003-12-31 11988.403 2004-06-30 17760.0 2004-03-31 52802468.0 2004-03-31 87.8025 2004-03-31 12181.398 2004-09-30 18210.0 2004-06-30 53719467.0 2004-06-30 88.3422 2004-06-30 12367.744 2004-12-31 12730.0 2004-09-30 56292611.0 2004-09-30 88.9623 2004-09-30 12562.163 2005-03-31 18180.0 2004-12-31 57438104.0 2004-12-31 89.7863 2004-12-31 12813.729 2005-06-30 18050.0 2005-03-31 59033071.0 2005-03-31 90.4381 2005-03-31 12974.083 2005-09-30 18490.0 2005-06-30 60750363.0 2005-06-30 91.2833 2005-06-30 13205.445 2005-12-31 15300.0 2005-09-30 62439279.0 2005-09-30 91.9762 2005-09-30 13381.629 2006-03-31 21230.0 2005-12-31 64944840.0 2005-12-31 92.6996 2005-12-31 13648.904 2006-06-30 21890.0 2006-03-31 64850400.0 2006-03-31 93.4450 2006-03-31 13799.794 2006-09-30 22460.0 2006-06-30 65232982.0 2006-06-30 94.0972 2006-06-30 13908.498 2006-12-31 22610.0 2006-09-30 66732175.0 2006-09-30 94.4264 2006-09-30 14066.370 2007-03-31 22580.0 2006-12-31 67714174.0 2006-12-31 95.4871 2006-12-31 14233.226 2007-06-30 23270.0 2007-03-31 68216046.0 2007-03-31 96.0208 2007-03-31 14422.313 2007-09-30 23770.0 2007-06-30 68011978.0 2007-06-30 96.3541 2007-06-30 14569.675 2007-12-31 23840.0 2007-09-30 66738155.0 2007-09-30 96.7734 2007-09-30 14685.330 2008-03-31 23830.0 2007-12-31 64284680.0 2007-12-31 97.3261 2007-12-31 14668.445 2008-06-30 24120.0 2008-03-31 62894134.0 2008-03-31 97.8001 2008-03-31 14812.974 2008-09-30 24750.0 2008-06-30 60736703.0 2008-06-30 98.4707 2008-06-30 14842.983 2008-12-31 24640.0 2008-09-30 56418324.0 2008-09-30 98.6095 2008-09-30 14549.9492009-03-31 26590.0 2008-12-31 55139938.0 2008-12-31 98.8543 2008-12-31 14383.885 2009-06-30 26860.0 2009-03-31 56068327.0 2009-03-31 98.6885 2009-03-31 14340.417 2009-09-30 27260.0 2009-06-30 57479484.0 2009-06-30 98.6669 2009-06-30 14384.145 2009-12-31 27090.0 2009-09-30 58259589.0 2009-09-30 98.9603 2009-09-30 14566.511 2010-03-31 26910.0 2009-12-31 59206864.0 2009-12-31 99.3093 2009-12-31 14681.063 2010-06-30 26770.0 2010-03-31 58057677.0 2010-03-31 99.7492 2010-03-31 14888.600 2010-09-30 26480.0 2010-06-30 59513339.0 2010-06-30 100.2053 2010-06-30 15057.660 2010-12-31 26400.0 2010-09-30 61884339.0 2010-09-30 100.7189 2010-09-30 15230.208 2011-03-31 26990.0 2010-12-31 63246114.0 2010-12-31 101.1638 2010-12-31 15238.371 2011-06-30 27540.0 2011-03-31 63627907.0 2011-03-31 101.8994 2011-03-31 15460.926 2011-09-30 27910.0 2011-06-30 61371544.0 2011-06-30 102.5157 2011-06-30 15587.125 2011-12-31 28440.0 2011-09-30 62955679.0 2011-09-30 102.6628 2011-09-30 15785.312 2012-03-31 28240.0 2011-12-31 65522234.0 2011-12-31 103.2008 2011-12-31 15973.881 2012-06-30 28550.0 2012-03-31 65685147.0 2012-03-31 103.6759 2012-03-31 16121.851 2012-09-30 29010.0 2012-06-30 67644175.0 2012-06-30 104.1556 2012-06-30 16227.939 2012-12-31 30040.0 2012-09-30 68768505.0 2012-09-30 104.5465 2012-09-30 16297.349 2013-03-31 29420.0 2012-12-31 71788307.0 2012-12-31 104.9222 2012-12-31 16475.440 2013-06-30 29790.0 2013-03-31 73394564.0 2013-03-31 105.2031 2013-03-31 16541.390 2013-09-30 30280.0 2013-06-30 75820137.0 2013-06-30 105.6323 2013-06-30 16749.349 2013-12-31 31060.0 2013-09-30 78535735.0 2013-09-30 106.0064 2013-09-30 16999.888 2014-03-31 30820.0 2013-12-31 79963834.0 2013-12-31 106.3581 2013-12-31 17031.324 2014-06-30 31480.0 2014-03-31 81592556.0 2014-03-31 106.9247 2014-03-31 17320.921 2014-09-30 31590.0 2014-06-30 81824860.0 2014-06-30 107.2925 2014-06-30 17622.257 2014-12-31 33190.0 2014-09-30 83635097.0 2014-09-30 107.3358 2014-09-30 17735.933 2015-03-31 31980.0 2014-12-31 85370161.0 2014-12-31 107.3074 2014-12-31 17874.715 2015-06-30 32220.0 2015-03-31 86050886.0 2015-03-31 108.6000 2015-03-31 18093.224 2015-09-30 33160.0 2015-06-30 84835248.0 2015-06-30 109.0000 2015-06-30 18227.689 2015-12-31 34250.0 2015-09-30 86695652.0 2015-09-30 109.2000 2015-09-30 18287.226 2016-03-31 32170.0 2015-12-31 87211040.0 2015-12-31 109.2000 2015-12-31 18325.187 2016-06-30 30530.0 2016-03-31 88002627.0 2016-03-31 109.9000 2016-03-31 18538.039 2016-09-30 30940.0 2016-06-30 90228138.0 2016-06-30 110.3000 2016-06-30 18729.130 2016-12-31 32340.0 2016-09-30 92171568.0 2016-09-30 110.8000 2016-09-30 18905.545 2017-03-31 29810.0 2016-12-31 94498047.0 2016-12-31 111.4000 2016-12-31 19057.705 2017-06-30 30550.0 2017-03-31 96195586.0 2017-03-31 111.7000 2017-03-31 19250.009 2017-09-30 31720.0 2017-06-30 112.3000 2017-06-30 19508.986

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Maximum Principles And Geometric Applications

Authors: Luis J AlĂ­as, Paolo Mastrolia, Marco Rigoli

1st Edition

3319243373, 9783319243375

More Books

Students also viewed these Mathematics questions