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!
- 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
