Information system assignment

profilezxy0120
is_assignment_for_ip_1.xlsx

Part 1

Date (Month) Adjusted Closing Price for TESLA Adjusted Closing Price for GM Adjusted Closing for NASDAQ
12/1/15 240.009995 32.774151 5007.410156
11/2/15 230.259995 34.520985 5108.669922
10/1/15 206.929993 33.290813 5053.75
9/1/15 248.399994 28.627621 4620.160156
8/3/15 249.059998 27.733307 4776.509766
7/1/15 266.149994 29.683304 5128.279785
6/1/15 268.26001 31.397797 4986.870117
5/1/15 250.800003 33.537411 5070.029785
4/1/15 226.050003 32.688953 4941.419922
3/2/15 188.770004 34.96394 4900.879883
2/2/15 203.339996 34.50351 4963.529785
1/2/15 203.600006 30.166294 4635.240234
12/1/14 222.410004 32.284039 4736.049805
11/3/14 244.520004 30.642021 4791.629883
10/1/14 241.699997 28.781319 4630.740234
9/2/14 242.679993 29.276283 4493.390137
8/1/14 269.700012 31.621035 4580.27002
7/1/14 223.300003 30.730558 4369.77002
6/2/14 240.059998 32.984013 4408.180176
5/1/14 207.770004 31.161242 4242.620117
4/1/14 207.889999 31.071125 4114.560059
3/3/14 208.449997 31.017056 4198.990234
2/3/14 244.809998 32.334007 4308.120117
1/2/14 181.410004 32.226822 4103.879883
12/2/13 150.429993 36.505268 4176.589844
11/1/13 127.279999 34.593811 4059.889893
10/1/13 159.940002 33.00391 3919.709961
9/3/13 193.369995 32.128571 3771.47998
8/1/13 169 30.440413 3589.870117
7/1/13 134.279999 32.039246 3626.370117
6/3/13 107.360001 29.752645 3403.25
5/1/13 97.760002 30.270702 3455.909912
4/1/13 53.990002 27.546429 3328.790039
3/1/13 37.889999 24.848951 3267.52002
2/1/13 34.830002 24.250504 3160.189941
1/2/13 37.509998 25.090117 3142.129883
12/3/12 33.869999 25.751087 3019.51001
11/1/12 33.82 23.116133 3010.23999
10/1/12 28.129999 22.776716 2977.22998
9/4/12 29.280001 20.320404 3116.22998
8/1/12 28.52 19.069918 3066.959961
7/2/12 27.42 17.605061 2939.52002
6/1/12 31.290001 17.613993 2935.050049
5/1/12 29.5 19.829142 2827.340088
4/2/12 33.130001 20.543705 3046.360107
3/1/12 37.240002 22.910696 3091.570068
2/1/12 33.41 23.241184 2966.889893
1/3/12 29.07 21.454775 2813.840088
12/1/11 28.559999 18.105257 2605.149902
11/1/11 32.740002 19.016327 2620.340088
10/3/11 29.370001 23.089338 2684.409912
9/1/11 24.389999 18.024868 2415.399902
8/1/11 24.74 21.463707 2579.459961
7/1/11 28.17 24.723904 2756.379883
6/1/11 29.129999 27.117691 2773.52002
5/2/11 30.139999 28.412836 2835.300049
4/1/11 27.6 28.662935 2873.540039
3/1/11 27.75 27.716139 2781.070068
2/1/11 23.889999 29.949148 2782.27002
1/3/11 24.1 32.593037 2700.080078

Part 2

1).
2).

TESLA vs. GM stock values comparison

Adjusted Closing Price for TESLA 42339 42310 42278 42248 42219 42186 42156 42125 42095 42065 42037 42006 41974 41946 41913 41884 41852 41821 41792 41760 41730 41701 41673 41641 41610 41579 41548 41520 41487 41456 41428 41395 41365 41334 41306 41276 41246 41214 41183 41156 41122 41092 41061 41030 41001 40969 40940 40911 40878 40848 40819 40787 40756 40725 240.009995 230.259995 206.929993 248.39999399999999 249.05999800000001 266.14999399999999 268.26001000000002 250.800003 226.050003 188.770004 203.33999600000001 203.60000600000001 222.41000399999999 244.520004 241.699997 242.679993 269.70001200000002 223.300003 240.05999800000001 207.770004 207.88999899999999 208.449997 244.80999800000001 181.41000399999999 150.429993 127.279999 159.94000199999999 193.36999499999999 169 134.279999 107.360001 97.760002 53.990001999999997 37.889999000000003 34.830002 37.509998000000003 33.869999 33.82 28.129999000000002 29.280000999999999 28.52 27.42 31.290001 29.5 33.130001 37.240001999999997 33.409999999999997 29.07 28.559999000000001 32.740001999999997 29.370000999999998 24.389999 24.74 28.17 29.129999000000002 30.139999 27.6 27.75 23.889999 24.1 Adjusted Closing Price for GM 42339 42310 42278 42248 42219 42186 42156 42125 42095 42065 42037 42006 41974 41946 41913 41884 41852 41821 41792 41760 41730 41701 41673 41641 41610 41579 41548 41520 41487 41456 41428 41395 41365 41334 41306 41276 41246 41214 41183 41156 41122 41092 41061 41030 41001 40969 40940 40911 40878 40848 40819 40787 40756 40725 32.774151000000003 34.520985000000003 33.290813 28.627621000000001 27.733307 29.683304 31.397797000000001 33.537410999999999 32.688952999999998 34.963940000000001 34.503509999999999 30.166294000000001 32.284039 30.642021 28.781319 29.276282999999999 31.621034999999999 30.730557999999998 32.984012999999997 31.161242000000001 31.071124999999999 31.017056 32.334007 32.226821999999999 36.505268000000001 34.593811000000002 33.003909999999998 32.128571000000001 30.440412999999999 32.039245999999999 29.752645000000001 30.270702 27.546429 24.848951 24.250503999999999 25.090116999999999 25.751086999999998 23.116133000000001 22.776716 20.320404 19.0699 18000000001 17.605060999999999 17.613993000000001 19.829142000000001 20.543704999999999 22.910696000000002 23.241184000000001 21.454775000000001 18.105257000000002 19.016327 23.089338000000001 18.024868000000001 21.463706999999999 24.723904000000001 27.117691000000001 28.412835999999999 28.662935000000001 27.716138999999998 29.949148000000001 32.593037000000002

date

price

Tesla vs. NASDAQ stock values comparison

Adjusted Closing for NASDAQ 42339 42310 42278 42248 42219 42186 42156 42125 42095 42065 42037 42006 41974 41946 41913 41884 41852 41821 41792 41760 41730 41701 41673 41641 41610 41579 41548 41520 41487 41456 41428 41395 41365 41334 41306 41276 41246 41214 41183 41156 41122 41092 41061 41030 41001 40969 40940 40911 40878 40848 40819 40787 40756 40725 40695 40665 40634 40603 40575 40546 5007.4101559999999 5108.669922 5053.75 4620.1601559999999 4776.5097660000001 5128.2797849999997 4986.8701170000004 5070.0297849999997 4941.419922 4900.8798829999996 4963.5297849999997 4635.2402339999999 4736.0498049999997 4791.6298829999996 4630.7402339999999 4493.3901370000003 4580.2700199999999 4369.7700199999999 4408.1801759999998 4242.6201170000004 4114.5600590000004 4198.9902339999999 4308.1201170000004 4103.8798 829999996 4176.5898440000001 4059.889893 3919.709961 3771.4799800000001 3589.8701169999999 3626.3701169999999 3403.25 3455.9099120000001 3328.790039 3267.5200199999999 3160.1899410000001 3142.1298830000001 3019.51001 3010.23999 2977.2299800000001 3116.2299800000001 3066.959961 2939.5200199999999 2935.0500489999999 2827.3400879999999 3046.360107 3091.570068 2966.889893 2813.8400879999999 2605.1499020000001 2620.3400879999999 2684.4099120000001 2415.3999020000001 2579.459961 2756.3798830000001 2773.5200199999999 2835.3000489999999 2873.540039 2781.070068 2782.2700199999999 2700.080078 Adjusted Closing Price for TESLA 42339 42310 42278 42248 42219 42186 42156 42125 42095 42065 42037 42006 41974 41946 41913 41884 41852 41821 41792 41760 41730 41701 41673 41641 41610 41579 41548 41520 41487 41456 41428 41395 41365 41334 41306 41276 41246 41214 41183 41156 41122 41092 41061 41030 41001 40969 40940 40911 40878 40848 40819 40787 40756 40725 40695 40665 40634 40603 40575 40546 240.009995 230.259995 206.929993 248.39999399999999 249.05999800000001 266.14999399999999 268.26001000000002 250.800003 226.050003 188.770004 203.33999600000001 203.60000600000001 222.41000399999999 244.520004 241.699997 242.679993 269.70001200000002 223.300003 240.05999800000001 207.770004 207.88999899999999 208.449997 244.80999800000001 181.41000399999999 150.429993 127 .279999 159.94000199999999 193.36999499999999 169 134.279999 107.360001 97.760002 53.990001999999997 37.889999000000003 34.830002 37.509998000000003 33.869999 33.82 28.129999000000002 29.280000999999999 28.52 27.42 31.290001 29.5 33.130001 37.240001999999997 33.409999999999997 29.07 28.559999000000001 32.740001999999997 29.370000999999998 24.389999 24.74 28.17 29.129999000000002 30.139999 27.6 27.75 23.889999 24.1

date

price

When looking at a visual comparison between Tesla Motors and General Motors regarding their stock values, the very first thing that one would notice is that Tesla's stocks are very inconsistent compared to GM's stock values. The graph also shows that although Tesla has higher adjusted closing prices overall, the company does better over time, and although it has moments where the stock value price goes down, Tesla does better than GM.

By looking at the chart above, it is clear that NASDAQ is doing dramatically better than Tesla, and although they show more inconsistency (with the price going up and down throughout the time intervals), the value of their stocks have started out and stayed consistently higher than Tesla's. It is not a very reasonable comparison, since NASDAQ is the second largest exchange in the world, while Tesla is a relatively new start-up company.