Assignment 2: Statistical Techniques for Business Environment

Assessment details for all students
Assessment item 2—Assignment 2
Due date: 6:00pm, Wednesday Week 10 ASSESSMENT
Weighting: 20%
2Format: Submit one file online as .doc, .docx, .rtf or .pdf
Assessment criteria
 This assignment must be typed, word-processed or clearly hand-written (but plots and graphs
must be done using EXCEL or equivalent software),and submitted online as a single file
through Moodle.Important note:The file size must not be over 100MB.
 MicrosoftExcel allows students to cut and paste information easily into Microsoft Word
documents. Word also allows the use of Microsoft Equation Editor to produce all necessary
formulae (use of these are recommended).
 It is expected that Excel would be used to assist in statistical calculations for questions in this
assignment.Where Excel is used, use copy function, “Snipping tool” or similar to cut and paste
relevant parts of the spreadsheet to verify that you have done the work. (In that case there is no
need to write the equations.)
 For those questions where Excelis not used to do the computations, all formulae and working
must be included to obtain full marks.
 Only one file will be accepted in any of the formats mentioned above. No zipped file or any other
file extension will be accepted.
 There will be late submission penalty for submissions beyond the deadline unless prior approval
is obtained from the Unit Coordinator through the extension system in Moodle. Under no
circumstances any submission that is late beyond 14 days from the deadline of Friday of Week 10
will be marked, or get any score other than zero.
Assignment markers will be looking for answers which
 demonstrate the student’s ability to interpret and apply the statistical techniques in the
scenarios and
 use statistical techniques as decision making tools in the business environment.
Full marks will not be awarded to answers which simply demonstrate statistical procedures without
comment, interpretation or discussion (as directed in the questions).
Plagiarism
CQU values academic honesty. Consequently, plagiarism will not be tolerated in assessment items. This
assignment must be completed by each student individually.
1 of 4

Question 1 4 Marks
Visit the Australian Stock Exchange website, www.asx.com.au and from “Prices and research” drop-
down menu, select “Company information”. Type in theASX code “NAB” (National Australia Bank), and
find out details about the company. Also, type in the ASX code “WBC” (Westpac Banking Corporation),
and find out the details about that company. Information available in the ASX website will be inadequate
for your purpose, you will need to search the internet for more information. Your task will be to get the
opening prices of NAB and WBCshares for every quarter from January 2009 to December 2017
(unadjusted prices). If you are retrieving the monthly prices, read the values in the beginning of every
Quarter (January, April, July, October) for every year from 2009 to 2017 (Total 36 observations).After
you have researched share prices, answer the following questions:
(a) List all the quarterly opening price values in two tables, one for NAB and the other for WBC. Then
construct a stem-and-leaf display with one stem value in the middle, and NABleaves on the right side
and WBC leaves on the left side. (Must use EXCEL or similar for the plot
NAB Quarterly Opening Price WBC Quarterly Opening Price
2 of 4

Quarter WBC Open
Oct-17 32.13
Jul-17 30.56
Apr-17 35
Jan-17 32.71
Oct-16 29.78
Jul-16 29.41
Apr-16 29.85
Jan-16 33.4
Oct-15 29.825
Jul-15 32.083
Apr-15 38.895
Jan-15 32.819
Oct-14 31.456
Jul-14 33.694
Apr-14 34.36
Jan-14 32.272
Oct-13 32.614
Jul-13 28.459
Apr-13 30.539
Jan-13 25.823
Oct-12 24.597
Jul-12 21.167
Apr-12 21.839
Jan-12 19.971
Oct-11 19.654
Jul-11 21.958
Apr-11 24.083
Jan-11 22.146
Oct-10 23.154
Jul-10 20.732
Apr-10 27.494
Jan-10 25.062
Oct-09 25.902
Jul-09 19.634
Apr-09 18.843
Jan-09 16.698
Stem and Leaf Display
9 9 9 8 6 1 9 9
9 9 8 7 5 5 4 4 3 2 1 1 1 0 2 0 1 1 2 2 2 3 3 4 4 4 5 5 5 6 7 8 8 9 9 9
8 5 4 3 3 2 2 2 2 2 2 1 0 0 3 0 0 1 1 1 2 2 3 3 3 6
WBC Leaf NAB Leaf
Stem
Stem and Leaf Display shows the price of both the banks are more concentrated on 20 to 30 range
basket.
(b) Construct a relative frequency histogram for NAB and a frequency polygon for WBC on the same
graph with equal class widths, the first class being “$14 to less than $16”. Use two different colours
for NAB and WBC. Graph must be done in EXCEL or similar software.
3 of 4
Quarter NAB Open
Oct-17 31.54
Jul-17 29.61
Apr-17 33.17
Jan-17 30.7
Oct-16 28
Jul-16 25.63
Apr-16 25.9
Jan-16 29.01
Oct-15 28.955
Jul-15 32.252
Apr-15 36.522
Jan-15 31.836
Oct-14 30.552
Jul-14 31.189
Apr-14 33.699
Jan-14 33.129
Oct-13 32.701
Jul-13 27.929
Apr-13 29.336
Jan-13 23.784
Oct-12 24.24
Jul-12 22.539
Apr-12 23.527
Jan-12 22.415
Oct-11 20.78
Jul-11 24.288
Apr-11 24.554
Jan-11 22.814
Oct-10 24.269
Jul-10 21.883
Apr-10 26.047
Jan-10 25.951
Oct-09 29.088
Jul-09 21.008
Apr-09 19.126
Jan-09 19.915