Finance Analysis: Stem-and-Leaf Displays, Market Capitals, Trend Analysis, and More

In this document we will discuss about Finance Analysis and below are the summary points of this document:- Includes stem-and-leaf displays for WBC and NAB data.  Involves calculating mean, standard deviation, and quartiles for each state. Contains undisclosed sub-questions, potentially related to a different topic or analysis. Covers undisclosed sub-questions, potentially related to a different topic or analysis. Covers undisclosed sub-questions, potentially related to a different topic or analysis.

Finance
Page 1

Table of Contents
Question 1........................................................................................................................................3
(a) Stem-And-Leaf Display.........................................................................................................3
(b) Relative Frequency Histogram of WBC & NAB and Frequency Polygon............................4
(c) Market Capitals......................................................................................................................5
(d) Market Situation of WBC and NAB......................................................................................5
Question 2........................................................................................................................................6
(a) Mean and Standard Deviation for Each State........................................................................6
(b) Minimum, Q1, Median, Q3 and Maximum Values for Each State.......................................7
(c) Whisker Plot...........................................................................................................................7
(d) Trend Analysis.......................................................................................................................8
Question 3........................................................................................................................................8
(a).................................................................................................................................................8
(b).................................................................................................................................................9
(c).................................................................................................................................................9
(d).................................................................................................................................................9
Question 4......................................................................................................................................10
(a)...............................................................................................................................................10
(b)...............................................................................................................................................10
(c)...............................................................................................................................................11
Question 5......................................................................................................................................11
(a)...............................................................................................................................................11
(b)...............................................................................................................................................11
(c)...............................................................................................................................................12
References......................................................................................................................................13
Page 2

Question 1
(a) Stem-And-Leaf Display
WBC NAB
Leaf Stem Leaf
9 15
16
17
18 4
78 19
4 20 8
139 21 66
226 22 69
23 37
59 24 189
2 25 167
5 26 477
4 27 9
28 5
18 29 1
194 30 1229
255 31 6
79 32 13447
1379 33 157
76 34
35
36 7
37
7 38
Table 1 Stem-And-Leaf Display of WBC and NAB
Page 3

(b) Relative Frequency Histogram of WBC & NAB and Frequency Polygon
Bin Frequency Bin Frequency
14 0 14 0
16 0 16 0
18 0 18 0
20 0 20 2
22 3 22 4
24 6 24 4
26 6 26 3
28 4 28 3
30 2 30 2
32 5 32 7
34 8 34 7
36 0 36 2
38 1 38 0
More 0 More 1
Histogram
NAB
Histogram
WBC
Table 2 Histogram of WBC and NAB
0
1
2
3
4
5
6
7
8
9
15 17 21 23 25 27 29 31 33 35 37 39 41
Frequency
Mid Points
Frequency Polygon
NAB Frequency WBC Frequency
Figure 1 Frequency Polygon of WBC and NAB
Page 4

(c) Market Capitals
976,374
897,326
788,325
839,993
101,490
167,441
0 200,000 400,000 600,000 800,000 1,000,000 1,200,000
CBA
ANZ
NAB
WBC
BQQ
MBL Market Capital Differences of ASX Companies
Market Capital
Figure 2 Market Capital Differences of ASX Companies
(d) Market Situation of WBC and NAB
Factors NAB WBC
Trend 24.92 24.90
P/E ratio 12.01 11.36
Dividend yield 7.96% 7.19%
Debt 791Million 710Million
Beta 1.2088 1.2747
Table 3 Market Situation of WBC and NAB
Based on the above table 3, the market conditions of WBC and NAB trend have been found to be
similar. Nevertheless, the P/E ratio of NAB is higher than the WBC accounting for 12.01 and
11.36 respectively. At the same time, NAB’s dividend yield is 7.96%, which is higher as
compared to WBC’s 7.19%. However, the debt of the WBC is lower than the NAB and beta of
both the companies is similar. Hence, NAB can be recommended for making an investment, as it
Page 5

is more favorable (InvestSMART Financial Services Pty Ltd, 2019; InvestSMART Financial
Services Pty Ltd, 2019a; Trading View, 2019; Trading View, 2019a).
Question 2
(a) Mean and Standard Deviation for Each State
Mean 33130.25 Mean 27187.91667 Mean 19418.83333
Standard Error 1118.450437 Standard Error 841.0726598 Standard Error 797.5536159
Median 32750 Median 27080.5 Median 18722
Mode #N/A Mode #N/A Mode #N/A
Standard Deviation 3874.425966 Standard Deviation 2913.561159 Standard Deviation 2762.806769
Sample Variance 15011176.57 Sample Variance 8488838.629 Sample Variance 7633101.242
Kurtosis 4.485398243 Kurtosis 2.860488706 Kurtosis 6.504791057
Skewness 1.755162583 Skewness 0.955092707 Skewness 2.360388676
Range 15057 Range 11836 Range 10400
Minimum 28392 Minimum 22426 Minimum 16870
Maximum 43449 Maximum 34262 Maximum 27270
Sum 397563 Sum 326255 Sum 233026
Count 12 Count 12 Count 12
Mean 5978.166667 Mean 8352.833333 Mean 1647.083333
Standard Error 203.6542239 Standard Error 256.7104498 Standard Error 82.69709774
Median 5968.5 Median 8085 Median 1629
Mode #N/A Mode #N/A Mode #N/A
Standard Deviation 705.4789261 Standard Deviation 889.2710839 Standard Deviation 286.4711499
Sample Variance 497700.5152 Sample Variance 790803.0606 Sample Variance 82065.7197
Kurtosis 1.380483294 Kurtosis 4.596736732 Kurtosis -1.789386344
Skewness 0.966497936 Skewness 1.973882349 Skewness 0.050156112
Range 2439 Range 3169 Range 776
Minimum 5174 Minimum 7580 Minimum 1298
Maximum 7613 Maximum 10749 Maximum 2074
Sum 71738 Sum 100234 Sum 19765
Count 12 Count 12 Count 12
Mean 894.6666667 Mean 1543.416667
Standard Error 52.76711748 Standard Error 6.098258983
Median 865.5 Median 1546
Mode #N/A Mode #N/A
Standard Deviation 182.7906569 Standard Deviation 21.12498879
Sample Variance 33412.42424 Sample Variance 446.2651515
Kurtosis -0.05377863 Kurtosis -1.282850995
Skewness 0.650238626 Skewness -0.122197857
Range 614 Range 64
Minimum 626 Minimum 1509
Maximum 1240 Maximum 1573
Sum 10736 Sum 18521
Count 12 Count 12
WA TAS
NT ACT
QLDVIC
SA
NSWNSW
Table 4 Standard Deviation of Sates Sales
Page 6

(b) Minimum, Q1, Median, Q3 and Maximum Values for Each State
Quartiles NSW VIC QLD SA WA TAS NT ACT
Minimum 28392 22426 16870 5174 7580 1298 626 1509
Q1 31395.75 25973 17984.75 5390 7810 1371.5 789.5 1527
Median 32750 27081 18722 5968.5 8085 1629 865.5 1546
Q3 33830 27979 19599.25 6310.25 8682.25 1906.75 982.5 1560.75
Maximum 43449 34262 27270 7613 10749 2074 1240 1573
Table 5 Quartiles of Each State Sale
(c) Whisker Plot
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
50000
NSW VIC QLD SA WA TAS NT ACT
Box and Whisker Plot
Figure 3: Box and Whisker Plot of State
Page 7

(d) Trend Analysis
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
50000
NSW
VIC
QLD
SA
WA
TAS
NT
ACT
Figure 4: Trend Analysis of New Vehicle Sales in Each state sale in 2016
The above table 4 depicts the of vehicles sales in six states. Contextually, the new cars, which
were sold in NSW accounted for 39, 7563 in the year 2016. At the same time, in VIC, QLD, SA,
WA, TAS, NT, and ACT were found to be 326,255, 233,026, 71,738, 100,234, 19,765, 10,736,
and 18,521 respectively.
Question 3
(a)
0= Lives In Victoria
Prabability 1= Not Lives in Victoria
45
45%
P(out of 3 people, exactly 1 person is Lives Victoria)
45% households lives in Victoria
Table 6
The probability is 45% of the household lives in Victoria (refer to table 6).
Page 8

(b)
0= Internet Users
1= Not Using Internate
P(out of 3 people, exactly 2 person is using Internet)
19
19%
19% households using internet in Tasamania
Table 7
Around 19% of the households living in Tasmania had access to the internet in 2010-2011 (refer
to table 7).
(c)
0= Lives in New South Wales
Prabability 1= Not Lives South Wales
36
36%
P(out of 3 people, exactly 2 person is lives in Soth Wales)
36% households lives in Lives in south Wales
Table 8
The probability is 36% of household’s lives in Lives in South Wales 2012-13 (refer to table 8)
(d)
0= Internet Users
1= Not Using Internate
P(out of 2 people, exactly 1 person is using Internet)
22
22%
22% households using internet
Table 9
Page 9

The probability is 22% of households using the internet in 2010-11 or 2012-13 (refer to the table
9).
Question 4
(a)
Factors Actual Time 5% of the Time Time Exceed Value
Mean Time 73 3.65 76.65
SD 8 0.4 8.4
Table 10
The Upper Value is 76.65 if the time exceeds 5% (refer to table 10).
(b)
16.5 degree = 0
21 degree = 1
Mean Value 16.5
P(Out of 4 days, 2 days temp. are less then 21D)
13
13%
13% chances that the temp. will be less than 21D
Table 11
The Probability is 13% chances that the temperature will be less than 21 degrees (refer to table
11).
Page 10

(c)
0= Product A
1= Product B
P(out of two products, 1 person takes Product B
92
92%
the probability is 92% people will choice product B
31
Hence, 31% people will choice Product B, if 50% to 60% Smaples are Correct
Table 12
(i) 92% is the probability that the sample percentage of correct identifications is greater than 65
(refer to table 12).
(ii) 31% is the probability that the sample will have between 50% and 60% of the identifications
correct (refer to table 12 above).
Question 5
(a)
In the case of probability, the succeeding rate is identified to be less than 0; hence the company
should conduct more trials to get success in the project.
(b)
Assumean 260
Actual Mean 251
S.D. 145
No. Observations 500
Significance 0.003
Actual Significance 0.001
Table 13: Actual level of Significance of Customers
Page 11

The above table 13 reflects the actual significance, which accounted for 0.001. This depicts
strong evidence that the population proportion of travelers, who select their flights and cancel
their bookings, is less than 0.50.
(c)
Column1
Mean 101.222
Standard Error 7.29493
Median 105
Mode #N/A
Standard Deviation 21.8848
Sample Variance 478.944
Kurtosis -0.93944
Skewness -0.31044
Range 66
Minimum 65
Maximum 131
Sum 911
Count 9
Confidence Level(95.0%) 16.8221
Table 14: Mean Value at the 95% Significant Level
Maximum Interval 118
Minimum Interval 84
Table 15: Maximum and Minimum Mean Value at the 95% Significant Level
Page 12

References
InvestSMART Financial Services Pty Ltd., 2019. National Australia bank limited (NAB).
Company Financials. [Online] Available at:
https://www.investsmart.com.au/shares/asx-nab/national-australia-bank-limited/financials
[Accessed January 25, 2019].
InvestSMART Financial Services Pty Ltd., 2019a. Westpac Banking Corporation (WBC).
Company Financials. [Online] Available at:
https://www.investsmart.com.au/shares/asx-wbc/westpac-banking-corporation/financials
[Accessed January 25, 2019].
Trading View, 2019. National Australia Bank Limited. ASX:NAB. [Online] Available at:
https://www.tradingview.com/symbols/ASX-NAB/ [Accessed January 25, 2019].
Trading View, 2019a. Westpac Banking Corporation. ASX:WBC. [Online] Available at:
https://www.tradingview.com/symbols/ASX-WBC/ [Accessed January 25, 2019].
Page 13