ZuoTi.Pro
Question

If there are any seasonality or relationship between the price and the US oil price? How...

If there are any seasonality or relationship between the price and the US oil price? How to analyze?

Jan-10

2.769

Jan-11

3.148

Jan-12

3.44

Jan-13

3.391

Jan-14

3.392

Feb-10

2.699

Feb-11

3.264

Feb-12

3.64

Feb-13

3.736

Feb-14

3.434

Mar-10

2.824

Mar-11

3.615

Mar-12

3.907

Mar-13

3.779

Mar-14

3.606

Apr-10

2.9

Apr-11

3.852

Apr-12

3.958

Apr-13

3.638

Apr-14

3.735

May-10

2.89

May-11

3.96

May-12

3.791

May-13

3.675

May-14

3.75

Jun-10

2.785

Jun-11

3.735

Jun-12

3.596

Jun-13

3.689

Jun-14

3.766

Jul-10

2.782

Jul-11

3.705

Jul-12

3.498

Jul-13

3.661

Jul-14

3.688

Aug-10

2.783

Aug-11

3.696

Aug-12

3.78

Aug-13

3.645

Aug-14

3.565

Sep-10

2.757

Sep-11

3.667

Sep-12

3.91

Sep-13

3.604

Sep-14

3.484

Oct-10

2.853

Oct-11

3.506

Oct-12

3.812

Oct-13

3.42

Oct-14

3.255

Nov-10

2.913

Nov-11

3.443

Nov-12

3.521

Nov-13

3.322

Nov-14

2.997

Dec-10

3.048

Dec-11

3.326

Dec-12

3.381

Dec-13

3.357

Dec-14

2.632

Jan-15

2.208

Jan-16

2.057

Jan-17

2.458

Jan-18

2.671

Jan-19

2.338

Feb-15

2.301

Feb-16

1.872

Feb-17

2.416

Feb-18

2.705

Feb-19

2.393

Mar-15

2.546

Mar-16

2.071

Mar-17

2.437

Mar-18

2.709

Mar-19

2.594

Apr-15

2.555

Apr-16

2.216

Apr-17

2.528

Apr-18

2.873

Apr-19

2.881

May-15

2.802

May-16

2.371

May-17

2.503

May-18

2.987

May-19

2.946

Jun-15

2.885

Jun-16

2.467

Jun-17

2.46

Jun-18

2.97

Jun-19

2.804

Jul-15

2.88

Jul-16

2.345

Jul-17

2.414

Jul-18

2.928

Jul-19

2.823

Aug-15

2.726

Aug-16

2.284

Aug-17

2.494

Aug-18

2.914

Aug-19

2.707

Sep-15

2.462

Sep-16

2.327

Sep-17

2.761

Sep-18

2.915

Sep-19

2.681

Oct-15

2.387

Oct-16

2.359

Oct-17

2.621

Oct-18

2.943

Oct-19

2.724

Nov-15

2.26

Nov-16

2.295

Nov-17

2.678

Nov-18

2.736

Nov-19

2.693

Dec-15

2.144

Dec-16

2.366

Dec-17

2.594

Dec-18

2.457

Dec-19

2.645
business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The data can be written as follows for comparing the seasonality or relationship:

10-Jan 2.77 11-Jan 3.15 12-Jan 3.44 13-Jan 3.39 14-Jan 3.39 15-Jan 2.21 16-Jan 2.06 17-Jan 2.46 18-Jan 2.67 19-Jan 2.34
10-Feb 2.7 11-Feb 3.26 12-Feb 3.64 13-Feb 3.74 14-Feb 3.43 15-Feb 2.3 16-Feb 1.87 17-Feb 2.42 18-Feb 2.71 19-Feb 2.39
10-Mar 2.82 11-Mar 3.62 12-Mar 3.91 13-Mar 3.78 14-Mar 3.61 15-Mar 2.55 16-Mar 2.07 17-Mar 2.44 18-Mar 2.71 19-Mar 2.59
10-Apr 2.9 11-Apr 3.85 12-Apr 3.96 13-Apr 3.64 14-Apr 3.74 15-Apr 2.56 16-Apr 2.22 17-Apr 2.53 18-Apr 2.87 19-Apr 2.88
10-May 2.89 11-May 3.96 12-May 3.79 13-May 3.68 14-May 3.75 15-May 2.8 16-May 2.37 17-May 2.5 18-May 2.99 19-May 2.95
10-Jun 2.79 11-Jun 3.74 12-Jun 3.6 13-Jun 3.69 14-Jun 3.77 15-Jun 2.89 16-Jun 2.47 17-Jun 2.46 18-Jun 2.97 19-Jun 2.8
10-Jul 2.78 11-Jul 3.71 12-Jul 3.5 13-Jul 3.66 14-Jul 3.69 15-Jul 2.88 16-Jul 2.35 17-Jul 2.41 18-Jul 2.93 19-Jul 2.82
10-Aug 2.78 11-Aug 3.7 12-Aug 3.78 13-Aug 3.65 14-Aug 3.57 15-Aug 2.73 16-Aug 2.28 17-Aug 2.49 18-Aug 2.91 19-Aug 2.71
10-Sep 2.76 11-Sep 3.67 12-Sep 3.91 13-Sep 3.6 14-Sep 3.48 15-Sep 2.46 16-Sep 2.33 17-Sep 2.76 18-Sep 2.92 19-Sep 2.68
10-Oct 2.85 11-Oct 3.51 12-Oct 3.81 13-Oct 3.42 14-Oct 3.26 15-Oct 2.39 16-Oct 2.36 17-Oct 2.62 18-Oct 2.94 19-Oct 2.72
10-Nov 2.91 11-Nov 3.44 12-Nov 3.52 13-Nov 3.32 14-Nov 3 15-Nov 2.26 16-Nov 2.3 17-Nov 2.68 18-Nov 2.74 19-Nov 2.69
10-Dec 3.05 11-Dec 3.33 12-Dec 3.38 13-Dec 3.36 14-Dec 2.63 15-Dec 2.14 16-Dec 2.37 17-Dec 2.59 18-Dec 2.46 19-Dec 2.65

From the data, we can see that there is no seasonality pattern available in the table. In some years its mid year is having lows of the year and in some years year-ends are having lows of the year. In some years the prices are in raising trend and in some years prices are in declining trend.

There is also no relationship between the given data set.   

0 0
Add a comment
Know the answer?
Add Answer to:
If there are any seasonality or relationship between the price and the US oil price? How...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel....

    calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel. In a text box nearby, comment on whether investors’ trading decisions have created value. Month ADKSX Return (%) ADKSX Cash Flow ($) Nov-09 3.49 -$10,648,393 Dec-09 6.93 -$618,800 Jan-10 -2.05 $940,820 Feb-10 5.74 -$2,484,437 Mar-10 5.19 -$3,699,836 Apr-10 5.48 -$1,379,757 May-10 -4.68 $2,145,936 Jun-10 -6.31 -$2,953,884 Jul-10 5.9 -$4,160,472 Aug-10 -5.18 $1,096,304 Sep-10 8.61 -$5,571,657 Oct-10 4.5 -$669,464 Nov-10 2.77 -$3,145,367 Dec-10 9.16 -$6,162,018...

  • Calculate the sample correlation coefficient rxy. Calculate the value of the test statistic. Date Energy Healthcare...

    Calculate the sample correlation coefficient rxy. Calculate the value of the test statistic. Date Energy Healthcare Jan-10 -4.87 -0.15 Feb-10 1.8 0.53 Mar-10 2.26 1.41 Apr-10 3.03 -3.75 May-10 -11.5 -5.12 Jun-10 -5.67 -0.52 Jul-10 8.73 1.49 Aug-10 -5.99 -0.97 Sep-10 10.15 8.24 Oct-10 3.89 2.28 Nov-10 2.85 -2.52 Dec-10 5.55 1.4 Jan-11 6.6 1.55 Feb-11 5.7 3.04 Mar-11 1.32 1.22 Apr-11 1.64 5.89 May-11 -4.06 2.62 Jun-11 -2.08 -0.55 Jul-11 1.14 -2.64 Aug-11 -10.41 -2.8 Sep-11 -15.06 -4.17 Oct-11...

  • Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15,...

    Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15, 2010 2.079 80.06 Jan 22, 2010 2.010 76.62 Jan 29, 2010 1.942 73.94 Feb 05, 2010 1.885 74.57 Feb 12, 2010 1.908 73.88 Feb 19, 2010 2.031 78.25 Feb 26, 2010 2.042 79.22 Mar 05, 2010 2.127 80.19 Mar 12, 2010 2.154 81.76 Mar 19, 2010 2.150 81.44 Mar 26, 2010 2.118 80.65 Apr 02, 2010 2.191 83.01 Apr 09, 2010 2.238 85.66 Apr...

  • Consider five years of monthly sales data for a company in the attached file (Q5.xlsx). a) Foreca...

    Consider five years of monthly sales data for a company in the attached file (Q5.xlsx). a) Forecast monthly sales for the next year (2020). (10 marks) b) Discuss whether a simple exponential smoothing model works well with this data or not. (5 m 7 9 Month Sales 747 Feb-14 697 Mar-14 1014 Jan-14 Ap4 1126 May-14 1105 Jun-14 1450 Jul-14 1633 Aug-14 1711 Sep-14 1307 Oct-1223 Nov-14 9T5 Dec-14S53 4J-15 1024 Feb-15928 Mar-151442 7Apr-151371 May-15 1536 Ju15 2004 Jul-15 1854...

  • From the following monthly stock prices assume rf of 0.5% per month and calculate 1.Monthly growth...

    From the following monthly stock prices assume rf of 0.5% per month and calculate 1.Monthly growth return 2.CAPM and beta 3.Average return 4.Variance 5.Covariance 6. Assume a credit rating and calculate a VAT assuming debt to equity structure 1 date share price benchmark 2 Mar 18 3 Feb-18 4 Jan-18 5 Dec-17 6 Nov-17 7 Oct-17 8 Sep-17 304.85 24,263.35 322.3 25,107.40 354.4 27,379.45 315.15 25,539.45 306.9 25,332.40 314.25 25,019.35 350 24.053.00 350.61 24,318.40 361.9 25,103.65 292.7 23,211.20 286.27 23,424.80...

  • Use the data table to estimate the alpha of Nike and HP Inc. ​stock, expressed as​...

    Use the data table to estimate the alpha of Nike and HP Inc. ​stock, expressed as​ % per month. Monthly Returns Date Nike HP Inc. S&P 500 Jan-11 -3.442% 8.527% 2.330% Feb-11 7.941% -4.509% 3.474% Mar-11 -14.624% -5.913% -0.005% Apr-11 8.745% -1.465% 2.896% May-11 2.587% -7.406% -1.121% Jun-11 6.915% -2.301% -1.706% Jul-11 0.189% -3.379% -2.000% Aug-11 -3.882% -25.988% -5.498% Sep-11 -0.958% -13.292% -6.910% Oct-11 12.677% 18.530% 10.915% Nov-11 -0.176% 5.036% -0.406% Dec-11 0.572% -7.406% 1.024% Jan-12 7.907% 8.618% 4.637% Feb-12...

  • Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average...

    Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...

  • Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 De...

    Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...

  • Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14...

    Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...

  • On Blackboard under "Course Content / Homeworks and Practice Tests" there is an Excel file titled...

    On Blackboard under "Course Content / Homeworks and Practice Tests" there is an Excel file titled "HW 6 Data" with monthly stock return data to be used for this question: What is Deckers Outdoor Corporation's [DECK] beta? Round to two decimal places. [Hint: Take S&P 500 as a proxy for the market, and use the beta formula from the book. You will need to use two Excel functions: STDEV.S and CORREL] Numeric Answer S&PS00 DECK NKE SBUX -1.5% Ос-19 7.4%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT