Assignment on Statistics for Financial Decisions

STATISTICS FOR FINANCIAL DECISIONS
assignment
The board of Schmeckt Gut Energy is interested in opening new branches in three countries
Nockaragua, Macronesia and Industria. The data used in the analysis was collected in year 2016.
The countries are divided into districts. Nockaragua has five districts A, B, C, D and E.
Macronesia has seven districts A, B, C, D, E, F and G. Industria has eight districts A, B, C, D, E,
F, G and H. The data was record as per different countries and districts.
Data Analysis
Descriptive statistics
26%
26%19%
16%
13%
Nockaragua Districts
A
B
C
D
E
Fig1. A pie chart of Nockaragua districts
The data was collected in 30 stores. The sample selected from Nockaragua country, the pie chart
above indicate that equivalent data from district A and B were recorded represented by 26%.
District C, D and E had 19%, 16% and 13% respectively. The prices of the energy products in
the five districts had a range from 2.0 to 4.5 with an average price of 2.97. The total sale of the
five districts of Nockaragua country is 95915 with a mean sale of 3197.1667.

A
3%
B
31%
C
3%
D
17%
E
11%
F
28%
G
8%
Macronesia Districts
Fig2. A pie chart of Macronesia district
Sample selected 30% was from district B, followed by F which had 28%. Most of the stores were
located in district B and F. Few stores were located in district A and C represented by 3%. The
prices in these districts ranged from 1.75 to 4 with average price of 2.68. The total sales of
Macronesia districts are 160068 with mean sale of 4573.37.
A
18%
B
20%
C
5%
D
13%
E
5%
F
13%
G
15%
H
13%
Industria Districts
Fig3. A pie chart of Industria districts
District B had 30% representation in the data recorded followed by A with 17%. This country
has the largest number of district. The mean price of the eight districts is 3.615. The range of

prices is 2.0 to 5.0. The total sale of these districts is 158,757 with average sale as 3968.925
(Charles G., 2016).
Inferential analysis
Comparison of districts within each county
Nockaragua
Ho: there is no significant difference in the prices in different districts
H1: the prices are different in different districts
SUMMARY
Groups Count Sum
Averag
e
Varianc
e
A 8 23.9 2.9875
0.40839
3
B 8 22.45 2.80625
0.51245
5
C 5 16 3.2 1.075
D 5 14.5 2.9 0.28875
E 4 12.25 3.0625
0.51562
5
ANOVA
Source of
Variation SS df MS F P-value F crit
Between
Groups
0.54018
7 4
0.13504
7
0.25105
7
0.90627
6
2.7587
1
Within
Groups
13.4478
1 25
0.53791
3

Total 13.988 29
The mean sales of the different towns differ in all the five towns A, B, C, D and E. The analysis
of variance has the p-value as 0.906276 greater than 0.05 we reject Ho we conclude there is
significant difference in the prices in the different districts in Nockaragua.
Macronesia district
SUMMARY
Groups Count Sum
Averag
e
Varianc
e
A 1 1.5 1.5
#DIV/
0!
B 11 29.8
2.70909
1
0.60040
9
C 1 3.25 3.25
#DIV/
0!
D 6 16.5 2.75 0.547
E 4 9.5 2.375
0.22916
7
F 10 27.75 2.775
0.31180
6
G 2 5.5 2.75 0.125
ANOVA
Source of
Variation SS df MS F P-value F crit
Between
Groups
2.22815
9 6 0.37136
0.84141
5
0.54880
1
2.44525
9
Within 12.3578 28 0.44135