Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to know what excel formulas I have to use for each question. The blue boxes and grey boxes need to be filled out
I need to know what excel formulas I have to use for each question.
The blue boxes and grey boxes need to be filled out with the correct formulas
this is the only data I was given
The purp 801 411 0.09558 1139 11.29 -4.00 12.54 11072 13105104 13.14 4.000 1941 OSS 11.08.10717 Bute SAP LORE 10:30 106.19 11/200 101 005716 12/1/00 1111 001777 1.410 10737 - 2/1/00 1104 BOOKS V 116.43 00 4/10116, 0.01476 5910108941408198 6100 1001 11016 8310104933 404745 11412 0735 10/1/10 11126 11/110 115 12/170 13744 1/11 1386.12 M 2/1/11 1327.22 0.00196 193589 000105 4/ 136.61 DSO 11452001180 61/10 1320.64 0.0136 71/1 120328-000147 121889 008679 W 1131,42 -07176 10 111 1335010 110 16514 137 0211 13003132 15 21 113 0719 11.14 I DI 11:41 36 137 3830 4-Test STY, LUV Value 20 sreg Sresid Reject H, Reject 4 TIN SAYIS Dale Purp 2 3 4 5 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 35 36 37 38 39 40 Date S&P 500 %Chg 10/5/09 1036.19 11/2/09 1095.63 0.05736 12/1/09 1115.1 0.01777 1/4/10 1073.87 -0.03697 2/1/10 1104.49 0.02851 3/1/10 1169.43 0.05880 4/1/10 1186.69 0.01476 5/3/10 1089.41 -0.08198 6/1/10 1030.71 -0.05388 7/1/10 1101.6 0.06878 8/2/10 1049.33 -0.04745 9/1/10 1141.2 0.08755 10/1/10 1183.26 0.03686 11/1/10 1180.55 -0.00229 12/1/10 1257.64 0.06530 1/3/11 1286.12 0.02265 2/1/11 1327.22 0.03196 3/1/11 1325.83 -0.00105 1363.61 0.02850 5/2/11 1345.2 -0.01350 6/1/11 1320.64 -0.01826 7/1/11 1292.28 -0.02147 8/1/11 1218.89 -0.05679 9/1/11 1131.42 -0.07176 10/3/11 1225.38 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 SP 500 vs. LUV m b t-Test Critical Value 2.021 sem seb R? sey F SSreg SSresid tm to Reject H, Reject H,? F29-G33: F34: G34:1 42 43 Optional IF/THEN Statement to Answer YES/NO F35: 45 46 Data Quiz1-LINEST + The purp 801 411 0.09558 1139 11.29 -4.00 12.54 11072 13105104 13.14 4.000 1941 OSS 11.08.10717 Bute SAP LORE 10:30 106.19 11/200 101 005716 12/1/00 1111 001777 1.410 10737 - 2/1/00 1104 BOOKS V 116.43 00 4/10116, 0.01476 5910108941408198 6100 1001 11016 8310104933 404745 11412 0735 10/1/10 11126 11/110 115 12/170 13744 1/11 1386.12 M 2/1/11 1327.22 0.00196 193589 000105 4/ 136.61 DSO 11452001180 61/10 1320.64 0.0136 71/1 120328-000147 121889 008679 W 1131,42 -07176 10 111 1335010 110 16514 137 0211 13003132 15 21 113 0719 11.14 I DI 11:41 36 137 3830 4-Test STY, LUV Value 20 sreg Sresid Reject H, Reject 4 TIN SAYIS Dale Purp 2 3 4 5 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 35 36 37 38 39 40 Date S&P 500 %Chg 10/5/09 1036.19 11/2/09 1095.63 0.05736 12/1/09 1115.1 0.01777 1/4/10 1073.87 -0.03697 2/1/10 1104.49 0.02851 3/1/10 1169.43 0.05880 4/1/10 1186.69 0.01476 5/3/10 1089.41 -0.08198 6/1/10 1030.71 -0.05388 7/1/10 1101.6 0.06878 8/2/10 1049.33 -0.04745 9/1/10 1141.2 0.08755 10/1/10 1183.26 0.03686 11/1/10 1180.55 -0.00229 12/1/10 1257.64 0.06530 1/3/11 1286.12 0.02265 2/1/11 1327.22 0.03196 3/1/11 1325.83 -0.00105 1363.61 0.02850 5/2/11 1345.2 -0.01350 6/1/11 1320.64 -0.01826 7/1/11 1292.28 -0.02147 8/1/11 1218.89 -0.05679 9/1/11 1131.42 -0.07176 10/3/11 1225.38 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 SP 500 vs. LUV m b t-Test Critical Value 2.021 sem seb R? sey F SSreg SSresid tm to Reject H, Reject H,? F29-G33: F34: G34:1 42 43 Optional IF/THEN Statement to Answer YES/NO F35: 45 46 Data Quiz1-LINEST + Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started