Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
NM - got it! I had to use an ActiveX scroll bar. This is done!!
Task 1:
(1) The daily returns of five different stocks as well as the daily returns of the S&P 500 are given.
Convert the data to an Excel table and rename the table "TableDailyReturns." In the space provided,
give the reason for why the source data should be converted to an Excel table.
(2) Create a scatter plot of stock returns (y-axis) and market returns (S&P 500; x-axis) and use option
buttons to dynamically select the stock for the plot. (The y-axis should not move as a different stock is
selected.)
(3) Add a linear trend line (the characteristic line) that also displays R2 and equation.
(4) Make sure the chart title automatically changes when you select a different stock. The title must
include the company name and the beta of the stock selected. (For example, "Amazon Characteristic
Line with Beta = 1.62.")
Date
SnP500
Amazon
Boing
CitiGroup
Dunkin Donuts Ebay
1/2/2018
0.83%
1.67%
0.65%
-0.07%
1.68%
0.85%
1/3/2018
0.64%
1.28%
0.32%
0.31%
0.73%
3.05%
1/4/2018
0.40%
0.45%
-0.38%
1.23%
-1.64%
-1.66%
1/5/2018
0.70%
1.62%
4.10%
-0.13%
-0.85%
2.90%
1/8/2018
0.17%
1.44%
0.42%
-1.17%
-0.02%
0.28%
1/9/2018
0.13%
0.47%
2.67%
1.05%
-1.16%
-0.68%
1/10/2018
-0.11%
0.13%
0.57%
0.45%
-0.96%
-4.63%
1/11/2018
0.70%
1.78%
2.45%
-0.12%
0.27%
0.29%
1/12/2018
0.67%
2.23%
2.47%
1.69%
1.88%
0.56%
1/16/2018
-0.35%
-0.03%
-0.31%
0.35%
-1.07%
-0.89%
1/17/2018
0.94%
-0.76%
4.73%
0.47%
0.14%
0.82%
1/18/2018
-0.16%
-0.13%
-3.09%
-0.10%
2.04%
1.97%
1/19/2018
0.44%
0.10%
-0.71%
1.18%
-0.81%
-0.80%
1/22/2018
0.81%
2.53%
0.08%
0.37%
0.31%
2.99%
1/23/2018
0.22%
2.65%
-0.71%
-0.05%
2.96%
0.48%
1/24/2018
-0.06%
-0.37%
-0.27%
1.15%
1.48%
0.13%
1/25/2018
0.06%
1.51%
2.52%
-0.01%
1.05%
0.50%
1/26/2018
1.18%
1.75%
0.03%
0.81%
-0.29%
2.17%
1/29/2018
-0.67%
1.11%
-0.70%
-0.15%
-2.38%
-0.22%
1/30/2018
-1.09%
1.42%
-0.91%
-1.68%
-1.59%
-0.98%
1/31/2018
0.05%
0.91%
4.93%
-0.18%
-1.30%
0.45%
2/1/2018
-0.06%
-4.20%
0.73%
0.92%
-0.57%
13.82%
2/2/2018
-2.12%
2.87%
-2.25%
-2.75%
-3.02%
-4.09%
2/5/2018
-4.10%
-2.79%
-5.74%
-4.87%
-2.41%
-4.36%
2/6/2018
1.74%
3.80%
3.66%
2.12%
-1.86%
0.99%
2/7/2018
-0.50%
-1.81%
2.11%
0.23%
-1.42%
-1.08%
2/8/2018
-3.75%
-4.68%
-5.30%
-4.16%
0.51%
-3.09%
2/9/2018
1.49%
-0.81%
0.96%
2.52%
-1.00%
1.56%
2/12/2018
1.39%
3.48%
3.30%
1.47%
1.18%
1.58%
2/13/2018
0.26%
2.04%
-0.19%
0.56%
0.57%
-0.40%
2/14/2018
1.34%
2.58%
0.49%
2.04%
2.90%
0.69%
2/15/2018
2/16/2018
2/20/2018
2/21/2018
2/22/2018
2/23/2018
2/26/2018
2/27/2018
2/28/2018
3/1/2018
3/2/2018
3/5/2018
3/6/2018
3/7/2018
3/8/2018
3/9/2018
3/12/2018
3/13/2018
3/14/2018
3/15/2018
3/16/2018
3/19/2018
3/20/2018
3/21/2018
3/22/2018
3/23/2018
3/26/2018
3/27/2018
3/28/2018
3/29/2018
4/2/2018
4/3/2018
4/4/2018
4/5/2018
4/6/2018
4/9/2018
4/10/2018
4/11/2018
4/12/2018
4/13/2018
4/16/2018
4/17/2018
4/18/2018
4/19/2018
4/20/2018
4/23/2018
4/24/2018
1.21%
0.04%
-0.58%
-0.55%
0.10%
1.60%
1.18%
-1.27%
-1.11%
-1.33%
0.51%
1.10%
0.26%
-0.05%
0.45%
1.74%
-0.13%
-0.64%
-0.57%
-0.08%
0.17%
-1.42%
0.15%
-0.18%
-2.52%
-2.10%
2.72%
-1.73%
-0.29%
1.38%
-2.23%
1.26%
1.16%
0.69%
-2.19%
0.33%
1.67%
-0.55%
0.83%
-0.29%
0.81%
1.07%
0.08%
-0.57%
-0.85%
0.01%
-1.34%
0.74%
-0.89%
1.36%
0.99%
0.16%
0.99%
1.46%
-0.66%
0.03%
-1.26%
0.46%
1.56%
0.92%
0.48%
0.44%
1.74%
1.24%
-0.64%
0.18%
-0.55%
-0.67%
-1.70%
2.69%
-0.29%
-2.34%
-3.19%
4.03%
-3.78%
-4.38%
1.11%
-5.21%
1.46%
1.33%
2.92%
-3.20%
0.06%
2.14%
-0.64%
1.50%
-1.22%
0.75%
4.32%
1.60%
1.90%
-1.89%
-0.63%
-3.81%
3.37%
-0.40%
-0.48%
-0.28%
1.01%
0.21%
1.91%
0.32%
-0.67%
-3.46%
-1.44%
2.34%
-1.09%
-0.54%
0.49%
1.66%
-2.91%
-1.60%
-2.48%
-0.08%
0.15%
0.39%
1.77%
-0.16%
-5.19%
0.43%
2.48%
-2.39%
-0.34%
2.46%
-1.66%
2.60%
-1.02%
2.74%
-3.06%
-1.12%
3.83%
-2.23%
3.09%
-2.43%
0.76%
1.49%
1.27%
-0.11%
-0.58%
0.05%
-2.89%
0.48%
-0.34%
-0.47%
0.71%
-0.95%
1.06%
0.74%
-1.64%
-1.17%
-2.42%
0.03%
1.00%
-0.48%
-0.19%
0.26%
2.70%
-0.12%
-1.46%
-1.92%
-0.18%
0.18%
-1.05%
0.30%
0.55%
-4.11%
-3.43%
2.77%
-2.15%
-0.03%
-1.11%
0.31%
1.14%
1.21%
1.31%
-2.31%
1.22%
1.54%
-0.88%
3.21%
-1.55%
-1.32%
-0.47%
-1.09%
1.88%
-0.40%
-0.74%
-0.52%
4.16%
-1.94%
-0.78%
-2.33%
1.00%
1.09%
-0.16%
-0.94%
-2.30%
-2.47%
1.56%
0.22%
0.05%
-0.08%
0.99%
0.78%
-0.46%
-0.78%
-0.74%
-0.07%
0.79%
0.25%
0.95%
0.73%
-2.36%
-0.66%
2.69%
-2.01%
0.64%
-0.20%
-2.66%
1.46%
1.78%
0.27%
-0.78%
0.65%
0.23%
0.10%
0.83%
-0.74%
-0.15%
0.00%
0.63%
0.64%
-0.15%
0.79%
-0.29%
1.34%
0.77%
0.12%
-0.62%
-0.67%
1.98%
0.34%
-1.55%
-0.67%
-1.38%
1.61%
0.56%
-0.12%
1.83%
-0.57%
0.30%
0.21%
-2.46%
0.02%
-0.56%
-0.31%
-0.87%
-0.31%
-0.69%
-2.62%
-2.14%
3.27%
-1.93%
-0.27%
0.32%
-2.19%
0.64%
0.45%
0.60%
-2.35%
-0.54%
1.83%
0.61%
1.76%
-1.55%
0.73%
1.05%
2.81%
0.86%
0.21%
-1.42%
-1.01%
4/25/2018
4/26/2018
4/27/2018
4/30/2018
5/1/2018
5/2/2018
5/3/2018
5/4/2018
5/7/2018
5/8/2018
5/9/2018
5/10/2018
5/11/2018
5/14/2018
5/15/2018
5/16/2018
5/17/2018
5/18/2018
5/21/2018
5/22/2018
5/23/2018
5/24/2018
5/25/2018
5/29/2018
5/30/2018
5/31/2018
6/1/2018
6/4/2018
6/5/2018
6/6/2018
6/7/2018
6/8/2018
6/11/2018
6/12/2018
6/13/2018
6/14/2018
6/15/2018
6/18/2018
6/19/2018
6/20/2018
6/21/2018
6/22/2018
6/25/2018
6/26/2018
6/27/2018
6/28/2018
6/29/2018
0.18%
1.04%
0.11%
-0.82%
0.25%
-0.72%
-0.23%
1.28%
0.35%
-0.03%
0.97%
0.94%
0.17%
0.09%
-0.68%
0.41%
-0.09%
-0.26%
0.74%
-0.31%
0.32%
-0.20%
-0.24%
-1.16%
1.27%
-0.69%
1.08%
0.45%
0.07%
0.86%
-0.07%
0.31%
0.11%
0.17%
-0.40%
0.25%
-0.10%
-0.21%
-0.40%
0.17%
-0.63%
0.19%
-1.37%
0.22%
-0.86%
0.62%
0.08%
0.01%
3.96%
3.60%
-0.41%
1.03%
-0.80%
0.15%
0.56%
1.21%
-0.48%
0.98%
0.07%
-0.38%
-0.09%
-1.59%
0.71%
-0.35%
-0.47%
0.70%
-0.26%
1.29%
0.08%
0.44%
0.17%
0.75%
0.29%
0.73%
1.45%
1.87%
-0.04%
-0.38%
-0.31%
0.30%
0.57%
0.36%
1.11%
-0.46%
0.46%
0.64%
0.88%
-1.13%
-0.84%
-3.06%
1.68%
-1.81%
2.47%
-0.10%
4.19%
-0.02%
-0.56%
-2.15%
-1.21%
-1.62%
2.00%
1.13%
1.79%
-0.61%
1.81%
-0.12%
-0.47%
0.62%
-0.72%
-0.34%
0.93%
2.06%
3.61%
-2.45%
1.18%
-0.06%
0.30%
-2.11%
1.62%
-1.68%
1.29%
1.12%
-0.17%
3.18%
-0.82%
0.26%
0.39%
-0.09%
-1.83%
-0.39%
-1.25%
-0.88%
-3.84%
0.46%
-1.47%
0.37%
-2.27%
0.03%
-0.45%
1.46%
0.26%
0.35%
-0.26%
-0.27%
-1.04%
-0.03%
-0.38%
-0.07%
0.00%
0.82%
3.65%
1.34%
0.86%
0.40%
-0.33%
0.08%
-1.00%
-0.54%
-2.24%
0.67%
0.92%
-1.18%
-1.32%
-1.26%
-3.99%
1.48%
0.01%
0.88%
0.09%
-0.86%
2.20%
0.32%
0.03%
-0.53%
-0.73%
-0.47%
-1.68%
0.27%
0.62%
0.04%
0.90%
0.37%
-0.64%
-2.16%
0.85%
-1.28%
2.17%
0.06%
1.62%
-0.31%
-2.29%
0.59%
2.21%
-0.47%
-0.08%
2.81%
0.61%
1.03%
-1.24%
0.16%
1.70%
-0.08%
-0.22%
0.85%
0.49%
0.12%
0.27%
-1.13%
1.04%
0.06%
-1.36%
-2.13%
0.64%
-0.23%
-0.39%
1.05%
1.04%
1.58%
1.32%
0.54%
-0.45%
1.28%
0.04%
0.74%
0.09%
0.67%
-0.22%
0.00%
0.71%
0.62%
-0.79%
-0.40%
0.33%
-0.03%
-0.10%
-0.51%
-5.59%
-1.16%
-0.92%
-0.13%
-1.72%
1.24%
0.96%
-0.53%
0.79%
0.34%
0.71%
-0.62%
0.34%
-0.81%
0.71%
0.13%
0.00%
-0.29%
-1.36%
0.71%
-0.66%
0.40%
-1.08%
0.85%
-0.34%
1.64%
1.90%
2.48%
-0.22%
1.25%
-0.40%
0.50%
-0.10%
-2.77%
-0.84%
-0.28%
-0.08%
0.82%
0.20%
-3.18%
0.21%
-2.57%
-0.11%
-2.08%
-0.44%
0.33%
7/2/2018
7/2/2018
7/5/2018
7/6/2018
7/9/2018
7/10/2018
7/11/2018
7/12/2018
7/13/2018
7/16/2018
7/17/2018
7/18/2018
7/19/2018
7/20/2018
7/23/2018
7/24/2018
7/25/2018
7/26/2018
7/27/2018
7/30/2018
7/31/2018
8/1/2018
8/2/2018
8/3/2018
8/6/2018
8/7/2018
8/8/2018
8/9/2018
8/10/2018
8/13/2018
8/14/2018
8/15/2018
8/16/2018
8/17/2018
8/20/2018
8/21/2018
8/22/2018
8/23/2018
8/24/2018
8/27/2018
8/28/2018
8/29/2018
8/30/2018
8/31/2018
9/4/2018
9/5/2018
9/6/2018
0.31%
-0.49%
0.86%
0.85%
0.88%
0.35%
-0.71%
0.87%
0.11%
-0.10%
0.40%
0.22%
-0.40%
-0.09%
0.18%
0.48%
0.91%
-0.30%
-0.66%
-0.58%
0.49%
-0.10%
0.49%
0.46%
0.35%
0.28%
-0.03%
-0.14%
-0.71%
-0.40%
0.64%
-0.76%
0.79%
0.33%
0.24%
0.21%
-0.04%
-0.17%
0.62%
0.77%
0.03%
0.57%
-0.44%
0.01%
-0.17%
-0.28%
-0.37%
0.82%
-1.16%
0.34%
0.64%
1.66%
0.23%
0.68%
2.37%
0.91%
0.52%
1.18%
-0.05%
-1.63%
0.04%
-0.65%
1.51%
1.88%
-2.98%
0.51%
-2.09%
-0.10%
1.11%
2.07%
-0.60%
1.34%
0.80%
1.29%
0.64%
-0.64%
0.52%
1.24%
-1.93%
0.21%
-0.23%
-0.29%
0.36%
1.14%
-0.10%
0.13%
1.17%
0.27%
3.38%
0.21%
0.52%
1.33%
-2.19%
-1.83%
0.17%
-0.94%
0.08%
0.44%
2.18%
1.53%
-1.89%
1.59%
1.38%
1.51%
0.22%
0.94%
-1.36%
-0.12%
-0.46%
1.42%
-0.66%
0.96%
0.37%
-2.66%
1.49%
-0.99%
-0.86%
-0.37%
-0.54%
1.21%
-0.85%
-1.17%
-1.25%
-0.31%
0.23%
-2.18%
4.29%
0.12%
1.25%
0.86%
-1.06%
-0.73%
0.55%
1.25%
-0.72%
-0.29%
-0.94%
-1.18%
1.01%
0.12%
1.32%
0.36%
-1.64%
0.76%
0.87%
2.68%
-1.03%
-0.47%
0.88%
-2.20%
3.67%
-0.16%
0.72%
-1.23%
0.33%
1.43%
1.22%
0.91%
-0.53%
0.49%
0.84%
-0.55%
0.06%
-0.13%
0.77%
0.01%
0.01%
0.66%
-1.25%
-2.39%
-1.57%
1.23%
-1.94%
1.33%
0.16%
1.23%
1.01%
-0.17%
-0.44%
-0.20%
2.43%
-0.01%
0.21%
-1.48%
-0.31%
0.22%
-0.32%
-1.49%
-0.43%
-0.31%
0.64%
1.70%
0.54%
0.62%
0.42%
-0.97%
1.18%
0.34%
0.70%
-0.17%
0.28%
1.04%
-0.75%
-1.78%
-0.37%
0.41%
-2.26%
-1.01%
1.09%
0.07%
1.31%
-0.11%
-0.09%
0.51%
0.73%
0.43%
-0.15%
-1.43%
2.44%
-0.11%
0.29%
-0.08%
0.33%
-1.17%
0.08%
-0.22%
-0.22%
-0.04%
0.91%
-0.35%
-0.11%
1.63%
4.35%
-0.71%
0.33%
1.13%
-0.08%
1.06%
0.97%
1.39%
-2.29%
-0.16%
1.54%
0.16%
0.32%
0.21%
0.37%
-10.12%
0.26%
-1.20%
-0.80%
1.10%
1.59%
-1.80%
-0.41%
-0.65%
-1.08%
0.39%
1.32%
0.98%
-0.62%
0.18%
0.92%
-0.18%
-0.62%
1.53%
-1.57%
-0.27%
0.71%
0.03%
1.50%
0.49%
-0.86%
0.38%
0.14%
0.46%
0.55%
-0.37%
-0.55%
0.55%
-1.93%
-1.38%
9/7/2018
9/10/2018
9/11/2018
9/12/2018
9/13/2018
9/14/2018
9/17/2018
9/18/2018
9/19/2018
9/20/2018
9/21/2018
9/24/2018
9/25/2018
9/26/2018
9/27/2018
9/28/2018
10/1/2018
10/2/2018
10/3/2018
10/4/2018
10/5/2018
10/8/2018
10/9/2018
10/10/2018
10/11/2018
10/12/2018
10/15/2018
10/16/2018
10/17/2018
10/18/2018
10/19/2018
10/22/2018
10/23/2018
10/24/2018
10/25/2018
10/26/2018
10/29/2018
10/30/2018
10/31/2018
11/1/2018
11/2/2018
11/5/2018
11/6/2018
11/7/2018
11/8/2018
11/9/2018
11/12/2018
-0.22%
0.19%
0.37%
0.04%
0.53%
0.03%
-0.56%
0.54%
0.13%
0.78%
-0.04%
-0.35%
-0.13%
-0.33%
0.28%
0.00%
0.36%
-0.04%
0.07%
-0.82%
-0.55%
-0.04%
-0.14%
-3.29%
-2.06%
1.42%
-0.59%
2.15%
-0.03%
-1.44%
-0.04%
-0.43%
-0.55%
-3.09%
1.86%
-1.73%
-0.66%
1.57%
1.09%
1.06%
-0.63%
0.56%
0.63%
2.12%
-0.25%
-0.92%
-1.97%
-0.32%
-0.67%
2.48%
0.14%
-0.01%
-0.99%
-3.16%
1.73%
-0.75%
0.93%
-1.51%
1.01%
2.08%
0.02%
1.93%
-0.50%
0.07%
-1.65%
-0.94%
-2.22%
-1.04%
-1.34%
0.32%
-6.15%
-2.04%
4.03%
-1.55%
3.35%
0.65%
-3.33%
-0.38%
1.43%
-1.15%
-5.91%
7.09%
-7.82%
-6.33%
-0.55%
4.42%
4.23%
0.00%
-2.27%
0.92%
6.86%
-0.03%
-2.42%
-4.41%
-0.57%
-2.12%
0.99%
2.36%
0.58%
1.22%
-1.07%
2.14%
0.45%
0.61%
1.30%
-1.14%
-0.21%
-0.60%
0.65%
1.23%
2.79%
1.07%
1.53%
-0.59%
-0.90%
-0.18%
-0.09%
-4.66%
-2.55%
0.56%
-0.34%
2.61%
-0.75%
-1.68%
-0.86%
-0.08%
-1.67%
1.31%
2.57%
-1.24%
-6.59%
4.27%
1.41%
2.31%
-1.47%
1.18%
1.24%
1.51%
-0.34%
-0.39%
-3.33%
-0.67%
-0.01%
-0.29%
1.56%
-0.51%
0.56%
0.48%
0.68%
3.31%
1.45%
-0.86%
-0.42%
-0.45%
-1.44%
0.69%
-1.66%
0.26%
-0.18%
0.78%
0.36%
-0.28%
0.23%
-0.96%
-2.70%
-2.24%
2.14%
-0.90%
0.72%
0.19%
-1.75%
0.35%
-3.30%
-1.29%
-2.94%
1.83%
-1.17%
0.22%
0.28%
1.44%
0.57%
0.14%
2.09%
-0.92%
2.37%
-0.70%
-2.98%
-2.36%
0.99%
-0.27%
-0.63%
0.49%
-0.24%
-2.30%
-1.52%
0.97%
0.24%
0.14%
-1.12%
-0.65%
1.33%
0.26%
-0.12%
-0.23%
-1.30%
-1.48%
-0.86%
0.59%
-0.21%
0.28%
2.61%
-1.85%
-1.51%
1.48%
1.61%
1.41%
0.30%
-1.10%
-1.35%
-0.17%
0.11%
-3.06%
4.78%
-1.30%
-2.61%
3.50%
-1.04%
-1.16%
0.54%
-0.17%
1.32%
1.07%
1.42%
-0.35%
-1.50%
0.98%
-0.82%
1.19%
0.44%
0.53%
-0.99%
0.29%
-0.23%
0.29%
0.06%
-0.58%
-0.94%
-2.85%
2.50%
-0.71%
-0.96%
-1.54%
0.15%
0.58%
-0.37%
-1.20%
1.05%
2.15%
-4.84%
-0.85%
1.02%
0.44%
1.22%
-0.71%
-1.47%
-8.87%
-0.90%
-1.05%
-3.19%
2.82%
-2.57%
-1.90%
2.24%
5.87%
1.69%
1.19%
-0.77%
1.05%
-0.30%
-0.07%
-0.70%
-2.26%
11/13/2018
11/14/2018
11/15/2018
11/16/2018
11/19/2018
11/20/2018
11/21/2018
11/22/2018
11/26/2018
11/27/2018
11/28/2018
11/29/2018
11/30/2018
12/3/2018
12/4/2018
12/6/2018
12/7/2018
12/10/2018
12/11/2018
12/12/2018
12/13/2018
12/14/2018
12/17/2018
12/18/2018
12/19/2018
12/20/2018
12/21/2018
12/23/2018
12/26/2018
12/27/2018
12/28/2018
-0.15%
-0.76%
1.06%
0.22%
-1.66%
-1.82%
0.30%
-0.66%
1.55%
0.33%
2.30%
-0.22%
0.82%
1.09%
-3.24%
-0.15%
-2.33%
0.18%
-0.04%
0.54%
-0.02%
-1.91%
-2.08%
0.01%
-1.54%
-1.58%
-2.06%
-2.71%
4.96%
0.86%
-0.12%
-0.35%
-1.97%
1.28%
-1.61%
-5.09%
-1.11%
1.42%
-0.97%
5.28%
0.01%
6.09%
-0.25%
0.99%
4.86%
-5.87%
1.85%
-4.12%
0.73%
0.13%
1.24%
-0.31%
-4.01%
-4.46%
2.01%
-3.64%
-2.29%
-5.71%
-2.43%
9.45%
-0.63%
1.12%
-2.11%
-1.37%
-0.91%
-1.65%
-4.47%
-1.01%
-0.12%
-1.58%
1.29%
0.53%
4.86%
2.72%
1.23%
3.81%
-4.85%
-3.09%
-2.62%
0.97%
-1.32%
1.45%
-0.37%
-2.06%
-0.82%
3.77%
-2.59%
-2.03%
-2.72%
-3.41%
6.72%
1.02%
-0.24%
0.89%
-1.98%
1.73%
0.54%
-0.51%
-3.23%
0.54%
-1.78%
3.21%
-0.42%
3.34%
-1.04%
-0.17%
0.57%
-4.45%
-3.53%
-2.85%
-2.19%
-1.49%
-0.43%
-0.38%
-1.34%
-1.40%
-0.59%
-2.06%
-1.04%
-3.88%
-1.95%
4.43%
0.64%
0.12%
-1.47%
0.06%
-1.17%
2.41%
-2.68%
0.18%
0.36%
-0.92%
0.76%
0.10%
1.97%
0.70%
0.65%
1.07%
-2.22%
0.48%
-2.52%
0.31%
-2.63%
1.01%
0.18%
-1.92%
-3.92%
0.21%
-0.96%
-2.54%
-0.39%
-3.67%
3.78%
-1.31%
-0.02%
-2.97%
-0.75%
1.00%
-0.18%
-0.57%
0.72%
0.64%
0.35%
1.27%
-0.21%
3.55%
-0.81%
1.12%
1.17%
-3.11%
0.72%
-1.39%
-0.28%
0.24%
-0.03%
-0.07%
-0.38%
-1.49%
0.07%
-0.70%
-1.10%
-5.04%
-1.66%
6.54%
0.65%
0.75%
500 are given.
e space provided,
Type your answer to part (1) here:
With the data in table format, we can easily filter to see infomration from a specific date to
quickly see how the market performed on any given day.
is) and use option
a different stock is
ck. The title must
zon Characteristic
Amazon
Boeing Characteristic Line with Beta = -2
20.00%
15.00%
10.00%
5.00%
-6.00%
-4.00%
0.00%
-2.00%
0.00%
-5.00%
Boing
y = 1.309x + 0.0008
R² = 0.5039
CitiGroup
2.00%
-10.00%
Boing
4.00%
6.00%
Dunkin Donuts
Linear (Boing)
Ebay
CitiGroup
Dunkin Donuts
SnP500
0.83%
0.64%
0.40%
0.70%
0.17%
0.13%
-0.11%
0.70%
0.67%
-0.35%
0.94%
-0.16%
0.44%
0.81%
0.22%
-0.06%
0.06%
1.18%
-0.67%
-1.09%
0.05%
-0.06%
-2.12%
-4.10%
1.74%
-0.50%
-3.75%
1.49%
1.39%
0.26%
1.34%
1.21%
0.04%
-0.58%
-0.55%
0.10%
1.60%
1.18%
-1.27%
-1.11%
-1.33%
0.51%
1.10%
0.26%
-0.05%
0.45%
1.74%
-0.13%
-0.64%
-0.57%
-0.08%
0.17%
-1.42%
0.15%
-0.18%
-2.52%
-2.10%
2.72%
-1.73%
-0.29%
1.38%
-2.23%
1.26%
1.16%
0.69%
-2.19%
0.33%
1.67%
-0.55%
0.83%
-0.29%
0.81%
1.07%
0.08%
-0.57%
-0.85%
0.01%
-1.34%
0.18%
1.04%
0.11%
-0.82%
0.25%
-0.72%
-0.23%
1.28%
0.35%
-0.03%
0.97%
0.94%
0.17%
0.09%
-0.68%
0.41%
-0.09%
-0.26%
0.74%
-0.31%
0.32%
-0.20%
-0.24%
-1.16%
1.27%
-0.69%
1.08%
0.45%
0.07%
0.86%
-0.07%
0.31%
0.11%
0.17%
-0.40%
0.25%
-0.10%
-0.21%
-0.40%
0.17%
-0.63%
0.19%
-1.37%
0.22%
-0.86%
0.62%
0.08%
0.31%
-0.49%
0.86%
0.85%
0.88%
0.35%
-0.71%
0.87%
0.11%
-0.10%
0.40%
0.22%
-0.40%
-0.09%
0.18%
0.48%
0.91%
-0.30%
-0.66%
-0.58%
0.49%
-0.10%
0.49%
0.46%
0.35%
0.28%
-0.03%
-0.14%
-0.71%
-0.40%
0.64%
-0.76%
0.79%
0.33%
0.24%
0.21%
-0.04%
-0.17%
0.62%
0.77%
0.03%
0.57%
-0.44%
0.01%
-0.17%
-0.28%
-0.37%
-0.22%
0.19%
0.37%
0.04%
0.53%
0.03%
-0.56%
0.54%
0.13%
0.78%
-0.04%
-0.35%
-0.13%
-0.33%
0.28%
0.00%
0.36%
-0.04%
0.07%
-0.82%
-0.55%
-0.04%
-0.14%
-3.29%
-2.06%
1.42%
-0.59%
2.15%
-0.03%
-1.44%
-0.04%
-0.43%
-0.55%
-3.09%
1.86%
-1.73%
-0.66%
1.57%
1.09%
1.06%
-0.63%
0.56%
0.63%
2.12%
-0.25%
-0.92%
-1.97%
-0.15%
-0.76%
1.06%
0.22%
-1.66%
-1.82%
0.30%
-0.66%
1.55%
0.33%
2.30%
-0.22%
0.82%
1.09%
-3.24%
-0.15%
-2.33%
0.18%
-0.04%
0.54%
-0.02%
-1.91%
-2.08%
0.01%
-1.54%
-1.58%
-2.06%
-2.71%
4.96%
0.86%
-0.12%
Amazon Boing
CitiGroup Dunkin Donuts
Ebay
1.67%
0.65%
-0.07%
1.68%
0.85%
1.28%
0.32%
0.31%
0.73%
3.05%
0.45%
-0.38%
1.23%
-1.64%
-1.66%
1.62%
4.10%
-0.13%
-0.85%
2.90%
1.44%
0.42%
-1.17%
-0.02%
0.28%
0.47%
2.67%
1.05%
-1.16%
-0.68%
0.13%
0.57%
0.45%
-0.96%
-4.63%
1.78%
2.45%
-0.12%
0.27%
0.29%
2.23%
2.47%
1.69%
1.88%
0.56%
-0.03%
-0.31%
0.35%
-1.07%
-0.89%
-0.76%
4.73%
0.47%
0.14%
0.82%
-0.13%
-3.09%
-0.10%
2.04%
1.97%
0.10%
-0.71%
1.18%
-0.81%
-0.80%
2.53%
0.08%
0.37%
0.31%
2.99%
2.65%
-0.71%
-0.05%
2.96%
0.48%
-0.37%
-0.27%
1.15%
1.48%
0.13%
1.51%
2.52%
-0.01%
1.05%
0.50%
1.75%
0.03%
0.81%
-0.29%
2.17%
1.11%
-0.70%
-0.15%
-2.38%
-0.22%
1.42%
-0.91%
-1.68%
-1.59%
-0.98%
0.91%
4.93%
-0.18%
-1.30%
0.45%
-4.20%
0.73%
0.92%
-0.57%
13.82%
2.87%
-2.25%
-2.75%
-3.02%
-4.09%
-2.79%
-5.74%
-4.87%
-2.41%
-4.36%
3.80%
3.66%
2.12%
-1.86%
0.99%
-1.81%
2.11%
0.23%
-1.42%
-1.08%
-4.68%
-5.30%
-4.16%
0.51%
-3.09%
-0.81%
0.96%
2.52%
-1.00%
1.56%
3.48%
3.30%
1.47%
1.18%
1.58%
2.04%
-0.19%
0.56%
0.57%
-0.40%
2.58%
0.49%
2.04%
2.90%
0.69%
0.74%
3.37%
0.48%
4.16%
1.34%
-0.89%
-0.40%
-0.34%
-1.94%
0.77%
1.36%
-0.48%
-0.47%
-0.78%
0.12%
0.99%
-0.28%
0.71%
-2.33%
-0.62%
0.16%
1.01%
-0.95%
1.00%
-0.67%
0.99%
0.21%
1.06%
1.09%
1.98%
1.46%
1.91%
0.74%
-0.16%
0.34%
-0.66%
0.32%
-1.64%
-0.94%
-1.55%
0.03%
-0.67%
-1.17%
-2.30%
-0.67%
-1.26%
-3.46%
-2.42%
-2.47%
-1.38%
0.46%
-1.44%
0.03%
1.56%
1.61%
1.56%
2.34%
1.00%
0.22%
0.56%
0.92%
-1.09%
-0.48%
0.05%
-0.12%
0.48%
-0.54%
-0.19%
-0.08%
1.83%
0.44%
0.49%
0.26%
0.99%
-0.57%
2
Boeing Characteristic Line with Beta = -2
1.74%
1.24%
-0.64%
0.18%
-0.55%
-0.67%
-1.70%
2.69%
-0.29%
-2.34%
-3.19%
4.03%
-3.78%
-4.38%
1.11%
-5.21%
1.46%
1.33%
2.92%
-3.20%
0.06%
2.14%
-0.64%
1.50%
-1.22%
0.75%
4.32%
1.60%
1.90%
-1.89%
-0.63%
-3.81%
0.01%
3.96%
3.60%
-0.41%
1.03%
-0.80%
0.15%
0.56%
1.21%
-0.48%
0.98%
0.07%
-0.38%
-0.09%
-1.59%
1.66%
-2.91%
-1.60%
-2.48%
-0.08%
0.15%
0.39%
1.77%
-0.16%
-5.19%
0.43%
2.48%
-2.39%
-0.34%
2.46%
-1.66%
2.60%
-1.02%
2.74%
-3.06%
-1.12%
3.83%
-2.23%
3.09%
-2.43%
0.76%
1.49%
1.27%
-0.11%
-0.58%
0.05%
-2.89%
4.19%
-0.02%
-0.56%
-2.15%
-1.21%
-1.62%
2.00%
1.13%
1.79%
-0.61%
1.81%
-0.12%
-0.47%
0.62%
-0.72%
2.70%
-0.12%
-1.46%
-1.92%
-0.18%
0.18%
-1.05%
0.30%
0.55%
-4.11%
-3.43%
2.77%
-2.15%
-0.03%
-1.11%
0.31%
1.14%
1.21%
1.31%
-2.31%
1.22%
1.54%
-0.88%
3.21%
-1.55%
-1.32%
-0.47%
-1.09%
1.88%
-0.40%
-0.74%
-0.52%
0.35%
-0.26%
-0.27%
-1.04%
-0.03%
-0.38%
-0.07%
0.00%
0.82%
3.65%
1.34%
0.86%
0.40%
-0.33%
0.08%
0.78%
-0.46%
-0.78%
-0.74%
-0.07%
0.79%
0.25%
0.95%
0.73%
-2.36%
-0.66%
2.69%
-2.01%
0.64%
-0.20%
-2.66%
1.46%
1.78%
0.27%
-0.78%
0.65%
0.23%
0.10%
0.83%
-0.74%
-0.15%
0.00%
0.63%
0.64%
-0.15%
0.79%
-0.29%
1.62%
-0.31%
-2.29%
0.59%
2.21%
-0.47%
-0.08%
2.81%
0.61%
1.03%
-1.24%
0.16%
1.70%
-0.08%
-0.22%
0.30%
0.21%
-2.46%
0.02%
-0.56%
-0.31%
-0.87%
-0.31%
-0.69%
-2.62%
-2.14%
3.27%
-1.93%
...