Computation of Dow Jones Industrial Average

profileoluwafemi45
djia_computation-_example.xlsx

Sheet1

DJIA Computation- Sample Only after 2-for1 split
Data used refer to a period in the past for Exxon
(copied from finance.yahoo.com)
Symbol Name Last Trade Change Volume
XOM EXXON MOBIL CP 71.79 2.80 (3.75%) 35.895
GM GEN MOTORS 2.2 0.30 (12.07%) 17,378,249 2.2
DD DU PONT E I DE NEM 21.41 0.99 (4.42%) 6,833,612 21.41
1 AA ALCOA INC 6.82 0.66 (8.82%) 22,486,030 6.82
BA BOEING CO 38.68 1.80 (4.45%) 4,301,982 38.68
KFT KRAFT FOODS INC 24.89 0.31 (1.23%) 9,060,895 24.89
AXP AMER EXPRESS INC 14.27 1.47 (9.34%) 17,030,844 14.27
DIS WALT DISNEY-DISNEY C 17.99 0.53 (2.87%) 14,056,200 17.99
MMM 3M COMPANY 47.69 1.73 (3.50%) 5,861,297 47.69
MRK MERCK CO INC 28.75 0.00 (0.02%) 9,762,329 28.75
UTX UNITED TECH 46.15 0.94 (2.00%) 6,231,632 46.15
MCD MCDONALDS CP 55.94 0.87 (1.53%) 5,909,528 55.94
VZ VERIZON COMMUN 28.37 1.19 (4.03%) 11,726,215 28.37
KO COCA COLA CO THE 42.98 0.87 (1.98%) 8,440,843 42.98
HPQ HEWLETT PACKARD CO 34.8 1.07 (2.98%) 11,075,993 34.8
C CITIGROUP INC 3.16 0.33 (9.46%) 124,573,628 3.16
CAT CATERPILLAR INC 29.01 1.93 (6.25%) 15,212,771 29.01
HD HOME DEPOT INC 20.1 1.12 (5.28%) 24,057,324 20.1
IBM INTL BUSINESS MACH 91.43 2.41 (2.57%) 5,289,326 91.43
INTC Intel Corporation 13.39 0.49 (3.57%) 37,826,732 13.39
JNJ JOHNSON AND JOHNS DC 56.35 0.75 (1.31%) 9,086,545 56.35
T AT&T INC. 23.3 0.89 (3.68%) 23,433,633 23.3
PFE PFIZER INC 14.33 0.25 (1.70%) 38,794,451 14.33
PG PROCTER GAMBLE CO 50.7 0.39 (0.76%) 13,393,500 50.7
CVX CHEVRON CORP 66.48 3.25 (4.66%) 10,706,211 66.48
MSFT Microsoft Corporation 18.41 0.55 (2.90%) 51,266,417 18.41
BAC BK OF AMERICA CP 5.06 0.51 (9.20%) 193,502,961 5.06
GE GEN ELECTRIC CO 10.99 0.45 (3.93%) 91,037,064 10.99
WMT WAL MART STORES 48.04 1.51 (3.25%) 25,503,256 48.04
JPM JP MORGAN CHASE CO 22.54 2.15 (8.71%) 56,478,955 22.54
920.125
Sum of prices 956.02
Divisor 0.125550712 0.1208367491
2 DJIA 7614.6123329034 7328.7119231948
3 Published value 7614.612
(taken from the same source where company price data were copied from)
http://finance.yahoo.com/q?s=AA http://finance.yahoo.com/q?s=GE http://finance.yahoo.com/q?s=GM http://finance.yahoo.com/q?s=HD http://finance.yahoo.com/q?s=HPQ http://finance.yahoo.com/q?s=IBM http://finance.yahoo.com/q?s=INTC http://finance.yahoo.com/q?s=JNJ http://finance.yahoo.com/q?s=JPM http://finance.yahoo.com/q?s=KFT http://finance.yahoo.com/q?s=KO http://finance.yahoo.com/q?s=AXP http://finance.yahoo.com/q?s=MCD http://finance.yahoo.com/q?s=MMM http://finance.yahoo.com/q?s=MRK http://finance.yahoo.com/q?s=MSFT http://finance.yahoo.com/q?s=PFE http://finance.yahoo.com/q?s=PG http://finance.yahoo.com/q?s=T http://finance.yahoo.com/q?s=UTX http://finance.yahoo.com/q?s=VZ http://finance.yahoo.com/q?s=WMT http://finance.yahoo.com/q?s=BA http://finance.yahoo.com/q?s=XOM http://finance.yahoo.com/q?s=BAC http://finance.yahoo.com/q?s=C http://finance.yahoo.com/q?s=CAT http://finance.yahoo.com/q?s=CVX http://finance.yahoo.com/q?s=DD http://finance.yahoo.com/q?s=DIS

Sheet2

Sheet3