Data Analysis: Frequencies, Correlation, and Regression

This document provides an analysis of data collected through a questionnaire. It covers frequencies distribution, correlation, and regression analysis. The main focus is on the relationship between network development and market supply.

RunningDATA ANALYSIS 1
DATA ANALYSIS
The main aim of the research is to determine the relationship between Network
Development and Market Supply. To conduct the analysis, the data obtained from the
questionnaire is to be used to answer the above questions. We are going to conduct the
analysis by focusing on the following parts:
I) Frequencies distribution
ii) Correlation
iii) Regression analysis
I) Frequencies distribution
We will create tables and graphs displaying the main information from the data collected
using the questionnaire. We will focus on the frequencies of the specific columns. We
will also display information about the central tendencies and measure of dispersion.
Central Tendencies of the columns
Age, Industry and Size


RunningDATA ANALYSIS 1
Age
Frequency % Valid % Cumulative %
1 2 2.0 2.0 2.0
2 1 1.0 1.0 3.0
3 6 5.9 5.9 8.9
4 4 4.0 4.0 12.9
5 9 8.9 8.9 21.8
6 2 2.0 2.0 23.8
7 2 2.0 2.0 25.7
8 5 5.0 5.0 30.7
10 6 5.9 5.9 36.6
11 2 2.0 2.0 38.6
12 2 2.0 2.0 40.6
13 1 1.0 1.0 41.6
14 1 1.0 1.0 42.6
15 8 7.9 7.9 50.5
16 1 1.0 1.0 51.5
17 3 3.0 3.0 54.5
18 1 1.0 1.0 55.4
19 2 2.0 2.0 57.4
20 6 5.9 5.9 63.4
21 2 2.0 2.0 65.3
22 4 4.0 4.0 69.3
24 2 2.0 2.0 71.3
25 4 4.0 4.0 75.2
26 2 2.0 2.0 77.2
27 1 1.0 1.0 78.2
29 2 2.0 2.0 80.2
30 2 2.0 2.0 82.2
31 1 1.0 1.0 83.2

RunningDATA ANALYSIS 1
35 1 1.0 1.0 84.2
36 1 1.0 1.0 85.1
37 1 1.0 1.0 86.1
38 1 1.0 1.0 87.1
40 2 2.0 2.0 89.1
45 1 1.0 1.0 90.1
46 2 2.0 2.0 92.1
47 1 1.0 1.0 93.1
50 1 1.0 1.0 94.1
57 1 1.0 1.0 95.0
60 2 2.0 2.0 97.0
71 1 1.0 1.0 98.0
76 1 1.0 1.0 99.0
85 1 1.0 1.0 100.0
Total 101 100.0 100.0

Size
Frequency % Valid % Cumulative %

RunningDATA ANALYSIS 1
Correlation
Before we conducted regression analysis, we transformed the data given from the questionnaire
to conduct this. We selected two columns that contains data from the column Specialized
Resources. We averaged the two columns to come up with one column name titled Market
Supply. We also transformed columns from Organization relationship column, averaged them
and titled it Network Development. The main goal of doing this, is to simplify our analysis so that
we make the data more readable and easy to analyze.

RunningDATA ANALYSIS 1
From the correlation analysis, we can observe that they was a correlation between Network
Development and Market Supply. The relationship was about 24.3 %. There was a relationship
thought it was weak.
Regression Analysis
The regression analysis determines the relationship between the predictor variable and
explanatory variable. It mainly focuses on the effect of the predictor variable towards dependent
variable. The general formula of regression analysis is given by:
y = mx + c
Below we conducted the regression analysis, we came up with the hypothesis:
I) There is no relationship between Network Development and Market Supply – Null hypothesis
Below is the results from the regression analysis

RunningDATA ANALYSIS 1
From the results above, we can summarize the regression equation as:
Network Development = 4.202 + 0.194 * Market Supply
This mean that 4.202 of Network Development is not affected by Market Supply. Similarly, a unit
of Market Supply increases the Network Development by 0.194 per unit. To determine the fit of
coefficient of determination, we focus on the value of R-squared. The value of R-squared is
0.061. This means that the only 6.1 % of Market Supply affect the number of Network
Development.
To determine whether our null hypothesis is true or not, we focus on the significant value. In our
situation, the significant value is 0.017. Since our significant value is less than 0.05, we reject the
null hypothesis. We therefore, conclude that there is a relationship between Network
Development and Market Supply. Though, the relationship is very low.