General Merchandise Division Marks Assignment | Strategic Analysis of Marks &amp

General Merchandise Division Marks Assignment Summarize the data for total revenue of the group and revenue from general merchandise division of Marks & Spencer using representative values (averages) and measures of dispersion. Analyse the results to draw valid conclusions.

Calculation of representative values

YearTotal Revenue($)Merchandise Revenue($)
20057490.503641.60
20067797.703644.40
20078588.104002.80
20089022.004059.30
20099062.103918.30
20109536.604152.00
20119740.304233.60
20129934.304195.10
201310026.804090.30
201410309.704092.50
201510311.403988.40
Total101819.544018.3

Mean

General Merchandise Division Marks Assignment | Strategic Analysis of Marks &amp Mean is a tool to take strategic decision by analysing the results. It is defined as the average of numbers and variables which are included in the collection and set data (Francis, et. Al 2016). It can be defined as arithmetical mean, mathematical expectation and averages of different values. Following is the calculation of Mean of the company M&S of total revenue and general merchandise revenue.

Mean = Sum of values/ Number of values
Mean of total revenue = $101,819.5/11
= $9,256.32
Mean of merchandise revenue = $44,018.3/11
= 4,001.67
Conclusion- from the above calculation mean which is the average value of numbers which is provided in the set data and making impact on the business decision making. There can be identified that the mean of the total revenue of the company is more than the mean of the general merchandise revenue of the company which is explaining that the company’s average revenues are related. The average profit which is earned by the company in year 2015 is more than the average revue of last 11 years which shows that it is on growing stage. This is exact same in the case of general merchandise revenue of the company. This is defining that there is rise in total revenue and profit margin in general merchandise of the company.

Median

Median is defined as the separation of the data in the half of data samples, populations, and probability distribution and discriminate it from other simple data. In simple words it can be defined as the middle value of the overall data set and is an effective tool of statistical analyses. It also used for describing the data by comparing with the mean of the data set. By calculating median we can identify the breakdown point. Calculation of median of the total group revenue and general merchandise revenue of M&S is as follows (Francis, et. Al 2016).
The median is calculated by using n+1/2 th term. It is used when the number of values is odd number and   average of n/2th term and n/2 +1 term, when the number of values represent even number. So the median will be-

Median of Total Revenue = n+1/2 th term

= 6th term

= Revenue during the year 2010

= $ 9,536.60

Median of Merchandise revenue = n+1/2 th term

= 6th term

= Revenue during the year 2010

= $4,152

Conclusion- By the calculation of median we have identified the mid value and breakpoint of the values which are showing the total revenue and general merchandise value of the company (Markovi?, et. Al 2013). Median of total group revenue is calculated as $ 9,536.60 and median of general merchandise revenue is $4,152. This is more than the mean of the company which explaining that the median value is more than the average of the total and general merchandise value of the company.

Mode

Mode defines the value with the highest frequency in the data set. It defines the value which repeated various times in given data and numbers. There are various ways to calculate the mode of the data in which frequency method is more effective and it is taken as an effective strategic tool for data analysis (Markovi?, et. Al 2013). To calculate mode it is required to put the following formula.

General Merchandise Division Marks Assignment | Strategic Analysis of Marks &amp

Mode= Highest Frequency

For calculating the mode of the total and general merchandise revenue of M&S we will identify the most reputed number and data. The revenue data of the company defines that there is not reputed any number and data in the company’s revenue history of last 11 years which defines that there cannot be calculated mode (Majumdar, 2014).

Measures of Dispersion
Standard Deviation

In the strategic analysis standard deviation is taken as an effective tool which helps in calculating variation and dispersion of the given data set. There are defined various advantages and disadvantages of calculating standard deviation. This is also treated as risk or beta factor in any organisation which is calculated to effectively manage the risk factors in the company. the calculation of Standard deviation is as follows for the company’s total revenue and general merchandise revenue of the company (measures of dispersion 2016).
The standard deviation of the data of M&S for the last 11 years of total revenue and general merchandise revenue of the company is as follows:

Total RevenueRevenue Merchandise
Standard Deviation26736.6311553.37
Explain the use of quartiles in drawing conclusion on the total revenue and general merchandise revenue of M&S.

Quartiles
Quartiles are defined as the tool of descriptive statistics which divides the set data in four equal groups and each quartile includes equal number of set data which are called as quantile. First quartile is the breakeven point between the lowest value and median of the set data (Manikandan, 2011). Second quartile is median and the third is the middle value between median and highest data set value. Calculation of the quartiles of the total revenue and general merchandise revenue of M&S is as follows.

Total revenueGeneral merchandise revenue
Quartile 1 (25th)8913.5253970.875
Quartile 2 (50th)9638.454074.8
Quartile 3 (75th)10097.534162.775

The above calculation of the quartile of the company’s revenue defines that the overall performance and level of the revenue generation and their effectiveness in the company. this describes the relationship between the revenues of different periods.

Estimation of correlation coefficient between total revenue and general merchandise revenue of M&S and relationship between these two variables.

Correlation coefficient
Correlation coefficient is defined as the level of correlation between two factors or data set. This is the measure by which can analyse and evaluate the belongingness and dependency of two factors and data set on each other. In the calculation of correlation coefficient between total revenue and general merchandise revenue of the company we find that it is near 1 which is the standard correlation coefficient (Manikandan, 2011).

Online Assignment Help Australia provide best quality assignment writing service in affordable prices and we are providing most flexible assignment writing according to Students need, so book your Assignment with us,Order Now