STATISTICAL ANAYSIS
OF FINANCIAL DATA
Semester-4 Internal Assignment
NAME- Piyush Mhaskar- 5812
CLASS- SY B. Com
DIV- D
PART 1- Analysis of the various
statistical measures of the company
“ONGC”
Introduction
Today, we will analyze the various statistical measures of
the company “ONGC” Our report will include the analysis
of- Mean, Median, Mode, Variance & Standard Deviation.
ONGC is a key player in the oil & gas sector, specializing
in the exploration, development, and production of crude
oil, natural gas, and value-added products, with
comprehensive in-house service capabilities.
Stock Prices of ONGC- (10 days- 10th Dec 2024 to 23rd
Dec 2024)
DATE STOCK PRICES
10-12-2024 256.9
11-12-2024 256.6
12-12-2024 254.05
13-12-2024 254.25
16-12-2024 251.8
17-12-2024 247.4
18-12-2024 244.15
19-12-2024 241.85
20-12-2024 237.1
23-12-2024 240.85
STATISTICAL MEASURES-
1) Mean = Σ of the stock prices ÷ No. of elements
= 2484.65 ÷ 10
= 248.49
2) Median = Step 1- Put the elements in ascending order
Step 2- Mean of 5th & 6th observation
Ascending Order- (237.1, 240.85, 241.85, 244.15,
247.4, 251.8, 254.05, 254.25, 256.6, 256.9)
∴ Median = 249.60
3) Mode = In the dataset there is no value that is repeated
twice, but if we take the round-off values- the mode comes
out to be 254 & 256.
4) Variance =
Step 1- Mean of the Dataset- 248.49
Step 2- Subtracting all the data points from the mean and
squaring them (70.45, 65.72, 30.57, 32.25, 11.18, 1.19,
19.18, 44.25, 130.93, 57.82)
Step 3- Dividing the sum of these by 10 = 463.84 ÷ 10
Variance = 46.38
5) Standard Deviation = Square root of Variance
= 6.81
Analysis of the Statistical measures-
The stock prices over the 10 days had an average value of
248.49, which means this is the typical price for the stock
during this period. The median, which is the middle value,
is 249.6, and it’s very close to the average, showing that
the prices were fairly consistent and not too far from the
centre. There is no mode because each stock price is
unique, so no price repeats. The variance of 46.38 and the
standard deviation of 6.81 show that the prices were a little
spread out, with small daily changes, but they weren't
changing too much or too suddenly. In simple terms, the
stock prices stayed fairly steady with a few minor
fluctuations around the average.
I am a personal investor in ONGC, and it’s a stable stock
that gives decent returns. Since ONGC is in the oil
industry, its performance can be affected by global
political events.
Note- Stock prices are obtained through KITE
(ZERODHA)- Investing Platform
Conclusion (PART 1)
The analysis of ONGC’s stock prices over 10 days shows
that the stock was stable and consistent during this time.
The average price was ₹248.49, and the middle value
(median) was ₹249.6, which are very close to each other,
showing that the prices stayed around the same range.
Since no price was repeated, there is no mode, but this also
means the prices were well-distributed. Overall, the stock
showed steady performance without big ups or downs.
The variance (46.38) and standard deviation (6.81)
indicate that the daily price changes were small and
predictable, with no sharp movements. This makes ONGC
a reliable and low-risk stock for investors. As someone
who invests in ONGC, this analysis confirms that it is a
stable option that offers decent returns. However, being in
the oil and gas sector, its performance can still be
influenced by global events and market trends.
PART 2- Analysis of the stock prices
of 2 Companies
(State Bank of India & HDFC Bank)
State Bank of India (SBI)- State Bank of India (SBI) is a
prominent public sector bank in India, providing a diverse
range of financial products to individuals, businesses, and
institutions with a focus on service, transparency, ethics,
and sustainability.
HDFC Bank- HDFC Bank Limited is a prominent private
bank in India, offering a wide range of commercial,
investment, and retail banking services across three key
segments.
Graphical Representation of Stock Prices of SBI in the
last 10 Months (Jan 2024- Oct 2024)
MONTH STOCK PRICES
January 641.35
February 647.65
March 769.15
April 758.3
May 830.05
June 905.65
July 841.95
August 862.65
September 822.15
October 796.95
Screenshot from KITE ZERODHA (Investing Platform)-
SBI is one of the most important public sector banks in
India and has consistently provided good returns to its
investors. The graph shows how SBI’s stock has
performed over the past 10 months. Although the stock
has experienced some ups and downs during this time,
there is a clear sign of overall growth. I personally invest
in SBI, and it has been a reliable investment, giving me
good returns. Since SBI operates in the banking sector, its
performance is closely linked to decisions made by the
Reserve Bank of India (RBI), such as changes in interest
rates, as well as other economic policies announced by the
Government of India. These factors can have a direct
impact on how the stock performs, making it sensitive to
changes in the economy.
Graphical Representation of Stock Prices of HDFC
Bank in the last 10 Months (Jan 2024- Oct 2024)
MONTH STOCK PRICES
January 1698.1
February 1466.35
March 1430.75
April 1470.5
May 1532.25
June 1572.2
July 1705.2
August 1638.8
September 1626.95
October 1726.2
Screenshot from KITE ZERODHA (Investing Platform)-
HDFC Bank is one of the leading private banks in India,
known for its stability and steady growth in the stock
market. Although its stock saw a slight drop in February,
it quickly bounced back, showing its strong position. In
my personal experience, it has given me the highest
returns compared to other banking stocks in my portfolio,
making it a reliable and safe investment option.
SBI, on the other hand, is a government-owned bank with
a huge customer base, especially in rural and semi-urban
areas. It is more influenced by government policies and
changes in interest rates set by the RBI, which can make
its stock more unstable at times. HDFC Bank, being a
private bank, focuses on efficiency, good customer
service, and technology, which makes it more popular in
cities and among tech-savvy people. While SBI may offer
long-term growth due to its government backing, HDFC
Bank tends to be more stable with fewer fluctuations and
often provides better returns.
Conclusion (Part 2)
SBI and HDFC Bank are both leading banks in India but
cater to different needs and types of investors. SBI, being
a public sector bank, focuses on government programs and
has a huge customer base in rural and semi-urban areas.
Its stock shows growth but can be unstable due to changes
in RBI interest rates and government policies. On the other
hand, HDFC Bank, as a private sector bank, focuses on
efficiency, technology, and customer service. Its stock is
more stable and consistent, making it a reliable choice for
investors looking for steady returns.
Both banks have their strengths, and the choice between
them depends on the investor’s goals. SBI is better for
those seeking long-term growth supported by government
backing, while HDFC Bank is ideal for those wanting
steady and higher returns. The additional data from the
KITE platform further highlights their performance and
confirms that both banks play key roles in India’s banking
sector.
NOTE- ALL THE INFORMATION USED IN THIS
REPORT IS OBTAINED FROM KITE (INVESTING
PLATFORM)