Insights into UK Netflix viewers' age and statistics analysis

Individual coursework

Contents
TASK 1: To gain some insights into the typical age of UK Netflix viewers, a sample of 115 subscribers was surveyed in March
2021.Some descriptive statistics, computed to summarize the data, are presented in Table A below. NB : Some values are
missing........................................................................................................................................................................................... 3
With reference toTable1above and using a calculator and showing all your working out:........................................................3
Compare the mean and the median values and comment on the distribution of the data............................................................3
TASK 2:........................................................................................................................................................................................... 4
1. Using the frequency table above as a starting point and the tabular method for summarizing grouped data, construct two
tables in Excel............................................................................................................................................................................ 4
2. By comparing the mean and standard deviation values from task 1 and task 2 comment on which findings are more
accurate-the ungrouped or grouped statistics? Justify your answer............................................................................................5
Using linear interpolation and showing your workings clearly, calculate an estimate for the median age of viewers. Give your
answer correct to the nearest whole number..............................................................................................................................5
Lm=35 CFm-1=36 CFm=66......................................................................................................................................................6
Using Excel, construct a cumulative frequency curve, labeling your graph correctly. You need to copy the correctly labeled
graph into your Word document................................................................................................................................................6
TASK 3:........................................................................................................................................................................................... 6
Showing your method clearly, state which variable is the ‘best’ predictor. Justify the reason for your choice..........................6
Interpret the relevant correlation coefficient and the coefficient of determination in context....................................................7
State the regression equation in context and interpret the intercept and gradient.......................................................................8
TASK 4: A maintenance project consists of following activities, as outlined in the table below. Table 3 –Precedence Table........8
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..........................................................................8
Identify the critical path and duration of the project..................................................................................................................8
Comment on the distinction between critical and non-critical activities....................................................................................8
TASK 5: 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 analyze 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 note evaluate teaching or the module for this exercise..........9
What do you think you did particularly well in this assignment?...............................................................................................9
What was the most challenging aspect of this course work and why was this the case?............................................................9
What would you do differently next time?.................................................................................................................................9

TASK 1: To gain some insights into the typical age of UK Netflix viewers, a sample of
115 subscribers was surveyed in March 2021.Some descriptive statistics, computed to
summarize the data, are presented in Table A below. NB : Some values are missing
With reference toTable1above and using a calculator and showing all your working out:
a) Calculate the mean and interpret what the mean suggests in the context of the scenario.
Mean = Sum/Count
Mean = 4702/115 = 40.88 = 40.8
b) Calculate the Minimum and interpret what the minimum value suggests in the context
of the scenario
Minimum = Maximum – Range Minimum = 80-65=15
c) Calculate the standard deviation and interpret what the standard deviation value
suggests in the context of the scenario
The standard deviation = √Sample Variance The Standard Deviation = √163.4
The Standard Deviation = 12.78 = 12.8
d) Calculate the coefficient of variation and interpret what the value suggests in the
context of the scenario provided.
Coefficient of Variation = Standard Deviation/Mean * 100 Coefficient of Variation = 12.8
/ 40.8 * 100 = 31.37 = 32.4%
The average age on Netflix viewers is 41 years old, and the minimum is 15 years old. The
spread between the mean and rest of the data is 12.8. The standard deviation measures how
concentrated the data are around the mean. There is a small gap and more stability between
the age of the viewers. The reliability of the viewers is 32.4% which means a very low
accuracy of the data.
Compare the mean and the median values and comment on the distribution of the data.
If Mean = 40.8 and Median 43.0; Mean ˂ Median. Which means that distribution is
negatively skewed. A negative skewness means a distribution of the data is heavy towards
the higher values. Mean is smaller than Median.