First, set the date range to be for exactly 1 year ending with the Monday that this course started.

data.xlsx

Home >Mathematics homework help >Numerical analysis homework help >First, set the date range to be for exactly 1 year ending with the Monday that this course started.

project 3

Date	Close
24-Aug-15	589.61
21-Aug-15	612.48
20-Aug-15	646.83
19-Aug-15	660.9
18-Aug-15	656.13
17-Aug-15	660.87
14-Aug-15	657.12
13-Aug-15	656.45
12-Aug-15	659.56
11-Aug-15	660.78
10-Aug-15	633.73
7-Aug-15	635.3
6-Aug-15	642.68
5-Aug-15	643.78
4-Aug-15	629.25
3-Aug-15	631.21
31-Jul-15	625.61
30-Jul-15	632.59
29-Jul-15	631.93
28-Jul-15	628
27-Jul-15	627.26
24-Jul-15	623.56
23-Jul-15	644.28
22-Jul-15	662.1
21-Jul-15	662.3
20-Jul-15	663.02
17-Jul-15	672.93
16-Jul-15	579.85
15-Jul-15	560.22
14-Jul-15	561.1
13-Jul-15	546.55
10-Jul-15	530.13
9-Jul-15	520.68
8-Jul-15	516.83
7-Jul-15	525.02
6-Jul-15	522.86
2-Jul-15	523.4
1-Jul-15	521.84
30-Jun-15	520.51
29-Jun-15	521.52
26-Jun-15	531.69
25-Jun-15	535.23
24-Jun-15	537.84
23-Jun-15	540.48
22-Jun-15	538.19
19-Jun-15	536.69
18-Jun-15	536.73
17-Jun-15	529.26
16-Jun-15	528.15
15-Jun-15	527.2
12-Jun-15	532.33
11-Jun-15	534.61
10-Jun-15	536.69
9-Jun-15	526.69
8-Jun-15	526.83
5-Jun-15	533.33
4-Jun-15	536.7
3-Jun-15	540.31
2-Jun-15	539.18
1-Jun-15	533.99
29-May-15	532.11
28-May-15	539.78
27-May-15	539.79
26-May-15	532.32
22-May-15	540.11
21-May-15	542.51
20-May-15	539.27
19-May-15	537.36
18-May-15	532.3
15-May-15	533.85
14-May-15	538.4
13-May-15	529.62
12-May-15	529.04
11-May-15	535.7
8-May-15	538.22
7-May-15	530.7
6-May-15	524.22
5-May-15	530.8
4-May-15	540.78
1-May-15	537.9
30-Apr-15	537.34
29-Apr-15	549.08
28-Apr-15	553.68
27-Apr-15	555.37
24-Apr-15	565.06
23-Apr-15	547
22-Apr-15	539.36
21-Apr-15	533.97
20-Apr-15	535.38
17-Apr-15	524.05
16-Apr-15	533.8
15-Apr-15	532.53
14-Apr-15	530.39
13-Apr-15	539.17
10-Apr-15	540.01
9-Apr-15	540.78
8-Apr-15	541.61
7-Apr-15	537.02
6-Apr-15	536.76
2-Apr-15	535.53
1-Apr-15	542.56
31-Mar-15	548
30-Mar-15	552.03
27-Mar-15	548.34
26-Mar-15	555.17
25-Mar-15	558.78
24-Mar-15	570.19
23-Mar-15	558.81
20-Mar-15	560.36
19-Mar-15	557.99
18-Mar-15	559.5
17-Mar-15	550.84
16-Mar-15	554.51
13-Mar-15	547.32
12-Mar-15	555.51
11-Mar-15	551.18
10-Mar-15	555.01
9-Mar-15	568.85
6-Mar-15	567.68
5-Mar-15	575.33
4-Mar-15	573.37
3-Mar-15	573.64
2-Mar-15	571.34
27-Feb-15	558.4
26-Feb-15	555.48
25-Feb-15	543.87
24-Feb-15	536.09
23-Feb-15	531.91
20-Feb-15	538.95
19-Feb-15	542.87
18-Feb-15	539.7
17-Feb-15	542.84
13-Feb-15	549.01
12-Feb-15	542.93
11-Feb-15	535.97
10-Feb-15	536.94
9-Feb-15	527.83
6-Feb-15	531
5-Feb-15	527.58
4-Feb-15	522.76
3-Feb-15	529.24
2-Feb-15	528.48
30-Jan-15	534.52
29-Jan-15	510.66
28-Jan-15	510
27-Jan-15	518.63
26-Jan-15	535.21
23-Jan-15	539.95
22-Jan-15	534.39
21-Jan-15	518.04
20-Jan-15	506.9
16-Jan-15	508.08
15-Jan-15	501.79
14-Jan-15	500.87
13-Jan-15	496.18
12-Jan-15	492.55
9-Jan-15	496.17
8-Jan-15	502.68
7-Jan-15	501.1
6-Jan-15	501.96
5-Jan-15	513.87
2-Jan-15	524.81
31-Dec-14	526.4
30-Dec-14	530.42
29-Dec-14	530.33
26-Dec-14	534.03
24-Dec-14	528.77
23-Dec-14	530.59
22-Dec-14	524.87
19-Dec-14	516.35
18-Dec-14	511.1
17-Dec-14	504.89
16-Dec-14	495.39
15-Dec-14	513.8
12-Dec-14	518.66
11-Dec-14	528.34
10-Dec-14	526.06
9-Dec-14	533.37
8-Dec-14	526.98
5-Dec-14	525.26
4-Dec-14	537.31
3-Dec-14	531.32
2-Dec-14	533.75
1-Dec-14	533.8
28-Nov-14	541.83
26-Nov-14	540.37
25-Nov-14	541.08
24-Nov-14	539.27
21-Nov-14	537.5
20-Nov-14	534.83
19-Nov-14	536.99
18-Nov-14	535.03
17-Nov-14	536.51
14-Nov-14	544.4
13-Nov-14	545.38
12-Nov-14	547.31
11-Nov-14	550.29
10-Nov-14	547.49
7-Nov-14	541.01
6-Nov-14	542.04
5-Nov-14	545.92
4-Nov-14	554.11
3-Nov-14	555.22
31-Oct-14	559.08
30-Oct-14	550.31
29-Oct-14	549.33
28-Oct-14	548.9
27-Oct-14	540.77
24-Oct-14	539.78
23-Oct-14	543.98
22-Oct-14	532.71
21-Oct-14	526.54
20-Oct-14	520.84
17-Oct-14	511.17
16-Oct-14	524.51
15-Oct-14	530.03
14-Oct-14	537.94
13-Oct-14	533.21
10-Oct-14	544.49
9-Oct-14	560.88
8-Oct-14	572.5
7-Oct-14	563.74
6-Oct-14	577.35
3-Oct-14	575.28
2-Oct-14	570.08
1-Oct-14	568.27
30-Sep-14	577.36
29-Sep-14	576.36
26-Sep-14	577.1
25-Sep-14	575.06
24-Sep-14	587.99
23-Sep-14	581.13
22-Sep-14	587.37
19-Sep-14	596.08
18-Sep-14	589.27
17-Sep-14	584.77
16-Sep-14	579.95
15-Sep-14	573.1
12-Sep-14	575.62
11-Sep-14	581.35
10-Sep-14	583.1
9-Sep-14	581.01
8-Sep-14	589.72
5-Sep-14	586.08
4-Sep-14	581.98
3-Sep-14	577.94
2-Sep-14	577.33
29-Aug-14	571.6
28-Aug-14	569.2
27-Aug-14	571
26-Aug-14	577.86
25-Aug-14	580.2
mean		552.9828174603
Standard deviation		51.0095795085
normal distribution