Statistics Projects

(See Solution) Please go back and take one months worth of information - #80078

Please go back and take one months worth of information for the car company General Motors (GM) in the following categories:(NYSE)

Log the: daily closing price, Date of each closing price and Dow Jones Industrial Average (DJIA) index for each date.

ANSWER THE FOLLOWING QUESTION IN THREE PAGES:

Can you predict what the price of your company's stock will do from the DJIA?

Solution: We use the website http://finance.yahoo.com to find historical closing prices for General Motors. (GM) We simply go to the “Stock” tab, and then click the “Historical Rates” link. The information obtained is summarized in the following table:

Date	Open	High	Low	Close	Volume	Adj. Close*
16-Jun-06	25.75	25.76	25.3	25.6	6229800	25.6
15-Jun-06	25.36	25.77	25.05	25.59	7527600	25.59
14-Jun-06	25.05	25.51	25.02	25.36	6203900	25.36
13-Jun-06	26	26.06	24.85	25.28	7271900	25.28
12-Jun-06	26.04	26.35	25.72	25.78	12961200	25.78
9-Jun-06	25.1	25.38	24.91	25.35	5859000	25.35
8-Jun-06	25.13	25.33	24.52	24.83	11560500	24.83
7-Jun-06	25.49	25.54	24.9	24.99	9296800	24.99
6-Jun-06	26.05	26.4	25	25.25	14592000	25.25
5-Jun-06	26.12	26.47	25.57	26.05	10947800	26.05
2-Jun-06	27	27.1	26.13	26.49	12458000	26.49
1-Jun-06	27.09	27.34	26.51	26.9	20834800	26.9
31-May-06	26.63	27.2	26.42	26.93	12925500	26.93
30-May-06	27.36	27.36	26.38	26.57	16054300	26.57
26-May-06	28.69	29.1	27.91	28.08	19767200	28.08
25-May-06	26.78	28.69	26.75	27.9	28519800	27.9
24-May-06	25.3	26.81	25.11	26.51	26998500	26.51
23-May-06	24.45	24.81	24.11	24.48	8941000	24.48
22-May-06	24.63	24.69	23.96	24.44	9724100	24.44
19-May-06	24.17	24.98	23.71	24.68	10025400	24.68
18-May-06	24.52	24.97	24.02	24.06	9044500	24.06
17-May-06	25.23	25.38	23.8	24.46	18828800	24.46
16-May-06	26.14	26.59	25.34	25.53	10471900	25.53
15-May-06	26.1	26.39	25.12	26.2	8776500	26.2
12-May-06	26.15	26.66	25.75	26.09	12288600	26.09
11-May-06	26.16	26.5	25.3	25.81	14319700	25.81
10-May-06	25.37	26.89	25.16	26.59	24633900	26.59
9-May-06	24.76	25.99	23.75	25.8	25306600	25.55
8-May-06	23.43	23.72	23.14	23.55	9599400	23.32

Now we show the DJIA index:

Date	Open	High	Low	Close	Volume	Adj. Close*
16-Jun-06	11009.1	11045.04	10984.29	11014.54	5900000	11014.54
15-Jun-06	10817.48	11049.85	10788.34	11015.19	2775480064	11015.19
14-Jun-06	10713.1	10816.99	10699.25	10816.91	5040000	10816.91
13-Jun-06	10783.14	10893.04	10653.23	10706.14	3215770112	10706.14
12-Jun-06	10892	10969.32	10767.61	10792.58	2247010048	10792.58
9-Jun-06	10939.14	11015.67	10842.89	10891.92	2214000128	10891.92
8-Jun-06	10929.7	11032.15	10726.15	10938.82	3543790080	10938.82
7-Jun-06	11002.06	11107.48	10897.76	10930.9	2644169984	10930.9
6-Jun-06	11048.24	11140.45	10890.24	11002.14	2697649920	11002.14
5-Jun-06	11247.55	11259.96	11025.75	11048.72	2313469952	11048.72
2-Jun-06	11260.52	11329.28	11158.06	11247.87	2295539968	11247.87
1-Jun-06	11169.03	11290.86	11115.4	11260.28	2360160000	11260.28
31-May-06	11091.15	11225.78	11050.4	11168.31	2692160000	11168.31
30-May-06	11277.25	11277.25	11071.7	11094.43	2176189952	11094.43
26-May-06	11211.69	11329.36	11177.43	11278.61	1814019968	11278.61
25-May-06	11114.96	11258.12	11089.55	11211.05	2372730112	11211.05
24-May-06	11100.11	11241.15	10980.29	11117.32	2999030016	11117.32
23-May-06	11126.29	11254.68	11068.49	11098.35	2605250048	11098.35
22-May-06	11092.9	11175.03	11040.16	11125.32	2773009920	11125.32
19-May-06	11124.37	11254.6	11009.98	11144.06	2982299904	11144.06
18-May-06	11206.17	11301.26	11096.35	11128.29	2537489920	11128.29
17-May-06	11410.13	11412.28	11139.17	11205.61	2830200064	11205.61
16-May-06	11428.21	11520.42	11334.64	11419.89	2386210048	11419.89
15-May-06	11380.43	11485.61	11273.65	11428.77	2505659904	11428.77
12-May-06	11500.01	11551.4	11336.96	11380.99	2567970048	11380.99
11-May-06	11639.29	11660.58	11449.74	11500.73	2531520000	11500.73
10-May-06	11630.48	11709.09	11545.64	11642.65	2268549888	11642.65
9-May-06	11584.62	11684.28	11535.71	11639.77	2157289984	11639.77
8-May-06	11576.37	11665.14	11504.09	11584.54	2151300096	11584.54