Using and Managing Data - Desklib

USING AND
MANAGING DATA

Table of Contents
PART 1............................................................................................................................................4
TASK 1............................................................................................................................................4
a) Calculate the sum and variance with the help of excel...........................................................4
b) Examine and interpret mean and standard deviation..............................................................4
TASK 2............................................................................................................................................4
a) Prepare table in excel and adjoin it in the report by considering the value given...................4
b) Give reasons behind standard deviation and mean of ungrouped and grouped data. Which
one is more accurate?..................................................................................................................5
c) Provide a statement on the minimum amount which the consumer spends on the top 25% of
its expenses..................................................................................................................................5
TASK 3............................................................................................................................................6
Describe the variation between the cross sectional and time series data with reference to the
demographic profile and lifestyle nature of the consumers........................................................6
TASK 4............................................................................................................................................7
a) Build a network diagram that reflects movement of forward and backward data..................7
b) Determine critical path and time period of the planned project.............................................9
c) Distinguish between critical and non critical activities..........................................................9
TASK 5............................................................................................................................................9
a) Build a correlation matrix and calculate the coefficient among quaterly sales, gross profit,
total cost and average order value...............................................................................................9
b) Determine the best predictor of quarterly sales and also give reason behind it......................9
c) Showcase a trend of regression equation and draw a scatter diagram....................................9
d) Examine the coefficient of determination and correlation....................................................10
e) Depict the value and state the mathematical evidence of regression....................................10
TASK 6..........................................................................................................................................11
1. Calculate the coefficient of variations for Firm A and B......................................................11
2. Which project must be chosen from the above laid projects. Also consider the risk of
retailers as negative...................................................................................................................11
TASK 7..........................................................................................................................................11

Describe the reflective learning with the help of project plans.................................................11
PART 2..........................................................................................................................................11
1. Figure out the cost related to variables with the help of high low method...........................11
b) Calculate monthly fixed expenditure....................................................................................12
c) Calculate break even for the month of January.....................................................................12
d) Number of T – Shirt which must be sold in order of achieving set targets..........................12
e) Calculate margin of safety....................................................................................................12
6. Examine the above carried out calculation...........................................................................12
REFERENCES..............................................................................................................................13

PART 1
TASK 1
a) Calculate the sum and variance with the help of excel.
It is considered as normal ones, if mean, mode and median are same. It refers there is an equality
both side. It is included as normal truly distribution. In the observation table, the data appears at
equal frequency. There is deviation between the values and mean by 75 if the standard deviation
implies.
b) Examine and interpret mean and standard deviation.and standard deviation
The data collected above explains that the standard deviation is 75 and central average of
the data is 224. Standard deviation defines the variation of the measure from the mean. In case
Expenditure (£) on
Stand Mixers
Average 224.00
Error of standard 6.58
Standmixer median 224.00
Highest frequency 224.00
Deviation standard 75.00
Variance of simple 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%