Question: please show work in excel along with explanation! Construct a graph of the Characteristic Line for Cin. On this graph (using EXCELs graphing features) include

please show work in excel along with explanation!

  1. Construct a graph of the Characteristic Line for Cin.
    1. On this graph (using EXCELs graphing features) include a trendline, the computed equation, and the R2 value.
    2. Label the axes and include a title for the graph.

Month Cin S&P 500
1 -0.0715% -0.5583%
2 0.0340% 0.1083%
3 -0.2371% 0.2167%
4 -0.2541% -0.2083%
5 0.4039% 0.8167%
6 0.1050% -0.0583%
7 0.4847% -0.0250%
8 -0.6000% -0.7500%
9 -0.0718% -0.4083%
10 0.4252% -0.0333%
11 0.1406% 0.5333%
12 -0.0691% 0.2250%
13 0.0721% 0.3667%
14 0.3884% 0.6000%
15 0.3712% 0.2000%
16 0.0285% 0.0250%
17 0.0000% 0.3583%
18 0.0984% -0.3833%
19 0.5205% 0.3917%
20 0.0311% 0.2000%
21 0.4957% -0.1333%
22 -0.0001% 0.1083%
23 0.6431% 0.9500%
24 -0.5185% -0.1583%
25 0.0281% 0.1083%
26 -0.2245% -0.1667%
27 0.2872% 0.2417%
28 -0.5385% 0.0417%
29 0.0000% -0.1250%
30 0.0283% -0.1667%
31 0.2825% 0.1000%
32 -0.1085% 0.0333%
33 -0.1408% 0.2833%
34 0.2147% 0.1083%
35 0.2663% 0.0583%
36 0.2888% 0.1167%
37 -0.0809% 0.2250%
38 0.5719% 0.0250%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!