Graduate Diploma in Accounting – TK1408

PROGRAMME: CODE TITLE

Graduate Diploma in Project Management – TK1403 Graduate Diploma in Operations and Production Management – TK1404 Graduate Diploma in Human Resource Management – TK1407 Graduate Diploma in Accounting – TK1408

Professional Practice A Semester 1 2020

Assignment 1

Due Date: Wednesday 24 June 2020

Weighting: 40% of Course Mark

Note in addition to handing in a hard copy on the due date, you are also required to use Turnitin for this assignment for questions 1,2,3 and 4. For question 5 you need to provide me with a soft copy of your analysis to include any graphs and tables generated.

Turnitin class ID: 25044220

Turnitin Enrolment key: BAM7.019ASS1

This assignment addresses the following course learning outcomes:

Learning Outcome
Apply quantitative methods within the decision-making process.
Analyse and examine quantitative methods used in the business environment.
Demonstrate and apply the principles and methods of research.
Utilise common statistical tools contained within standard business software (particularly spread sheets).

Question 1 (5 Marks)

Discuss how quantitative research methods facilitate the decision-making process using relevant examples.

Question 2 (30 Marks)

Below you will find URLs to three articles:

https://content.sciendo.com/view/journals/dim/2/2/article-p91.xml?language=en
https://www.tandfonline.com/doi/full/10.1080/09585192.2017.1380063
https://www.tandfonline.com/doi/full/10.1080/00207543.2017.1365182?src=recsys

Your task is to:

  1. Clearly identify and state the research question(s) or purpose(s) in each of the articles.

(3 marks)

  1. Provide a rationale for each of the three research studies. (3 marks)
  1. Identify what type of research was carried out in each case. Justify your answer. (3 marks)
  1. What were the sources of the data used in study and how was it collected in each case.

(6 marks)

  1. Choose one of the articles and then:
  1. Identify and list a minimum of five of the variables used and
  1. Provide an operational definition of those variables (2.5 marks)
  1. Label each variable as being continuous or discrete, noting why (2.5 marks)
VariableOperational DefinitionContinuous or DiscreteWhy
  1. What, if any, sampling frames and sampling techniques were used? (3 marks)
  1. What types of descriptive and inferential statistics were presented? Provide examples justifying your opinion. (5 marks)
  1. Was your chosen article easy to read? Why / Why not? (2 marks)

Question 3 (10 Marks)

Tabulate the advantages and disadvantages of five different data collection methods.

MethodAdvantageDisadvantage






























Question 4 (15 Marks)

2o is a mobile network operator competing with Spark, Vodafone and Skinny Mobile in the New Zealand market. The company has enlisted your help to identify what variables mobile customers see as being important in their purchase decisions for mobile phone plans and whether certain variables are more important than others in those decisions.

  1. Create a research question for this project and explain why such a question is important.

(3 marks)

  1. Briefly outline the research methodology you would use. (3 marks)
  2. Develop a sampling plan paying specific attention to the sampling frame and sampling design that you would use. (4 marks)
  3. What would you need to know in order to obtain a reliable sample size for this project?

(5 marks)

Question 5 (40 Marks) (See note at end of question)

The Indian Premier League (IPL) is a Twenty20 cricket tournament held every year in India. The tournament was first played in 2008.

(If you are not familiar with Twenty20 cricket read appendix 1)

The following table summarises the batting performance across the years since the tournament’s inception.

Table 1: Summary of IPL Batting Statistics

YearNumber of TeamsNumber of Batsmen*Runs ScoredAverage Runs Scored per batsman**
2008814416601
2009813514925
2010814417204
20111016519907
2012916021324
2013916621422
201489914952
2015812417409
2016813117966
2017810017684
2018810018926
2019810018426
Totals1268161710

*Batsmen who scored at least 1 run. Note they have only reported on the top 100 batsmen since 2017.

** To 2 decimal places

Required:

  1. Complete the above table filling in the average runs scored per batsman. (1 mark)

The following questions require use of the IPL 2019 Batting Statistics data base.

You are to use the statistical functions in Excel for all of the following questions wherever possible, placing your answers as indicated below.

  1. Provide the summary descriptive statistics for all of the columns highlighted in YELLOW below the appropriate columns. (3 marks)
  1. Create a frequency distribution for each of the following:
  1. Runs achieved by the top 50 batsmen in 2019. (1 mark)
  2. Number of fours achieved (1 mark)
  3. Number of Sixes achieved (1 mark)

Place them on the Data Sheet as indicated

(Note you will need to set your bins up with the upper number in each case e.g for runs: 200, 300, 400 etc.)

(Some functions also require you to use the Shift/Control and Enter keys all at the same time rather than the OK button)

  1. Create a histogram of the runs achieved distribution making sure you provide title and axis labels (Place these diagrams on the Answer Sheet) (2 marks)
  1. Comment on the distributions, particularly regarding central tendency, dispersion and symmetry. (Below the histograms). (3 marks)
  1. Explain the standard deviation, variance and standard error results for the “runs” and “balls-faced“ columns in the data sheet. (3 marks)
  1. Propose a “null” and “alternate” hypothesis regarding a relationship between the average runs scored per batsman over the duration of the IPL 2008 – 2019 and the achievements in the 2019 (1 mark)
  1. Carry out an appropriate statistical test of significance and state whether you will accept or reject the null hypothesis. (5 marks)
  1. Provide the standard deviation and variance for the “Runs Scored” and “Average Runs Scored per Batsman” in Table 1 Summary of IPL batting statistics above. (2 marks)
  1. Using the “Average” and “Strike Rate” data:
  1. Plot the data on the same scatter gram. (2 marks)
  2. What is the correlation coefficient for this data? (1 mark)
  3. Explain the figure obtained in (ii) above. (2 marks)
  4. Fit a linear trend line to the data (2 marks)
  5. What is the regression equation of this line? (2 marks)
  6. If the overall “Batting Average” is predicted to be greater than 40 in the 2020 competition, what can you predict about the overall average strike rate? ` (2 marks)
  7. Assuming that the number of fours and sixes represent categorical data represents categorical data, carry out a Chi-Square test (showing your workings longhand and verified by Excel function) to see if there is any significant difference between Indian Nationals and International players in the top 50 batsmen in scoring boundaries.

Explain your results. (6 marks)

(Note you will need to complete the source column to identify who is an Indian National (code as a 0) and who is not an Indian National (Code as 1) to perform this task).

Note please send me an electronic copy of your excel document once it is completed before or by the due date.

Appendix 1 Cricket Game Description

Before play commences, the two team captains call the toss of a coin, and the winning captain decides which team shall bat or bowl first. The captain who wins the toss makes his decision on the basis of tactical considerations regarding the strengths/weaknesses of the competing teams as well as field conditions. In One Day International (ODI) matches, 50overs (300 = 50 x 6 legal (game-permissible) ball deliveries) are allowed for each side, while 20overs (120 = 20 x 6 legal ball deliveries) are allowed in Twenty20 matches.

Figure 2a. Cricket Pitch

There are 11 players on each team. Batsmen play in pairs. Bowlers are not allowed to throw the ball; instead, they must use a “stiff-arm” ball delivery technique. There are two basic types of bowling: fast and spin. A fast bowler mainly uses speed as the tactic while a spinner may spin the ball, making it harder for the batsman to judge, and there are other factors, like swing and bounce, used to distract batsmen. The rectangular area in the middle of the field is called the pitch, and this is where most of the action happens. There are two sets of sticks, called wickets, which are placed 22 yards apart in the pitch.

A batman’s aim is to bat and score runs while simultaneously protecting the wickets. The bowler’s aim is to deliver (bowl) the ball at the wicket so that the ball hits and disrupts the wicket. This is one of several ways that a batsman can be called out. In one turn, a bowler delivers a set of six balls, which is called an over. Once a batsman hits the ball sufficiently far, he runs to the (non-striker) wicket while the other batsman at the non-striker wicket simultaneously runs to the striker wicket, accumulating a single run.

Figure 2b. Wicket

The batsman will be called out if a fielder breaks the wicket with the ball before the batsman reaches his wicket. Each switch like this gives one run to the striker, but the players may continue to switch as long it is safe to do so. There is an outside boundary around the cricket field. When a batsman hits the ball and it reaches the boundary after hitting the ground inside the boundary, four runs (a boundary) are awarded to the batsman. However, if the ball goes over the boundary without hitting the ground, six runs are awarded to the batsman.

There are several ways a batsman can be dismissed. If a batsman misses the ball and it hits the wicket, the batsman is out, and this dismissal is called bowled. If a fielder catches the ball in full (without it first hitting the ground) after it was hit by the batsman, he is out and this dismissal is called caught. If the ball hits the body (usually a leg) of the batsman, and if the umpire decides the ball would have hit the wicket otherwise, the batsman is called out and this dismissal is called LBW (Leg Before Wicket). If a fielder breaks the wicket using the ball before a batsman reaches his end while attempting to score, the batsman is called out and this dismissal is called a run out. If the wicket keeper, the fielder who stays behind the wicket at the striker end breaks the wicket with the ball while the striker batsman is outside his safe zone, the crease, the batsman is out and this dismissal is called stumped. If a batsman breaks the wicket with the bat or his body while attempting to score, he is called out and this dismissal is called hit wicket. There are a few other methods of dismissing batsman which are not so common, such as handle the ball (touching the ball while it is live), obstructing the fielder (deliberately obstructing a fielder), hit the ball twice (hitting the ball twice for any reason other than to defend his wicket from being broken by the ball) and timed out (new batsman taking more than two minutes to come to bat after a wicket has fallen). For more detailed information on the rules of cricket go to www.cricket-rules.com.

Leave a Reply

Your email address will not be published. Required fields are marked *