1
Course: Business Management – July 2020 intake
Module: BUSINESS DECISION MAKING
Assessment One (Individual Coursework)
Worth 30% of the module mark
Deadline:
All the 5 tasks must be attempted and you should present your answer in one WORD document.
————————————————————————————————————————————————–
Task 1: Ungrouped Descriptive Statistics [20 marks]
To gain some insights into the typical age of UK Netflix viewers, a sample of 113 subscribers was
surveyed in January 2020. Some descriptive statistics, computed to summarize the data, are
presented in Table 1 below. NB: Some values are missing.
Table 1 – Ungrouped Descriptive Statistics
UK Netflix Viewer Age
Mean
Standard Error 1.2
Median 43.0
Mode 43.0
Standard Deviation
Sample Variance 166.7
Kurtosis -1.0
Skewness 0.2
Range 46
Minimum 23
Maximum 69
Sum 4972
Count
Coefficient of Variation
Required for Task 1 (Comments for task 1 should not exceed 200 words in total.)
1. With reference to Table 1 above and using a calculator, find:
a) the mean,
b) the standard deviation,
c) the coefficient of variation and interpret each of the three values in the context of the
scenario provided. You should also provide a detailed explanation of how you calculate
these 3 statistics.
2. Compare the mean and the median values and comment on the distribution of the data.
2
Task 2: Grouped Descriptive Statistics [20 marks]
It was suggested that the UK Netflix sample data could also be summarized in a grouped table. This
table has been made available on weblearn as the Excel file named “BA4008QA CWK1
DataNov20” under the tab labelled Task 2.
Table 2 – Grouped Frequency Distribution
Age Category Frequency
Under 25 5
25 to 34 26
35 to 44 30
45 to 54 26
55 and over 26
Total Count 113
Required for Task 2 (Comments for task 2 should not exceed 100 words in total.)
1. Using the frequency table above as a starting point and the tabular method for summarising
grouped data, construct two tables in Excel.
a) The first table should show the percentage frequencies, cumulative frequencies and
cumulative percentage frequencies.
b) The second table should be constructed to estimate the mean and standard deviation. You
need to copy the Excel output (2 tables) into your Word document.
2. Compare the grouped data mean and standard deviation values to the ungrouped data mean and
standard deviation calculated under task 1. Which findings are more accurate; the ungrouped or
grouped statistics? Justify your answer.
3. Using Excel, construct a cumulative frequency curve and comment on the estimated minimum
age a viewer needs to have reached to belong to the top 25% of viewers in terms of age. You
need to copy the correctly labelled graph into your Word document.
—————————————————————————————————————-
Task 3: Relationships [25 marks]
To complete task 3, refer to the data provided under the tab labelled “Task 3” in the “BA4008QA
CWK1 DataNov20” Excel file.
Required for Task 3 (Comments for task 3 should not exceed 150 words in total.)
1. Create a scatter graph; plotting Job Separation Probabilities against the ‘best’ predictor. The
trend, regression equation and coefficient of determination should be shown on the graph. Copy
the correctly labelled graph into your Word file.
2. State the ‘best’ predictor; briefly explaining the reason for your choice.
3. Interpret the relevant correlation coefficient and the coefficient of determination in context.
4. State the regression equation in context and interpret the intercept and gradient.
3
Task 4: Networking [25 marks]
A maintenance project consists of 9 activities, as outlined in the table below.
Table 3 – Precedence Table
Required for Task 4 (Comments for task 4 should not exceed 50 words in total.)
1. Construct a network diagram by going through the forward and backward passes. You may draw
your network diagram in Excel or Word. The network diagram needs to be copied into your
Word file.
2. Identify the critical path and duration of the project.
3. Comment on the distinction between critical and non-critical activities.
Task 5 [10 marks]
This task requires reflection to provide insights into the process and quality of personal learning.
Your reflection should focus on your actions, motivations and emotions and should analyse what
changes will be made to practice in light of experiences, feedback and reflection. A good reflection
will help you understand what, why and how you learn.
NB: You should not comment on the theories of reflection. You should also not evaluate
teaching or the module for this exercise.
Required for Task 5 (Comments for task 5 should not exceed 150 words in total.)
1. What do you think you did particularly well in this assignment?
2. What was the most challenging aspect of this coursework and why was this the case?
3. What would you do differently next time?
4
Guidelines and Instructions – All Tasks (Further instructions will be provided on WebLearn)
1. This individual coursework consists of five tasks. You must attempt and complete all tasks. For
tasks 2 and 3, you need to download the “BA4008QA CWK1 Data Nov20” Excel file from
WebLearn. To complete tasks 1 and 4, refer to Tables 1 and 3 on pages 1 and 3 of this brief –
Excel data sets are not provided for tasks 1 and 4. Task 5 requires a short reflective
commentary.
Tasks need to be clearly labelled in your submission.
Start each task on a fresh page
Tables and graphs should be numbered and titled.
2. For task 1, you need to calculate the 3 missing values (mean, standard deviation and coefficient
of variation) using a calculator and provide an explanation on how you reach these
statistics. Also provide short comments on the findings.
For task 2, you need to complete two tables in Excel. The first should show the frequencies,
percentage frequencies, cumulative frequencies and percentage cumulative frequencies. The
second is used to find the mean, standard deviation and coefficient of variation. An appropriate
graph, with an informative title and axis labels, needs to be constructed. Short comments need
to be provided under points 2 and 3.
For task 3, you need to use an appropriate Excel function to create a correlation matrix to show
the relationship coefficients between all relevant variables. The best predictor of the Job
Separation Probability is identified and the reason for its selection is justified. A titled, welllabelled
scatter graph, with the trend, regression equation and coefficient of determination, is
presented. The relationship and the various coefficients should be explained in context.
Task 4 requires the construction of a network diagram to reveal the project’s critical path and
duration. The difference between critical and non‐critical activities is discussed.
Task 5 requires a short, reflective commentary.
Required Excel output, i.e. tables and graphs, need to be copied into your Word document and
presented alongside the comments.
3. Comment on the facts only: avoid speculations and generalisations. Comments must be
supported by the evidence.
4. For tasks 1 to 4, adopt a formal, professional language (third person, impersonal) and avoid the
use of ‘I’, ‘you’, ‘we’, ‘my’, etc.
5. The word limit for this coursework is 650 words in total. (± 10% above or below the word limit is allowed )
6. Interpretations should be written in your own words. Work copied directly from lecture notes, or
other sources, will have marks deducted and / or will be referred (also see point 7 below).
7. This is an individual assignment. Where Academic Misconduct, such as collusion, plagiarism or
cheating, is suspected, your coursework mark will be reduced proportionate to the extent of the
misconduct identified, however, more severe penalties are possible. Cases are referred to the
Casework Office and substantiated Academic Misconduct will be recorded on the student’s
record.
5
8. This is a Turnitin submission. The deadline for this coursework is Monday,
7th December 2020 before 3pm.
9. All output must be saved as a single Word document and uploaded to WebLearn on Turnitin.
Instructions on how to submit your work will be provided during lectures. The submitted
coursework should include a cover page (see Weblearn) with your student number. You are
advised to keep a copy of all work submitted.
Assessment Criteria
For all tasks, you are required to correctly calculate relevant statistics, analyse the data and provide
/demonstrate:
• Clear interpretations of all statistical analyses (do not just state the values but show your
workings and comment on what the values imply without speculating, where required);
• Graphs and tables with informative titles and appropriate labelling;
• Accurate calculations where required (equations are stated in the context of the data);
• Comments written in the context of the meaning of the data or analysis;
• Appropriate use of Excel functions, as evidenced by the output.
NB: This is a quantitative assessment and, as such, coursework marks can range from 0% to
100%. You can expect to get your provisional results
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
