Description
Study Reports On Correlating Indian Stock Indices (BSE) With American Stock Indices (NASDAQ), A correlation function is a statistical correlation between random variables at two different points in space or time, usually as a function of the spatial or temporal distance between the points. If one considers the correlation function between random variables representing the same quantity measured at two different points then this is often referred to as an autocorrelation function being made up of autocorrelations.
STUDY REPORTS ON CORRELATING INDIAN STOCK INDICES (BSE) WITH AMERICAN STOCK INDICES (NASDAQ)
ABSTRACT
Correlating BSE Sensex with NASDAQ stock exchange. This study tries to analyze the relation between BSE sensex with NASDAQ. When BSE sensex increases to new highs questions arises that weather there is an increase in other world stock market or not, I tried to find out the correlation between BSE sensex with NASDAQ For this purpose I have collected daily 1 year closings from 1 st JAN 2007 to 31st DEC 2007 of BSE and AMERICAN stock markets. FINDINGS OF THE STUDY: The study suggested that there is an overall positive as well as negative correlation between BSE sensex and NASDAQ. The study supports that mergers of top Indian companies will have its effect on Indian as well as foreign stock markets also.
TABLES OF CONTENT 1. INTRODUCTION
1.1 OBJECTIVE OF THE STUDY
2. COMPANY PROFILE
2.1 2.2 BSE NASDAQ
3. METHODOLOGY 4. DATA ANALYSIS
4.1 4.2 4.3 RETURN, VARIANCE, STANDARD DEVIATION OF BSE SENSEX RETURN, VARIANCE, STANDARD DEVIATION OF NASDAQ CORRELATION OF RETURNS BETWEEN BSE & NASDAQ
5. CONCLUSION 6. BIBLIOGRAPHY
OBJECTIVE OF THE STUDY
• • • •
TO ANALYSE THE PERFOMANCE OF BSE SENSEX. TO ANALYSE THE PERFOMANCE OF NASDAQ. TO KNOW THE RISK AND RETURN OF THE BSE &NASDAQ. TO CORRELATE THE PERFOMANCE OF BSE SENSEX WITH NASDAQ WITH THE HELP OF RETURNS. TO IDENTIFY THE FACTORS INFLUENCING THE INDICES.
•
COMPANY PROFILE
Bombay Stock Exchange (BSE)
About the Bombay Stock Exchange
Bombay Stock Exchange Limited is the oldest stock exchange in Asia with a rich heritage. Popularly known as "BSE", it was established as "The Native Share Stock Brokers Association" in 1875. It is the first stock exchange in the country to obtain permanent recognition in 1956 from the Government of India under the Securities Contracts (Regulation) Act, 1956.The Exchange's pivotal and pre-eminent role in the development of the Indian capital market is widely recognized and its index, SENSEX, is tracked worldwide. Earlier an Association of Persons (AOP), the Exchange is now a demutualised and corporatised entity incorporated under the provisions of the Companies Act, 1956,
BSE(Corporatisation and Demutualization) Scheme, 2005 notified by the Securities and Exchange Board of India (SEBI). With demutualization, the trading rights and ownership rights have been de-linked effectively addressing concerns regarding perceived and real conflicts of interest. The Exchange is professionally managed under the overall direction of the Board of Directors. The Board comprises eminent professionals, representatives of Trading Members and the Managing Director of the Exchange. The Board is inclusive and is designed to benefit from the participation of market intermediaries. In terms of organization structure, the Board formulates larger policy issues and exercises over-all control. The committees constituted by the Board are broad-based. The day-to-day operations of the Exchange are managed by the Managing Director and a management team of professionals.
The Exchange has a nation-wide reach with a presence in 417 cities and towns of India. The systems and processes of the Exchange are designed to safeguard market integrity and enhance transparency in operations. During the year 2004-2005, the trading volumes on the Exchange showed robust growth.
The Exchange provides an efficient and transparent market for trading in equity, debt instruments and derivatives. The BSE's On Line Trading System (BOLT) is a proprietary system of the Exchange and is BS 7799-2-2002 certified. The surveillance and clearing & settlement functions of the Exchange are ISO 9001:2000 certified.
History of the Bombay Stock Exchange :
The Bombay Stock Exchange is known as the oldest exchange in Asia. It traces its history to the 1850s, when stockbrokers would gather under banyan trees in front of Mumbai's Town Hall. The location of these meetings changed many times, as the number of brokers constantly increased. The group eventually moved to Dalal Street in 1874 and in 1875 became an official organization known as 'The Native Share & Stock Brokers Association'. In 1956, the BSE became the first stock exchange to be recognized by the Indian Government under the Securities Contracts Regulation Act. The Bombay Stock Exchange developed the BSE Sensex in 1986, giving the BSE a means to measure overall
performance of the exchange. In 2000 the BSE used this index to open its derivatives market, trading Sensex futures contracts. The development of Sensex options along with equity derivatives
followed in 2001 and 2002, expanding the BSE's trading platform. Historically an open-cry floor trading exchange, the Bombay Stock Exchange switched to an electronic trading system in 1995. It took the exchange only fifty days to make this transition.
About the NASDAQ: The NASDAQ, an acronym for National Association of Securities Dealers Automated Quotations, is an electronic stock exchange with 3,300 company listings. It currently has a greater trading volume than any other U.S. exchange, making approximately 1.8 billion trades per day. The NYSE is still considered the biggest exchange because its market capitalization far exceeds that of the NASDAQ. The NASDAQ trades shares in a variety of companies, but is well known for being a high-tech exchange, trading many new, high growth, and volatile stocks. This is partially due to the fact that the listing fees on the NASDAQ are significantly lower than those for the NYSE, with the maximum price only $150,000. The NASDAQ is a publicly owned company, trading its shares on its own exchange under the ticker symbol NDAQ. The NASDAQ, as an electronic exchange, has no physical trading floor, but makes all its trades through a computer and telecommunications system. The exchange is a dealers' market, meaning brokers buy and sell stocks through a market maker rather than from each other. A market maker deals in a particular stock and holds a certain number of stocks on his own books so that when a broker wants to purchase shares, he can purchase them directly from the market maker. Since there is no trading floor where the NASDAQ operates, the stock exchange built the NASDAQ Market Site in New York's Times Square to create a physical presence. The tower has a large outdoor electronic display, giving current financial information 24 hours a day.
The company also has a studio here where it broadcasts financial market updates. For a stock to be listed on the NASDAQ National Market, the company must meet certain strict financial criteria. For example, they must maintain a stock price of at least $1, and the total value of outstanding stocks must be at least $1.1 million. However the NASDAQ also has a market for smaller companies unable to meet these and other requirements, called the NASDAQ Small Caps Market. NASDAQ will move companies from one market to the other as their eligibility changes. NASDAQ NASDAQ Profile : Address Telephone Web Site Holidays One Liberty Plaza, 50th Floor, New York, NY 10006 212-401-8742 Click here for the NASDAQ web site New Year's Day, Martin Luther King Jr's Birthday, Presidents' Day, Good Friday, Memorial Day, Independence Day, Labor Day, Thanksgiving, and Christmas. Stocks President and CEO: Robert Greifeld since May 2003
Trading Hours Monday - Friday, 9:30 am - 4:00 pm EST
Securities Trading System Key Staff
History of the NASDAQ:
The NASDAQ was developed in 1971 as the first electronic stock exchange in the world. It was created as a means to increase the trading of Over-the-Counter stocks, those that were unable to meet listing requirements for larger exchanges. 2,500 OTC stocks were traded on the NASDAQ's first trading day, February 8, 1971.
The division between the NASDAQ National Market and the NASDAQ Small-Cap Market developed from 1982 to 1986, as the larger companies separated themselves from the smaller ones. It was in the 1990's that the NASDAQ began to be seen as a competitor of the NYSE, and in 1994 the NASDAQ beat the NYSE in annual shares traded. In 1998, the NASDAQ merged with the American Stock Exchange, which mostly traded options and derivatives, creating the NASDAQ-AMEX Market Group. The combined company still operates as two separate exchanges, but is better able to compete with the NYSE.
NASDAQ | NASDAQ companies Top 100 companies on the NASDAQ : MSFT AAPL GOOG INTC CSCO AMGN AMZN MEDI QCOM SUNW AMAT CMCSA RIMM LVLT ORCL ESRX BRCM EBAY YHOO DELL SNDK BEAS AKAM GILD SHLD NVDA JNPR HOLX ERTS BIIB DNDN Microsoft (MM) Apple Inc. (MM) Google Inc. (MM) Intel (MM) Cisco Systems (MM) Amgen Inc. (MM) Amazon.Com (MM) Medimmune (MM) Qualcomm Incorporated (MM) Sun Microsystems (MM) Applied Materials (MM) Comcast (MM) Research IN Motion Limited (MM) Level 3 Communications (MM) Oracle (MM) Express Scripts (MM) Broadcom (MM) EBay Inc. (MM) Yahoo! Inc. (MM) Dell Inc. (MM) Sandisk (MM) Bea Systems (MM) Akamai Technologies (MM) Gilead Sciences (MM) Sears Holdings (MM) Nvidia (MM) Juniper Networks (MM) Hologic (MM) Electronic Arts Inc. (MM) Biogen Idec (MM) Dendreon (MM)
METHODOLOGY
Arithmetic average or mean :
The arithmetic average measures the central tendency . The purpose of computing an average value for a set of observations is to obtain a single value, which is representative of all the items. The main objective of averaging is to arrive at a single value which is a representative of the characteristics of the entire mass of data and arithmetic average or mean of a series(usually denoted by x) is the value obtained by dividing the sum of the values of various items in a series (sigma x) divided by the number of items (N) constituting the series.
Thus, if X1,X2……………..Xn are the given N observations. Then
X= X1+X2+……….Xn N
RETURN
Current price-previous price *100 Previous price
STANDARD DEVIATION :
The concept of standard deviation was first suggested by Karl Pearson in 1983.it may be defined as the positive square root of the arithmetic mean of the squares of deviations of the given observations from their arithmetic mean. In short S.D may be defined as “Root Mean Square Deviation from Mean” It is by far the most important and widely used measure of studying dispersions. For a set of N observations X1,X2……..Xn with mean X, Deviations from Mean: (X1-X),(X2-X),….(Xn-X) Mean-square deviations from Mean: = 1/N (X1-X)2+(X2-X)2+……….+(Xn-X)2 =1/N sigma(X-X)2 Root-mean-square deviation from mean,i.e.
VARIANCE :
The square of standard deviation is known as Variance. Variance is the square root of the standard deviation: Variance =(S.D)2 Where,(S.D)is standard deviation
CORRELATION
Correlation is a statistical technique, which measures and analyses the degree or extent to which two or more variables fluctuate with reference to one another. Correlation thus denotes the inter-dependence amongst variables. The degrees are expressed by a coefficient, which ranges between –1 and +1. The direction of change is indicated by (+) or (-) signs. The former refers to a sympathetic movement in a same direction and the later in the opposite direction. Karl Pearson’s method of calculating coefficient (r) is based on covariance of the concerned variables. It was devised by Karl Pearson a great British Biometrician. This measure known as Pearsonian correlation coefficient between two variables (series) X and Y usually denoted by ‘r’ is a numerical measure of linear relationship and is defined as the ratio of the covariance between X and Y (written as Cov(X,Y) to the product of standard deviation of X and Y Symbolically r = Cov (X,Y) SD of X,Y = ? xy/N SD of X,Y = ?XY N
Where x =X-X, y=Y-Y
?xy = sum of the product of deviations in X and Y series calculated with reference to
their arithmetic means. X = standard deviation of the series X. Y = standard deviation of the series Y.
DATA ANALYSIS & INTERPRETATION
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF JAN-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 3-Jan-07 4-Jan-07 5-Jan-07 8-Jan-07 9-Jan-07 10-Jan-07 11-Jan-07 12-Jan-07 16-Jan-07 17-Jan-07 18-Jan-07 19-Jan-07 22-Jan-07 23-Jan-07 24-Jan-07 25-Jan-07 26-Jan-07 29-Jan-07 30-Jan-07
Close 13940.2 13942.24 14014.92 13871.71 13860.52 13652.15 13566.33 13362.16 13630.71 14056.53 14129.64 14114.73 14131.34 14217.75 14182.71 14209.24 14041.24 14110.46 14282.72 14211.96 MEAN
Returns(x) 0.01 0.52 -1.02 -0.08 -1.50 -0.63 -1.50 2.01 3.12 0.52 -0.11 0.12 0.61 -0.25 0.19 -1.18 0.49 1.22 -0.50 0.11
X-mean -0.09 0.41 -1.13 -0.19 -1.61 -0.74 -1.61 1.90 3.02 0.41 -0.21 0.01 0.50 -0.35 0.08 -1.29 0.39 1.11 -0.60 variance
(x-mean)2 0.01 0.17 1.28 0.04 2.60 0.54 2.60 3.62 9.10 0.17 0.05 0.00 0.25 0.13 0.01 1.66 0.15 1.24 0.36 1.26
Sd
1.12
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.10792733 0.014633936 1.153779443 1.331207004 4.628951122 -1.504975922 3.1239752
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JAN-07
2.00 0.00 1 -2.00 4 7 10 13 16 19 jan
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of jan-07.The graph says there is lot fluctuations in the price movements. Here risk is more when compared to returns and with price variation is 1.26.The returns can fluctuate in between -1.50 and 3.12
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF FEB-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 1-Feb-07 2-Feb-07 5-Feb-07 6-Feb-07 7-Feb-07 8-Feb-07 9-Feb-07 12-Feb-07 13-Feb-07 14-Feb-07 15-Feb-07 16-Feb-07 20-Feb-07 21-Feb-07 22-Feb-07 23-Feb-07 26-Feb-07 27-Feb-07 28-Feb-07 Close 14267.18 14403.77 14515.9 14478.19 14643.13 14652.09 14538.9 14190.7 14090.98 14009.9 14355.55 14402.9 14253.38 14188.49 14021.31 13632.53 13649.52 13478.83 12938.09 MEAN Returns(x) 0.39 0.96 0.78 -0.26 1.14 0.06 -0.77 -2.39 -0.70 -0.58 2.47 0.33 -1.04 -0.46 -1.18 -2.77 0.12 -1.25 -4.01 -0.48 X-mean 0.87 1.44 1.26 0.22 1.62 0.54 -0.29 -1.91 -0.22 -0.09 2.95 0.81 -0.56 0.03 -0.70 -2.29 0.61 -0.77 -3.53 variance (x-mean)2 0.76 2.07 1.59 0.05 2.63 0.30 0.08 3.66 0.05 0.01 8.70 0.66 0.31 0.00 0.48 5.25 0.37 0.59 12.46 2.11 Sd
1.45
DESCRIPTIVE STATISTICS Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.48240235 -0.455260436 1.490891666 2.222757959 6.478956455 -4.011772535 2.46718392
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF FEB-07
2.00 0.00 -2.00 -4.00 -6.00 1 3 5 7 9 11 13 15 17 19 Series1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of feb-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 2.11.The returns can fluctuate in between -4.011 and 2.462.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF MARCH-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 1-Mar-07 2-Mar-07 5-Mar-07 6-Mar-07 7-Mar-07 8-Mar-07 9-Mar-07 12-Mar-07 13-Mar-07 14-Mar-07 15-Mar-07 16-Mar-07 19-Mar-07 20-Mar-07 21-Mar-07 22-Mar-07 23-Mar-07 26-Mar-07 27-Mar-07 Close 13159.55 12886.13 12415.04 12697.09 12579.75 13049.35 12884.99 12902.63 12982.98 12529.62 12543.85 12430.4 12644.99 12705.94 12945.88 13308.03 13285.93 13124.32 12884.34 MEAN Returns(x) 1.71 -2.08 -3.66 2.27 -0.92 3.73 -1.26 0.14 0.62 -3.49 0.11 -0.90 1.73 0.48 1.89 2.80 -0.17 -1.22 -1.83 0.02 X-mean 1.69 -2.10 -3.67 2.25 -0.94 3.71 -1.28 0.12 0.60 -3.51 0.09 -0.92 1.71 0.46 1.87 2.78 -0.19 -1.24 -1.85 variance (x-mean)2 2.86 4.40 13.51 5.07 0.89 13.79 1.63 0.01 0.36 12.33 0.01 0.85 2.91 0.21 3.49 7.72 0.03 1.53 3.41 3.99 Sd
2.00
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.002140215 0.113570882 2.041710772 4.168582875 7.388774714 -3.655791149 3.732983565
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MARCH-07
2. 50 2. 00 1. 50 1. 00 0. 50 0. 00 -0. 50 -1. 00 -1. 50 -2. 00 -2. 50 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of March-07.The graph says there is lot fluctuations in the price movements. Here risk is more when compared to returns and with price variation is 3.99.The returns can fluctuate in between -3.650 and 3.732
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF APRIL-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 2-Apr-07 3-Apr-07 4-Apr-07 5-Apr-07 9-Apr-07 10-Apr-07 11-Apr-07 12-Apr-07 13-Apr-07 16-Apr-07 17-Apr-07 18-Apr-07 19-Apr-07 20-Apr-07 23-Apr-07 24-Apr-07 25-Apr-07 26-Apr-07 27-Apr-07 Close 12455.37 12624.58 12786.77 12856.08 13177.74 13189.54 13183.24 13113.81 13384.08 13695.58 13607.04 13672.19 13619.7 13897.41 13928.33 14136.72 14217.77 14228.88 13908.58 MEAN Returns(x) -3.33 1.36 1.28 0.54 2.50 0.09 -0.05 -0.53 2.06 2.33 -0.65 0.48 -0.38 2.04 0.22 1.50 0.57 0.08 -2.25 0.41 X-mean -3.74 0.94 0.87 0.13 2.09 -0.32 -0.46 -0.94 1.65 1.91 -1.06 0.06 -0.80 1.62 -0.19 1.08 0.16 -0.34 -2.67 variance (x-mean)2 14.01 0.89 0.76 0.02 4.36 0.11 0.21 0.89 2.71 3.66 1.12 0.00 0.64 2.64 0.04 1.17 0.03 0.11 7.10 2.13 Sd
1.46
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.414098377 0.47879627 1.499462358 2.248387364 5.831397395 -3.329390562 2.502006833
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF APRIL-07
1. 50
1. 00
0. 50 Ser i es 1 0. 00 1 -0. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
-1. 00
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of April-07.The graph says there is lot fluctuations in the price movements. Here risk is more when compared to returns and with price variation is 3.99.The returns can fluctuate in between -3.650 and 3.732 .
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF MAY-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 1-May-07 2-May-07 3-May-07 4-May-07 7-May-07 8-May-07 9-May-07 10-May-07 11-May-07 14-May-07 15-May-07 16-May-07 17-May-07 18-May-07 21-May-07 22-May-07 23-May-07 24-May-07 25-May-07 Close 14078.21 13934.27 13879.25 13765.46 13781.51 13771.23 13796.16 13965.86 13929.33 14127.31 14299.71 14303.41 14418.6 14453.72 14363.26 14218.11 14338.45 14397.89 14508.21 MEAN returns(x) 1.22 -1.02 -0.39 -0.82 0.12 -0.07 0.18 1.23 -0.26 1.42 1.22 0.03 0.81 0.24 -0.63 -1.01 0.85 0.41 0.77 0.24 x-mean 0.98 -1.26 -0.64 -1.06 -0.12 -0.31 -0.06 0.99 -0.50 1.18 0.98 -0.21 0.57 0.00 -0.87 -1.25 0.61 0.17 0.53 variance (x-mean)2 0.96 1.59 0.40 1.12 0.02 0.10 0.00 0.98 0.25 1.39 0.96 0.05 0.32 0.00 0.75 1.56 0.37 0.03 0.28 0.51 SD
0.71
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.225323609 0.181029581 0.786545998 0.618654608 2.443748583 -1.022431119 1.421317465
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MAY-07
1. 50
1. 00
0. 50
0. 00 1 -0. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
-1. 00
-1. 50
-2. 00
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of may-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.51.The returns can fluctuate in between -1.021 and 1.421.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF JUNE-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 date 1-Jun-07 4-Jun-07 5-Jun-07 6-Jun-07 7-Jun-07 8-Jun-07 11-Jun-07 12-Jun-07 13-Jun-07 14-Jun-07 15-Jun-07 18-Jun-07 19-Jun-07 20-Jun-07 21-Jun-07 22-Jun-07 25-Jun-07 26-Jun-07 27-Jun-07 Close 14570.75 14495.77 14535.01 14255.93 14186.18 14063.81 14083.41 14130.95 14003.03 14203.72 14162.71 14080.14 14295.5 14411.95 14499.24 14467.36 14487.72 14501.08 14431.06 MEAN returns(x) 0.43 -0.51 0.27 -1.92 -0.49 -0.86 0.14 0.34 -0.91 1.43 -0.29 -0.58 1.53 0.81 0.61 -0.22 0.14 0.09 -0.48 -0.05 x-mean 0.48 -0.46 0.32 -1.87 -0.44 -0.81 0.19 0.39 -0.86 1.48 -0.24 -0.53 1.58 0.86 0.66 -0.17 0.19 0.14 -0.43 variance (x-mean)2 0.23 0.22 0.10 3.50 0.19 0.66 0.04 0.15 0.73 2.20 0.06 0.28 2.50 0.75 0.43 0.03 0.04 0.02 0.19 0.67 SD
0.82
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.024821426 0.092216028 0.826373647 0.682893404 3.449583965 -1.920053719 1.529530246
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JUNE-07
2. 50 2. 00 1. 50 1. 00 0. 50 Ser i es 1 0. 00 1 -0. 50 -1. 00 -1. 50 -2. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of june-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.65.The returns can fluctuate in between -1.901 and 1.529.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF JULY-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 2-Jul-07 3-Jul-07 5-Jul-07 6-Jul-07 9-Jul-07 10-Jul-07 11-Jul-07 12-Jul-07 13-Jul-07 16-Jul-07 17-Jul-07 18-Jul-07 19-Jul-07 20-Jul-07 23-Jul-07 24-Jul-07 25-Jul-07 26-Jul-07 27-Jul-07
Close 14664.26 14806.51 14880.24 14861.89 14964.12 15045.73 15009.88 14910.62 15092.04 15272.72 15311.22 15289.82 15301.17 15550.13 15565.55 15732.2 15794.92 15699.33 15776.31 MEAN
returns(x) 1.62 0.97 0.50 -0.12 0.69 0.55 -0.24 -0.66 1.22 1.20 0.25 -0.14 0.07 1.63 0.10 1.07 0.40 -0.61 0.49 0.41
x-mean 1.21 0.56 0.09 -0.53 0.28 0.14 -0.65 -1.07 0.81 0.79 -0.16 -0.55 -0.33 1.22 -0.31 0.66 -0.01 -1.01 0.08 variance
(x-mean)2 1.46 0.31 0.01 0.28 0.08 0.02 0.42 1.15 0.65 0.62 0.02 0.30 0.11 1.48 0.10 0.44 0.00 1.03 0.01 0.39
SD
0.62
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.472391703 0.490339397 0.683599404 0.467308146 2.288362878 -0.661297759 1.62706512
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JULY-07
2.50 2.00 1.50 1.00 0.50 0.00 1 -0.50 -1.00 -1.50 -2.00 -2.50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of july-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.39.The returns can fluctuate in between -0.6611 and 1.6270.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF AUGUST-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 1-Aug-07 2-Aug-07 3-Aug-07 6-Aug-07 7-Aug-07 8-Aug-07 9-Aug-07 10-Aug-07 13-Aug-07 14-Aug-07 15-Aug-07 16-Aug-07 17-Aug-07 20-Aug-07 21-Aug-07 22-Aug-07 23-Aug-07 24-Aug-07 27-Aug-07
Close 14935.77 14985.7 15138.4 14903.03 14932.77 15307.98 15100.15 14868.25 15017.21 15000.91 14358.21 14141.52 14427.55 13989.11 14248.66 14163.98 14424.87 14842.38 14919.19 MEAN
Returns(x) -5.33 0.33 1.02 -1.55 0.20 2.51 -1.36 -1.54 1.00 -0.11 -4.28 -1.51 2.02 -3.04 1.86 -0.59 1.84 2.89 0.52 -0.07
X-mean -5.26 0.41 1.09 -1.48 0.27 2.58 -1.29 -1.46 1.07 -0.04 -4.21 -1.44 2.09 -2.97 1.93 -0.52 1.91 2.97 0.59 Variance
(x-mean)2 27.63 0.16 1.19 2.20 0.07 6.68 1.66 2.15 1.15 0.00 17.75 2.07 4.38 8.81 3.71 0.27 3.66 8.79 0.35 3.98
Sd
2.00
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.269064502 0.199556734 2.260061558 5.107878248 8.22223801 -5.327861838 2.894376171
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF AUG-07
3. 00
2. 00
1. 00
0. 00 1 -1. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Ser i es1
-2. 00
-3. 00
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of August-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 3.98.The returns can fluctuate in between -5.327 and 2.8943.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF SEPT-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 4-Sep-07 5-Sep-07 6-Sep-07 7-Sep-07 10-Sep-07 11-Sep-07 12-Sep-07 13-Sep-07 14-Sep-07 17-Sep-07 18-Sep-07 19-Sep-07 20-Sep-07 21-Sep-07 24-Sep-07 25-Sep-07 26-Sep-07 27-Sep-07 28-Sep-07
Close 15422.05 15465.4 15446.15 15616.31 15590.42 15596.83 15542.77 15505.36 15614.44 15603.8 15504.43 15669.12 16322.75 16347.95 16564.23 16845.83 16899.54 16921.39 17150.56 MEAN
Returns(x) 3.37 0.28 -0.12 1.10 -0.17 0.04 -0.35 -0.24 0.70 -0.07 -0.64 1.06 4.17 0.15 1.32 1.70 0.32 0.13 1.35 0.74
X-mean 2.63 -0.46 -0.87 0.36 -0.91 -0.70 -1.09 -0.98 -0.04 -0.81 -1.38 0.32 3.43 -0.59 0.58 0.96 -0.42 -0.61 0.61 variance
(x-mean)2 6.90 0.21 0.75 0.13 0.83 0.49 1.19 0.97 0.00 0.66 1.91 0.10 11.75 0.35 0.34 0.91 0.18 0.38 0.37 1.50
Sd
1.22
DESCRIPTIVE STATISTIC Mean 0.743625816
Median Standard Deviation Sample Variance Range Minimum Maximum
0.281091035 1.256553092 1.578925674 4.808285205 -0.636832054 4.171453151
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF SEPT-07
3.00 2.00 1 .00 0.00 1 -1 .00 - 2.00 - 3.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of sept07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.50.The returns can fluctuate in between -0.6361 and 4.1714.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF OCT-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 1-Oct-07 2-Oct-07 3-Oct-07 4-Oct-07 5-Oct-07 8-Oct-07 9-Oct-07 10-Oct-07 11-Oct-07 12-Oct-07 15-Oct-07 16-Oct-07 17-Oct-07 18-Oct-07 19-Oct-07 22-Oct-07 23-Oct-07 24-Oct-07 25-Oct-07
Close 17328.62 17847.04 17777.14 17773.36 17491.39 18280.24 18658.25 18814.07 18419.04 19058.67 19051.86 18715.82 17998.39 17559.98 17613.99 18492.84 18512.91 18770.89 19243.17 MEAN
Returns(x) 1.04 2.99 -0.39 -0.02 -1.59 4.51 2.07 0.84 -2.10 3.47 -0.04 -1.76 -3.83 -2.44 0.31 4.99 0.11 1.39 2.52 0.53
X-mean 0.51 2.47 -0.92 -0.55 -2.11 3.98 1.54 0.31 -2.63 2.95 -0.56 -2.29 -4.36 -2.96 -0.22 4.46 -0.42 0.87 1.99 variance
(x-mean)2 0.26 6.08 0.84 0.30 4.46 15.87 2.38 0.10 6.90 8.68 0.32 5.25 19.01 8.78 0.05 19.92 0.17 0.75 3.96 6.05
Sd
2.46
DESCRIPTIVE STATISTIC Mean 0.634890588
Median Standard Deviation Sample Variance Range Minimum Maximum
0.307574382 2.401787736 5.768584327 8.822780973 -3.833281149 4.989499824
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF OCT-07
2.00 1 .50 1 .00 0.50 0.00 - 0.50 -1 .00 -1 .50 - 2.00 - 2.50 - 3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of oct07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.50.The returns can fluctuate in between -3.8331 and 4.9814.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF NOV-07
S.no
Date
Close
Returns(x)
X-mean
(x-mean)2
Sd
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
1-Nov-07 2-Nov-07 5-Nov-07 6-Nov-07 7-Nov-07 8-Nov-07 9-Nov-07 12-Nov-07 13-Nov-07 14-Nov-07 15-Nov-07 16-Nov-07 19-Nov-07 20-Nov-07 21-Nov-07 23-Nov-07 26-Nov-07 27-Nov-07 28-Nov-07
19724.35 19976.23 19590.78 19400.67 19289.83 19058.93 18907.6 18737.27 19035.48 19929.06 19784.89 19698.36 19633.36 19280.8 18602.62 18526.32 18852.87 19247.54 19127.73 MEAN
2.50 1.28 -1.93 -0.97 -0.57 -1.20 -0.79 -0.90 1.59 4.69 -0.72 -0.44 -0.33 -1.80 -3.52 -0.41 1.76 2.09 -0.62 -0.15
2.66 1.43 -1.78 -0.82 -0.42 -1.04 -0.64 -0.75 1.75 4.85 -0.57 -0.28 -0.18 -1.64 -3.36 -0.26 1.92 2.25 -0.47 variance
7.05 2.05 3.15 0.67 0.17 1.09 0.41 0.56 3.05 23.51 0.32 0.08 0.03 2.69 11.31 0.07 3.68 5.05 0.22 3.23
1.80
DESCRIPTIVE STATISTIC Mean Median Standard Deviation -0.014748575 -0.571320475 1.897068332
Sample Variance Range Minimum Maximum
3.598868255 8.21167184 -3.517385171 4.694286669
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF NOV-07
4.00 3.00 2.00 1 .00 0.00 1 -1 .00 - 2.00 - 3.00 - 4.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of nov07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 3.23.The returns can fluctuate in between -3.5173 and 4.6934.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF DEC-07
S.no
Date
Close
Returns(x)
X-mean
(x-mean)2
Sd
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
3-Dec-07 4-Dec-07 5-Dec-07 6-Dec-07 7-Dec-07 10-Dec-07 11-Dec-07 12-Dec-07 13-Dec-07 14-Dec-07 17-Dec-07 18-Dec-07 19-Dec-07 20-Dec-07 21-Dec-07 24-Dec-07 26-Dec-07 27-Dec-07 28-Dec-07
19603.41 19529.5 19738.07 19795.87 19966 19930.68 20290.89 20375.87 20104.39 20030.83 19261.35 19079.64 19091.96 19162.57 19854.12 20192.52 20216.72 20206.95 20286.99 MEAN
2.49 -0.38 1.07 0.29 0.86 -0.18 1.81 0.42 -1.33 -0.37 -3.84 -0.94 0.06 0.37 3.61 1.70 0.12 -0.05 0.40 0.32
2.17 -0.70 0.75 -0.03 0.54 -0.50 1.49 0.10 -1.65 -0.69 -4.16 -1.27 -0.26 0.05 3.29 1.38 -0.20 -0.37 0.07 variance
4.69 0.49 0.56 0.00 0.29 0.25 2.21 0.01 2.74 0.47 17.33 1.60 0.07 0.00 10.81 1.91 0.04 0.14 0.01 2.29
1.51
DESCRIPTIVE STATISTIC Mean Median Standard Deviation 0.321657448 0.292835115 1.556319052
Sample Variance Range Minimum Maximum
2.422128992 7.450336672 -3.841478361 3.608858311
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF DEC-07
2.50 2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 -2.50 -3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 12 1 3 1 4 1 5 1 6 1 7 18 1 9 Series1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of December-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 2.29.The returns can fluctuate in between -3.8414 and 3.6088.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF JAN-07
S.no 1 Date 3-Jan-07 Close 2422.10 2423.16 Returns(x) 0.04 X-mean -0.02 (x-mean)2 0.00 Sd
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
4-Jan-07 5-Jan-07 8-Jan-07 9-Jan-07 10-Jan-07 11-Jan-07 12-Jan-07 16-Jan-07 17-Jan-07 18-Jan-07 19-Jan-07 22-Jan-07 23-Jan-07 24-Jan-07 25-Jan-07 26-Jan-07 29-Jan-07 30-Jan-07
2453.43 2434.25 2438.20 2443.83 2459.33 2484.85 2502.82 2497.78 2479.42 2443.21 2451.31 2431.07 2431.41 2466.28 2434.24 2435.49 2441.09 2448.64 mean
1.25 -0.78 0.16 0.23 0.63 1.04 0.72 -0.20 -0.74 -1.46 0.33 -0.83 0.01 1.43 -1.30 0.05 0.23 0.31 0.06
1.19 -0.84 0.10 0.17 0.57 0.98 0.66 -0.26 -0.80 -1.52 0.27 -0.89 -0.05 1.37 -1.36 -0.01 0.17 0.25 variance
1.41 0.71 0.01 0.03 0.33 0.96 0.44 0.07 0.63 2.31 0.07 0.79 0.00 1.89 1.85 0.00 0.03 0.06 0.61
0.78
DESCRIPTIVE STATISTIC Mean Median Standard Deviation 0.060424758 0.162267639 0.802326123
Sample Variance Range Minimum Maximum
0.643727208 2.89456946 -1.460422196 1.434147264
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JAN-07
2.00 0.00 1 -2.00 4 7 10 13 16 19 jan
Above table and graph depicts, the risk and returns of NASDAQ for the month of January-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.61.The returns can fluctuate in between -1.4604 and 1.4341. .
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF FEB-07
s.no 1 2 Date 1-Feb-07 2-Feb-07 close 2468.38 2475.88 returns(x) 0.81 0.30 x-mean 0.87 0.37 (x-mean)2 0.76 0.14 SD
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
5-Feb-07 6-Feb-07 7-Feb-07 8-Feb-07 9-Feb-07 12-Feb-07 13-Feb-07 14-Feb-07 15-Feb-07 16-Feb-07 20-Feb-07 21-Feb-07 22-Feb-07 23-Feb-07 26-Feb-07 27-Feb-07 28-Feb-07
2470.60 2471.49 2490.50 2488.67 2459.82 2450.38 2459.88 2488.38 2497.10 2496.31 2513.04 2518.42 2524.94 2515.10 2504.52 2407.86 2416.15 mean
-0.21 0.04 0.77 -0.07 -1.16 -0.38 0.39 1.16 0.35 -0.03 0.67 0.21 0.26 -0.39 -0.42 -3.86 0.34 -0.06
-0.15 0.10 0.83 -0.01 -1.09 -0.32 0.45 1.22 0.42 0.03 0.74 0.28 0.32 -0.32 -0.36 -3.79 0.41 variance
0.02 0.01 0.70 0.00 1.20 0.10 0.20 1.50 0.17 0.00 0.54 0.08 0.10 0.11 0.13 14.40 0.17 1.07
1.03
DESCRIPTIVE STATISTIC Mean Median Standard Deviation -0.064832507 0.214083341 1.062446461
Sample Variance Range Minimum Maximum
1.128792482 5.018015267 -3.859422165 1.158593102
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF FEB-07
2.00 0.00 -2.00 -4.00 -6.00 1 3 5 7 9 11 13 15 17 19 Series1
Above table and graph depicts, the risk and returns of NASDAQ for the month of February-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.07.The returns can fluctuate in between -3.8594 and 1.1585.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF MARCH-07
S.no 1 2 3 Date 1-Mar-07 2-Mar-07 5-Mar-07 Close 2404.21 2368.00 2340.68 Returns(x) -0.49 -1.51 -1.15 X-mean -0.67 -1.68 -1.33 (x-mean)2 0.45 2.83 1.77 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
6-Mar-07 7-Mar-07 8-Mar-07 9-Mar-07 12-Mar-07 13-Mar-07 14-Mar-07 15-Mar-07 16-Mar-07 19-Mar-07 20-Mar-07 21-Mar-07 22-Mar-07 23-Mar-07 26-Mar-07 27-Mar-07
2385.14 2374.64 2387.73 2387.55 2402.29 2350.57 2371.74 2378.70 2372.66 2394.41 2408.21 2455.92 2451.74 2448.93 2455.63 2437.43 mean
1.90 -0.44 0.55 -0.01 0.62 -2.15 0.90 0.29 -0.25 0.92 0.58 1.98 -0.17 -0.11 0.27 -0.74 0.18
1.72 -0.62 0.38 -0.18 0.44 -2.33 0.73 0.12 -0.43 0.74 0.40 1.81 -0.35 -0.29 0.10 -0.92 variance
2.97 0.38 0.14 0.03 0.20 5.42 0.53 0.01 0.18 0.55 0.16 3.26 0.12 0.08 0.01 0.84 0.98
0.99
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.0513323 -0.007538541 1.044587014 1.09116203 4.13408525 -2.152945731 1.981139519
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MARCH-07
2.50 2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 -2.50 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es1
Above table and graph depicts, the risk and returns of NASDAQ for the month of march-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.98.The returns can fluctuate in between -2.1529 and 1.9811.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF APRIL-07
S.no 1 2 3 Date 2-Apr-07 3-Apr-07 4-Apr-07 Close 2422.26 2450.33 2458.69 Returns(x) -0.62 1.16 0.34 X-mean -0.88 0.90 0.09 (x-mean)2 0.77 0.82 0.01 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
5-Apr-07 9-Apr-07 10-Apr-07 11-Apr-07 12-Apr-07 13-Apr-07 16-Apr-07 17-Apr-07 18-Apr-07 19-Apr-07 20-Apr-07 23-Apr-07 24-Apr-07 25-Apr-07 26-Apr-07 27-Apr-07
2471.34 2469.18 2477.61 2459.31 2480.32 2491.94 2518.33 2516.95 2510.50 2505.35 2526.39 2523.67 2524.54 2547.89 2554.46 2557.21 mean
0.51 -0.09 0.34 -0.74 0.85 0.47 1.06 -0.05 -0.26 -0.21 0.84 -0.11 0.03 0.92 0.26 0.11 0.25
0.26 -0.34 0.09 -0.99 0.60 0.21 0.80 -0.31 -0.51 -0.46 0.59 -0.36 -0.22 0.67 0.00 -0.15 variance
0.07 0.12 0.01 0.99 0.36 0.05 0.65 0.10 0.26 0.21 0.34 0.13 0.05 0.45 0.00 0.02 0.28
0.53
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance 0.254220378 0.257860426 0.547031309 0.299243253
Range Minimum Maximum
1.897450174 -0.738615036 1.158835137
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF APRIL-07
1. 50
1. 00
0. 50 Ser i es 1 0. 00 1 -0.50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
-1.00
Above table and graph depicts, the risk and returns of NASDAQ for the month of april-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.28.The returns can fluctuate in between -0.7386 and 1.1588.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF MAY-07
S.no 1 2 3 Date 1-May-07 2-May-07 3-May-07 Close 2531.53 2557.84 2565.46 Returns(x) -1.00 1.04 0.30 X-mean -1.01 1.04 0.30 (x-mean)2 1.01 1.08 0.09 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
4-May-07 7-May-07 8-May-07 9-May-07 10-May-07 11-May-07 14-May-07 15-May-07 16-May-07 17-May-07 18-May-07 21-May-07 22-May-07 23-May-07 24-May-07 25-May-07
2572.15 2570.95 2571.75 2576.34 2533.74 2562.22 2546.44 2525.29 2547.42 2539.38 2558.45 2578.79 2588.02 2577.05 2537.92 2557.19 mean
0.26 -0.05 0.03 0.18 -1.65 1.12 -0.62 -0.83 0.88 -0.32 0.75 0.80 0.36 -0.42 -1.52 0.76 0.00
0.26 -0.05 0.03 0.18 -1.66 1.12 -0.62 -0.83 0.87 -0.32 0.75 0.79 0.36 -0.43 -1.52 0.76 variance
0.07 0.00 0.00 0.03 2.74 1.26 0.38 0.69 0.77 0.10 0.56 0.63 0.13 0.18 2.31 0.57 0.62
0.79
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.003284241 0.17847769 0.836667474 0.700012462 2.777538555
Minimum Maximum
-1.653508465 1.12403009
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MAY-07
1. 50
1. 00
0. 50
0. 00 1 -0. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
-1. 00
-1. 50
-2. 00
Above table and graph depicts, the risk and returns of NASDAQ for the month of may-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.62 the returns can fluctuate in between -1.6535 and 1.1240.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF JUNE-07
S.NO 1 2 3 4 DATE 1-Jun-07 4-Jun-07 5-Jun-07 6-Jun-07 CLOSE 2613.92 2618.29 2611.23 2587.18 RETURNS(X) 2.22 0.17 -0.27 -0.92 X-MEAN 2.23 0.18 -0.26 -0.91 (X-MEAN)2 4.99 0.03 0.07 0.82 SD
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
7-Jun-07 8-Jun-07 11-Jun-07 12-Jun-07 13-Jun-07 14-Jun-07 15-Jun-07 18-Jun-07 19-Jun-07 20-Jun-07 21-Jun-07 22-Jun-07 25-Jun-07 26-Jun-07 27-Jun-07
2541.38 2573.54 2572.15 2549.77 2582.31 2599.41 2626.71 2626.60 2626.76 2599.96 2616.96 2588.96 2577.08 2574.16 2605.35 mean
-1.77 1.27 -0.05 -0.87 1.28 0.66 1.05 0.00 0.01 -1.02 0.65 -1.07 -0.46 -0.11 1.21 -0.01
-1.76 1.28 -0.04 -0.86 1.29 0.68 1.06 0.01 0.02 -1.01 0.67 -1.06 -0.44 -0.10 1.23 variance
3.08 1.64 0.00 0.73 1.67 0.46 1.13 0.00 0.00 1.01 0.45 1.11 0.20 0.01 1.50 0.77
0.88
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.103142764 -0.004187748 1.017582244 1.035473623 3.988717962
Minimum Maximum
-1.770267241 2.218450721
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JUNE-07
2. 50 2. 00 1. 50 1. 00 0. 50 Ser i es 1 0. 00 1 -0. 50 -1. 00 -1. 50 -2. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Above table and graph depicts, the risk and returns of NASDAQ for the month of june-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.77he returns can fluctuate in between -1.7704 and 2.2184.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF JULY-07
S.no 1 2 3 4 5 Date 2-Jul-07 3-Jul-07 5-Jul-07 6-Jul-07 9-Jul-07 Close 2632.30 2644.95 2656.65 2666.51 2670.02 Returns(x) 1.03 0.48 0.44 0.37 0.13 X-mean 1.18 0.63 0.59 0.52 0.28 (x-mean)2 1.39 0.39 0.34 0.27 0.08 Sd
6 7 8 9 10 11 12 13 14 15 16 17 18 19
10-Jul-07 11-Jul-07 12-Jul-07 13-Jul-07 16-Jul-07 17-Jul-07 18-Jul-07 19-Jul-07 20-Jul-07 23-Jul-07 24-Jul-07 25-Jul-07 26-Jul-07 27-Jul-07
2639.16 2651.79 2701.73 2707.00 2697.33 2712.29 2699.49 2720.04 2687.60 2690.58 2639.86 2648.17 2599.34 2562.24 mean
-1.16 0.48 1.88 0.20 -0.36 0.55 -0.47 0.76 -1.19 0.11 -1.89 0.31 -1.84 -1.43 -0.14
-1.01 0.62 2.03 0.34 -0.21 0.70 -0.33 0.91 -1.05 0.26 -1.74 0.46 -1.70 -1.28 variance
1.02 0.39 4.11 0.12 0.05 0.49 0.11 0.82 1.10 0.07 3.03 0.21 2.89 1.64 0.95
0.98
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range -0.082912523 0.195060202 1.011945693 1.024034086 3.768351623
Minimum
MAXIMUM GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JULY-07
2. 50 2. 00 1. 50 1. 00 0. 50 0. 00 1 -0. 50 -1. 00 -1. 50 -2. 00 -2. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
-1.885095407 1.883256216
Above table and graph depicts, the risk and returns of NASDAQ for the month of july-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.95.The returns can fluctuate in between -1.885 and 1.883.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF AUG-07
S.no 1 2 3 Date 1-Aug-07 2-Aug-07 3-Aug-07 Close 2553.87 2575.98 2511.25 Returns(x) -0.33 0.87 -2.51 X-mean -0.46 0.73 -2.64 (x-mean)2 0.21 0.54 6.99 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
6-Aug-07 7-Aug-07 8-Aug-07 9-Aug-07 10-Aug-07 13-Aug-07 14-Aug-07 15-Aug-07 16-Aug-07 17-Aug-07 20-Aug-07 21-Aug-07 22-Aug-07 23-Aug-07 24-Aug-07 27-Aug-07
2547.33 2561.60 2612.98 2556.49 2544.89 2542.24 2499.12 2458.83 2451.07 2505.03 2508.59 2521.30 2552.80 2541.70 2576.69 2561.25 mean
1.44 0.56 2.01 -2.16 -0.45 -0.10 -1.70 -1.61 -0.32 2.20 0.14 0.51 1.25 -0.43 1.38 -0.60 0.13
1.31 0.43 1.87 -2.29 -0.59 -0.24 -1.83 -1.74 -0.45 2.07 0.01 0.38 1.12 -0.57 1.25 -0.73 variance
1.70 0.18 3.51 5.26 0.34 0.06 3.34 3.04 0.20 4.29 0.00 0.14 1.25 0.32 1.55 0.53 1.61
1.27
.
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.006709979 -0.104130237 1.357378425 1.842476189 4.714317582
Minimum Maximum
-2.512830069 2.201487514
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF AUG-07
3. 00
2. 00
1. 00
0. 00 1 -1. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Ser i es 1
-2. 00
-3. 00
Above table and graph depicts, the risk and returns of NASDAQ for the month of August-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.61.The returns can fluctuate in between -2.51 and 2.20.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF SEPT-07
S.no 1 2 3 4 Date 4-Sep-07 5-Sep-07 6-Sep-07 7-Sep-07 Close 2630.24 2605.95 2614.32 2565.70 Returns(x) 2.69 -0.92 0.32 -1.86 X-mean 2.41 -1.21 0.03 -2.15 (x-mean)2 5.79 1.46 0.00 4.61 Sd
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
10-Sep-07 11-Sep-07 12-Sep-07 13-Sep-07 14-Sep-07 17-Sep-07 18-Sep-07 19-Sep-07 20-Sep-07 21-Sep-07 24-Sep-07 25-Sep-07 26-Sep-07 27-Sep-07 28-Sep-07
2559.11 2597.47 2592.07 2601.06 2602.18 2581.66 2651.66 2666.48 2654.29 2671.22 2667.95 2683.45 2699.03 2709.59 2701.50 Mean
-0.26 1.50 -0.21 0.35 0.04 -0.79 2.71 0.56 -0.46 0.64 -0.12 0.58 0.58 0.39 -0.30 0.29
-0.54 1.21 -0.49 0.06 -0.24 -1.08 2.42 0.27 -0.74 0.35 -0.41 0.29 0.29 0.10 -0.59 variance
0.30 1.47 0.24 0.00 0.06 1.16 5.88 0.07 0.55 0.12 0.17 0.09 0.09 0.01 0.34 1.18
1.09
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.286837829 0.32118805 1.116017421 1.245494885 4.571190759
Minimum Maximum
-1.859757031 2.711433729
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF SEPT-07
3.00 2.00 1 .00 0.00 1 -1 .00 - 2.00 - 3.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of NASDAQ for the month of September-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.18.The returns can fluctuate in between -1.8595 and 2.7114.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF OCT-07
S.no 1 2 3 4 5 Date 1-Oct-07 2-Oct-07 3-Oct-07 4-Oct-07 5-Oct-07 Close 2740.99 2747.11 2729.43 2733.57 2780.32 Returns(x) 1.46 0.22 -0.64 0.15 1.71 X-mean 1.41 0.17 -0.70 0.10 1.65 (x-mean)2 1.98 0.03 0.49 0.01 2.74 Sd
6 7 8 9 10 11 12 13 14 15 16 17 18 19
8-Oct-07 9-Oct-07 10-Oct-07 11-Oct-07 12-Oct-07 15-Oct-07 16-Oct-07 17-Oct-07 18-Oct-07 19-Oct-07 22-Oct-07 23-Oct-07 24-Oct-07 25-Oct-07
2787.37 2803.91 2811.61 2772.20 2805.68 2780.05 2763.91 2792.67 2799.31 2725.16 2753.93 2799.26 2774.76 2750.86 Mean
0.25 0.59 0.27 -1.40 1.21 -0.91 -0.58 1.04 0.24 -2.65 1.06 1.65 -0.88 -0.86 0.06
0.20 0.54 0.22 -1.46 1.15 -0.97 -0.64 0.98 0.18 -2.70 1.00 1.59 -0.93 -0.92 variance
0.04 0.29 0.05 2.12 1.33 0.94 0.40 0.97 0.03 7.31 1.00 2.53 0.87 0.84 1.34
1.16
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum 0.101658334 0.237765293 1.152933714 1.329256149 4.359084816 -2.648867042
Maximum
1.710217774
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF OCT-07
2.00 1 .50 1 .00 0.50 0.00 - 0.50 -1 .00 -1 .50 - 2.00 - 2.50 - 3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of NASDAQ for the month of October-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.34.The returns can fluctuate in between -2.641 and 1.7102.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF NOV-07
S.no 1 2 3 4 5 6 7 Date 1-Nov-07 2-Nov-07 5-Nov-07 6-Nov-07 7-Nov-07 8-Nov-07 9-Nov-07 Close 2794.83 2810.38 2795.18 2825.18 2748.76 2696.00 2627.94 Returns(x) 1.60 0.56 -0.54 1.07 -2.70 -1.92 -2.52 X-mean 1.85 0.81 -0.29 1.33 -2.45 -1.67 -2.27 (x-mean)2 3.42 0.65 0.08 1.76 6.02 2.78 5.16 Sd
8 9 10 11 12 13 14 15 16 17 18 19
12-Nov-07 13-Nov-07 14-Nov-07 15-Nov-07 16-Nov-07 19-Nov-07 20-Nov-07 21-Nov-07 23-Nov-07 26-Nov-07 27-Nov-07 28-Nov-07
2584.13 2673.65 2644.32 2618.51 2637.24 2593.38 2596.81 2562.15 2596.60 2540.99 2580.80 2662.91 mean
-1.67 3.46 -1.10 -0.98 0.72 -1.66 0.13 -1.33 1.34 -2.14 1.57 3.18 -0.25
-1.42 3.72 -0.85 -0.72 0.97 -1.41 0.38 -1.08 1.60 -1.89 1.82 3.43 variance
2.00 13.81 0.71 0.52 0.94 1.99 0.15 1.17 2.55 3.57 3.31 11.79 3.28
1.81
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.154558313 -0.540852127 1.859108495 3.456284396 6.169182393 -2.704960392 3.464222001
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF NOV-07
4.00 3.00 2.00 1.00 0.00 1 -1 .00 -2.00 -3.00 -4.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 13 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of NASDAQ for the month of November-07 graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 3.28.The returns can fluctuate in between -2.704 and 3.468.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF DEC-07
S.no 1 2 3 4 5 6 7 Date 3-Dec-07 4-Dec-07 5-Dec-07 6-Dec-07 7-Dec-07 10-Dec-07 11-Dec-07 Close 2637.13 2619.83 2666.36 2709.03 2706.16 2718.95 2652.35 Returns(x) -0.97 -0.66 1.78 1.60 -0.11 0.47 -2.45 X-mean -1.00 -0.69 1.74 1.57 -0.14 0.44 -2.48 (x-mean)2 1.00 0.47 3.04 2.46 0.02 0.19 6.15 Sd
8 9 10 11 12 13 14 15 16 17 18 19
12-Dec-07 13-Dec-07 14-Dec-07 17-Dec-07 18-Dec-07 19-Dec-07 20-Dec-07 21-Dec-07 24-Dec-07 26-Dec-07 27-Dec-07 28-Dec-07
2671.14 2668.49 2635.74 2574.46 2596.03 2601.01 2640.86 2691.99 2713.50 2724.41 2676.79 2674.46 mean
0.71 -0.10 -1.23 -2.32 0.84 0.19 1.53 1.94 0.80 0.40 -1.75 -0.09 0.03
0.68 -0.13 -1.26 -2.36 0.81 0.16 1.50 1.91 0.77 0.37 -1.78 -0.12 variance
0.46 0.02 1.58 5.55 0.65 0.03 2.25 3.63 0.59 0.14 3.16 0.01 1.65
1.29
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.031077258 0.191831373 1.321196342 1.745559774 4.385586702 -2.449474981 1.936111721
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF DEC-07
2.50 2.00 1 .50 1 .00 0.50 0.00 -0.50 -1 .00 -1 .50 -2.00 -2.50 -3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 Series1
Above table and graph depicts, the risk and returns of NASDAQ for the month of December-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.65.The returns can fluctuate in between -2.4494 and 1.9361.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH JAN-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 BSE 0.01 0.52 -1.02 -0.08 -1.50 -0.63 -1.50 2.01 3.12 0.52 -0.11 0.12 NASDAQ 0.04 1.25 -0.78 0.16 0.23 0.63 1.04 0.72 -0.20 -0.74 -1.46 0.33 CORREL
13 14 15 16 17 18 19
0.61 -0.25 0.19 -1.18 0.49 1.22 -0.50
-0.83 0.01 1.43 -1.30 0.05 0.23 0.31
0.07
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF JAN-07
4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION. THERE IS A SLIGHT POSITIVE CORRELATION BETWEEN THEM.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH FEB-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 BSE 0.39 0.96 0.78 -0.26 1.14 0.06 -0.77 -2.39 -0.70 -0.58 2.47 0.33 -1.04 NASDAQ 0.81 0.30 -0.21 0.04 0.77 -0.07 -1.16 -0.38 0.39 1.16 0.35 -0.03 0.67 CORREL
14 15 16 17 18 19
-0.46 -1.18 -2.77 0.12 -1.25 -4.01
0.21 0.26 -0.39 -0.42 -3.86 0.34
0.20
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF FEB-07
3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 -5.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY AT THE STARTING THEY HAVE STARTED STUDYLY BUT AT THE MIDDLE STAGE THERE HAS BEEN A FLUCUATION IN BOTH BSE AND NASDAQ. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE OPPOSITE DIRECTION. BY LOOKING AT THE CORRELATION WE CAN SAY THAT THERE IS STORNG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH MARCH-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 BSE 1.71 -2.08 -3.66 2.27 -0.92 3.73 -1.26 0.14 0.62 -3.49 0.11 -0.90 NASDAQ -0.49 -1.51 -1.15 1.90 -0.44 0.55 -0.01 0.62 -2.15 0.90 0.29 -0.25 CORREL
13 14 15 16 17 18 19
1.73 0.48 1.89 2.80 -0.17 -1.22 -1.83
0.92 0.58 1.98 -0.17 -0.11 0.27 -0.74
0.40
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF MARCH-07
5.00 4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 -5.00
BSE 1 3 5 7 9 11 13 15 17 19 NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE HAS BEEN A GREAT AMOUT FLUCUATION GOING IN BOTH THE MARKETS, THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS STRONG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH APRIL-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 BSE -3.33 1.36 1.28 0.54 2.50 0.09 -0.05 -0.53 2.06 2.33 -0.65 NASDAQ -0.62 1.16 0.34 0.51 -0.09 0.34 -0.74 0.85 0.47 1.06 -0.05 CORREL
12 13 14 15 16 17 18 19
0.48 -0.38 2.04 0.22 1.50 0.57 0.08 -2.25
-0.26 -0.21 0.84 -0.11 0.03 0.92 0.26 0.11
0.49
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF APRIL-07
3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THE BSE WAS GOING GREAT IN THE BEGINNING BUT AT THE END OF THE PERIOD IT WAS GOING DOWN AGAIN. THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE STRONG CORRELATION. CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH MAY-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 BSE 1.22 -1.02 -0.39 -0.82 0.12 -0.07 0.18 1.23 -0.26 1.42 1.22 0.03 0.81 0.24 -0.63 -1.01 NASDAQ -1.00 1.04 0.30 0.26 -0.05 0.03 0.18 -1.65 1.12 -0.62 -0.83 0.88 -0.32 0.75 0.80 0.36 CORREL
17 18 19
0.85 0.41 0.77
-0.42 -1.52 0.76
-0.69
CORRELATION OF RETURNS BETW EEN BSE AND NASDAQ FOR THE MONTH OF MAY-07
2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 1 4 7 10 13 16 19 BSE N A SDA Q
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE NEGITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH JUNE-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BSE 0.43 -0.51 0.27 -1.92 -0.49 -0.86 0.14 0.34 -0.91 1.43 -0.29 -0.58 1.53 0.81 0.61 -0.22 0.14 NASDAQ 2.22 0.17 -0.27 -0.92 -1.77 1.27 -0.05 -0.87 1.28 0.66 1.05 0.00 0.01 -1.02 0.65 -1.07 -0.46 CORREL
18 19
0.09 -0.48
-0.11 1.21
0.05
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF JUNE-07
3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SLIGHT POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH JULY-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BSE 1.62 0.97 0.50 -0.12 0.69 0.55 -0.24 -0.66 1.22 1.20 0.25 -0.14 0.07 1.63 0.10 1.07 0.40 NASDAQ 1.03 0.48 0.44 0.37 0.13 -1.16 0.48 1.88 0.20 -0.36 0.55 -0.47 0.76 -1.19 0.11 -1.89 0.31 CORREL
18 19
-0.61 0.49
-1.84 -1.43
-0.17
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF JULY-07
2.50 2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 -2.50
BSE 1 3 5 7 9 11 13 15 17 19 NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE HAS BEEN FALL IN THE BOTH BSE AND NASDAQ BUT AT THE LATER STAGE THERE HAS BEEN FLUCUATIONS IN THE MARKET. BUT BY LOOKING AT THE NEGITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SLIGHT NEGITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH AUG-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BSE -5.33 0.33 1.02 -1.55 0.20 2.51 -1.36 -1.54 1.00 -0.11 -4.28 -1.51 2.02 -3.04 1.86 -0.59 1.84 NASDAQ -0.33 0.87 -2.51 1.44 0.56 2.01 -2.16 -0.45 -0.10 -1.70 -1.61 -0.32 2.20 0.14 0.51 1.25 -0.43 CORREL
18 19
2.89 0.52
1.38 -0.60
0.37
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF AUG-07
4.00 2.00 0.00 1 -2.00 -4.00 -6.00 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.THERE IS A STRONG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH SEPT-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 BSE 3.37 0.28 -0.12 1.10 -0.17 0.04 -0.35 -0.24 0.70 -0.07 -0.64 1.06 4.17 0.15 1.32 1.70 0.32 0.13 NASDAQ 2.69 -0.92 0.32 -1.86 -0.26 1.50 -0.21 0.35 0.04 -0.79 2.71 0.56 -0.46 0.64 -0.12 0.58 0.58 0.39 CORREL
19
1.35
-0.30
0.02
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF SEPT-07
5.00 4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION. THERE HAS BEEN SLIGHT CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH OCT-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 BSE 1.04 2.99 -0.39 -0.02 -1.59 4.51 2.07 0.84 -2.10 3.47 -0.04 -1.76 -3.83 -2.44 0.31 4.99 0.11 1.39 NASDAQ 1.46 0.22 -0.64 0.15 1.71 0.25 0.59 0.27 -1.40 1.21 -0.91 -0.58 1.04 0.24 -2.65 1.06 1.65 -0.88 CORREL
19
2.52
-0.86
0.12
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF OCT-07
6.00 4.00 2.00 0.00 -2.00 -4.00 -6.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH NOV-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 BSE 2.50 1.28 -1.93 -0.97 -0.57 -1.20 -0.79 -0.90 1.59 4.69 -0.72 -0.44 -0.33 -1.80 -3.52 -0.41 1.76 2.09 -0.62 NASDAQ 1.60 0.56 -0.54 1.07 -2.70 -1.92 -2.52 -1.67 3.46 -1.10 -0.98 0.72 -1.66 0.13 -1.33 1.34 -2.14 1.57 3.18 CORREL
0.23
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF NOV-07
6.00 4.00 2.00 0.00 1 -2.00 -4.00 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE STRONG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH DEC-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 BSE 2.49 -0.38 1.07 0.29 0.86 -0.18 1.81 0.42 -1.33 -0.37 -3.84 -0.94 0.06 0.37 3.61 1.70 0.12 -0.05 0.40 NASDAQ -0.97 -0.66 1.78 1.60 -0.11 0.47 -2.45 0.71 -0.10 -1.23 -2.32 0.84 0.19 1.53 1.94 0.80 0.40 -1.75 -0.09 CORREL
0.36
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF DEC-07
4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 -5.00
BSE 1 3 5 7 9 11 13 15 17 19 NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.
CONCLUSION
Here correlation means relation ship between two or more variables. In this study we taken two variables BSE SENSEX and NASDAQ. In the month of April the correlation between BSE SENSEX and NASDAQ is 0.49.so there exists slight positive relation ship and all data points are form as non linear structure and tilts upwards towards right. Remaining all the months there exists low correlation, and in the months of july and may there exists negative correlation ie -0.17 and -0.69, so there exists strong negative relationship and all data points tilts downward towards right. There is an overall positive as well as negative correlation of returns between the BSE sensex and NASDAQ stock exchange, because out of (12) month data collected (10) months have positive correlation and (2) months have negative correlation on returns. It shows that when BSE is increasing NASDAQ is decreasing and vice-versa because financial institutions are the main investors in BSE sensex
If we see the closing of both BSE and NASDAQ it’s as follows. BSE started with a closing of 13940.14and NASDAQ started with a closing of 2422.41 By seeing the closing of both the stock markets we can say that increase and movement of funds is more in BSE when compared to NASDAQ.
BIBLIOGRAPY 1. WEBSITES • http://www.bseindia.com • http://www.bseindia.com/about/introbse.asp • http://www.bseindia.com/about/abindices/preface.asp • http://www.ieg.nic.in/dis_rna_20.pdf • http://en.wikipedia.org/wiki/NASDAQ • http://www.nasdaq.com/ • http://images.search.yahoo.com/search/images? _adv_prop=images&imgsz=all&va=nasdaq+logo&ei=UTF8&fr=slv8-msgr&b=1 2. NEWS PAPER ? Times of India ? Business Line 3. BOOKS • Donald E. Fischer & Ronald J. Jordan
(SECURITY ANALYSIS AND PORTFOLIO MANAGENENT)
doc_555853513.doc
Study Reports On Correlating Indian Stock Indices (BSE) With American Stock Indices (NASDAQ), A correlation function is a statistical correlation between random variables at two different points in space or time, usually as a function of the spatial or temporal distance between the points. If one considers the correlation function between random variables representing the same quantity measured at two different points then this is often referred to as an autocorrelation function being made up of autocorrelations.
STUDY REPORTS ON CORRELATING INDIAN STOCK INDICES (BSE) WITH AMERICAN STOCK INDICES (NASDAQ)
ABSTRACT
Correlating BSE Sensex with NASDAQ stock exchange. This study tries to analyze the relation between BSE sensex with NASDAQ. When BSE sensex increases to new highs questions arises that weather there is an increase in other world stock market or not, I tried to find out the correlation between BSE sensex with NASDAQ For this purpose I have collected daily 1 year closings from 1 st JAN 2007 to 31st DEC 2007 of BSE and AMERICAN stock markets. FINDINGS OF THE STUDY: The study suggested that there is an overall positive as well as negative correlation between BSE sensex and NASDAQ. The study supports that mergers of top Indian companies will have its effect on Indian as well as foreign stock markets also.
TABLES OF CONTENT 1. INTRODUCTION
1.1 OBJECTIVE OF THE STUDY
2. COMPANY PROFILE
2.1 2.2 BSE NASDAQ
3. METHODOLOGY 4. DATA ANALYSIS
4.1 4.2 4.3 RETURN, VARIANCE, STANDARD DEVIATION OF BSE SENSEX RETURN, VARIANCE, STANDARD DEVIATION OF NASDAQ CORRELATION OF RETURNS BETWEEN BSE & NASDAQ
5. CONCLUSION 6. BIBLIOGRAPHY
OBJECTIVE OF THE STUDY
• • • •
TO ANALYSE THE PERFOMANCE OF BSE SENSEX. TO ANALYSE THE PERFOMANCE OF NASDAQ. TO KNOW THE RISK AND RETURN OF THE BSE &NASDAQ. TO CORRELATE THE PERFOMANCE OF BSE SENSEX WITH NASDAQ WITH THE HELP OF RETURNS. TO IDENTIFY THE FACTORS INFLUENCING THE INDICES.
•
COMPANY PROFILE
Bombay Stock Exchange (BSE)
About the Bombay Stock Exchange
Bombay Stock Exchange Limited is the oldest stock exchange in Asia with a rich heritage. Popularly known as "BSE", it was established as "The Native Share Stock Brokers Association" in 1875. It is the first stock exchange in the country to obtain permanent recognition in 1956 from the Government of India under the Securities Contracts (Regulation) Act, 1956.The Exchange's pivotal and pre-eminent role in the development of the Indian capital market is widely recognized and its index, SENSEX, is tracked worldwide. Earlier an Association of Persons (AOP), the Exchange is now a demutualised and corporatised entity incorporated under the provisions of the Companies Act, 1956,
BSE(Corporatisation and Demutualization) Scheme, 2005 notified by the Securities and Exchange Board of India (SEBI). With demutualization, the trading rights and ownership rights have been de-linked effectively addressing concerns regarding perceived and real conflicts of interest. The Exchange is professionally managed under the overall direction of the Board of Directors. The Board comprises eminent professionals, representatives of Trading Members and the Managing Director of the Exchange. The Board is inclusive and is designed to benefit from the participation of market intermediaries. In terms of organization structure, the Board formulates larger policy issues and exercises over-all control. The committees constituted by the Board are broad-based. The day-to-day operations of the Exchange are managed by the Managing Director and a management team of professionals.
The Exchange has a nation-wide reach with a presence in 417 cities and towns of India. The systems and processes of the Exchange are designed to safeguard market integrity and enhance transparency in operations. During the year 2004-2005, the trading volumes on the Exchange showed robust growth.
The Exchange provides an efficient and transparent market for trading in equity, debt instruments and derivatives. The BSE's On Line Trading System (BOLT) is a proprietary system of the Exchange and is BS 7799-2-2002 certified. The surveillance and clearing & settlement functions of the Exchange are ISO 9001:2000 certified.
History of the Bombay Stock Exchange :
The Bombay Stock Exchange is known as the oldest exchange in Asia. It traces its history to the 1850s, when stockbrokers would gather under banyan trees in front of Mumbai's Town Hall. The location of these meetings changed many times, as the number of brokers constantly increased. The group eventually moved to Dalal Street in 1874 and in 1875 became an official organization known as 'The Native Share & Stock Brokers Association'. In 1956, the BSE became the first stock exchange to be recognized by the Indian Government under the Securities Contracts Regulation Act. The Bombay Stock Exchange developed the BSE Sensex in 1986, giving the BSE a means to measure overall
performance of the exchange. In 2000 the BSE used this index to open its derivatives market, trading Sensex futures contracts. The development of Sensex options along with equity derivatives
followed in 2001 and 2002, expanding the BSE's trading platform. Historically an open-cry floor trading exchange, the Bombay Stock Exchange switched to an electronic trading system in 1995. It took the exchange only fifty days to make this transition.
About the NASDAQ: The NASDAQ, an acronym for National Association of Securities Dealers Automated Quotations, is an electronic stock exchange with 3,300 company listings. It currently has a greater trading volume than any other U.S. exchange, making approximately 1.8 billion trades per day. The NYSE is still considered the biggest exchange because its market capitalization far exceeds that of the NASDAQ. The NASDAQ trades shares in a variety of companies, but is well known for being a high-tech exchange, trading many new, high growth, and volatile stocks. This is partially due to the fact that the listing fees on the NASDAQ are significantly lower than those for the NYSE, with the maximum price only $150,000. The NASDAQ is a publicly owned company, trading its shares on its own exchange under the ticker symbol NDAQ. The NASDAQ, as an electronic exchange, has no physical trading floor, but makes all its trades through a computer and telecommunications system. The exchange is a dealers' market, meaning brokers buy and sell stocks through a market maker rather than from each other. A market maker deals in a particular stock and holds a certain number of stocks on his own books so that when a broker wants to purchase shares, he can purchase them directly from the market maker. Since there is no trading floor where the NASDAQ operates, the stock exchange built the NASDAQ Market Site in New York's Times Square to create a physical presence. The tower has a large outdoor electronic display, giving current financial information 24 hours a day.
The company also has a studio here where it broadcasts financial market updates. For a stock to be listed on the NASDAQ National Market, the company must meet certain strict financial criteria. For example, they must maintain a stock price of at least $1, and the total value of outstanding stocks must be at least $1.1 million. However the NASDAQ also has a market for smaller companies unable to meet these and other requirements, called the NASDAQ Small Caps Market. NASDAQ will move companies from one market to the other as their eligibility changes. NASDAQ NASDAQ Profile : Address Telephone Web Site Holidays One Liberty Plaza, 50th Floor, New York, NY 10006 212-401-8742 Click here for the NASDAQ web site New Year's Day, Martin Luther King Jr's Birthday, Presidents' Day, Good Friday, Memorial Day, Independence Day, Labor Day, Thanksgiving, and Christmas. Stocks President and CEO: Robert Greifeld since May 2003
Trading Hours Monday - Friday, 9:30 am - 4:00 pm EST
Securities Trading System Key Staff
History of the NASDAQ:
The NASDAQ was developed in 1971 as the first electronic stock exchange in the world. It was created as a means to increase the trading of Over-the-Counter stocks, those that were unable to meet listing requirements for larger exchanges. 2,500 OTC stocks were traded on the NASDAQ's first trading day, February 8, 1971.
The division between the NASDAQ National Market and the NASDAQ Small-Cap Market developed from 1982 to 1986, as the larger companies separated themselves from the smaller ones. It was in the 1990's that the NASDAQ began to be seen as a competitor of the NYSE, and in 1994 the NASDAQ beat the NYSE in annual shares traded. In 1998, the NASDAQ merged with the American Stock Exchange, which mostly traded options and derivatives, creating the NASDAQ-AMEX Market Group. The combined company still operates as two separate exchanges, but is better able to compete with the NYSE.
NASDAQ | NASDAQ companies Top 100 companies on the NASDAQ : MSFT AAPL GOOG INTC CSCO AMGN AMZN MEDI QCOM SUNW AMAT CMCSA RIMM LVLT ORCL ESRX BRCM EBAY YHOO DELL SNDK BEAS AKAM GILD SHLD NVDA JNPR HOLX ERTS BIIB DNDN Microsoft (MM) Apple Inc. (MM) Google Inc. (MM) Intel (MM) Cisco Systems (MM) Amgen Inc. (MM) Amazon.Com (MM) Medimmune (MM) Qualcomm Incorporated (MM) Sun Microsystems (MM) Applied Materials (MM) Comcast (MM) Research IN Motion Limited (MM) Level 3 Communications (MM) Oracle (MM) Express Scripts (MM) Broadcom (MM) EBay Inc. (MM) Yahoo! Inc. (MM) Dell Inc. (MM) Sandisk (MM) Bea Systems (MM) Akamai Technologies (MM) Gilead Sciences (MM) Sears Holdings (MM) Nvidia (MM) Juniper Networks (MM) Hologic (MM) Electronic Arts Inc. (MM) Biogen Idec (MM) Dendreon (MM)
METHODOLOGY
Arithmetic average or mean :
The arithmetic average measures the central tendency . The purpose of computing an average value for a set of observations is to obtain a single value, which is representative of all the items. The main objective of averaging is to arrive at a single value which is a representative of the characteristics of the entire mass of data and arithmetic average or mean of a series(usually denoted by x) is the value obtained by dividing the sum of the values of various items in a series (sigma x) divided by the number of items (N) constituting the series.
Thus, if X1,X2……………..Xn are the given N observations. Then
X= X1+X2+……….Xn N
RETURN
Current price-previous price *100 Previous price
STANDARD DEVIATION :
The concept of standard deviation was first suggested by Karl Pearson in 1983.it may be defined as the positive square root of the arithmetic mean of the squares of deviations of the given observations from their arithmetic mean. In short S.D may be defined as “Root Mean Square Deviation from Mean” It is by far the most important and widely used measure of studying dispersions. For a set of N observations X1,X2……..Xn with mean X, Deviations from Mean: (X1-X),(X2-X),….(Xn-X) Mean-square deviations from Mean: = 1/N (X1-X)2+(X2-X)2+……….+(Xn-X)2 =1/N sigma(X-X)2 Root-mean-square deviation from mean,i.e.
VARIANCE :
The square of standard deviation is known as Variance. Variance is the square root of the standard deviation: Variance =(S.D)2 Where,(S.D)is standard deviation
CORRELATION
Correlation is a statistical technique, which measures and analyses the degree or extent to which two or more variables fluctuate with reference to one another. Correlation thus denotes the inter-dependence amongst variables. The degrees are expressed by a coefficient, which ranges between –1 and +1. The direction of change is indicated by (+) or (-) signs. The former refers to a sympathetic movement in a same direction and the later in the opposite direction. Karl Pearson’s method of calculating coefficient (r) is based on covariance of the concerned variables. It was devised by Karl Pearson a great British Biometrician. This measure known as Pearsonian correlation coefficient between two variables (series) X and Y usually denoted by ‘r’ is a numerical measure of linear relationship and is defined as the ratio of the covariance between X and Y (written as Cov(X,Y) to the product of standard deviation of X and Y Symbolically r = Cov (X,Y) SD of X,Y = ? xy/N SD of X,Y = ?XY N
Where x =X-X, y=Y-Y
?xy = sum of the product of deviations in X and Y series calculated with reference to
their arithmetic means. X = standard deviation of the series X. Y = standard deviation of the series Y.
DATA ANALYSIS & INTERPRETATION
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF JAN-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 3-Jan-07 4-Jan-07 5-Jan-07 8-Jan-07 9-Jan-07 10-Jan-07 11-Jan-07 12-Jan-07 16-Jan-07 17-Jan-07 18-Jan-07 19-Jan-07 22-Jan-07 23-Jan-07 24-Jan-07 25-Jan-07 26-Jan-07 29-Jan-07 30-Jan-07
Close 13940.2 13942.24 14014.92 13871.71 13860.52 13652.15 13566.33 13362.16 13630.71 14056.53 14129.64 14114.73 14131.34 14217.75 14182.71 14209.24 14041.24 14110.46 14282.72 14211.96 MEAN
Returns(x) 0.01 0.52 -1.02 -0.08 -1.50 -0.63 -1.50 2.01 3.12 0.52 -0.11 0.12 0.61 -0.25 0.19 -1.18 0.49 1.22 -0.50 0.11
X-mean -0.09 0.41 -1.13 -0.19 -1.61 -0.74 -1.61 1.90 3.02 0.41 -0.21 0.01 0.50 -0.35 0.08 -1.29 0.39 1.11 -0.60 variance
(x-mean)2 0.01 0.17 1.28 0.04 2.60 0.54 2.60 3.62 9.10 0.17 0.05 0.00 0.25 0.13 0.01 1.66 0.15 1.24 0.36 1.26
Sd
1.12
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.10792733 0.014633936 1.153779443 1.331207004 4.628951122 -1.504975922 3.1239752
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JAN-07
2.00 0.00 1 -2.00 4 7 10 13 16 19 jan
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of jan-07.The graph says there is lot fluctuations in the price movements. Here risk is more when compared to returns and with price variation is 1.26.The returns can fluctuate in between -1.50 and 3.12
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF FEB-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 1-Feb-07 2-Feb-07 5-Feb-07 6-Feb-07 7-Feb-07 8-Feb-07 9-Feb-07 12-Feb-07 13-Feb-07 14-Feb-07 15-Feb-07 16-Feb-07 20-Feb-07 21-Feb-07 22-Feb-07 23-Feb-07 26-Feb-07 27-Feb-07 28-Feb-07 Close 14267.18 14403.77 14515.9 14478.19 14643.13 14652.09 14538.9 14190.7 14090.98 14009.9 14355.55 14402.9 14253.38 14188.49 14021.31 13632.53 13649.52 13478.83 12938.09 MEAN Returns(x) 0.39 0.96 0.78 -0.26 1.14 0.06 -0.77 -2.39 -0.70 -0.58 2.47 0.33 -1.04 -0.46 -1.18 -2.77 0.12 -1.25 -4.01 -0.48 X-mean 0.87 1.44 1.26 0.22 1.62 0.54 -0.29 -1.91 -0.22 -0.09 2.95 0.81 -0.56 0.03 -0.70 -2.29 0.61 -0.77 -3.53 variance (x-mean)2 0.76 2.07 1.59 0.05 2.63 0.30 0.08 3.66 0.05 0.01 8.70 0.66 0.31 0.00 0.48 5.25 0.37 0.59 12.46 2.11 Sd
1.45
DESCRIPTIVE STATISTICS Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.48240235 -0.455260436 1.490891666 2.222757959 6.478956455 -4.011772535 2.46718392
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF FEB-07
2.00 0.00 -2.00 -4.00 -6.00 1 3 5 7 9 11 13 15 17 19 Series1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of feb-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 2.11.The returns can fluctuate in between -4.011 and 2.462.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF MARCH-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 1-Mar-07 2-Mar-07 5-Mar-07 6-Mar-07 7-Mar-07 8-Mar-07 9-Mar-07 12-Mar-07 13-Mar-07 14-Mar-07 15-Mar-07 16-Mar-07 19-Mar-07 20-Mar-07 21-Mar-07 22-Mar-07 23-Mar-07 26-Mar-07 27-Mar-07 Close 13159.55 12886.13 12415.04 12697.09 12579.75 13049.35 12884.99 12902.63 12982.98 12529.62 12543.85 12430.4 12644.99 12705.94 12945.88 13308.03 13285.93 13124.32 12884.34 MEAN Returns(x) 1.71 -2.08 -3.66 2.27 -0.92 3.73 -1.26 0.14 0.62 -3.49 0.11 -0.90 1.73 0.48 1.89 2.80 -0.17 -1.22 -1.83 0.02 X-mean 1.69 -2.10 -3.67 2.25 -0.94 3.71 -1.28 0.12 0.60 -3.51 0.09 -0.92 1.71 0.46 1.87 2.78 -0.19 -1.24 -1.85 variance (x-mean)2 2.86 4.40 13.51 5.07 0.89 13.79 1.63 0.01 0.36 12.33 0.01 0.85 2.91 0.21 3.49 7.72 0.03 1.53 3.41 3.99 Sd
2.00
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.002140215 0.113570882 2.041710772 4.168582875 7.388774714 -3.655791149 3.732983565
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MARCH-07
2. 50 2. 00 1. 50 1. 00 0. 50 0. 00 -0. 50 -1. 00 -1. 50 -2. 00 -2. 50 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of March-07.The graph says there is lot fluctuations in the price movements. Here risk is more when compared to returns and with price variation is 3.99.The returns can fluctuate in between -3.650 and 3.732
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF APRIL-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 2-Apr-07 3-Apr-07 4-Apr-07 5-Apr-07 9-Apr-07 10-Apr-07 11-Apr-07 12-Apr-07 13-Apr-07 16-Apr-07 17-Apr-07 18-Apr-07 19-Apr-07 20-Apr-07 23-Apr-07 24-Apr-07 25-Apr-07 26-Apr-07 27-Apr-07 Close 12455.37 12624.58 12786.77 12856.08 13177.74 13189.54 13183.24 13113.81 13384.08 13695.58 13607.04 13672.19 13619.7 13897.41 13928.33 14136.72 14217.77 14228.88 13908.58 MEAN Returns(x) -3.33 1.36 1.28 0.54 2.50 0.09 -0.05 -0.53 2.06 2.33 -0.65 0.48 -0.38 2.04 0.22 1.50 0.57 0.08 -2.25 0.41 X-mean -3.74 0.94 0.87 0.13 2.09 -0.32 -0.46 -0.94 1.65 1.91 -1.06 0.06 -0.80 1.62 -0.19 1.08 0.16 -0.34 -2.67 variance (x-mean)2 14.01 0.89 0.76 0.02 4.36 0.11 0.21 0.89 2.71 3.66 1.12 0.00 0.64 2.64 0.04 1.17 0.03 0.11 7.10 2.13 Sd
1.46
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.414098377 0.47879627 1.499462358 2.248387364 5.831397395 -3.329390562 2.502006833
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF APRIL-07
1. 50
1. 00
0. 50 Ser i es 1 0. 00 1 -0. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
-1. 00
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of April-07.The graph says there is lot fluctuations in the price movements. Here risk is more when compared to returns and with price variation is 3.99.The returns can fluctuate in between -3.650 and 3.732 .
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF MAY-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Date 1-May-07 2-May-07 3-May-07 4-May-07 7-May-07 8-May-07 9-May-07 10-May-07 11-May-07 14-May-07 15-May-07 16-May-07 17-May-07 18-May-07 21-May-07 22-May-07 23-May-07 24-May-07 25-May-07 Close 14078.21 13934.27 13879.25 13765.46 13781.51 13771.23 13796.16 13965.86 13929.33 14127.31 14299.71 14303.41 14418.6 14453.72 14363.26 14218.11 14338.45 14397.89 14508.21 MEAN returns(x) 1.22 -1.02 -0.39 -0.82 0.12 -0.07 0.18 1.23 -0.26 1.42 1.22 0.03 0.81 0.24 -0.63 -1.01 0.85 0.41 0.77 0.24 x-mean 0.98 -1.26 -0.64 -1.06 -0.12 -0.31 -0.06 0.99 -0.50 1.18 0.98 -0.21 0.57 0.00 -0.87 -1.25 0.61 0.17 0.53 variance (x-mean)2 0.96 1.59 0.40 1.12 0.02 0.10 0.00 0.98 0.25 1.39 0.96 0.05 0.32 0.00 0.75 1.56 0.37 0.03 0.28 0.51 SD
0.71
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.225323609 0.181029581 0.786545998 0.618654608 2.443748583 -1.022431119 1.421317465
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MAY-07
1. 50
1. 00
0. 50
0. 00 1 -0. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
-1. 00
-1. 50
-2. 00
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of may-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.51.The returns can fluctuate in between -1.021 and 1.421.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF JUNE-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 date 1-Jun-07 4-Jun-07 5-Jun-07 6-Jun-07 7-Jun-07 8-Jun-07 11-Jun-07 12-Jun-07 13-Jun-07 14-Jun-07 15-Jun-07 18-Jun-07 19-Jun-07 20-Jun-07 21-Jun-07 22-Jun-07 25-Jun-07 26-Jun-07 27-Jun-07 Close 14570.75 14495.77 14535.01 14255.93 14186.18 14063.81 14083.41 14130.95 14003.03 14203.72 14162.71 14080.14 14295.5 14411.95 14499.24 14467.36 14487.72 14501.08 14431.06 MEAN returns(x) 0.43 -0.51 0.27 -1.92 -0.49 -0.86 0.14 0.34 -0.91 1.43 -0.29 -0.58 1.53 0.81 0.61 -0.22 0.14 0.09 -0.48 -0.05 x-mean 0.48 -0.46 0.32 -1.87 -0.44 -0.81 0.19 0.39 -0.86 1.48 -0.24 -0.53 1.58 0.86 0.66 -0.17 0.19 0.14 -0.43 variance (x-mean)2 0.23 0.22 0.10 3.50 0.19 0.66 0.04 0.15 0.73 2.20 0.06 0.28 2.50 0.75 0.43 0.03 0.04 0.02 0.19 0.67 SD
0.82
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.024821426 0.092216028 0.826373647 0.682893404 3.449583965 -1.920053719 1.529530246
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JUNE-07
2. 50 2. 00 1. 50 1. 00 0. 50 Ser i es 1 0. 00 1 -0. 50 -1. 00 -1. 50 -2. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of june-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.65.The returns can fluctuate in between -1.901 and 1.529.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF JULY-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 2-Jul-07 3-Jul-07 5-Jul-07 6-Jul-07 9-Jul-07 10-Jul-07 11-Jul-07 12-Jul-07 13-Jul-07 16-Jul-07 17-Jul-07 18-Jul-07 19-Jul-07 20-Jul-07 23-Jul-07 24-Jul-07 25-Jul-07 26-Jul-07 27-Jul-07
Close 14664.26 14806.51 14880.24 14861.89 14964.12 15045.73 15009.88 14910.62 15092.04 15272.72 15311.22 15289.82 15301.17 15550.13 15565.55 15732.2 15794.92 15699.33 15776.31 MEAN
returns(x) 1.62 0.97 0.50 -0.12 0.69 0.55 -0.24 -0.66 1.22 1.20 0.25 -0.14 0.07 1.63 0.10 1.07 0.40 -0.61 0.49 0.41
x-mean 1.21 0.56 0.09 -0.53 0.28 0.14 -0.65 -1.07 0.81 0.79 -0.16 -0.55 -0.33 1.22 -0.31 0.66 -0.01 -1.01 0.08 variance
(x-mean)2 1.46 0.31 0.01 0.28 0.08 0.02 0.42 1.15 0.65 0.62 0.02 0.30 0.11 1.48 0.10 0.44 0.00 1.03 0.01 0.39
SD
0.62
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.472391703 0.490339397 0.683599404 0.467308146 2.288362878 -0.661297759 1.62706512
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JULY-07
2.50 2.00 1.50 1.00 0.50 0.00 1 -0.50 -1.00 -1.50 -2.00 -2.50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of july-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.39.The returns can fluctuate in between -0.6611 and 1.6270.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF AUGUST-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 1-Aug-07 2-Aug-07 3-Aug-07 6-Aug-07 7-Aug-07 8-Aug-07 9-Aug-07 10-Aug-07 13-Aug-07 14-Aug-07 15-Aug-07 16-Aug-07 17-Aug-07 20-Aug-07 21-Aug-07 22-Aug-07 23-Aug-07 24-Aug-07 27-Aug-07
Close 14935.77 14985.7 15138.4 14903.03 14932.77 15307.98 15100.15 14868.25 15017.21 15000.91 14358.21 14141.52 14427.55 13989.11 14248.66 14163.98 14424.87 14842.38 14919.19 MEAN
Returns(x) -5.33 0.33 1.02 -1.55 0.20 2.51 -1.36 -1.54 1.00 -0.11 -4.28 -1.51 2.02 -3.04 1.86 -0.59 1.84 2.89 0.52 -0.07
X-mean -5.26 0.41 1.09 -1.48 0.27 2.58 -1.29 -1.46 1.07 -0.04 -4.21 -1.44 2.09 -2.97 1.93 -0.52 1.91 2.97 0.59 Variance
(x-mean)2 27.63 0.16 1.19 2.20 0.07 6.68 1.66 2.15 1.15 0.00 17.75 2.07 4.38 8.81 3.71 0.27 3.66 8.79 0.35 3.98
Sd
2.00
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.269064502 0.199556734 2.260061558 5.107878248 8.22223801 -5.327861838 2.894376171
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF AUG-07
3. 00
2. 00
1. 00
0. 00 1 -1. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Ser i es1
-2. 00
-3. 00
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of August-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 3.98.The returns can fluctuate in between -5.327 and 2.8943.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF SEPT-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 4-Sep-07 5-Sep-07 6-Sep-07 7-Sep-07 10-Sep-07 11-Sep-07 12-Sep-07 13-Sep-07 14-Sep-07 17-Sep-07 18-Sep-07 19-Sep-07 20-Sep-07 21-Sep-07 24-Sep-07 25-Sep-07 26-Sep-07 27-Sep-07 28-Sep-07
Close 15422.05 15465.4 15446.15 15616.31 15590.42 15596.83 15542.77 15505.36 15614.44 15603.8 15504.43 15669.12 16322.75 16347.95 16564.23 16845.83 16899.54 16921.39 17150.56 MEAN
Returns(x) 3.37 0.28 -0.12 1.10 -0.17 0.04 -0.35 -0.24 0.70 -0.07 -0.64 1.06 4.17 0.15 1.32 1.70 0.32 0.13 1.35 0.74
X-mean 2.63 -0.46 -0.87 0.36 -0.91 -0.70 -1.09 -0.98 -0.04 -0.81 -1.38 0.32 3.43 -0.59 0.58 0.96 -0.42 -0.61 0.61 variance
(x-mean)2 6.90 0.21 0.75 0.13 0.83 0.49 1.19 0.97 0.00 0.66 1.91 0.10 11.75 0.35 0.34 0.91 0.18 0.38 0.37 1.50
Sd
1.22
DESCRIPTIVE STATISTIC Mean 0.743625816
Median Standard Deviation Sample Variance Range Minimum Maximum
0.281091035 1.256553092 1.578925674 4.808285205 -0.636832054 4.171453151
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF SEPT-07
3.00 2.00 1 .00 0.00 1 -1 .00 - 2.00 - 3.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of sept07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.50.The returns can fluctuate in between -0.6361 and 4.1714.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF OCT-07
S.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Date 1-Oct-07 2-Oct-07 3-Oct-07 4-Oct-07 5-Oct-07 8-Oct-07 9-Oct-07 10-Oct-07 11-Oct-07 12-Oct-07 15-Oct-07 16-Oct-07 17-Oct-07 18-Oct-07 19-Oct-07 22-Oct-07 23-Oct-07 24-Oct-07 25-Oct-07
Close 17328.62 17847.04 17777.14 17773.36 17491.39 18280.24 18658.25 18814.07 18419.04 19058.67 19051.86 18715.82 17998.39 17559.98 17613.99 18492.84 18512.91 18770.89 19243.17 MEAN
Returns(x) 1.04 2.99 -0.39 -0.02 -1.59 4.51 2.07 0.84 -2.10 3.47 -0.04 -1.76 -3.83 -2.44 0.31 4.99 0.11 1.39 2.52 0.53
X-mean 0.51 2.47 -0.92 -0.55 -2.11 3.98 1.54 0.31 -2.63 2.95 -0.56 -2.29 -4.36 -2.96 -0.22 4.46 -0.42 0.87 1.99 variance
(x-mean)2 0.26 6.08 0.84 0.30 4.46 15.87 2.38 0.10 6.90 8.68 0.32 5.25 19.01 8.78 0.05 19.92 0.17 0.75 3.96 6.05
Sd
2.46
DESCRIPTIVE STATISTIC Mean 0.634890588
Median Standard Deviation Sample Variance Range Minimum Maximum
0.307574382 2.401787736 5.768584327 8.822780973 -3.833281149 4.989499824
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF OCT-07
2.00 1 .50 1 .00 0.50 0.00 - 0.50 -1 .00 -1 .50 - 2.00 - 2.50 - 3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of oct07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.50.The returns can fluctuate in between -3.8331 and 4.9814.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF NOV-07
S.no
Date
Close
Returns(x)
X-mean
(x-mean)2
Sd
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
1-Nov-07 2-Nov-07 5-Nov-07 6-Nov-07 7-Nov-07 8-Nov-07 9-Nov-07 12-Nov-07 13-Nov-07 14-Nov-07 15-Nov-07 16-Nov-07 19-Nov-07 20-Nov-07 21-Nov-07 23-Nov-07 26-Nov-07 27-Nov-07 28-Nov-07
19724.35 19976.23 19590.78 19400.67 19289.83 19058.93 18907.6 18737.27 19035.48 19929.06 19784.89 19698.36 19633.36 19280.8 18602.62 18526.32 18852.87 19247.54 19127.73 MEAN
2.50 1.28 -1.93 -0.97 -0.57 -1.20 -0.79 -0.90 1.59 4.69 -0.72 -0.44 -0.33 -1.80 -3.52 -0.41 1.76 2.09 -0.62 -0.15
2.66 1.43 -1.78 -0.82 -0.42 -1.04 -0.64 -0.75 1.75 4.85 -0.57 -0.28 -0.18 -1.64 -3.36 -0.26 1.92 2.25 -0.47 variance
7.05 2.05 3.15 0.67 0.17 1.09 0.41 0.56 3.05 23.51 0.32 0.08 0.03 2.69 11.31 0.07 3.68 5.05 0.22 3.23
1.80
DESCRIPTIVE STATISTIC Mean Median Standard Deviation -0.014748575 -0.571320475 1.897068332
Sample Variance Range Minimum Maximum
3.598868255 8.21167184 -3.517385171 4.694286669
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF NOV-07
4.00 3.00 2.00 1 .00 0.00 1 -1 .00 - 2.00 - 3.00 - 4.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of nov07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 3.23.The returns can fluctuate in between -3.5173 and 4.6934.
RETURN, VARIANCE AND STANDARD DEVIATION OF BSE FOR THE MONTH OF DEC-07
S.no
Date
Close
Returns(x)
X-mean
(x-mean)2
Sd
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
3-Dec-07 4-Dec-07 5-Dec-07 6-Dec-07 7-Dec-07 10-Dec-07 11-Dec-07 12-Dec-07 13-Dec-07 14-Dec-07 17-Dec-07 18-Dec-07 19-Dec-07 20-Dec-07 21-Dec-07 24-Dec-07 26-Dec-07 27-Dec-07 28-Dec-07
19603.41 19529.5 19738.07 19795.87 19966 19930.68 20290.89 20375.87 20104.39 20030.83 19261.35 19079.64 19091.96 19162.57 19854.12 20192.52 20216.72 20206.95 20286.99 MEAN
2.49 -0.38 1.07 0.29 0.86 -0.18 1.81 0.42 -1.33 -0.37 -3.84 -0.94 0.06 0.37 3.61 1.70 0.12 -0.05 0.40 0.32
2.17 -0.70 0.75 -0.03 0.54 -0.50 1.49 0.10 -1.65 -0.69 -4.16 -1.27 -0.26 0.05 3.29 1.38 -0.20 -0.37 0.07 variance
4.69 0.49 0.56 0.00 0.29 0.25 2.21 0.01 2.74 0.47 17.33 1.60 0.07 0.00 10.81 1.91 0.04 0.14 0.01 2.29
1.51
DESCRIPTIVE STATISTIC Mean Median Standard Deviation 0.321657448 0.292835115 1.556319052
Sample Variance Range Minimum Maximum
2.422128992 7.450336672 -3.841478361 3.608858311
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF DEC-07
2.50 2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 -2.50 -3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 12 1 3 1 4 1 5 1 6 1 7 18 1 9 Series1
Above table and graph depicts, the risk and returns of BSE SENSEX for the month of December-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 2.29.The returns can fluctuate in between -3.8414 and 3.6088.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF JAN-07
S.no 1 Date 3-Jan-07 Close 2422.10 2423.16 Returns(x) 0.04 X-mean -0.02 (x-mean)2 0.00 Sd
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
4-Jan-07 5-Jan-07 8-Jan-07 9-Jan-07 10-Jan-07 11-Jan-07 12-Jan-07 16-Jan-07 17-Jan-07 18-Jan-07 19-Jan-07 22-Jan-07 23-Jan-07 24-Jan-07 25-Jan-07 26-Jan-07 29-Jan-07 30-Jan-07
2453.43 2434.25 2438.20 2443.83 2459.33 2484.85 2502.82 2497.78 2479.42 2443.21 2451.31 2431.07 2431.41 2466.28 2434.24 2435.49 2441.09 2448.64 mean
1.25 -0.78 0.16 0.23 0.63 1.04 0.72 -0.20 -0.74 -1.46 0.33 -0.83 0.01 1.43 -1.30 0.05 0.23 0.31 0.06
1.19 -0.84 0.10 0.17 0.57 0.98 0.66 -0.26 -0.80 -1.52 0.27 -0.89 -0.05 1.37 -1.36 -0.01 0.17 0.25 variance
1.41 0.71 0.01 0.03 0.33 0.96 0.44 0.07 0.63 2.31 0.07 0.79 0.00 1.89 1.85 0.00 0.03 0.06 0.61
0.78
DESCRIPTIVE STATISTIC Mean Median Standard Deviation 0.060424758 0.162267639 0.802326123
Sample Variance Range Minimum Maximum
0.643727208 2.89456946 -1.460422196 1.434147264
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JAN-07
2.00 0.00 1 -2.00 4 7 10 13 16 19 jan
Above table and graph depicts, the risk and returns of NASDAQ for the month of January-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.61.The returns can fluctuate in between -1.4604 and 1.4341. .
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF FEB-07
s.no 1 2 Date 1-Feb-07 2-Feb-07 close 2468.38 2475.88 returns(x) 0.81 0.30 x-mean 0.87 0.37 (x-mean)2 0.76 0.14 SD
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
5-Feb-07 6-Feb-07 7-Feb-07 8-Feb-07 9-Feb-07 12-Feb-07 13-Feb-07 14-Feb-07 15-Feb-07 16-Feb-07 20-Feb-07 21-Feb-07 22-Feb-07 23-Feb-07 26-Feb-07 27-Feb-07 28-Feb-07
2470.60 2471.49 2490.50 2488.67 2459.82 2450.38 2459.88 2488.38 2497.10 2496.31 2513.04 2518.42 2524.94 2515.10 2504.52 2407.86 2416.15 mean
-0.21 0.04 0.77 -0.07 -1.16 -0.38 0.39 1.16 0.35 -0.03 0.67 0.21 0.26 -0.39 -0.42 -3.86 0.34 -0.06
-0.15 0.10 0.83 -0.01 -1.09 -0.32 0.45 1.22 0.42 0.03 0.74 0.28 0.32 -0.32 -0.36 -3.79 0.41 variance
0.02 0.01 0.70 0.00 1.20 0.10 0.20 1.50 0.17 0.00 0.54 0.08 0.10 0.11 0.13 14.40 0.17 1.07
1.03
DESCRIPTIVE STATISTIC Mean Median Standard Deviation -0.064832507 0.214083341 1.062446461
Sample Variance Range Minimum Maximum
1.128792482 5.018015267 -3.859422165 1.158593102
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF FEB-07
2.00 0.00 -2.00 -4.00 -6.00 1 3 5 7 9 11 13 15 17 19 Series1
Above table and graph depicts, the risk and returns of NASDAQ for the month of February-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.07.The returns can fluctuate in between -3.8594 and 1.1585.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF MARCH-07
S.no 1 2 3 Date 1-Mar-07 2-Mar-07 5-Mar-07 Close 2404.21 2368.00 2340.68 Returns(x) -0.49 -1.51 -1.15 X-mean -0.67 -1.68 -1.33 (x-mean)2 0.45 2.83 1.77 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
6-Mar-07 7-Mar-07 8-Mar-07 9-Mar-07 12-Mar-07 13-Mar-07 14-Mar-07 15-Mar-07 16-Mar-07 19-Mar-07 20-Mar-07 21-Mar-07 22-Mar-07 23-Mar-07 26-Mar-07 27-Mar-07
2385.14 2374.64 2387.73 2387.55 2402.29 2350.57 2371.74 2378.70 2372.66 2394.41 2408.21 2455.92 2451.74 2448.93 2455.63 2437.43 mean
1.90 -0.44 0.55 -0.01 0.62 -2.15 0.90 0.29 -0.25 0.92 0.58 1.98 -0.17 -0.11 0.27 -0.74 0.18
1.72 -0.62 0.38 -0.18 0.44 -2.33 0.73 0.12 -0.43 0.74 0.40 1.81 -0.35 -0.29 0.10 -0.92 variance
2.97 0.38 0.14 0.03 0.20 5.42 0.53 0.01 0.18 0.55 0.16 3.26 0.12 0.08 0.01 0.84 0.98
0.99
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.0513323 -0.007538541 1.044587014 1.09116203 4.13408525 -2.152945731 1.981139519
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MARCH-07
2.50 2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 -2.50 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es1
Above table and graph depicts, the risk and returns of NASDAQ for the month of march-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.98.The returns can fluctuate in between -2.1529 and 1.9811.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF APRIL-07
S.no 1 2 3 Date 2-Apr-07 3-Apr-07 4-Apr-07 Close 2422.26 2450.33 2458.69 Returns(x) -0.62 1.16 0.34 X-mean -0.88 0.90 0.09 (x-mean)2 0.77 0.82 0.01 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
5-Apr-07 9-Apr-07 10-Apr-07 11-Apr-07 12-Apr-07 13-Apr-07 16-Apr-07 17-Apr-07 18-Apr-07 19-Apr-07 20-Apr-07 23-Apr-07 24-Apr-07 25-Apr-07 26-Apr-07 27-Apr-07
2471.34 2469.18 2477.61 2459.31 2480.32 2491.94 2518.33 2516.95 2510.50 2505.35 2526.39 2523.67 2524.54 2547.89 2554.46 2557.21 mean
0.51 -0.09 0.34 -0.74 0.85 0.47 1.06 -0.05 -0.26 -0.21 0.84 -0.11 0.03 0.92 0.26 0.11 0.25
0.26 -0.34 0.09 -0.99 0.60 0.21 0.80 -0.31 -0.51 -0.46 0.59 -0.36 -0.22 0.67 0.00 -0.15 variance
0.07 0.12 0.01 0.99 0.36 0.05 0.65 0.10 0.26 0.21 0.34 0.13 0.05 0.45 0.00 0.02 0.28
0.53
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance 0.254220378 0.257860426 0.547031309 0.299243253
Range Minimum Maximum
1.897450174 -0.738615036 1.158835137
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF APRIL-07
1. 50
1. 00
0. 50 Ser i es 1 0. 00 1 -0.50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
-1.00
Above table and graph depicts, the risk and returns of NASDAQ for the month of april-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.28.The returns can fluctuate in between -0.7386 and 1.1588.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF MAY-07
S.no 1 2 3 Date 1-May-07 2-May-07 3-May-07 Close 2531.53 2557.84 2565.46 Returns(x) -1.00 1.04 0.30 X-mean -1.01 1.04 0.30 (x-mean)2 1.01 1.08 0.09 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
4-May-07 7-May-07 8-May-07 9-May-07 10-May-07 11-May-07 14-May-07 15-May-07 16-May-07 17-May-07 18-May-07 21-May-07 22-May-07 23-May-07 24-May-07 25-May-07
2572.15 2570.95 2571.75 2576.34 2533.74 2562.22 2546.44 2525.29 2547.42 2539.38 2558.45 2578.79 2588.02 2577.05 2537.92 2557.19 mean
0.26 -0.05 0.03 0.18 -1.65 1.12 -0.62 -0.83 0.88 -0.32 0.75 0.80 0.36 -0.42 -1.52 0.76 0.00
0.26 -0.05 0.03 0.18 -1.66 1.12 -0.62 -0.83 0.87 -0.32 0.75 0.79 0.36 -0.43 -1.52 0.76 variance
0.07 0.00 0.00 0.03 2.74 1.26 0.38 0.69 0.77 0.10 0.56 0.63 0.13 0.18 2.31 0.57 0.62
0.79
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.003284241 0.17847769 0.836667474 0.700012462 2.777538555
Minimum Maximum
-1.653508465 1.12403009
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF MAY-07
1. 50
1. 00
0. 50
0. 00 1 -0. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
-1. 00
-1. 50
-2. 00
Above table and graph depicts, the risk and returns of NASDAQ for the month of may-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.62 the returns can fluctuate in between -1.6535 and 1.1240.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF JUNE-07
S.NO 1 2 3 4 DATE 1-Jun-07 4-Jun-07 5-Jun-07 6-Jun-07 CLOSE 2613.92 2618.29 2611.23 2587.18 RETURNS(X) 2.22 0.17 -0.27 -0.92 X-MEAN 2.23 0.18 -0.26 -0.91 (X-MEAN)2 4.99 0.03 0.07 0.82 SD
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
7-Jun-07 8-Jun-07 11-Jun-07 12-Jun-07 13-Jun-07 14-Jun-07 15-Jun-07 18-Jun-07 19-Jun-07 20-Jun-07 21-Jun-07 22-Jun-07 25-Jun-07 26-Jun-07 27-Jun-07
2541.38 2573.54 2572.15 2549.77 2582.31 2599.41 2626.71 2626.60 2626.76 2599.96 2616.96 2588.96 2577.08 2574.16 2605.35 mean
-1.77 1.27 -0.05 -0.87 1.28 0.66 1.05 0.00 0.01 -1.02 0.65 -1.07 -0.46 -0.11 1.21 -0.01
-1.76 1.28 -0.04 -0.86 1.29 0.68 1.06 0.01 0.02 -1.01 0.67 -1.06 -0.44 -0.10 1.23 variance
3.08 1.64 0.00 0.73 1.67 0.46 1.13 0.00 0.00 1.01 0.45 1.11 0.20 0.01 1.50 0.77
0.88
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.103142764 -0.004187748 1.017582244 1.035473623 3.988717962
Minimum Maximum
-1.770267241 2.218450721
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JUNE-07
2. 50 2. 00 1. 50 1. 00 0. 50 Ser i es 1 0. 00 1 -0. 50 -1. 00 -1. 50 -2. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Above table and graph depicts, the risk and returns of NASDAQ for the month of june-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.77he returns can fluctuate in between -1.7704 and 2.2184.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF JULY-07
S.no 1 2 3 4 5 Date 2-Jul-07 3-Jul-07 5-Jul-07 6-Jul-07 9-Jul-07 Close 2632.30 2644.95 2656.65 2666.51 2670.02 Returns(x) 1.03 0.48 0.44 0.37 0.13 X-mean 1.18 0.63 0.59 0.52 0.28 (x-mean)2 1.39 0.39 0.34 0.27 0.08 Sd
6 7 8 9 10 11 12 13 14 15 16 17 18 19
10-Jul-07 11-Jul-07 12-Jul-07 13-Jul-07 16-Jul-07 17-Jul-07 18-Jul-07 19-Jul-07 20-Jul-07 23-Jul-07 24-Jul-07 25-Jul-07 26-Jul-07 27-Jul-07
2639.16 2651.79 2701.73 2707.00 2697.33 2712.29 2699.49 2720.04 2687.60 2690.58 2639.86 2648.17 2599.34 2562.24 mean
-1.16 0.48 1.88 0.20 -0.36 0.55 -0.47 0.76 -1.19 0.11 -1.89 0.31 -1.84 -1.43 -0.14
-1.01 0.62 2.03 0.34 -0.21 0.70 -0.33 0.91 -1.05 0.26 -1.74 0.46 -1.70 -1.28 variance
1.02 0.39 4.11 0.12 0.05 0.49 0.11 0.82 1.10 0.07 3.03 0.21 2.89 1.64 0.95
0.98
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range -0.082912523 0.195060202 1.011945693 1.024034086 3.768351623
Minimum
MAXIMUM GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF JULY-07
2. 50 2. 00 1. 50 1. 00 0. 50 0. 00 1 -0. 50 -1. 00 -1. 50 -2. 00 -2. 50 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Ser i es 1
-1.885095407 1.883256216
Above table and graph depicts, the risk and returns of NASDAQ for the month of july-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.95.The returns can fluctuate in between -1.885 and 1.883.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF AUG-07
S.no 1 2 3 Date 1-Aug-07 2-Aug-07 3-Aug-07 Close 2553.87 2575.98 2511.25 Returns(x) -0.33 0.87 -2.51 X-mean -0.46 0.73 -2.64 (x-mean)2 0.21 0.54 6.99 Sd
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
6-Aug-07 7-Aug-07 8-Aug-07 9-Aug-07 10-Aug-07 13-Aug-07 14-Aug-07 15-Aug-07 16-Aug-07 17-Aug-07 20-Aug-07 21-Aug-07 22-Aug-07 23-Aug-07 24-Aug-07 27-Aug-07
2547.33 2561.60 2612.98 2556.49 2544.89 2542.24 2499.12 2458.83 2451.07 2505.03 2508.59 2521.30 2552.80 2541.70 2576.69 2561.25 mean
1.44 0.56 2.01 -2.16 -0.45 -0.10 -1.70 -1.61 -0.32 2.20 0.14 0.51 1.25 -0.43 1.38 -0.60 0.13
1.31 0.43 1.87 -2.29 -0.59 -0.24 -1.83 -1.74 -0.45 2.07 0.01 0.38 1.12 -0.57 1.25 -0.73 variance
1.70 0.18 3.51 5.26 0.34 0.06 3.34 3.04 0.20 4.29 0.00 0.14 1.25 0.32 1.55 0.53 1.61
1.27
.
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.006709979 -0.104130237 1.357378425 1.842476189 4.714317582
Minimum Maximum
-2.512830069 2.201487514
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF AUG-07
3. 00
2. 00
1. 00
0. 00 1 -1. 00 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Ser i es 1
-2. 00
-3. 00
Above table and graph depicts, the risk and returns of NASDAQ for the month of August-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 0.61.The returns can fluctuate in between -2.51 and 2.20.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF SEPT-07
S.no 1 2 3 4 Date 4-Sep-07 5-Sep-07 6-Sep-07 7-Sep-07 Close 2630.24 2605.95 2614.32 2565.70 Returns(x) 2.69 -0.92 0.32 -1.86 X-mean 2.41 -1.21 0.03 -2.15 (x-mean)2 5.79 1.46 0.00 4.61 Sd
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
10-Sep-07 11-Sep-07 12-Sep-07 13-Sep-07 14-Sep-07 17-Sep-07 18-Sep-07 19-Sep-07 20-Sep-07 21-Sep-07 24-Sep-07 25-Sep-07 26-Sep-07 27-Sep-07 28-Sep-07
2559.11 2597.47 2592.07 2601.06 2602.18 2581.66 2651.66 2666.48 2654.29 2671.22 2667.95 2683.45 2699.03 2709.59 2701.50 Mean
-0.26 1.50 -0.21 0.35 0.04 -0.79 2.71 0.56 -0.46 0.64 -0.12 0.58 0.58 0.39 -0.30 0.29
-0.54 1.21 -0.49 0.06 -0.24 -1.08 2.42 0.27 -0.74 0.35 -0.41 0.29 0.29 0.10 -0.59 variance
0.30 1.47 0.24 0.00 0.06 1.16 5.88 0.07 0.55 0.12 0.17 0.09 0.09 0.01 0.34 1.18
1.09
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range 0.286837829 0.32118805 1.116017421 1.245494885 4.571190759
Minimum Maximum
-1.859757031 2.711433729
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF SEPT-07
3.00 2.00 1 .00 0.00 1 -1 .00 - 2.00 - 3.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of NASDAQ for the month of September-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.18.The returns can fluctuate in between -1.8595 and 2.7114.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF OCT-07
S.no 1 2 3 4 5 Date 1-Oct-07 2-Oct-07 3-Oct-07 4-Oct-07 5-Oct-07 Close 2740.99 2747.11 2729.43 2733.57 2780.32 Returns(x) 1.46 0.22 -0.64 0.15 1.71 X-mean 1.41 0.17 -0.70 0.10 1.65 (x-mean)2 1.98 0.03 0.49 0.01 2.74 Sd
6 7 8 9 10 11 12 13 14 15 16 17 18 19
8-Oct-07 9-Oct-07 10-Oct-07 11-Oct-07 12-Oct-07 15-Oct-07 16-Oct-07 17-Oct-07 18-Oct-07 19-Oct-07 22-Oct-07 23-Oct-07 24-Oct-07 25-Oct-07
2787.37 2803.91 2811.61 2772.20 2805.68 2780.05 2763.91 2792.67 2799.31 2725.16 2753.93 2799.26 2774.76 2750.86 Mean
0.25 0.59 0.27 -1.40 1.21 -0.91 -0.58 1.04 0.24 -2.65 1.06 1.65 -0.88 -0.86 0.06
0.20 0.54 0.22 -1.46 1.15 -0.97 -0.64 0.98 0.18 -2.70 1.00 1.59 -0.93 -0.92 variance
0.04 0.29 0.05 2.12 1.33 0.94 0.40 0.97 0.03 7.31 1.00 2.53 0.87 0.84 1.34
1.16
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum 0.101658334 0.237765293 1.152933714 1.329256149 4.359084816 -2.648867042
Maximum
1.710217774
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF OCT-07
2.00 1 .50 1 .00 0.50 0.00 - 0.50 -1 .00 -1 .50 - 2.00 - 2.50 - 3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of NASDAQ for the month of October-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.34.The returns can fluctuate in between -2.641 and 1.7102.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF NOV-07
S.no 1 2 3 4 5 6 7 Date 1-Nov-07 2-Nov-07 5-Nov-07 6-Nov-07 7-Nov-07 8-Nov-07 9-Nov-07 Close 2794.83 2810.38 2795.18 2825.18 2748.76 2696.00 2627.94 Returns(x) 1.60 0.56 -0.54 1.07 -2.70 -1.92 -2.52 X-mean 1.85 0.81 -0.29 1.33 -2.45 -1.67 -2.27 (x-mean)2 3.42 0.65 0.08 1.76 6.02 2.78 5.16 Sd
8 9 10 11 12 13 14 15 16 17 18 19
12-Nov-07 13-Nov-07 14-Nov-07 15-Nov-07 16-Nov-07 19-Nov-07 20-Nov-07 21-Nov-07 23-Nov-07 26-Nov-07 27-Nov-07 28-Nov-07
2584.13 2673.65 2644.32 2618.51 2637.24 2593.38 2596.81 2562.15 2596.60 2540.99 2580.80 2662.91 mean
-1.67 3.46 -1.10 -0.98 0.72 -1.66 0.13 -1.33 1.34 -2.14 1.57 3.18 -0.25
-1.42 3.72 -0.85 -0.72 0.97 -1.41 0.38 -1.08 1.60 -1.89 1.82 3.43 variance
2.00 13.81 0.71 0.52 0.94 1.99 0.15 1.17 2.55 3.57 3.31 11.79 3.28
1.81
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum -0.154558313 -0.540852127 1.859108495 3.456284396 6.169182393 -2.704960392 3.464222001
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF NOV-07
4.00 3.00 2.00 1.00 0.00 1 -1 .00 -2.00 -3.00 -4.00 2 3 4 5 6 7 8 9 1 0 1 1 1 2 13 1 4 1 5 1 6 1 7 1 8 1 9 S eries1
Above table and graph depicts, the risk and returns of NASDAQ for the month of November-07 graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 3.28.The returns can fluctuate in between -2.704 and 3.468.
RETURN, VARIANCE AND STANDARD DEVIATION OF NASDAQ FOR THE MONTH OF DEC-07
S.no 1 2 3 4 5 6 7 Date 3-Dec-07 4-Dec-07 5-Dec-07 6-Dec-07 7-Dec-07 10-Dec-07 11-Dec-07 Close 2637.13 2619.83 2666.36 2709.03 2706.16 2718.95 2652.35 Returns(x) -0.97 -0.66 1.78 1.60 -0.11 0.47 -2.45 X-mean -1.00 -0.69 1.74 1.57 -0.14 0.44 -2.48 (x-mean)2 1.00 0.47 3.04 2.46 0.02 0.19 6.15 Sd
8 9 10 11 12 13 14 15 16 17 18 19
12-Dec-07 13-Dec-07 14-Dec-07 17-Dec-07 18-Dec-07 19-Dec-07 20-Dec-07 21-Dec-07 24-Dec-07 26-Dec-07 27-Dec-07 28-Dec-07
2671.14 2668.49 2635.74 2574.46 2596.03 2601.01 2640.86 2691.99 2713.50 2724.41 2676.79 2674.46 mean
0.71 -0.10 -1.23 -2.32 0.84 0.19 1.53 1.94 0.80 0.40 -1.75 -0.09 0.03
0.68 -0.13 -1.26 -2.36 0.81 0.16 1.50 1.91 0.77 0.37 -1.78 -0.12 variance
0.46 0.02 1.58 5.55 0.65 0.03 2.25 3.63 0.59 0.14 3.16 0.01 1.65
1.29
DESCRIPTIVE STATISTIC Mean Median Standard Deviation Sample Variance Range Minimum Maximum 0.031077258 0.191831373 1.321196342 1.745559774 4.385586702 -2.449474981 1.936111721
GRAPHICAL REPRESENTATION
RETURNS FOR THE MONTH OF DEC-07
2.50 2.00 1 .50 1 .00 0.50 0.00 -0.50 -1 .00 -1 .50 -2.00 -2.50 -3.00 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 Series1
Above table and graph depicts, the risk and returns of NASDAQ for the month of December-07.The graph says there is lot fluctuations in the price movements. Here risk is at greater level when compared to returns and with price variation is 1.65.The returns can fluctuate in between -2.4494 and 1.9361.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH JAN-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 BSE 0.01 0.52 -1.02 -0.08 -1.50 -0.63 -1.50 2.01 3.12 0.52 -0.11 0.12 NASDAQ 0.04 1.25 -0.78 0.16 0.23 0.63 1.04 0.72 -0.20 -0.74 -1.46 0.33 CORREL
13 14 15 16 17 18 19
0.61 -0.25 0.19 -1.18 0.49 1.22 -0.50
-0.83 0.01 1.43 -1.30 0.05 0.23 0.31
0.07
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF JAN-07
4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION. THERE IS A SLIGHT POSITIVE CORRELATION BETWEEN THEM.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH FEB-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 BSE 0.39 0.96 0.78 -0.26 1.14 0.06 -0.77 -2.39 -0.70 -0.58 2.47 0.33 -1.04 NASDAQ 0.81 0.30 -0.21 0.04 0.77 -0.07 -1.16 -0.38 0.39 1.16 0.35 -0.03 0.67 CORREL
14 15 16 17 18 19
-0.46 -1.18 -2.77 0.12 -1.25 -4.01
0.21 0.26 -0.39 -0.42 -3.86 0.34
0.20
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF FEB-07
3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 -5.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY AT THE STARTING THEY HAVE STARTED STUDYLY BUT AT THE MIDDLE STAGE THERE HAS BEEN A FLUCUATION IN BOTH BSE AND NASDAQ. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE OPPOSITE DIRECTION. BY LOOKING AT THE CORRELATION WE CAN SAY THAT THERE IS STORNG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH MARCH-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 BSE 1.71 -2.08 -3.66 2.27 -0.92 3.73 -1.26 0.14 0.62 -3.49 0.11 -0.90 NASDAQ -0.49 -1.51 -1.15 1.90 -0.44 0.55 -0.01 0.62 -2.15 0.90 0.29 -0.25 CORREL
13 14 15 16 17 18 19
1.73 0.48 1.89 2.80 -0.17 -1.22 -1.83
0.92 0.58 1.98 -0.17 -0.11 0.27 -0.74
0.40
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF MARCH-07
5.00 4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 -5.00
BSE 1 3 5 7 9 11 13 15 17 19 NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE HAS BEEN A GREAT AMOUT FLUCUATION GOING IN BOTH THE MARKETS, THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS STRONG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH APRIL-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 BSE -3.33 1.36 1.28 0.54 2.50 0.09 -0.05 -0.53 2.06 2.33 -0.65 NASDAQ -0.62 1.16 0.34 0.51 -0.09 0.34 -0.74 0.85 0.47 1.06 -0.05 CORREL
12 13 14 15 16 17 18 19
0.48 -0.38 2.04 0.22 1.50 0.57 0.08 -2.25
-0.26 -0.21 0.84 -0.11 0.03 0.92 0.26 0.11
0.49
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF APRIL-07
3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THE BSE WAS GOING GREAT IN THE BEGINNING BUT AT THE END OF THE PERIOD IT WAS GOING DOWN AGAIN. THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE STRONG CORRELATION. CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH MAY-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 BSE 1.22 -1.02 -0.39 -0.82 0.12 -0.07 0.18 1.23 -0.26 1.42 1.22 0.03 0.81 0.24 -0.63 -1.01 NASDAQ -1.00 1.04 0.30 0.26 -0.05 0.03 0.18 -1.65 1.12 -0.62 -0.83 0.88 -0.32 0.75 0.80 0.36 CORREL
17 18 19
0.85 0.41 0.77
-0.42 -1.52 0.76
-0.69
CORRELATION OF RETURNS BETW EEN BSE AND NASDAQ FOR THE MONTH OF MAY-07
2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 1 4 7 10 13 16 19 BSE N A SDA Q
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE NEGITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH JUNE-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BSE 0.43 -0.51 0.27 -1.92 -0.49 -0.86 0.14 0.34 -0.91 1.43 -0.29 -0.58 1.53 0.81 0.61 -0.22 0.14 NASDAQ 2.22 0.17 -0.27 -0.92 -1.77 1.27 -0.05 -0.87 1.28 0.66 1.05 0.00 0.01 -1.02 0.65 -1.07 -0.46 CORREL
18 19
0.09 -0.48
-0.11 1.21
0.05
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF JUNE-07
3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SLIGHT POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH JULY-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BSE 1.62 0.97 0.50 -0.12 0.69 0.55 -0.24 -0.66 1.22 1.20 0.25 -0.14 0.07 1.63 0.10 1.07 0.40 NASDAQ 1.03 0.48 0.44 0.37 0.13 -1.16 0.48 1.88 0.20 -0.36 0.55 -0.47 0.76 -1.19 0.11 -1.89 0.31 CORREL
18 19
-0.61 0.49
-1.84 -1.43
-0.17
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF JULY-07
2.50 2.00 1.50 1.00 0.50 0.00 -0.50 -1.00 -1.50 -2.00 -2.50
BSE 1 3 5 7 9 11 13 15 17 19 NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE HAS BEEN FALL IN THE BOTH BSE AND NASDAQ BUT AT THE LATER STAGE THERE HAS BEEN FLUCUATIONS IN THE MARKET. BUT BY LOOKING AT THE NEGITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SLIGHT NEGITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH AUG-07
s.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 BSE -5.33 0.33 1.02 -1.55 0.20 2.51 -1.36 -1.54 1.00 -0.11 -4.28 -1.51 2.02 -3.04 1.86 -0.59 1.84 NASDAQ -0.33 0.87 -2.51 1.44 0.56 2.01 -2.16 -0.45 -0.10 -1.70 -1.61 -0.32 2.20 0.14 0.51 1.25 -0.43 CORREL
18 19
2.89 0.52
1.38 -0.60
0.37
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF AUG-07
4.00 2.00 0.00 1 -2.00 -4.00 -6.00 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.THERE IS A STRONG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH SEPT-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 BSE 3.37 0.28 -0.12 1.10 -0.17 0.04 -0.35 -0.24 0.70 -0.07 -0.64 1.06 4.17 0.15 1.32 1.70 0.32 0.13 NASDAQ 2.69 -0.92 0.32 -1.86 -0.26 1.50 -0.21 0.35 0.04 -0.79 2.71 0.56 -0.46 0.64 -0.12 0.58 0.58 0.39 CORREL
19
1.35
-0.30
0.02
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF SEPT-07
5.00 4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION. THERE HAS BEEN SLIGHT CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH OCT-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 BSE 1.04 2.99 -0.39 -0.02 -1.59 4.51 2.07 0.84 -2.10 3.47 -0.04 -1.76 -3.83 -2.44 0.31 4.99 0.11 1.39 NASDAQ 1.46 0.22 -0.64 0.15 1.71 0.25 0.59 0.27 -1.40 1.21 -0.91 -0.58 1.04 0.24 -2.65 1.06 1.65 -0.88 CORREL
19
2.52
-0.86
0.12
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF OCT-07
6.00 4.00 2.00 0.00 -2.00 -4.00 -6.00 1 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH NOV-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 BSE 2.50 1.28 -1.93 -0.97 -0.57 -1.20 -0.79 -0.90 1.59 4.69 -0.72 -0.44 -0.33 -1.80 -3.52 -0.41 1.76 2.09 -0.62 NASDAQ 1.60 0.56 -0.54 1.07 -2.70 -1.92 -2.52 -1.67 3.46 -1.10 -0.98 0.72 -1.66 0.13 -1.33 1.34 -2.14 1.57 3.18 CORREL
0.23
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF NOV-07
6.00 4.00 2.00 0.00 1 -2.00 -4.00 3 5 7 9 11 13 15 17 19 BSE NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE STRONG POSITIVE CORRELATION.
CORRELATION BETWEEN BSE AND NASDAQ FOR THE MONTH DEC-07
S.NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 BSE 2.49 -0.38 1.07 0.29 0.86 -0.18 1.81 0.42 -1.33 -0.37 -3.84 -0.94 0.06 0.37 3.61 1.70 0.12 -0.05 0.40 NASDAQ -0.97 -0.66 1.78 1.60 -0.11 0.47 -2.45 0.71 -0.10 -1.23 -2.32 0.84 0.19 1.53 1.94 0.80 0.40 -1.75 -0.09 CORREL
0.36
CORRELATION OF RETURNS BETWEEN BSE AND NASDAQ FOR THE MONTH OF DEC-07
4.00 3.00 2.00 1.00 0.00 -1.00 -2.00 -3.00 -4.00 -5.00
BSE 1 3 5 7 9 11 13 15 17 19 NASDAQ
IN THE ABOVE GRAPH IF YOU SEE CAREFULLY THERE ARE ONLY SOME POINTS WHICH ARE ABOVE NORMAL POSITIVE LINE AND MOST OF THE RETURNS OF BSE AND NASDAQ ARE BELOW THE NORMAL POSITIVE LINE. BUT BY LOOKING AT THE POSITIVE CORRELATION WE CAN SAY THAT BOTH THE MARKETS ARE IN THE SAME DIRECTION.
CONCLUSION
Here correlation means relation ship between two or more variables. In this study we taken two variables BSE SENSEX and NASDAQ. In the month of April the correlation between BSE SENSEX and NASDAQ is 0.49.so there exists slight positive relation ship and all data points are form as non linear structure and tilts upwards towards right. Remaining all the months there exists low correlation, and in the months of july and may there exists negative correlation ie -0.17 and -0.69, so there exists strong negative relationship and all data points tilts downward towards right. There is an overall positive as well as negative correlation of returns between the BSE sensex and NASDAQ stock exchange, because out of (12) month data collected (10) months have positive correlation and (2) months have negative correlation on returns. It shows that when BSE is increasing NASDAQ is decreasing and vice-versa because financial institutions are the main investors in BSE sensex
If we see the closing of both BSE and NASDAQ it’s as follows. BSE started with a closing of 13940.14and NASDAQ started with a closing of 2422.41 By seeing the closing of both the stock markets we can say that increase and movement of funds is more in BSE when compared to NASDAQ.
BIBLIOGRAPY 1. WEBSITES • http://www.bseindia.com • http://www.bseindia.com/about/introbse.asp • http://www.bseindia.com/about/abindices/preface.asp • http://www.ieg.nic.in/dis_rna_20.pdf • http://en.wikipedia.org/wiki/NASDAQ • http://www.nasdaq.com/ • http://images.search.yahoo.com/search/images? _adv_prop=images&imgsz=all&va=nasdaq+logo&ei=UTF8&fr=slv8-msgr&b=1 2. NEWS PAPER ? Times of India ? Business Line 3. BOOKS • Donald E. Fischer & Ronald J. Jordan
(SECURITY ANALYSIS AND PORTFOLIO MANAGENENT)
doc_555853513.doc