Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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!
- Construct a graph of the Characteristic Line for Cin.
- On this graph (using EXCELs graphing features) include a trendline, the computed equation, and the R2 value.
- 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
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