Business Decision Making Report - Data Analysis and Reporting

This report delves into the core principles of business decision-making, emphasizing the crucial role of information gathering and analysis. It begins by outlining plans for collecting both primary and secondary data, highlighting survey methodologies and sampling frames, and designing effective questionnaires. The report then proceeds to detail data summarization techniques using representative values, followed by a deep dive into data analysis, employing measures of dispersion to inform business scenarios. Furthermore, it covers the use of spreadsheets for graphical representation and forecasting, alongside the production of formal business reports. The assignment also explores the use of information processing and financial tools for effective decision-making, culminating in a comprehensive analysis and conclusion.

BUSINESS
DECISION MAKING

Introduction ................................................................................................................................................3
Task 1...........................................................................................................................................................3
create a plan for the collection of primary and secondary data for a given business problem...............3
1.2 present the survey methodology and sampling frame used..............................................................4
1.3 design a questionnaire for a given business problem........................................................................4
Task 2...........................................................................................................................................................5
2.1 Create information for decision making by summarizing data using representative values..............5
2.2 create information for decision making by summarizing data using representative &values
analyses the results to draw valid conclusion .........................................................................................7
2.3 analyses data using measures of dispersion to inform a given business scenario.............................9
2.4 explain how quartiles, percentiles and the correlation coefficient are used...................................10
Task 3.........................................................................................................................................................11
3.1 produce graphs using spreadsheets and draw valid conclusions based on the information derived
...............................................................................................................................................................11
3.2 trend lines in spreadsheet graphs to assist in forecasting for specified business information&
business using suitable software and techniques..................................................................................12
3.3 Covered in ppt.................................................................................................................................12
3.4produce a formal business report.....................................................................................................12
Task 4.........................................................................................................................................................13
4.1 Use of information processing tool..................................................................................................13
4.2 Use appropriate information processing tools & project plan for an activity and determine the
critical path............................................................................................................................................13
4.3Use financial tools for decision making............................................................................................14
Conclusion.................................................................................................................................................15
REFRENCES................................................................................................................................................17

Introduction
The success of a business making good decision to required use of different effective use
of information. Business decision makings to provide the different opportunities of leaning
various variety of sources and developing in the different aspect of a particular information: data
gathering, tools available, data storages tools to creating the useful information and presenting.
The presentation of the information to provide the advantages of using different department of
the information system. The business decision making business purpose to achieving the aims of
different variety of data sources. The collective information of the data has specific task of the
organization. There are two way of data collective primary and secondary data. Which used to
highly information collects to effective manners. It can need of the company for collective
current relevant information would help to make affective decision or strategy (Bechara, 2003).
The preparation of the information in the effective conclusion provide. The basis of the data
analysis is required to clarity the importance use of effective data to relative techniques. The
analysis of the information is very important to take efficient and effective business decision into
the organization(Hwang and Masud, 2012). This help the manage different industry brief and
addition tools to introduction new process and rules and regulation to increasing the quality and
quality of the productivity. After the collective information to evaluated the data and this
requirement developing of the organization. The project report to increasing customer’s
sanctification level of the need to define the related feedback related product of markets.
Task 1
create a plan for the collection of primary and secondary data for a given business
problem
The primary to collected is the first hands that are collected firs times. it relevant and more focused as
data are collected for the first times so that there less changes that would be menupulated to related the
project reports . there are various which to data collected on the first times likes questionnaire, surveys,
interview and other different methods. that is collected would be firm of certain populations different
age of group. To this task to take questionnaire would to maintain the relevant questionnaire in relation of
the research would be mention can by further aspects of effective manners.
Secondary data is already to present and evaluated by the different peoples(Frey, Schulz-Hardt, and
Stahlberg, 2013). The data should be internal and externally based that can become helpful of thee
research. This types of the research can form the internal sources along with the statically data trends and
records of the customer preferences. And the secondary sources to easily to understands.
Plan for the collectives to different requirement of the data:
All the primary data should research would be collected from the mean of the questionnaires that would
be distractive population a specific preference as well interest.
The appropriates samplings methods be used so that the no extra information are wasted by the research
of the implantation plan.

1.2 present the survey methodology and sampling frame used.
The methods in the used in the survey of the relevant other best practice used interrelation in the better
samplings of different types of the population, in a particular best research. Another concept that used in
this research is samplings frame that to down of the sources of the materials. There are different sampling
frames presents performed task in an effectives and efficient manner the research.
Random systematic samplings: it is random selective of the particular data from the different population
of every particular time of period.
Cluster samplings: it references to the selective of the data from the populations.it can done with a
particular time.
Stratified samplings: the data that’s selected in a sampling is on the searcher only.
Judgments samplings: in this particular research the best and effective way to person to sampling alone
random systematic samplings.
1.3 design a questionnaire for a given business problem
The method of the survey in which used various e questions are related to the population in
related to the specific research to collect the different the most of the relevant data from a particular
population can used in the research in effectively use of systematic manners. In this research
questionnaire to represent helpful of the survey of bailti places
Name______________
Address____________
Gender _______________
Organtion ______________
Date_________________
1. How could you like a land to London?
a) By transport.
b) With minimal effort carrier.
c) With real carrier.
d) Via prepare.
2. Where did you find out about this restaurant?
a) I knew about it.
b) Via Internet.
c) Companions and relatives.
d) Media.
e) Books and aides.

f) Travel office.
g) Fairs as well as displays.
h) It was a piece of the travel bundle.
Other, what: ____________________________________
3. Is this your first visit to this restaurant?
a) No.
b)Yes.
4. From how much time you are visiting our restaurant?
a) From its existence
b) From last 6 months
c) From last 1 year
5. What were the fundamental explanations behind your visit to this restaurant?
a) Seeing relatives and companions.
b) Business reasons.
c) Going to a meeting, congress, workshop, different types of instructions.
d) Culture.
e) Fun.
f) Games and diversion.
e) Wellbeing.
f) Religious reasons.
Task 2
2.1 Create information for decision making by summarizing data using representative
values
There are 100 respondents are taken to analyses the responses and the results are
considered as follows
1. How could you like a land to London?
a) By transport. 20
b) With minimal effort carrier. 22
c) With real carrier. 35

d) Via prepare. 23
2. Where did you find out about this restaurant?
a) I knew about it. 15
b) Via Internet. 8
c) Companions and relatives. 11
d) Media. 22
e) Books and aides. 12
f) Travel office. 15
g) Fairs as well as displays. 11
h) It was a piece of the travel bundle. 6
3. Is this your first visit to this restaurant?
a) No. 35
b)Yes. 65
4. From how much time you are visiting our restaurant?
a) From its existence 35
b) From last 6 months 25
c) From last 1 year 40
5. What were the fundamental explanations behind your visit to this restaurant?
a) Seeing relatives and companions. -10
b) Business reasons. 8
c) Going to a meeting, congress, workshop, different types of
instructions. 11
d) Culture. 11
e) Fun. 32

f) Games and diversion. 11
g) Wellbeing. 15
h) Religious reasons. 22
2.2 create information for decision making by summarizing data using representative
&values analyses the results to draw valid conclusion
The quantities types of poll youthful grow up the age 30-40 pay to acquitting to the responded
from 5000 every months has been decided to the venture and spot there are two note wordy accessibilities
has been considered into the while gathering information to first age and seconds pay of accessibilities the
information.
From the above reports it has the picked age 30-40 the picked ages group of gathering being such of the
dining timing of the prices. the cost of the item must be specific and lower aspects to adopt goal of the
destinations(Tzeng, and Huang, 2011).
The standard deviation is the measurement of dispersion of different collective data from the mean .in the
project that information focus on the further of the mean of aspects there are higher deviations inside the
information’s to collect of index. Above this report sequences root of variation by the deciding between
data to connection to the mean. The standard deviation is the most one key central hazed of the experts.
The right of facts to members is the frequencies to given answer to the end user and financial spec list all
the times.
Arithmetic mean: the average of the mean or normal consider different number of values. the mean is
the provide the rules related with averages of all individual numbers. The mean by define doing all
numbers and diving’s the quality of the arrangement Individuals numbers.
Median: it referees to the center numbers all numerical numbers. If the numbers in an odd number, then
the arrangements median will middle levels. But if any numbers are even that the averse of the two
middle be a perfect median.
Modes: it refers to the men frequencies rehashed commonly used by the progressions of the numbers it
called the modes. It including mean mode median is an instrument of statistics. It one numbers state
modes most external numbers to given a specific arrangements or her hands has mot possibilities of
aspects of selective beings.
1. How could you like a land to London?
a) By transport. 20
b) With minimal effort carrier. 22
c) With real carrier. 35
d) Via prepare. 23
Mean 25
Median 23
Mode 20

2. Where did you find out about this restaurant?
a) I knew about it. 15
b) Via Internet. 8
c) Companions and relatives. 11
d) Media. 22
e) Books and aides. 12
f) Travel office. 15
g) Fairs as well as displays. 11
h) It was a piece of the travel bundle. 6
Mean 12.5
Median 11.5
Mode 3
3. Is this your first visit to this restaurant?
a) No. 35
b)Yes. 65
Mean 50
Median 50
Mode 35
4. From how much time you are visiting our restaurant?
a) From its existence 35
b) From last 6 months 25
c) From last 1 year 40
Mean
33.33333333
33
Median 35
Mode 35
5. What were the fundamental explanations behind your visit to this restaurant?

a) Seeing relatives and companions. -10
b) Business reasons. 8
c) Going to a meeting, congress, workshop, different types of
instructions. 11
d) Culture. 11
e) Fun. 32
f) Games and diversion. 11
g) Wellbeing. 15
h) Religious reasons. 22
Mean 12.5
Median 11
Mode 12
2.3 analyses data using measures of dispersion to inform a given business scenario
Degree of the dispersion: it referees to the change abilities between two aspects of the factors.an the
define of the homogeny factors of the desertion only low sides measurement of dispersions and high
indicates of the dispersions of the homogeny. The level of dispersion is measure different computing’s
flection level of disruption or homogeny between to the two factors to how the factors to define two
factors or same of each other dispersions.
Standard deviation: √∑Fdx2/N – (∑Fdx/N)2
Calculation of standard deviation
S. No. Respondents view
1 1
2 1
3 1
4 1
5 2
6 2
7 2
8 3
9 4
ST. DEV 1.0540925534

Perspective of respondents are examine by there giving position. As indicated by the load age of each
inquiry from the clients they are come to there resolution. 1.05 is decide in the wake of making
appropriate examination. The standard risk of
There are different sorts of proportion of scattering :
Relative measure of dispersion: it is known as unadulterated esteem that is taken as contrast
among at least two than two arrangement of qualities. It is coefficient of scattering which is gathered
from various proportions or rates.
Absolute measure of dispersion: It is known as those measures which is communicated in
connection to correct units of information. It comprises of extents, means and standard deviation.
Variance: this is recognised as the square foundation of standard deviation of arbitrary factors
from its mean. It is utilized to quantify add up to set of numbers are spread out from their normal esteem.
formula: S2 = ∑(X – X )2/n-1
Measurement of dispersion: it referee to the measurement of dispersion to utilization a part of the
computing’s two factors in the data to collected frequencies when data should be given on the on
measurement of the dis person which define the knowing connection between the factors to given a data
of the company. Range and variances are adding using the differ change abilities the variables when the
all thinks of the related to the like hoods.
2.4 explain how quartiles, percentiles and the correlation coefficient are used
Quartiles: the quartiles define the different ranges of quarter based likes quarter1, quatar2,
quarter 3 and so on the quarter might to different characteristics to the connection of between most new
numbers and certain numbers are specific of the quarter and seconds quarter might to different
characteristics of the define the median data of the reports, and specific off the features it also to creating
the different between numbers to medium based and most elements numbers. it might to connection back
accounts and applied to different add numbers.
QD = 1/2(Q3 – Q1)
Percentiles: it refers to the define of characteristics its rates of mean and recorded status of then
projects. It is more important of an organization .it discrete to the typically distribution curve and also it
define zone of curve .it makes the different specimen size of the organizations. Its formula is
R= P/100 (n+1)
Coefficient of the correction: a coefficient of the correction it refers to the different reliance
numbers of the statics. Coefficient of correlation it connection between two different types individual
relationship coefficient inside. It can provide the different correction techniques item likes correction, in
charges correction rank strategies and techniques are best of the originations ( Elango, Kundu, and
Paudel,2010). It can also inner change of the characteristics the natures of the items. the quality of
project high and low based. It a position of the strategies for the measurements related the different
factors of the characteristics it additional standard deviation and covariance’s relationship of the factors of
the two vaeribles.it can provides the qualified the most rant of the organizations. It quality of the rank to
relationship based on the coefficient.

Task 3
3.1 produce graphs using spreadsheets and draw valid conclusions based on the
information derived
The line charts shoe to trends which to take places in the sales of the domestic and international
marketing to duration the specific activity during the 2010-2015 . as the chart related trends of the
different markets of two different markets were conditions. It can used of UK has found that stability in
domestic market of the their location in the places of international market thought they have successful
before the high sales of the products.so it necessary need to attach more specific aspects more important
in the selective of the international markets proper strategy and plan in the marketing on the quality of
the products to attraction major forging patters.
From the above charts it can be analyzed that the frequencies movements of the sales of the company.
The incasing of sales off the business of the increasing that good sign for the business (García-Peñalvo,
and Conde, 2014).
Line chart of cost
The cost is also showing to the pattern of the busines.now work of business hard to make it low based .
Line chart of profit

In the business show to correct decision makings happing into the business corrective manner
3.2 trend lines in spreadsheet graphs to assist in forecasting for specified business information&
business using suitable software and techniques.
Bar chart of profit
3.3 Covered in ppt
3.4produce a formal business report
The writing business report for a business it is an important to know the specific needs for the any
projects. the purpose of the report need to clarify the different aspects. Developing a company of
restaurants in this name to given a particular aspect, a location of the restaurants rent, what food process
in to market .it including different numbers of restaurant owner and long experience define the particular
times. After this report the manager and employee are need to described different think which are detail
of the given a particular staff to given. In the report to manage different activity and operation of the
restaurants likes furniture’s corky other that product to including into the mention of reports. the supplier