Answered step by step
Verified Expert Solution
Link Copied!

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!

  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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Finance Theory And Practice

Authors: Anne Marie Ward

4th Edition

191235036X, 978-1912350360

More Books

Students also viewed these Finance questions

Question

explain what is meant by experiential learning

Answered: 1 week ago

Question

identify the main ways in which you learn

Answered: 1 week ago