Descriptive Statistics and Financial Analysis for a Retailer

MN4063QA

Table of 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
Part (b) Give the reason of difference in mean and standard deviation of grouped and ungrouped data
and which one is more accurate? .......................................................................................................6
Part(c) Comment on the minimum amount of the consumer needs estimated to spend......................6
Task 3.............................................................................................................................................................6
Task 4.............................................................................................................................................................7
(a) Frame a network diagram which shows the movement of forwards and backward passes of the
activities...............................................................................................................................................7
........................................................................................................................................................................8
(b) Classify the critical path and duration of the project.....................................................................9
(c) Differentiate between critical and non – critical activities.............................................................9
Task 5.................................................................................................................................................10
Part (a) Develop a correlation matrix and work out the coefficients between quarterly revenues and
different variables..............................................................................................................................10
Part (b) The best predictor for quarterly sales revenue could be the correlation of sales and revenue
total costs...........................................................................................................................................10
Part (c) Draw a scatter graph and show a trend line of the regression equation. ..............................10
(d) Interpret the coefficient of correlation and determination...........................................................11
(e) State the equation of regression and interpret the value of intercepts..........................................11
Task 6.................................................................................................................................................11
Part (1)Calculate the coefficients of variation for business A and B.................................................11
Task 7...........................................................................................................................................................12
Give a reflective learning through the project...................................................................................12
By participating in above project helps me to develop several skills. It gives me the overall scenario and
gives me the instance of finance that will be beneficial for my professional career. I was so excited at the
time of doing this project because I know it will enhance my knowledge and productivity. My confidence
has increased after the completion of above presentation. The most challenging aspects that faced during

the assignment is due miscalculations of numbers. Due to such issues I faced issues in matching the
numbers. Next time my focus will be on learning of formulas that will ease the difficult numericals for
my future project..........................................................................................................................................12
PART-2........................................................................................................................................................12
6. Interpret the above calculations.....................................................................................................12
REFERENCES.............................................................................................................................................14
Books and Journals............................................................................................................................14

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.0
0
Kurtosis -0.49
Skewness -0.32
Range 301.00
Minimum 68.00
Maximum 369.00
Sum 29120
Count 130.00
Coefficient of
Variation 33.50%
Sample variance Standard deviation * Standard deviation
Sum Mean * Total no of prices included
(b) Infer the mean and standard deviation from the data given.
The above scenario shows that a customer is willing to pay a price of Rs. 224 for
purchasing kitchen appliances on an average. The low standard deviation of 75 indicates that the
values are close enough to the mean of the above set.