Set hedging strategies for each year on the last day of the year or the last day of data provided for the year

 evaluating the effectiveness of each strategy chosen in 2021.

Transcribed Image Text:

Excel File Edit View Insert Format Tools Data Window Help Home Insert Page Layout Formulas Data Review View Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx [mk [00:07:38 9% x qunh exel Wed 10:17 AM Q Search Sheet + Share Check for Updates M31 A B C D E F G H J K L M N P Q R S T U V 1 2 PX_LAST PX_SETTLE 3 1/1/21 140.88 4 1/8/21 148.45 147.63 157.95 SUMMARY OUTPUT 5 1/15/21 148.79 159.29 6 1/22/21 144.98 157.6 Regression Statistics PX SETTLE Line Fit Plot 7 1/29/21 145.34 160.04 Multiple R 0.16939613 8 2/5/21 158.87 171.37 R Square 0.02869505 9 2/12/21 163.14 177.14 Adjusted R Sq -0.0101572 10 2/19/21 168.29 182.29 11 2/26/21 169.65 185.65 Standard Erro 15.7488113 Observations 300 200 100 27 12 3/5/21 178.4 13 3/12/21 180.5 14 3/19/21 166.48 194.4 196.75 182.23 ANOVA 15 3/26/21 165.5 181 16 4/2/21 169.04 183.16 17 4/9/21 165.51 180.76 df SS MS Regression Residual Total 1 183.183735 183.183735 0.73856947 25 6200.62646 248.025058 26 6383.81019 Significance F 0.39828557 0 *PX_LAST Predicted PX_LAST 50 100 150 200 250 PX_SETTLE 18 4/16/21 174.44 189.57 19 4/23/21 171.73 187.35 20 4/30/21 174.61 192.11 21 5/7/21 180.56 201.06 Intercept PX_SETTLE Coefficients standard Error t Stat 176.140578 9.7266577 18.1090548 P-value 6.9404E-16 Lower 95% 156.108151 Upper 95% Lower 95.0% Upper 95.0% 196.173004 156.108151 196.173004 -0.052553 0.06115077 -0.8594006 0.39828557 -0.1784954 0.07338935 -0.1784954 0.07338935 22 5/14/21 181.59 200.09 23 5/21/21 199.75 62.61 24 5/28/21 153.81 64.32 25 6/4/21 169.19 66.07 RESIDUAL OUTPUT 26 6/11/21 186.10 71.07 27 6/18/21 204.72 76.23 Observation edicted PX LA 28 6/25/21 157.63 75.95 29 7/2/21 173.40 77.10 30 1 168.382177 2 167.83983 Residuals -27.502177 -19.38983 3 167.769409 -18.979409 32 33 34 35 36 Ready Jet Fuel Prices 2019 2020 2021 OCT 13 4 167.858224 -22.878224 5 167.729994 -22.389994 6 167.134569 -8.2645687 7 166.831338 -3.6913378 8 166.56069 1.72931016 9 166.384112 3.26588827 16 166 179104 26190606 Sheet5 Ad Window Keep Open to VPN Sheet6 Sheet7 Commodity Sheet4 + TOO? A W X 100% Excel File Edit View Insert Format Tools Data Window Help Home Insert Page Layout Formulas Data Review View Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx [mk [00:07:38 9% x qunh exel Wed 10:17 AM Q Search Sheet + Share Check for Updates M31 A B C D E F G H J K L M N P Q R S T U V 1 2 PX_LAST PX_SETTLE 3 1/1/21 140.88 4 1/8/21 148.45 147.63 157.95 SUMMARY OUTPUT 5 1/15/21 148.79 159.29 6 1/22/21 144.98 157.6 Regression Statistics PX SETTLE Line Fit Plot 7 1/29/21 145.34 160.04 Multiple R 0.16939613 8 2/5/21 158.87 171.37 R Square 0.02869505 9 2/12/21 163.14 177.14 Adjusted R Sq -0.0101572 10 2/19/21 168.29 182.29 11 2/26/21 169.65 185.65 Standard Erro 15.7488113 Observations 300 200 100 27 12 3/5/21 178.4 13 3/12/21 180.5 14 3/19/21 166.48 194.4 196.75 182.23 ANOVA 15 3/26/21 165.5 181 16 4/2/21 169.04 183.16 17 4/9/21 165.51 180.76 df SS MS Regression Residual Total 1 183.183735 183.183735 0.73856947 25 6200.62646 248.025058 26 6383.81019 Significance F 0.39828557 0 *PX_LAST Predicted PX_LAST 50 100 150 200 250 PX_SETTLE 18 4/16/21 174.44 189.57 19 4/23/21 171.73 187.35 20 4/30/21 174.61 192.11 21 5/7/21 180.56 201.06 Intercept PX_SETTLE Coefficients standard Error t Stat 176.140578 9.7266577 18.1090548 P-value 6.9404E-16 Lower 95% 156.108151 Upper 95% Lower 95.0% Upper 95.0% 196.173004 156.108151 196.173004 -0.052553 0.06115077 -0.8594006 0.39828557 -0.1784954 0.07338935 -0.1784954 0.07338935 22 5/14/21 181.59 200.09 23 5/21/21 199.75 62.61 24 5/28/21 153.81 64.32 25 6/4/21 169.19 66.07 RESIDUAL OUTPUT 26 6/11/21 186.10 71.07 27 6/18/21 204.72 76.23 Observation edicted PX LA 28 6/25/21 157.63 75.95 29 7/2/21 173.40 77.10 30 1 168.382177 2 167.83983 Residuals -27.502177 -19.38983 3 167.769409 -18.979409 32 33 34 35 36 Ready Jet Fuel Prices 2019 2020 2021 OCT 13 4 167.858224 -22.878224 5 167.729994 -22.389994 6 167.134569 -8.2645687 7 166.831338 -3.6913378 8 166.56069 1.72931016 9 166.384112 3.26588827 16 166 179104 26190606 Sheet5 Ad Window Keep Open to VPN Sheet6 Sheet7 Commodity Sheet4 + TOO? A W X 100%