MN4063QA July21 Coursework 1 - Desklib

MN4063QA July21
Coursework 1

Contents
PART 1...................................................................................................................................................4
TASK 1....................................................................................................................................................4
(a) Calculate the sum and variance....................................................................................................4
(b) Infer the mean and standard deviation from the data given.......................................................4
TASK 2....................................................................................................................................................4
(a) Complete the following tables by extracting the values...............................................................4
(b) Give the reason of difference in mean and standard deviation of grouped and ungrouped data
and which one is more accurate?......................................................................................................5
(c) Comment on the minimum amount of the consumer needs estimated to spend........................5
TASK 3....................................................................................................................................................6
Give the difference between the cross – sectional data and time series data with reference to the
examples considering the demographic profile and lifestyle nature of the consumers....................6
TASK 4....................................................................................................................................................7
(a) Frame a network diagram which shows the movement of forwards and backward passes of the
activities.............................................................................................................................................7
(b) Classify the critical path and duration of the project...................................................................8
(c) Differentiate between critical and non – critical activities............................................................8
TASK 5....................................................................................................................................................9
(a) Develop a correlation matrix and work out the coefficients between quarterly revenues and
different variables..............................................................................................................................9
(b) Identify the best predictor of the quarterly sales, explain the reason.........................................9
(c) Draw a scatter graph and show a trend line of the regression equation......................................9
(d) Interpret the coefficient of correlation and determination........................................................10
(e) State the equation of regression and interpret the value of intercepts.....................................10
TASK 6..................................................................................................................................................10
1. Calculate the coefficients of variation for business A and B........................................................10
2. By taking an assumption, that the risk of retailer is adverse, choose a project...........................10
TASK 7..................................................................................................................................................10
Give a reflective learning through the project.................................................................................10
PART 2.................................................................................................................................................11
1. Estimate the variable cost through high – low method...............................................................11
2. Calculate the monthly fixed cost.................................................................................................11
3. Calculate break even of January 2021.........................................................................................11
4. How many t-shirts should be sold to achieve the target profit in January 2021..........................11
5. Calculate margin of safety...........................................................................................................11

6. Interpret the above calculations..................................................................................................11
REFERENCES........................................................................................................................................13

PART 1
TASK 1
(a) Calculate the sum and variance.
Expenditure (£) on Stand Mixers
Mean 224.00
Standard Error 6.58
Median 224.00
Mode 224.00
Standard Deviation 75.00
Sample Variance 5625.00
Kurtosis -0.49
Skewness -0.32
Range 301.00
Minimum 68.00
Maximum 369.00
Sum 29120.00
Count 130.00
Coefficient of Variation 33.5%
(b) Infer the mean and standard deviation from the data given.
It can be inferred from the data that the mean and standard deviation is 224 and 75.
This shows the differentiation in both the values. Mean is the average of the frequencies
whilst standard deviation is means how much the data is varied or different from the mean.
TASK 2
(a) Complete the following tables by extracting the values.
Table 1
Expenditure (£) Frequency Frequency (%)
Under 100 14 11%
100 and under 200 35 27%
200 and under 300 65 50%
300 and over 16 12%
Total 130 100%
Table 2