Analyzing Information and Data for Problem Solving

This report analyzes various issues related to Eco-Fone smartphones, including the mobile phone market in the UK, forecasting adult smartphone use, potential market for older customers, feasibility of expanding business to Kingston, cost of a new building, testing the difference in net takings, customer satisfaction, and quality procedures.

Analyzing Information and Data for Problem
Solving

Table of Contents
INTRODUCTION.......................................................................................................................................3
1. Analysis of Issues for Eco-Fone Smartphones.....................................................................................4
1.1 An Overview of the Mobile phone market in the UK...................................................................4
1.2 Forecasting the UK Adult Smartphone use...................................................................................5
1.3 Smartphones – A potential market for older customers................................................................6
1.4 Feasibility of Expanding business to Kingston using Pros and Cons table..................................7
1.5 Cost of a New Building.....................................................................................................................8
1.5 Testing the possible difference in Net Takings in the two shops..................................................9
1.6 Customer satisfaction..................................................................................................................10
1.7 Quality Procedures......................................................................................................................11
Conclusion.................................................................................................................................................12
REFERENCES..........................................................................................................................................13
Appendices................................................................................................................................................14

INTRODUCTION
This report incorporates industry monitoring tools through the EcoFone appraisal group; This
group participates in the sale of mobile phones through two stores operated by Putney and
Richmond. According to a contextual study group founded in 2014 and needs to expand their
business across Kingston. An industry report will cover additional and downstream audit
strategies and will include review information via line sheet support. An estimate was made to
determine the level of increase recorded in the 2018-19 financial year. A monthly contract
amount was determined with the help of key page formulas. To disseminate the quality
assessment; A poison proprietary strategy has been put in place to detect errors in the disposal
supply. The report also includes an investigation report on how an old user used the phones and
installs 103 wannabes in terms of support and various elements of EcoFone will help support
procedures to those parties that have prevented the group from disrespecting the group.

1. Analysis of Issues for Eco-Fone Smartphones
1.1 An Overview of the Mobile phone market in the UK
A UK population review report shows that the country's total population, at 33.5 million, has
been categorized into a number of rallies; 32 million are employed, 1 million are teenagers
attending schools and universities and 0.5 million are women out of work. Studies have found
that at least half of the working population has to use cell phones at least to allow a business
application to work productively and schedule reporting. Some significant claims were based on
information gathered from the staff group As a result; 44% of customers tend to send emails,
34% tend to make voice calls, and only 23% use the phone to track important times on a
schedule. In any case, some of the key points require specific information records or less
possible use by employees, for example, by shaping the asset data and moving the important data
to the a guide through detailed framework applications (Karlis, 2003). There are still some other
resources in the mobile phone that have no need in the workplace or in the workplace, but this
can make people's lives as simple as text messaging, portable programs, multitasking and
photography channels to create their own funny and wonderful photos. Most people as identified
in the inspection report; check whatsapp at least once a day. Similarly, the additional set of
information shows that PCs and PCs cannot be broadcast at any time by merchants, direct
advertisers, resellers and any fieldwork expert; however, they had to share their reports on the
web and in the updated field with google map tools. From now on, cell phones will meet their
specific needs by sending letters, sending reports, checking for any exposures and tracking the
remaining product in the cell phones distribution centers; and create a system to improve
coordination.
In Figure 1; a visual diagram showing that all parts of use referred to in the graph have been
reduced compared to 2016; in particular, the visibility of records has practically decreased while
standard decisions on mobile phones have just dropped by 1% (Adelson, 1966). In any case, all
the exercises not mentioned in a high practice list are an increase from 44 and a half percent; this
shows that the use and taste of the public have changed and EcoFone has to think about it.

Figure 1: Usage of smartphones in 2016-17
Email
Making Standard Calls
Viewing Documents
Managing my
time/workload
None of these
0% 10% 20% 30% 40% 50% 60% 70% 80% 90%
37%
32%
0%
60%
50%
41%
33%
17%
80%
44%
2016
2017
1.2 Forecasting the UK Adult Smartphone use
In 2017; 85% of mobile phone buyers have a seat with UK adult buyers; indicative results show
that this usage will expand 4% to 2019. Market entry showed a growth rate of 9% to 2019;
although cell phone rationing speeds towards the start of its long-range models started to reach
52% earlier. The adolescent will show a 90% acceptance rate between the ages of 18 and 45
(Grainger and Garcia, 1996).
Figure 2: UK adult smartphone use in the period 2012-2017
2012 2013 2014 2015 2016 2017
0%
20%
40%
60%
80%
100%
Figure 2
Laptop Smartphone Tablet
YEAR
U
S
A
G
E

The future expected usage of smartphone by Adult population is mentioned below with the help
of line graph:
Figure 3: Expected usage of smartphones in 2018 and 2019:
2012 2013 2014 2015 2016 2017 2018 2019
0%
20%
40%
60%
80%
100%
120%
Laptop
Smartphone
Tablet
The evaluation of the future use of smartphones by adults is carried out using the method of
normal movement based on the fact that the previous mobile phone models show a consistent
improvement; consequently the movement of a conventional strategy is more suited to the
situation. Then again; education is only part of a repeating pattern and needs at least two
features; free and low-cost factors to show the effect. Be that as it may, here; only one
receptionist factor will be brought; therefore a direct test method cannot be applied here (Lintner,
1948).
1.3 Smartphones – A potential market for older customers
 A review report relying on a population of more experienced people shows the result as
follows: 71% of seniors who have grown between 55 and 75 prefer cell phones and show a
high level of of adoption compared to other groups. An analysis of the model of recent
years shows that there has been a dramatic increase in the reception rate of this sector
during these years as a result of the blessing received by their people and the level of usage
extending their daily lives (smartphones handle over 55, 2017). The adult population still
has a higher usage rate than older customers; with only 20% checking their phone within
15 minutes of waking up; half added to Facebook, but 70% of adults are used to using
Facebook and show a higher level of usage than older people. Some of the most interesting

or valuable events that have increased the speed of cell phone adoption among older
customers are outlined below (Acharya Richardson, Van Nieuwerburgh & White, 2011):
 Using the smartphone app for the allotment to stop the online meters.
 Taxi maintenance in urban areas with the help of the Oil application.
 The larger screen of the new phones makes it easier for older people to read text.
 The office speaker provided through standard phones makes it easy to handle well.
 Device programming provided in new cell phones optimizes uptime and simplifies
deployment.
 Face recognition verification programming helps to avoid the situation of wearing
glasses to dial physically and pressing the key to unlock the phone.
 Photo channels are urging older people to adopt this latest innovation to post their
photos via web-based media such as instagram and facebook (Kelly, 2011)
1.4 Feasibility of Expanding business to Kingston using Pros and Cons table
Should we expand our business to Kingston?
Pros Score/10 Cons Score/10
More diverse
customers
7 Shortage of cash 9
Raise in Income 8 Compromised
quality 7
More opportunities
for business 6 Loss of control 5
Boost in brand
awareness 6 More working
capital
requirement
5
Less Competition 5 Risk of failure 7
More market
penetration 7 Increase work
load 6
Visibility in the
market 7
Failure in
meeting
unexpected
demand
5
Total Pros 46 Total Cons 44
Average Pros 6.57 Average Cons 6.28

The above calculation shows that a normal set of Pros encourages a normal Cons; which makes
growing a company in Kingston a great place to start. It is then possible to grow the business in
Kingston to reap numerous benefits such as new freedoms, additional income and conflict
reduction. As a slump in the past suggests that the UK mobile phone market is developing
rapidly, so can free up building openings and less risk for new business sectors opened in
Kingston. Then again; Avoiding opposition can be costly to the organization, so he suggested
that the Ecophone should devise procedures to limit risks such as extended burden, loss of
control, quality of trade and reduced deficit. Unless bound by EcoFone, Kingston can counter the
inability of methods to achieve expansion (Immergluck, 2011).
1.5 Cost of a New Building
The expansion of the new business to Kingston EcoFone requires the facility to open its new
office. On examination, it emerged that the administration was considering two alternatives;
whether a monthly or monthly home loan or a business rental in Kingston provides another
facility (Ford, Burrows & Nettleton, 2001). In any case, no difference was found in the level of
the rent and the contract and the organization chose to acquire the facility by making an
occasional recorded payment of £ 3145.90 per month, which has to be paid for a long time at
7%. each year. The group operates the facility on rent financing, with additional benefits for life.
The company can adjust this high amount in its salary definition to obtain tax deductions that
were inconvenient when purchased with real money (Ford, Burrows & Nettleton, 2001).

Popular mortgage brands of UK
(Small business prices, 2020)
1.5 Testing the possible difference in Net Takings in the two shops
To differentiate a two-store reputation test by Eco-Fone to determine if there was isolation or
comparison in the network encountered by the two stores. For this test; 40 networks per day were
inspected by both stores; and the significance of the main shop was shown to be the general
deviation of £ 100 and £ 20; although the combined valuation for a two-store shop is £ 90 and a
standard deviation of £ 40. Analyzing the information from both shops, it was found that the
following branch has a greater combination of website building when comparing main store .
The method used to find the connection between the two is the "mixing coefficient" because no
other data is provided other than the mean, general deviation and test size (significantly
correlated, 2013). The abundance of this fruit has been shown to make adjustments with a
significance level of 5%. The test results show that the p compliance is 0.099017 and the
information range was determined based on the 95% validation level, with the lowest
information limit - 0.20552 and the highest information limit 0.264094. Like these lines, the p
respect is determined between the upper and lower limits; after which it can be said that the

proximity of the total compensation is in each store. The size of the example here is 40, but it is
not populated; the estimate of n is taken from 1 (Appendix).
1.6 Customer satisfaction
Consumer loyalty is a consumer bias after using products; there is no uniform estimate to
determine what customer satisfaction has been received. Be that as it may, the assessment
framework was found to be powerful in eliciting consumer perceptions of cell phone use; these
feedback will later help the Ecophone make changes to raise customer loyalty levels. EcoFone
always provides customer advice, advice and administration; it basically focuses on customer
bias and consistently manages oversight through customer reviews, criticism structure and
manual queue through web-based media and email information.
An overview conducted by the group through surveys shows the views of 103 respondents. The
results include the midpoints of each review study reviewed below:
An average of 103 replies indicates that customers will visit the Ecophone store somewhere
within 3.5 years. This means that the level of performance and commitment at the messenger
level is normal. The results show that normal individuals use cell phones for 3 years. Individuals
believe that it is appropriate and appropriate to help; Which makes them very unhappy; Vendor
management was also found to be appropriate, and respondents also found that item costs are
normal. Typical respondents generally found compliance with the article impartial. Similarly,
clients do not know whether to continue working with Eicofron because they are impartial. In
any case, the actual number of respondents was chosen for the ability to order articles and
manage cell phones for others.

1.7 Quality Procedures
The Standard Accounting Office received two return searches out of 10,000 applications; the
quality agency has set a target of no more than 15% in one month. Here the Poisson proprietary
method is implemented as the size of the information is 10,000 with an overall 1% error rate;
The Poisson distribution strategy is the best cost-effective case for testing such large examples
(Poison Distribution, 2020).
In this way, for the reasons mentioned above, the Poisson relevance strategy found the best way
to set the above case. The following are likely to be several errors to look for:
P(x ≤ 2, 2) = P(0;2) + P(1;2) + P(2;2)
= [(e-2)(20)/0!] + [(e-2)(21)/1!] + [(e-2)(22)/2!]
= 68%
There's 68% chance of error less than 2 in one month
Hence, probability of error more than 3 in one month will be:
= 100 -68 = 32%
The minimum percentage to meet quality was set not more
than 15% but actual data shows that probability of error
occurring more than 3 in one month is 32%; therefore it can
be declared that quality has not met
Subsequently, based on the above result, it was possible to determine that 15% of quality
methods and 32% of real varieties were not achieved. EcoFone needs multiple steps to improve
its quality and reduce the chance by 30% under 15%.

Conclusion
Therefore, after examining the whole report, it can be well reasoned that the connection between
the two sources during different tests, the verification of customer loyalty levels and quality
assurance tests; It was found that there is a positive relationship between the net profit of the two
EcoFone stores in that their net income is somewhat similar. The level of customer loyalty of
each of the 103 respondents reflects a neutral response; which is a major problem for the
organization and the industry should take action to increase the level of customer loyalty.

REFERENCES
Books and Journals
Acharya, V.V., Richardson, M., Van Nieuwerburgh, S. and White, L.J., 2011. Guaranteed to
fail: Fannie Mae, Freddie Mac, and the debacle of mortgage finance. Princeton
University Press.
Adelson, R.M., 1966. Compound poisson distributions. Journal of the Operational Research
Society, 17(1), pp.73-75.
Ford, J., Burrows, R. and Nettleton, S., 2001. Home ownership in a risk society: a social analysis
of mortgage arrears and possessions. Policy Press.
Grainger, R.J.R. and Garcia, S.M., 1996. Chronicles of marine fishery landings (1950-1994):
trend analysis and fisheries potential (p. 51). Rome: FAO.
Immergluck, D., 2011. Foreclosed: High-risk lending, deregulation, and the undermining of
America's mortgage market. Cornell University Press.
Karlis, D., 2003. An EM algorithm for multivariate Poisson distribution and related
models. Journal of Applied Statistics, 30(1), pp.63-77.
Kelly, R., 2011. The good, the bad and the impaired: A credit risk model of the Irish mortgage
market. Central Bank and Financial Services Authority of Ireland.
Lintner, J., 1948. Mutual savings banks in the savings and mortgage markets. Division of
Research, Graduate School of Business Administration, Harvard University.
Online:
Correlation in excel, 2013, Online Available through: <https://www.youtube.com/watch?
v=AjQA78tI39Q>
Small business prices, 2020, Online Available through:
<https://smallbusinessprices.co.uk/commercial-mortgages/>
Smartphone sales boom with over-55s, 2017, Online Available through:
<https://www.bbc.com/news/technology-41319684>
Poison Distribution, 2020, Online Available through: <https://stattrek.com/probability-
distributions/poisson.aspx>

Appendices
Figure 1
Activities 2016 2017
Email 41% 37%
Making Standard Calls 33% 32%
Viewing Documents 17% 0%
Managing my time/workload 80% 60%
None of these 44% 50%
Figure 2
Products 2012 2013 2014 2015 2016 2017
Laptop 73% 76% 75% 79% 76% 78%
Smartphone 52% 62% 70% 76% 81% 85%
Tablet 16% 36% 50% 60% 63% 68%
Figure 3: Forecasted usage for 2018-2019
Products
201
2 2013
201
4 2015 2016 2017 2018 2019
Laptop 73% 76% 75% 79% 76% 78% 79.5%
80.5
%
Smartphon
e 52% 62% 70% 76% 81% 85% 91%
97.3
%
Tablet 16% 36% 50% 60% 63% 68% 74.8%
82.3
%
Forecasted usage of Laptop
Yea
r (X) Usage % (Y)
Y1 = (Ȳ̅ -
Y)
X1 = ( -X̄̅
X) Y1X1 (X1)2
1 73% -3% -2.5 8% 6.25
2 76% 0% -1.5 0% 2.25
3 75% -1% -0.5 1% 0.25

4 79% 3% 0.5 2% 0.25
5 76% 0% 1.5 0% 2.25
6 78% 2% 2.5 5% 6.25
21 457% 15% 17.50
Mean of X
( )X̄̅ 3.5
Mean of Y
(Ȳ̅) 76%
b1 = Y1X1/(X1)2 = 15%/17.5 = 1
= 76% - 1(3.5) = 72.5%X̄̅
Fitted Equation: Y = 72.5% + 1(X)
Note: For Smartphone and Tablet moving average @ 7%
growth rate for Smartphone and @10% for Tablet
Mortgage
calculation
Loan amount £350,000
Term in years 15
Interest rate 7%
Formula (monthly installment) = PMT(rate/12, term*12, -C4)
Monthly
Payment
£3,145.9
0

Task 7:
ID Q1 Q2 Q3a Q3b Q3c Q3d Q4 Q5 Q6
001 1 3 2 3 4 3 2 3 5
002 4 2 4 3 2 1 4 3 2
003 1 4 2 3 2 4 2 3 5
004 3 4 1 2 4 2 1 2 5
005 2 4 2 3 4 1 2 3 4
006 2 3 2 3 4 4 2 3 4
007 1 3 1 4 4 4 4 5 4
008 4 2 2 3 4 1 2 3 4
009 1 1 3 2 4 1 3 2 4
010 3 4 2 2 1 2 2 2 1
011 2 4 2 2 4 2 2 2 4
012 2 3 1 1 1 1 4 1 5
013 5 3 3 4 4 3 3 5 4
014 4 2 2 2 4 3 2 2 4
015 1 4 2 1 1 3 2 1 5
016 3 4 1 2 4 4 4 2 4

017 2 4 2 2 1 2 2 2 5
018 2 3 1 2 4 3 5 2 4
019 1 3 3 4 4 3 3 4 4
020 4 2 1 2 2 3 5 2 2
021 1 1 2 3 4 3 2 3 4
022 3 4 1 3 2 1 5 3 2
023 2 4 2 3 2 4 2 3 2
024 2 3 1 2 4 2 5 2 4
025 1 3 2 3 4 1 2 3 5
026 4 2 2 3 4 4 2 3 5
027 5 1 4 4 4 4 4 4 5
028 3 4 2 3 4 1 2 3 4
029 2 4 3 2 4 1 3 2 4
030 2 3 2 2 1 2 2 2 5
031 1 3 2 2 4 2 2 2 4
032 4 2 1 1 1 1 5 1 1
033 1 4 1 4 4 3 3 4 4
034 3 4 2 2 4 3 2 2 4
035 5 3 2 1 1 3 2 1 5
036 4 2 1 2 4 4 5 2 4
037 5 3 2 2 1 2 2 2 5
038 4 2 1 2 4 3 1 2 4
039 2 4 3 4 4 3 3 4 4
040 2 3 1 2 2 3 1 2 2
041 5 3 2 3 4 3 2 3 4
042 4 2 4 3 2 1 5 3 2
043 1 4 2 3 2 4 2 3 2
044 3 4 1 2 4 2 1 2 4
045 5 3 2 3 4 1 2 3 5
046 4 2 2 3 4 4 2 3 5
047 5 3 4 4 4 4 4 4 4
048 4 2 2 3 4 1 2 3 4

049 2 4 3 2 4 1 3 2 4
050 2 3 2 2 1 2 2 2 1
051 5 3 2 2 4 2 2 2 4
052 4 2 1 1 1 1 1 1 5
053 1 4 3 4 4 3 3 4 4
054 3 4 2 2 4 3 2 2 4
055 5 3 2 1 1 3 2 1 1
056 4 2 1 2 4 4 1 2 4
057 5 3 2 2 1 2 2 2 1
058 4 2 1 2 4 3 1 2 4
059 1 1 3 4 4 3 3 4 4
060 2 3 1 2 2 3 1 2 2
061 5 3 2 3 4 3 2 3 4
062 4 2 4 3 2 1 4 3 2
063 1 4 2 3 2 4 2 3 2
064 3 4 1 2 4 2 1 2 4
065 5 3 2 3 4 1 2 3 4
066 4 2 2 3 4 4 2 3 4
067 5 3 4 4 4 4 4 4 4
068 4 2 2 3 4 1 2 3 4
069 1 1 3 2 4 1 3 2 4
070 2 3 2 2 5 2 2 2 5
071 5 3 2 2 4 2 2 2 4
072 4 2 1 1 1 1 5 1 5
073 1 4 3 4 4 3 3 4 4
074 3 4 2 2 4 3 2 2 4
075 1 3 2 1 1 3 2 1 5
076 4 2 1 2 4 4 5 2 4
077 1 3 2 2 5 2 2 2 5
078 4 2 1 2 4 3 1 2 4
079 1 1 2 4 4 3 3 4 4
080 2 3 1 2 2 3 1 2 2

081 5 3 2 3 4 3 2 3 4
082 4 2 4 3 2 1 4 3 2
083 1 4 2 3 2 4 2 3 2
084 3 4 1 2 4 2 5 2 4
085 1 3 2 3 4 1 2 3 4
086 4 2 2 3 4 4 2 3 4
087 5 3 2 4 4 4 4 4 4
088 4 2 2 3 4 1 2 3 4
089 1 1 3 2 4 1 3 2 4
090 2 3 2 2 1 2 2 2 1
091 1 3 2 2 4 2 2 2 4
092 4 2 1 1 5 1 1 1 5
093 1 4 3 4 4 3 3 4 4
094 3 4 2 2 4 3 2 2 4
095 5 3 2 1 1 3 2 1 1
096 4 2 1 2 4 4 1 2 4
097 5 3 2 2 1 2 2 2 5
098 4 2 1 2 4 3 5 2 4
099 1 1 3 4 4 3 3 4 4
100 5 5 1 2 5 3 1 2 2
101 4 4 1 2 4 3 1 2 4
102 2 2 3 4 4 3 3 4 4
103 2 4 1 2 2 3 1 2 2
Averag
e
3 3 2 3 3 3 3 3 4