Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed
image text in transcribed
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

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

Venture Capital And The Finance Of Innovation

Authors: Andrew Metrick, Ayako Yasuda

3rd Edition

1119490111, 978-1119490111

More Books

Students also viewed these Finance questions

Question

What laws were probably being violated?

Answered: 1 week ago