Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 02, 2024

You need to return data, not price data: IBM return is dependent variable and S&P500 return is independent variable. (Why?) Date Adj Close Adj Close

You need to return data, not price data: IBM return is dependent variable and S&P500 return is independent variable. (Why?)

Date Adj Close Adj Close Returns (%)

IBM S&P500 (^GSPC) IBM S&P500 (^GSPC)

1/3/11 145.61 1271.87

1/4/11 145.77 1270.2 0.110% -0.131%

1/5/11 145.19 1276.56 -0.398% 0.501%

1/6/11 146.78 1273.85 1.095% -0.212%

1/7/11 146.05 1271.5 -0.497% -0.184%

1/10/11 145.77 1269.75 -0.192% -0.138%

1/11/11 145.41 1274.48 -0.247% 0.373%

1/12/11 147.21 1285.96 1.238% 0.901%

1/13/11 146.93 1283.76 -0.190% -0.171%

1/14/11 148.1 1293.24 0.796% 0.738%

1/18/11 148.74 1295.02 0.432% 0.138%

1/19/11 153.72 1281.92 3.348% -1.012%

1/20/11 153.82 1280.26 0.065% -0.129%

1/21/11 153.53 1283.35 -0.189% 0.241%

1/24/11 157.61 1290.84 2.657% 0.584%

1/25/11 159.39 1291.18 1.129% 0.026%

1/26/11 159 1296.63 -0.245% 0.422%

1/27/11 159.03 1299.54 0.019% 0.224%

1/28/11 157.19 1276.34 -1.157% -1.785%

1/31/11 159.95 1286.12 1.756% 0.766%

2/1/11 161.49 1307.59 0.963% 1.669%

2/2/11 161.23 1304.03 -0.161% -0.272%

2/3/11 161.46 1307.1 0.143% 0.235%

2/4/11 161.92 1310.87 0.285% 0.288%

2/7/11 162.73 1319.05 0.500% 0.624%

2/8/11 164.59 1324.57 1.143% 0.418%

2/9/11 163.21 1320.88 -0.838% -0.279%

2/10/11 162.65 1321.87 -0.343% 0.075%

2/11/11 162.41 1329.15 -0.148% 0.551%

2/14/11 161.79 1332.32 -0.382% 0.238%

2/15/11 161.41 1328.01 -0.235% -0.323%

2/16/11 161.97 1336.32 0.347% 0.626%

2/17/11 162.8 1340.43 0.512% 0.308%

2/18/11 163.39 1343.01 0.362% 0.192%

2/22/11 160.53 1315.44 -1.750% -2.053%

2/23/11 158.78 1307.4 -1.090% -0.611%

2/24/11 159.36 1306.1 0.365% -0.099%

2/25/11 160.86 1319.88 0.941% 1.055%

2/28/11 160.46 1327.22 -0.249% 0.556%

3/1/11 158.57 1306.33 -1.178% -1.574%

3/2/11 158.76 1308.44 0.120% 0.162%

3/3/11 162.05 1330.97 2.072% 1.722%

3/4/11 160.41 1321.15 -1.012% -0.738%

3/7/11 158.53 1310.13 -1.172% -0.834%

3/8/11 160.86 1321.82 1.470% 0.892%

3/9/11 164.41 1320.02 2.207% -0.136%

3/10/11 160.6 1295.11 -2.317% -1.887%

3/11/11 161.01 1304.28 0.255% 0.708%

3/14/11 159.97 1296.39 -0.646% -0.605%

3/15/11 157.63 1281.87 -1.463% -1.120%

3/16/11 151.66 1256.88 -3.787% -1.949%

3/17/11 152.83 1273.72 0.771% 1.340%

3/18/11 154.52 1279.21 1.106% 0.431%

3/21/11 156.3 1298.38 1.152% 1.499%

3/22/11 156.61 1293.77 0.198% -0.355%

3/23/11 158.13 1297.54 0.971% 0.291%

3/24/11 158.64 1309.66 0.323% 0.934%

3/25/11 160.76 1313.8 1.336% 0.316%

3/28/11 159.96 1310.19 -0.498% -0.275%

3/29/11 161.45 1319.44 0.931% 0.706%

3/30/11 162.17 1328.26 0.446% 0.668%

3/31/11 161.64 1325.83 -0.327% -0.183%

4/1/11 162.83 1332.41 0.736% 0.496%

4/4/11 162.81 1332.87 -0.012% 0.035%

4/5/11 162.55 1332.63 -0.160% -0.018%

4/6/11 162.6 1335.54 0.031% 0.218%

4/7/11 162.94 1333.51 0.209% -0.152%

4/8/11 162.61 1328.17 -0.203% -0.400%

4/11/11 162.51 1324.46 -0.061% -0.279%

4/12/11 161.82 1314.16 -0.425% -0.778%

4/13/11 162.51 1314.41 0.426% 0.019%

4/14/11 163.52 1314.52 0.622% 0.008%

4/15/11 164.75 1319.68 0.752% 0.393%

4/18/11 164.48 1305.14 -0.164% -1.102%

4/19/11 163.95 1312.62 -0.322% 0.573%

4/20/11 163.31 1330.36 -0.390% 1.351%

4/21/11 166.8 1337.38 2.137% 0.528%

4/25/11 166.2 1335.25 -0.360% -0.159%

4/26/11 167.01 1347.24 0.487% 0.898%

4/27/11 168.88 1355.66 1.120% 0.625%

4/28/11 169.28 1360.48 0.237% 0.356%

4/29/11 169.08 1363.61 -0.118% 0.230%

5/2/11 170.64 1361.22 0.923% -0.175%

5/3/11 171.35 1356.62 0.416% -0.338%

5/4/11 169.12 1347.32 -1.301% -0.686%

5/5/11 166.98 1335.1 -1.265% -0.907%

5/6/11 168.16 1340.2 0.707% 0.382%

5/9/11 168.37 1346.29 0.125% 0.454%

5/10/11 169.64 1357.16 0.754% 0.807%

5/11/11 168.77 1342.08 -0.513% -1.111%

5/12/11 171.49 1348.65 1.612% 0.490%

5/13/11 169.18 1337.77 -1.347% -0.807%

5/16/11 168.13 1329.47 -0.621% -0.620%

5/17/11 169.76 1328.98 0.969% -0.037%

5/18/11 169.7 1340.68 -0.035% 0.880%

5/19/11 169.85 1343.6 0.088% 0.218%

5/20/11 169.42 1333.27 -0.253% -0.769%

5/23/11 167.53 1317.37 -1.116% -1.193%

5/24/11 167.26 1316.28 -0.161% -0.083%

5/25/11 167.02 1320.47 -0.143% 0.318%

5/26/11 166.46 1325.69 -0.335% 0.395%

5/27/11 166.77 1331.1 0.186% 0.408%

5/31/11 168.2 1345.2 0.857% 1.059%

6/1/11 165.84 1314.55 -1.403% -2.278%

6/2/11 165.37 1312.94 -0.283% -0.122%

6/3/11 164.33 1300.16 -0.629% -0.973%

6/6/11 164.04 1286.17 -0.176% -1.076%

6/7/11 162.98 1284.94 -0.646% -0.096%

6/8/11 163.63 1279.56 0.399% -0.419%

6/9/11 164.13 1289 0.306% 0.738%

6/10/11 162.47 1270.98 -1.011% -1.398%

6/13/11 162.46 1271.83 -0.006% 0.067%

6/14/11 163.41 1287.87 0.585% 1.261%

6/15/11 161.63 1265.42 -1.089% -1.743%

6/16/11 161.96 1267.64 0.204% 0.175%

6/17/11 163.73 1271.5 1.093% 0.305%

6/20/11 164.3 1278.36 0.348% 0.540%

6/21/11 165.5 1295.52 0.730% 1.342%

6/22/11 164.96 1287.14 -0.326% -0.647%

6/23/11 165.4 1283.5 0.267% -0.283%

6/24/11 164.35 1268.45 -0.635% -1.173%

6/27/11 166.89 1280.1 1.545% 0.918%

6/28/11 169.27 1296.67 1.426% 1.294%

6/29/11 169.8 1307.41 0.313% 0.828%

6/30/11 170.81 1320.64 0.595% 1.012%

7/1/11 173.78 1339.67 1.739% 1.441%

7/5/11 174.67 1337.88 0.512% -0.134%

7/6/11 176.94 1339.22 1.300% 0.100%

7/7/11 175.71 1353.22 -0.695% 1.045%

7/8/11 175.72 1343.8 0.006% -0.696%

7/11/11 174.23 1319.49 -0.848% -1.809%

7/12/11 173.3 1313.64 -0.534% -0.443%

7/13/11 173.56 1317.72 0.150% 0.311%

7/14/11 173.47 1308.87 -0.052% -0.672%

7/15/11 174.78 1316.14 0.755% 0.555%

7/18/11 174.52 1305.44 -0.149% -0.813%

7/19/11 184.41 1326.73 5.667% 1.631%

7/20/11 182.85 1325.84 -0.846% -0.067%

7/21/11 184.1 1343.8 0.684% 1.355%

7/22/11 184.38 1345.02 0.152% 0.091%

7/25/11 182.9 1337.43 -0.803% -0.564%

7/26/11 182.14 1331.94 -0.416% -0.410%

7/27/11 180.56 1304.89 -0.867% -2.031%

7/28/11 181.01 1300.67 0.249% -0.323%

7/29/11 181.06 1292.28 0.028% -0.645%

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

Recommended Textbook for

Quantitative Financial Risk Management

Authors: Constantin Zopounidis, Emilios Galariotis

1st Edition

1118738187, 978-1118738184

More Books

Students also viewed these Finance questions

Question

★★★★★

Using Net Present Value (NPV), determine the proposal's appropriateness and economic viability. Answer the following in your report: Apply calculations to determine the proposal's appropriateness...

Answered: 1 week ago

Question

★★★★★

=+ (d) Show that eub- - > w(t)/(at) in a neighborhood of 0 and hence that [feist- ds - [{((s)/(as)) ds. Conclude that b ,, converges.

Answered: 1 week ago

Question

★★★★★

Expenditure analysis is used when fraud has been discovered or strongly suspected and the information to calculate a suspects income and expenditures can be obtained (. g., asset and liability...

Answered: 1 week ago

Question

★★★★★

Problem 25 See schedule for due date. You may develop your own working paper format (i.e. use the matrix format) or use the working papers provided. Deckers Corporation manufactures a single product....

Answered: 1 week ago

Question

★★★★★

On January 1 of Year 1, Congo Express Airways issued $3,500,000 of 7%, bonds that pay interest semiannually on January 1 and July 1. The bond issue price is $3,197,389 and the market rate of interest...

Answered: 1 week ago

Question

★★★★★

Solve the following optimization problems. (c) min z = f(x) = ln(x+x+1) subject to x = R. (d) max z = f(x) = 1 e subject to x = R.

Answered: 1 week ago

Question

★★★★★

No matter where you are in the Americas, the place where you live has a history tied to its Indigenous Community whose land you live on or work on. Using the link above, do a search on your own...

Answered: 1 week ago

Question

★★★★★

You be The Arbitrator" Remember, you are the Arbitrator, or judge and must follow the contract and the facts presented. Fully explain your ruling. 4.How do "school voucher programs" threaten public...

Answered: 1 week ago

Question

★★★★★

A company has three production departments P, Q and R and two service departments M and C . Following details in respect of indirect expenses incurred are furnished for a month : Indirect labour Rs....

Answered: 1 week ago

Question

★★★★★

Using the data for Project S and Project T below, conduct an Incremental IRR Analysis. MARR is 10% per year. S T First Cost -50,000 -75,000 Annual Cost -9,300 -3,000 Salvage 5,000 8,000 Value Life 5 5

Answered: 1 week ago

Question

★★★★★

2. Take a look at a piece of writing youve produced (an essay, your rsum, or a private Facebook message to a friend). Do you use high or low levels of abstraction? Is your choice of language...

Answered: 1 week ago

Question

★★★★★

4. Examine the language you use in mediated communication. Are there subtle ways in which you and your communication partners negotiate influence and create connectedness? Are any language choices...

Answered: 1 week ago

Question

★★★★★

1. Describe the power of nonverbal communication

Answered: 1 week ago

Previous Question Next Question

Date	Adj Close	Adj Close	Returns (%)
	IBM	S&P500 (^GSPC)	IBM	S&P500 (^GSPC)
1/3/11	145.61	1271.87
1/4/11	145.77	1270.2	0.110%	-0.131%
1/5/11	145.19	1276.56	-0.398%	0.501%
1/6/11	146.78	1273.85	1.095%	-0.212%
1/7/11	146.05	1271.5	-0.497%	-0.184%
1/10/11	145.77	1269.75	-0.192%	-0.138%
1/11/11	145.41	1274.48	-0.247%	0.373%
1/12/11	147.21	1285.96	1.238%	0.901%
1/13/11	146.93	1283.76	-0.190%	-0.171%
1/14/11	148.1	1293.24	0.796%	0.738%
1/18/11	148.74	1295.02	0.432%	0.138%
1/19/11	153.72	1281.92	3.348%	-1.012%
1/20/11	153.82	1280.26	0.065%	-0.129%
1/21/11	153.53	1283.35	-0.189%	0.241%
1/24/11	157.61	1290.84	2.657%	0.584%
1/25/11	159.39	1291.18	1.129%	0.026%
1/26/11	159	1296.63	-0.245%	0.422%
1/27/11	159.03	1299.54	0.019%	0.224%
1/28/11	157.19	1276.34	-1.157%	-1.785%
1/31/11	159.95	1286.12	1.756%	0.766%
2/1/11	161.49	1307.59	0.963%	1.669%
2/2/11	161.23	1304.03	-0.161%	-0.272%
2/3/11	161.46	1307.1	0.143%	0.235%
2/4/11	161.92	1310.87	0.285%	0.288%
2/7/11	162.73	1319.05	0.500%	0.624%
2/8/11	164.59	1324.57	1.143%	0.418%
2/9/11	163.21	1320.88	-0.838%	-0.279%
2/10/11	162.65	1321.87	-0.343%	0.075%
2/11/11	162.41	1329.15	-0.148%	0.551%
2/14/11	161.79	1332.32	-0.382%	0.238%
2/15/11	161.41	1328.01	-0.235%	-0.323%
2/16/11	161.97	1336.32	0.347%	0.626%
2/17/11	162.8	1340.43	0.512%	0.308%
2/18/11	163.39	1343.01	0.362%	0.192%
2/22/11	160.53	1315.44	-1.750%	-2.053%
2/23/11	158.78	1307.4	-1.090%	-0.611%
2/24/11	159.36	1306.1	0.365%	-0.099%
2/25/11	160.86	1319.88	0.941%	1.055%
2/28/11	160.46	1327.22	-0.249%	0.556%
3/1/11	158.57	1306.33	-1.178%	-1.574%
3/2/11	158.76	1308.44	0.120%	0.162%
3/3/11	162.05	1330.97	2.072%	1.722%
3/4/11	160.41	1321.15	-1.012%	-0.738%
3/7/11	158.53	1310.13	-1.172%	-0.834%
3/8/11	160.86	1321.82	1.470%	0.892%
3/9/11	164.41	1320.02	2.207%	-0.136%
3/10/11	160.6	1295.11	-2.317%	-1.887%
3/11/11	161.01	1304.28	0.255%	0.708%
3/14/11	159.97	1296.39	-0.646%	-0.605%
3/15/11	157.63	1281.87	-1.463%	-1.120%
3/16/11	151.66	1256.88	-3.787%	-1.949%
3/17/11	152.83	1273.72	0.771%	1.340%
3/18/11	154.52	1279.21	1.106%	0.431%
3/21/11	156.3	1298.38	1.152%	1.499%
3/22/11	156.61	1293.77	0.198%	-0.355%
3/23/11	158.13	1297.54	0.971%	0.291%
3/24/11	158.64	1309.66	0.323%	0.934%
3/25/11	160.76	1313.8	1.336%	0.316%
3/28/11	159.96	1310.19	-0.498%	-0.275%
3/29/11	161.45	1319.44	0.931%	0.706%
3/30/11	162.17	1328.26	0.446%	0.668%
3/31/11	161.64	1325.83	-0.327%	-0.183%
4/1/11	162.83	1332.41	0.736%	0.496%
4/4/11	162.81	1332.87	-0.012%	0.035%
4/5/11	162.55	1332.63	-0.160%	-0.018%
4/6/11	162.6	1335.54	0.031%	0.218%
4/7/11	162.94	1333.51	0.209%	-0.152%
4/8/11	162.61	1328.17	-0.203%	-0.400%
4/11/11	162.51	1324.46	-0.061%	-0.279%
4/12/11	161.82	1314.16	-0.425%	-0.778%
4/13/11	162.51	1314.41	0.426%	0.019%
4/14/11	163.52	1314.52	0.622%	0.008%
4/15/11	164.75	1319.68	0.752%	0.393%
4/18/11	164.48	1305.14	-0.164%	-1.102%
4/19/11	163.95	1312.62	-0.322%	0.573%
4/20/11	163.31	1330.36	-0.390%	1.351%
4/21/11	166.8	1337.38	2.137%	0.528%
4/25/11	166.2	1335.25	-0.360%	-0.159%
4/26/11	167.01	1347.24	0.487%	0.898%
4/27/11	168.88	1355.66	1.120%	0.625%
4/28/11	169.28	1360.48	0.237%	0.356%
4/29/11	169.08	1363.61	-0.118%	0.230%
5/2/11	170.64	1361.22	0.923%	-0.175%
5/3/11	171.35	1356.62	0.416%	-0.338%
5/4/11	169.12	1347.32	-1.301%	-0.686%
5/5/11	166.98	1335.1	-1.265%	-0.907%
5/6/11	168.16	1340.2	0.707%	0.382%
5/9/11	168.37	1346.29	0.125%	0.454%
5/10/11	169.64	1357.16	0.754%	0.807%
5/11/11	168.77	1342.08	-0.513%	-1.111%
5/12/11	171.49	1348.65	1.612%	0.490%
5/13/11	169.18	1337.77	-1.347%	-0.807%
5/16/11	168.13	1329.47	-0.621%	-0.620%
5/17/11	169.76	1328.98	0.969%	-0.037%
5/18/11	169.7	1340.68	-0.035%	0.880%
5/19/11	169.85	1343.6	0.088%	0.218%
5/20/11	169.42	1333.27	-0.253%	-0.769%
5/23/11	167.53	1317.37	-1.116%	-1.193%
5/24/11	167.26	1316.28	-0.161%	-0.083%
5/25/11	167.02	1320.47	-0.143%	0.318%
5/26/11	166.46	1325.69	-0.335%	0.395%
5/27/11	166.77	1331.1	0.186%	0.408%
5/31/11	168.2	1345.2	0.857%	1.059%
6/1/11	165.84	1314.55	-1.403%	-2.278%
6/2/11	165.37	1312.94	-0.283%	-0.122%
6/3/11	164.33	1300.16	-0.629%	-0.973%
6/6/11	164.04	1286.17	-0.176%	-1.076%
6/7/11	162.98	1284.94	-0.646%	-0.096%
6/8/11	163.63	1279.56	0.399%	-0.419%
6/9/11	164.13	1289	0.306%	0.738%
6/10/11	162.47	1270.98	-1.011%	-1.398%
6/13/11	162.46	1271.83	-0.006%	0.067%
6/14/11	163.41	1287.87	0.585%	1.261%
6/15/11	161.63	1265.42	-1.089%	-1.743%
6/16/11	161.96	1267.64	0.204%	0.175%
6/17/11	163.73	1271.5	1.093%	0.305%
6/20/11	164.3	1278.36	0.348%	0.540%
6/21/11	165.5	1295.52	0.730%	1.342%
6/22/11	164.96	1287.14	-0.326%	-0.647%
6/23/11	165.4	1283.5	0.267%	-0.283%
6/24/11	164.35	1268.45	-0.635%	-1.173%
6/27/11	166.89	1280.1	1.545%	0.918%
6/28/11	169.27	1296.67	1.426%	1.294%
6/29/11	169.8	1307.41	0.313%	0.828%
6/30/11	170.81	1320.64	0.595%	1.012%
7/1/11	173.78	1339.67	1.739%	1.441%
7/5/11	174.67	1337.88	0.512%	-0.134%
7/6/11	176.94	1339.22	1.300%	0.100%
7/7/11	175.71	1353.22	-0.695%	1.045%
7/8/11	175.72	1343.8	0.006%	-0.696%
7/11/11	174.23	1319.49	-0.848%	-1.809%
7/12/11	173.3	1313.64	-0.534%	-0.443%
7/13/11	173.56	1317.72	0.150%	0.311%
7/14/11	173.47	1308.87	-0.052%	-0.672%
7/15/11	174.78	1316.14	0.755%	0.555%
7/18/11	174.52	1305.44	-0.149%	-0.813%
7/19/11	184.41	1326.73	5.667%	1.631%
7/20/11	182.85	1325.84	-0.846%	-0.067%
7/21/11	184.1	1343.8	0.684%	1.355%
7/22/11	184.38	1345.02	0.152%	0.091%
7/25/11	182.9	1337.43	-0.803%	-0.564%
7/26/11	182.14	1331.94	-0.416%	-0.410%
7/27/11	180.56	1304.89	-0.867%	-2.031%
7/28/11	181.01	1300.67	0.249%	-0.323%
7/29/11	181.06	1292.28	0.028%	-0.645%