Using and Managing Data - Desklib

This article covers various aspects of using and managing data, including calculation of sum and variance, building correlation matrix, and project planning. It also discusses the difference between cross sectional and time series data, critical and non-critical activities, and reflective learning. The article is relevant for students studying courses related to data analysis, project management, and business analytics.

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 being followed it
is observed to be fluctuating at a higher scale in respect of mean (Agah and et.al., 2021). The
standard deviation comes from the calculation. In the given question mean is 224
TASK 2
a) Prepare table in excel and adjoin it in the report by considering the value given.
Table 1
Expenditure (£) Frequency Frequency
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%

(%)
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
Expenditure (£) Frequency
Cumulative
Frequency
Cumulative Frequency
(%)
Under 100 14 14 11%
Under 200 35 49 38%
Under 300 65 114 88%
Under 400 16 130 100%
Total: 130

WW
The number of observation is average the total frequency. Standard deviation and variance is the
difference from the observation of the mean value.
The range is between 100-85, in order to be under 25% the customer needed are 14.
b) Give reasons behind standard deviation and mean of ungrouped and grouped data. Which one
is more accurate?
Standard deviation calculated for grouped data is 20 and mean resulted as 214. Even though
mean of standard deviation in case of ungrouped data is recorded as 75 and for grouped data it
resulted as 224. It can thus be said that the deviation in reference to ungrouped data is very big
due to inaccurate information and data. The fluctuation is because of the raw information
collected and functions being used during the process. The data that is available in the group data
can be said to be accurate because role performed is with pre adjusted accumulation (Burnaev
and et.al., 2021).
c) Provide a statement on the minimum amount which the consumer spends on the top 25% of its
expenses.
The bare quantity that the consumer required to spend on top is 25% that is
approximately 250.

TASK 3
Describe the variation between the cross sectional and time series data with reference to the
demographic profile and lifestyle nature of the consumers.
Time Series Data Cross Sectional Data
It focus on elements over a particular period of
time.
For instance, total revenue generated within a
organisation for a period of 3 years.
It concentrates on observing many components
at same period of time. For example, Revenue
rendered by the companies by sale of several
goods and commodities in a year.
The retailers include cross sectional data tool as it enables collection of information of
different variables for example lifestyle preferences and demographic profiles. Hence, this
method proves to be useful towards retailers for understanding and tapping targeted audiences
(Chang, Hsiao and Boudier-Revéret, 2020).
TASK 4
a) Build a network diagram that reflects movement of forward and backward data.

b) Determine critical path and time period of the planned project.
Critical path is computed as A-C-E-I-J is of 23 weeks. The project's time duration is 10.
c) Distinguish between critical and non critical activities.
Critical activities are those in which end time period is defined. Some of the actions that
gets delayed increases the project's time period as well. On other part non critical activities does
not involve any limitation within time and can be accomplished freely (Khattar and et.al.,2020).
TASK 5
a) Build a correlation matrix and calculate the coefficient among quaterly sales, gross profit, total
cost and average order value.
Coefficient of correlation Coefficient of determination
Quarterly Sales Revenue and
Average order value
0.974847027 0.950326726
Quarterly Sales Revenue and
gross profit
0.423092657 0.179007396
Quarterly Sales Revenue and
total costs
0.54003673 0.29163967
b) Determine the best predictor of quarterly sales and also give reason behind it.
The best predictor must rely between its quarterly sales and average order value resulting
0.97. It has resulted as Highly co- related in case of highest correlation coefficient.
c) Showcase a trend of regression equation and draw a scatter diagram.

d) Examine the coefficient of determination and correlation.
Determination reflects approximately 95% of the regression model and is appropriate in
data. Coefficient of correlation predicts linkage between the variables which are connected with
each other (Rashidi and Cullinane,2019).
e) Depict the value and state the mathematical evidence of regression.
Regression equation is
Y = 0.0312X + 10.267
Coefficient
s
Standar
d Error t Stat
P-
value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Interce 9.8227312 2.07508 4.73365 8.17E 5.5399653 14.105 5.53996 14.105

pt 29 5 1 -05 28 5 5 5
Sales
Reven
ue
0.0314612
2
0.00149
7 21.019
5.78E
-17
0.0283719
78
0.0345
5
0.02837
2
0.0345
5
TASK 6
1. Calculate the coefficient of variations for Firm A and B.
Enterprise A:
Coefficient of variation = (Standard Deviation / Net EV) * 100 %
= (30.08 / 700) * 100 = 67
Enterprise B:
Coefficient of variation = (Standard Deviation / Net EV) * 100 %
= (13.32 / 400) * 100 = 33
2. Which project must be chosen from the above laid projects. Also consider the risk of retailers
as negative.
The retailer must select Plan B for investment related activities the reason behind is low
coefficient variation that represents lower level of dispersion from mean.
TASK 7
Describe the reflective learning with the help of project plans.
By completion of above plan, it would further help to develop several skills. It explains
the authority given in financial areas and overall scenarios as well. Such projects are useful and
assist in improvement of knowledge and productivity. It though led to issues and problems in
matching the numbers, thus it is necessary to focus on learning methods that would lead to easy
computations.

PART 2
1. Figure out the cost related to variables with the help of high low method.
Variable cost per unit = (Highest activity cost – Lowest activity cost) / (Highest activity
units – Lowest activity units)
= (4,00,000 – 1,95,000) / (34000 – 14000)
= 205000 / 20000
= 10.25
To calculate the fixed cost, the following method are to be used:
The cost of 10.25 euro variable cost will incur in 14502 units.
Since, Total cost = variable cost + fixed cost
Fc = 195000-148645.5
=50000
b Breakeven point means where the company incurs no loss or no profit, to finding the value of
t-shirts the following units are must to sold by Andeera Ltd.
Breakeven point = 50000 / ( 15 -10)
=10000 units
d) Number of T – Shirt which must be sold in order of achieving set targets.
Present sales level for establishment of targets = (Estimated profit + Fixed costs) / Selling
price per unit – Variable cost per unit)
= (110000) / (12 - 7) = 110000 / 5 = 22000 Units.
e) Calculate margin of safety.
Margin of safety = (Current sales level – Breakeven point)
= 22000-10000
=12000 units

6. Examine the above carried out calculation.
a) Negative of break even point evaluation:
 The relation among variable cost and sales is not ascertained.
 Data authenticity is secure by the accurate calculations done.
b) For completing a targeted profit scale of £200000 the company is required to process
a sale of at-least 88345 units in a year.
c) The number of production must be raised in reference for achieving the break even
point for at least 19380. It is the same amount that is being sold by the firm on an average.
d) The margin of safety is recorded as 78.06 % on the sale of units for achieving the
expected profit.

REFERENCES
Books and Journals
Agah, J.J., and et.al., 2021. Managing examination induced stress among students using FEAR-
model of cognitive behavioural intervention: Policy implications for educational
evaluators. Current Psychology. pp.1-13.
Burnaev, Z., and et.al., 2021. Features of Managing the Process of Physical Training of Military
Personnel and Cadets of Higher Military Educational Institutions of The Armed Forces
of The Republic of Kazakhstan Using Computer Technology. Review of International
Geographical Education Online, 11(7).
Chang, M.C., Hsiao, M.Y. and Boudier-Revéret, M., 2020. Blockchain technology: efficiently
managing medical information in the pain management field. Pain Medicine. 21(7).
pp.1512-1513.
Khattar, R., and et.al.,2020, December. A Web-based Framework for Managing and Sharing
Earth-observation Applications for Water Resources. In AGU Fall Meeting
Abstracts (Vol. 2020, pp. H038-0005).
Rashidi, K. and Cullinane, K., 2019. Evaluating the sustainability of national logistics
performance using Data Envelopment Analysis. Transport Policy. 74. pp.35-46.