Quantitative Business Analysis



Quantitative Business Analysis

Introduction

The data set for this report has been collected from a large company that sells LCD televisions, it has been mentioned that the company has many branches throughout the UK. These shops are divided into three different regions (i.e. North, South and East of the UK), altogether there are over 100 outlets. The LCD televisions that are sold by the company are available in three different screens:

Type A= 12inches

Type B= 15inches

Type C= 19inches

Discussion

The purpose of this report is to produce the summary of company's data set provided; the variables that have been used in this study are given below with their complete description. To analyze the data set different statistical techniques have been used, the purpose of using the narrative (descriptive) statistics is for processing of empirical data, their classification, graphic representation in the form of graphs and tables, as well as their quantification by means of key statistical indicators.

Variables

Column

Name

Description

C1

Outlet

Number of the outlet

C2

Region

Regional location of the outlet

1= North2=South3=East

C3

Gender

Gender of manager

1=Male 2=Female

C4

Experience

Experience of the Outlet manager

C5

Distance

Distance of the outlet from the High Street (miles)

C6

Advertising

Average Monthly Advertising Expenditure (£)

C7

Type A

Annual sales of 12” screens (£000s)

C8

Type B

Annual sales of 15” screens (£000s)

C9

Type C

Annual sales of 19” screens (£000s)

In contrast to inductive statistics, descriptive statistics do not make conclusions about the population based on the results of the study of particular cases. Inductive same statistics on the contrary suggests that the properties and laws identified in the study of objects of the sample, as are inherent in the general population.

Descriptive Statistics

N

Minimum

Maximum

Mean

Std. Deviation

Experience of the Outlet manager

105

-1

16

9.50

3.411

Distance of the outlet from the High Street (miles)

105

.75

4.00

2.2143

.90362

Average Monthly Advertising Expenditure (£)

105

-1

1623

1024.22

304.410

Annual sales of 12” screens (£000s)

105

96

250

176.09

40.457

Annual sales of 15” screens (£000s)

105

182

288

251.23

27.673

Annual sales of 19” screens (£000s)

105

236

384

328.90

39.270

Total Annual Sales

105

561

903

756.22

93.259

The results in the table below shows the descriptive statistics for the selected variables, it can be observed that on average the manager has an experience of around 10 years. The result in the table below shows that the company on average spends 1024.22 £ per month, it is quite interesting to see that on average the total annual sales for the company is around 756 £ (in 000's), which means that on average the company's total annual sale is around 63000 £ per month.

Regional location of the outlet

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

North

36

34.3

34.3

34.3

South

41

39.0

39.0

73.3

East

28

26.7

26.7

100.0

Total

105

100.0

100.0

In statistics, frequency distribution is called the grouping of data into mutually exclusive categories that indicate the number of observations in each class. This provides added value to the grouping of data. The frequency distribution shows the classified observations so you can see the existing number in each class. These groups of data are usually grouped in tables. The frequency table for the variable of Region shows that the maximum numbers of outlets (i.e. 41) of the company are located in the South region, whereas, 36 and 28 are located in the North and East respectively.

The contingency tables are used to record and analyze the relationship between two or more variables, usually by nature qualitative (nominal or ...