Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I submitted the request early this morning and all I got back was to have it in a format that can be copied to excel....I

I submitted the request early this morning and all I got back was to have it in a format that can be copied to excel....I ask for suggestions and got no reply. This is the best I can do. I really need help on this problem set-up tonight Sunday 2/16/2020.

I tried to attach file but was unable.... any suggestions?

Hello experts I'm having a difficult time setting up a regression analysis in excel with the given data. I'm not sure which variable to use for a correlation test? Please help!

Question: Based on the recent 2007 to 2011 is there a reason to switch from WTI to Brent hedging?

Hint: Use the regression analysis and do a correlation test. Pick the one which has a higher regression coefficient.

WTI vs Brent

Jan-2009 1.416 41.73 44.17 1.437 0.422 0.364 (0.021)

Feb-2009 1.265 44.15 44.41 1.271 0.214 0.208 (0.006)

Mar-2009 1.341 49.64 46.13 1.336 0.159 0.243 0.005

Apr-2009 1.294 50.35 50.3 1.299 0.095 0.096 (0.005)

May-2009 1.672 66.31 64.98 1.636 0.093 0.125 0.036

Jun-2009 1.788 69.82 68.11 1.715 0.126 0.166 0.073

Jul-2009 1.831 69.26 70.08 1.793 0.182 0.162 0.038

Aug-2009 1.781 69.97 69.02 1.773 0.115 0.138 0.008

Sep-2009 1.794 70.46 65.82 1.805 0.116 0.227 (0.011)

Oct-2009 1.976 77.04 74.91 1.965 0.142 0.192 0.011

Nov-2009 2.004 77.19 77.77 1.984 0.166 0.152 0.020

Dec-2009 2.088 79.39 77.91 2.109 0.198 0.233 (0.021)

Jan-2010 1.91 72.85 71.2 1.894 0.175 0.215 0.016

Feb-2010 2.055 79.72 76.36 2.02 0.157 0.237 0.035

Mar-2010 2.188 83.45 80.37 2.162 0.201 0.274 0.026

Apr-2010 2.324 86.07 86.19 2.265 0.275 0.272 0.059

May-2010 2.039 74 73 2.006 0.277 0.301 0.033

Jun-2010 1.993 75.59 74.94 1.975 0.193 0.209 0.018

Jul-2010 2.093 78.85 77.5 2.038 0.216 0.248 0.055

Aug-2010 2.01 71.93 75.51 1.966 0.297 0.212 0.044

Sep-2010 2.239 79.95 80.77 2.239 0.335 0.316 0.000

Oct-2010 2.253 81.45 82.47 2.211 0.314 0.289 0.042

Nov-2010 2.291 84.12 86.02 2.288 0.288 0.243 0.003

Dec-2010 2.528 91.38 93.23 2.546 0.352 0.308 (0.018)

Jan-2011 2.742 90.99 98.97 2.723 0.576 0.386 0.019

Feb-2011 2.998 97.1 112.27 2.928 0.686 0.325 0.070

Mar-2011 3.161 106.19 116.94 3.098 0.633 0.377 0.063

Apr-2011 3.368 113.39 126.59 3.263 0.668 0.354 0.105

May-2011 3.134 102.7 117.18 3.049 0.689 0.344 0.085

Jun-2011 2.996 95.3 111.71 2.936 0.727 0.336 0.060

Jul-2011 3.161 95.68 115.93 3.086 0.883 0.401 0.075

Aug-2011 3.113 88.81 116.48 3.068 0.998 0.340 0.045

Sep-2011 2.844 78.93 105.42 2.781 0.965 0.334 0.063

Oct-2011 3.028 93.19 108.43 3.04 0.809 0.446 (0.012)

Nov-2011 3.001 100.36 111.22 3.012 0.611 0.353 (0.011)

Dec-2011 2.917 98.83 108.09 2.917 0.564 0.343 0.000

Hello experts I tried to attach file but was unable....suggestions

Hello experts I'm having a difficult time setting up a regression analysis in excel with the given data. I'm not sure which variable to use for a correlation test? Please help!

Question: Based on the recent 2007 to 2011 is there a reason to switch from WTI to Brent hedging?

Hint: Use the regression analysis and do a correlation test. Pick the one which has a higher regression coefficient.

Exhibit 6 2012 FUEL HEDGING AT JETBLUE AIRWAYS Jet Fuel, Heating Oil, WTI, and Brent Crude Oil Spot Prices, 2007-2011 (Mont Year Jan-2009 Feb-2009 Mar-2009 Apr-2009 May-2009 Jun-2009 Jul-2009 Aug-2009 Sep-2009 Oct-2009 Nov-2009 Dec-2009 Jan-2010 Feb

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

Research In Finance Volume 24

Authors: Andrew H. Chen

1st Edition

0762313773, 978-0762313778

More Books

Students also viewed these Finance questions

Question

Explain the forces that influence how people handle conflict

Answered: 1 week ago