Question

1 Approved Answer

Posted on Sep 29, 2024

I need help with this. Excel Linest. Thank you very much! %Chg Date 10/5/09 11/2/09 12/1/09 1/4/10 2/1/10 3/1/10 4/1/10 5/3/10 6/1/10 7/1/10 8/2/10 9/1/10

I need help with this. Excel Linest. Thank you very much! image text in transcribed

%Chg Date 10/5/09 11/2/09 12/1/09 1/4/10 2/1/10 3/1/10 4/1/10 5/3/10 6/1/10 7/1/10 8/2/10 9/1/10 10/1/10 11/1/10 12/1/10 1/3/11 2/1/11 3/1/11 4/1/11 5/2/11 6/1/11 7/1/11 8/1/11 9/1/11 10/3/11 S&P 500 1036.19 1095.63 1115.1 1073.87 1104.49 1169.43 1186.69 1089.41 1030.71 1101.6 1049.33 1141.2 1183.26 1180.55 1257.64 1286.12 1327.22 1325.83 1363.61 1345.2 1320.64 1292.28 1218.89 1131.42 1225.38 0.05736 0.01777 -0.03697 0.02851 0.05880 0.01476 -0.08198 -0.05388 0.06878 -0.04745 0.08755 0.03686 -0.00229 0.06530 0.02265 0.03196 -0.00105 0.02850 -0.01350 -0.01826 -0.02147 -0.05679 -0.07176 0.08305 LUV %Chg 8.37 9.17 0.09558 11.39 0.24209 11.29 -0.00878 12.54 0.11072 13.18 0.05104 13.14 -0.00303 12.41 -0.05556 11.08 -0.10717 12.02 0.08484 11.03 -0.08236 13.05 0.18314 13.73 0.05211 13.3 -0.03132 12.96 -0.02556 11.83 -0.08719 11.81 -0.00169 12.62 0.06859 11.74 -0.06973 11.82 0.00681 11.41 -0.03469 9.95 -0.12796 8.62 -0.13367 8.04 -0.06729 8.82 0.09701 E t-Test Critical Value 2.021 SP 500 vs. LUV b sem seb R2 sey F df Ssreg SSresid tm tb Reject Ho? Reject HO? F29-G33: F34: G34: Optional IF/THEN Statement to Answer YES/NO F35: E 1 K M 1 3 - MONO 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 B D Date S&P 500 %Chg 1036:19 1095.63 0.05736 1113.1 0.01777 1/4/2010 1073.87 -0.03697 2/1/2010 1104.49 0.02851 3/1/2010 1169.43 0.05880 4/1/2010 1186.69 0.01476 5/3/2010 1089.41 -0.08198 6/1/2010 1030.71 -0.05388 7/1/2010 1101.6 0.06878 822010 1049.33 -0.04745 9/1/2010 11412 0.08755 1183.26 0.03686 1180.55 -0.00229 1257.64 0.06530 1/3/2011 1286.12 0.02265 2/1/2011 132722 0.03196 3/1/2011 1325.83 -0.00105 4/1/2011 1363.61 0.02850 5/2/2011 1345.2 -0.01350 6/1/2011 1320.64 -0.01826 7/1/2011 1292.28 -0.02147 8/1/2011 1218.89 -0.05679 9/1/2011 1131.42 -0.07176 1225.38 0.08305 F G LUV %Chg 8.37 9.17 0.09558 11.39 0.24209 11.29 -0.00878 12.34 0.11072 13.18 0.05104 13.14 -0.00303 12.41 -0.05556 11.08 -0.10717 12.02 0.08484 11.03 -0.08236 13.05 0.18314 13.73 0.05211 13.3 -0.03132 12.96 -0.02556 11.83 -0.08719 11.81 -0.00169 12.62 0.06859 11.74 -0.06973 11.82 0.00681 11.41 -0.03469 9.95 -0.12796 8.62 -0.13367 8.04 -0.06729 8.82 0.09701 SP 500 vs. LUV t-Test Critical Value b sen = se. R? 2.021 se, SSreg t. dt SSresid to ni Clipboard Font Alignment Number S > F29 f E G H J K L M N an B D Date S&P 500 %Chg 1183.26 0.03686 ### 1180.55 -0.00229 WM 1257.64 0.06530 1/3/2011 1286.12 0.02265 2/1/2011 1327.22 0.03196 3/1/2011 1325.83 -0.00105 4/1/2011 1363.61 0.02850 52/2011 1345.2 -0.01350 6/1/2011 1320.64 -0.01826 7/1/2011 1292.28 -0.02147 8/1/2011 1218.89 -0.05679 9/1/2011 1131.42 -0.07176 1225 38 0.08305 F G LUV %Chg 13.73 0.05211 13.3 -0.03132 12.96 -0.02556 11.83 -0.08719 11.81 -0.00169 12.62 0.06859 11.74 -0.06973 11.82 0.00681 11.41 -0.03469 9.95 -0.12796 8.62 -0.13367 8.04 -0.06729 8.82 0.09701 1 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 12 13 44 $$ 46 t-Test Critical Value 2.021 SP 500 vs, LUV m b sem se R sey F dt Ssreg ssresid to to Reject H, Reject H,? F29-G33: F34: G34: Optional IF/THEN Statement to Answer YES/NO F35: %Chg Date 10/5/09 11/2/09 12/1/09 1/4/10 2/1/10 3/1/10 4/1/10 5/3/10 6/1/10 7/1/10 8/2/10 9/1/10 10/1/10 11/1/10 12/1/10 1/3/11 2/1/11 3/1/11 4/1/11 5/2/11 6/1/11 7/1/11 8/1/11 9/1/11 10/3/11 S&P 500 1036.19 1095.63 1115.1 1073.87 1104.49 1169.43 1186.69 1089.41 1030.71 1101.6 1049.33 1141.2 1183.26 1180.55 1257.64 1286.12 1327.22 1325.83 1363.61 1345.2 1320.64 1292.28 1218.89 1131.42 1225.38 0.05736 0.01777 -0.03697 0.02851 0.05880 0.01476 -0.08198 -0.05388 0.06878 -0.04745 0.08755 0.03686 -0.00229 0.06530 0.02265 0.03196 -0.00105 0.02850 -0.01350 -0.01826 -0.02147 -0.05679 -0.07176 0.08305 LUV %Chg 8.37 9.17 0.09558 11.39 0.24209 11.29 -0.00878 12.54 0.11072 13.18 0.05104 13.14 -0.00303 12.41 -0.05556 11.08 -0.10717 12.02 0.08484 11.03 -0.08236 13.05 0.18314 13.73 0.05211 13.3 -0.03132 12.96 -0.02556 11.83 -0.08719 11.81 -0.00169 12.62 0.06859 11.74 -0.06973 11.82 0.00681 11.41 -0.03469 9.95 -0.12796 8.62 -0.13367 8.04 -0.06729 8.82 0.09701 E t-Test Critical Value 2.021 SP 500 vs. LUV b sem seb R2 sey F df Ssreg SSresid tm tb Reject Ho? Reject HO? F29-G33: F34: G34: Optional IF/THEN Statement to Answer YES/NO F35: E 1 K M 1 3 - MONO 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 B D Date S&P 500 %Chg 1036:19 1095.63 0.05736 1113.1 0.01777 1/4/2010 1073.87 -0.03697 2/1/2010 1104.49 0.02851 3/1/2010 1169.43 0.05880 4/1/2010 1186.69 0.01476 5/3/2010 1089.41 -0.08198 6/1/2010 1030.71 -0.05388 7/1/2010 1101.6 0.06878 822010 1049.33 -0.04745 9/1/2010 11412 0.08755 1183.26 0.03686 1180.55 -0.00229 1257.64 0.06530 1/3/2011 1286.12 0.02265 2/1/2011 132722 0.03196 3/1/2011 1325.83 -0.00105 4/1/2011 1363.61 0.02850 5/2/2011 1345.2 -0.01350 6/1/2011 1320.64 -0.01826 7/1/2011 1292.28 -0.02147 8/1/2011 1218.89 -0.05679 9/1/2011 1131.42 -0.07176 1225.38 0.08305 F G LUV %Chg 8.37 9.17 0.09558 11.39 0.24209 11.29 -0.00878 12.34 0.11072 13.18 0.05104 13.14 -0.00303 12.41 -0.05556 11.08 -0.10717 12.02 0.08484 11.03 -0.08236 13.05 0.18314 13.73 0.05211 13.3 -0.03132 12.96 -0.02556 11.83 -0.08719 11.81 -0.00169 12.62 0.06859 11.74 -0.06973 11.82 0.00681 11.41 -0.03469 9.95 -0.12796 8.62 -0.13367 8.04 -0.06729 8.82 0.09701 SP 500 vs. LUV t-Test Critical Value b sen = se. R? 2.021 se, SSreg t. dt SSresid to ni Clipboard Font Alignment Number S > F29 f E G H J K L M N an B D Date S&P 500 %Chg 1183.26 0.03686 ### 1180.55 -0.00229 WM 1257.64 0.06530 1/3/2011 1286.12 0.02265 2/1/2011 1327.22 0.03196 3/1/2011 1325.83 -0.00105 4/1/2011 1363.61 0.02850 52/2011 1345.2 -0.01350 6/1/2011 1320.64 -0.01826 7/1/2011 1292.28 -0.02147 8/1/2011 1218.89 -0.05679 9/1/2011 1131.42 -0.07176 1225 38 0.08305 F G LUV %Chg 13.73 0.05211 13.3 -0.03132 12.96 -0.02556 11.83 -0.08719 11.81 -0.00169 12.62 0.06859 11.74 -0.06973 11.82 0.00681 11.41 -0.03469 9.95 -0.12796 8.62 -0.13367 8.04 -0.06729 8.82 0.09701 1 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 12 13 44 $$ 46 t-Test Critical Value 2.021 SP 500 vs, LUV m b sem se R sey F dt Ssreg ssresid to to Reject H, Reject H,? F29-G33: F34: G34: Optional IF/THEN Statement to Answer YES/NO F35