logo

Statistics Assignment (Solution)

   

Added on  2021-01-03

21 Pages4859 Words41 Views
STATISTICS

Table of ContentsQUESTION 1...................................................................................................................................1(a) Data for CSR Ltd and SFR Ltd along with stem-and-leaf diagram using Excel..............1(b) Construction of Relative frequency for CSR Ltd and frequency polygon for SFR Ltd:..4(c) Bar Chart for six listed companies in Material Sector according to market capital.........6(d) Recommendations to invest in CSR Ltd or SFR Ltd. based on fundamental analysis andexpert advice...........................................................................................................................7QUESTION 2...................................................................................................................................8(a) Calculation of Mean, Median, first quartile, and third quartile of sold prices for each cityusing excel..............................................................................................................................8(b) Calculation of standard deviation, mean absolute deviation and range for each city usingexcel........................................................................................................................................8c) Box and Whisker Plot for the sold prices of each city.......................................................9d) Recent trends in apartment prices in Australia..................................................................9QUESTION 3.................................................................................................................................10a) Calculation of probability that an employee in Australia.................................................11b) Probability of male sale worker employed in Australia...................................................11c) Probability of female employee working in part time of clerical and administrative workers ..............................................................................................................................................11d) Ratio for total persons in 2013 between Owner managers of incorporated enterprises toOwner managers of unincorporated enterprises...................................................................12b) Professional......................................................................................................................14QUESTION 4.................................................................................................................................14b)...........................................................................................................................................14QUESTION 5...................................................................................................................................1CONCLUSION................................................................................................................................2REFERENCES................................................................................................................................3APPENDIX......................................................................................................................................4

QUESTION 1(a) Data for CSR Ltd and SFR Ltd along with stem-and-leaf diagram using ExcelThe sample data for two ASX listed companies viz. CSR Limited and SFR Limited havebeen provided below along with their unadjusted opening prices for the time period January 2008to December 2017. (Price and research of SFR Limited, 2019)DateOpening Prices (Unadjusted)2008CSR LTD. (in $ AUD)SFR LTD. (in $ AUD)January8.210.34April8.450.3July6.590.27October6.780.172009January5.190.08April3.530.08July4.931October5.543.42010January5.43.7April5.313.62October5.46.912011January5.078.11April3.286.81July2.937.11October2.265.882012January1.966.58April1.818.04July1.427.27October1.558.362013January1.968.631

April2.066.02July2.225.13October2.446.432014January2.656.46April3.55.85July3.56.18October3.35.772015January3.94.55April4.034.37July3.595.71October2.885.652016January2.895.63April3.255.67July3.685.25October3.655.082017January4.625.64April4.56.37July4.225.62October4.725.76Stem-and-leaf Display:As the name suggests, stem and leaf diagram is a table produced by Excel that splits thegiven data into stems and leaves. It is an analytical tool that helps in bifurcation of given datainto more legible and easier manner for the analysts to make sense of the collected data (Al-Omari, 2016).Given below is an output of values in stem and leaf pattern which shows stem valuesranging between 0 to 8 and includes CSR and SFR values on the right side and left siderespectively (Armstrong and Taylor, 2014). Here, the data values are broken down into stemsand just like the stem holds the leaves of a plant, the leaves values originate from these given2

stem values. For instance, Stem Value 0 produces an SFR leaf depicting the value for unadjustedopening prices for January 2008 0.34 in decimal values. Since, CSR prices have no value with azero in it, the CSR leaves for stem value 0 has been left empty. For Stem Value 1, SFR Leavesproduces a value zero since there is only one opening price for SFR in the above data thattouches $1 for July 2009. Therefore, SFR leaf shows zero in front of Stem-value 1 since zeroplus one would render a value of one (Boehm and Thomas, 2013). The value 0.3430271708 for Stem-value 0 can be read as the prices $0.34, $0.30, $0.27,$0.17 and $0.08. This is applicable for both SFR and CSR Leaves. It is easier to see through thisplot the ranges of opening prices at which the Company stocks have been frequent. For instance,SFR Share price has not touched price $2 at all, it has either touched $5 and $6 as its highestopening prices and $0.08 as its lowest opening price between January 2008 and December 2017(Price and research of CSR Limited, 2019).SFR LeavesStemCSR Leaves0.34302717080010.968142559620.93260622450.4070622130.53285539590.553740.93980362520.881385777250.19544314070.918158024360.59780.112773

0.1104366380.2145(b) Construction of Relative frequency for CSR Ltd and frequency polygon for SFR Ltd:i.Relative Frequency histogram for CSR Ltd.:Relative Frequency is the percent unit for how many times a frequency has occurred inrelation to the total of frequency for given range values. The following table shows relativefrequency table and histogram for CSR Ltd:Relative Frequency table for CSR Ltd.:RangesCSR LTD. ( frequency)CSR Ltd. (Relative Frequency )$0 to less than $100$1 to less than $250.125$2 to less than $380.2$3 to less than $4101$4 to less than $570.175$5 to less than $660.15$6 to less than $722$7 to less than $800$8 to less than $920.05Total40The above table shows classification of the sample data given with first range describinghow many times an opening price for CSR Limited has fallen between '$0 to less than $1', '$1 toless than $2' and so on.. After finding the frequency, relative frequency for each range has beenascertained by dividing frequency of CSR Limited from total observations, that is, 40 (Brozovićand Schlenker, 2011).This table has then been converted into a Relative Frequency histogram shown belowusing Excel for getting a better picture of the behaviour of share opening prices between January2008 to December 2017. It can clearly show that the opening prices have frequently fallenbetween the class width '$6 to less than $7' and least between the class width '$7 to less than $8'.4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Statistics for Analytical Decisions and Probability Computation
|24
|2666
|233

Statistics Study Material with Solved Assignments and Examples - Desklib
|18
|1097
|365

Statistics Assignment on Australian Stock Exchange, Apartment Prices and Employment Type in Australia
|14
|2812
|105

Statistics Assignment
|14
|1633
|314