survey_data <- read_csv("Downloads/ANT 400 SURVEY DATA.csv")
survey_data %>%
ggplot(aes(x = fct_infreq(Q01SC_SECTOR))) +
geom_bar() +
scale_x_discrete(labels = function(x) str_wrap(x, width = 10)) +
labs(x = "Sector", y = NULL, title = "Distribution by sector")
survey_data %>%
ggplot(aes(x = fct_infreq(Q02SC_STARTDATE))) +
geom_bar() +
scale_x_discrete(labels = function(x) str_wrap(x, width = 10)) +
labs(x = "Start Time", y = NULL, title = "Distribution by start time")
survey_data %>%
ggplot(aes(x = fct_infreq(Q03SC_NOEMPLOYEE))) +
geom_bar() +
scale_x_discrete(labels = function(x) str_wrap(x, width = 10)) +
labs(x = "Number of Employees", y = NULL, title = "Distribution by number of employees")
Statistics for confidence in feeling as entrepreneur measure.
survey_data %>%
summarise(
entprfeel_mean = mean(Q04SCL_ENTPRFEEL, na.rm = TRUE),
entprfeel_sd = sd(Q04SCL_ENTPRFEEL, na.rm = TRUE),
entprfeel_1st_quartie = quantile(Q04SCL_ENTPRFEEL, 0.25, na.rm = TRUE),
entprfeel_median = median(Q04SCL_ENTPRFEEL, na.rm = TRUE),
entprfeel_3d_quartile = quantile(Q04SCL_ENTPRFEEL, 0.75, na.rm = TRUE)
)
## # A tibble: 1 × 5
## entprfeel_mean entprfeel_sd entprfeel_1st_quartie entprfeel_median
## <dbl> <dbl> <dbl> <dbl>
## 1 3.27 1.10 3 3
## # ℹ 1 more variable: entprfeel_3d_quartile <dbl>
Statistics for ratings of factors in assessing current business
survey_data %>%
summarise(
q6finance_mean = mean(Q06SCL01_FINANCE, na.rm = TRUE),
q6finance_sd = sd(Q06SCL01_FINANCE, na.rm = TRUE),
q6finance_1st_quartie = quantile(Q06SCL01_FINANCE, 0.25, na.rm = TRUE),
q6finance_median = median(Q06SCL01_FINANCE, na.rm = TRUE),
q6finance_3d_quartile = quantile(Q06SCL01_FINANCE, 0.75, na.rm = TRUE)
)
## # A tibble: 1 × 5
## q6finance_mean q6finance_sd q6finance_1st_quartie q6finance_median
## <dbl> <dbl> <dbl> <dbl>
## 1 3.02 1.37 2 3
## # ℹ 1 more variable: q6finance_3d_quartile <dbl>
survey_data %>%
summarise(
q6knowledge_mean = mean(Q06SCL02_KNOWLEDGE, na.rm = TRUE),
q6knowledge_sd = sd(Q06SCL02_KNOWLEDGE, na.rm = TRUE),
q6knowledge_1st_quartie = quantile(Q06SCL02_KNOWLEDGE, 0.25, na.rm = TRUE),
q6knowledge_median = median(Q06SCL02_KNOWLEDGE, na.rm = TRUE),
q6knowledge_3d_quartile = quantile(Q06SCL02_KNOWLEDGE, 0.75, na.rm = TRUE)
)
## # A tibble: 1 × 5
## q6knowledge_mean q6knowledge_sd q6knowledge_1st_quartie q6knowledge_median
## <dbl> <dbl> <dbl> <dbl>
## 1 3.44 0.977 3 4
## # ℹ 1 more variable: q6knowledge_3d_quartile <dbl>
survey_data %>%
summarise(
q6network_mean = mean(Q06SCL03_NETWORK, na.rm = TRUE),
q6network_sd = sd(Q06SCL03_NETWORK, na.rm = TRUE),
q6network_1st_quartie = quantile(Q06SCL03_NETWORK, 0.25, na.rm = TRUE),
q6network_median = median(Q06SCL03_NETWORK, na.rm = TRUE),
q6network_3d_quartile = quantile(Q06SCL03_NETWORK, 0.75, na.rm = TRUE)
)
## # A tibble: 1 × 5
## q6network_mean q6network_sd q6network_1st_quartie q6network_median
## <dbl> <dbl> <dbl> <dbl>
## 1 3.42 0.875 3 3
## # ℹ 1 more variable: q6network_3d_quartile <dbl>
survey_data %>%
summarise(
q6confidence_mean = mean(Q06SCL04_CONFIDENCE, na.rm = TRUE),
q6confidence_sd = sd(Q06SCL04_CONFIDENCE, na.rm = TRUE),
q6confidence_1st_quartie = quantile(Q06SCL04_CONFIDENCE, 0.25, na.rm = TRUE),
q6confidence_median = median(Q06SCL04_CONFIDENCE, na.rm = TRUE),
q6confidence_3d_quartile = quantile(Q06SCL04_CONFIDENCE, 0.75, na.rm = TRUE)
)
## # A tibble: 1 × 5
## q6confidence_mean q6confidence_sd q6confidence_1st_quartie q6confidence_median
## <dbl> <dbl> <dbl> <dbl>
## 1 3.62 0.952 3 4
## # ℹ 1 more variable: q6confidence_3d_quartile <dbl>
survey_data %>%
summarise(
q6confidence_mean = mean(Q06SCL04_CONFIDENCE, na.rm = TRUE),
q6confidence_sd = sd(Q06SCL04_CONFIDENCE, na.rm = TRUE),
q6confidence_1st_quartie = quantile(Q06SCL04_CONFIDENCE, 0.25, na.rm = TRUE),
q6confidence_median = median(Q06SCL04_CONFIDENCE, na.rm = TRUE),
q6confidence_3d_quartile = quantile(Q06SCL04_CONFIDENCE, 0.75, na.rm = TRUE)
)
## # A tibble: 1 × 5
## q6confidence_mean q6confidence_sd q6confidence_1st_quartie q6confidence_median
## <dbl> <dbl> <dbl> <dbl>
## 1 3.62 0.952 3 4
## # ℹ 1 more variable: q6confidence_3d_quartile <dbl>
Does number of employees affect confidence in feeling as entrepreneur?
Hypothesis #1: Does number of employees affect feeling as entrepreneur?
survey_data_model1 <-
survey_data %>%
drop_na()
survey_model1 <-
lm(Q04SCL_ENTPRFEEL ~ Q03SC_NOEMPLOYEE,
data = survey_data_model1)
summary(survey_model1)
##
## Call:
## lm(formula = Q04SCL_ENTPRFEEL ~ Q03SC_NOEMPLOYEE, data = survey_data_model1)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.0000 -0.5000 0.0000 0.3333 2.0000
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.000e+00 1.691e-01 17.746 <2e-16 ***
## Q03SC_NOEMPLOYEE10-19 1.000e+00 5.856e-01 1.708 0.0953 .
## Q03SC_NOEMPLOYEE20-49 1.333e+00 5.856e-01 2.277 0.0281 *
## Q03SC_NOEMPLOYEE5-9 -7.948e-16 4.660e-01 0.000 1.0000
## Q03SC_NOEMPLOYEE50-100 1.000e+00 7.072e-01 1.414 0.1649
## Q03SC_NOEMPLOYEEabove 100 2.000e+00 9.857e-01 2.029 0.0490 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9711 on 41 degrees of freedom
## Multiple R-squared: 0.2332, Adjusted R-squared: 0.1397
## F-statistic: 2.494 on 5 and 41 DF, p-value: 0.04628
anova(survey_model1)
## Analysis of Variance Table
##
## Response: Q04SCL_ENTPRFEEL
## Df Sum Sq Mean Sq F value Pr(>F)
## Q03SC_NOEMPLOYEE 5 11.759 2.35177 2.4937 0.04628 *
## Residuals 41 38.667 0.94309
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
survey_data %>%
ggplot(aes(x = Q03SC_NOEMPLOYEE, y = Q04SCL_ENTPRFEEL)) +
geom_point() +
labs(x = "Number of Employees", y = "Confidence as Entrepreneur",
title = "Distribution of Number of Employees vs. Confidence as Entrepreneur") +
geom_smooth(method = "gam")
ggplot(data = survey_model1,
aes(sample = .resid)) +
stat_qq() +
stat_qq_line(color = "red")
#Hypothesis #2: Does longer time of entrepreneurial activity affect
feeling as entrepreneur?
survey_data_model2 <-
survey_data %>%
drop_na()
survey_model2 <-
lm(Q04SCL_ENTPRFEEL ~ Q02SC_STARTDATE,
data = survey_data_model2)
summary(survey_model2)
##
## Call:
## lm(formula = Q04SCL_ENTPRFEEL ~ Q02SC_STARTDATE, data = survey_data_model2)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.4483 -0.4483 -0.4483 0.5517 2.3333
##
## Coefficients:
## Estimate Std. Error t value
## (Intercept) 3.000e+00 5.272e-01 5.690
## Q02SC_STARTDATEbetween 6 and 12 months ago 4.755e-15 7.456e-01 0.000
## Q02SC_STARTDATEI have not yet started -1.429e-01 6.609e-01 -0.216
## Q02SC_STARTDATEless than 1 month ago -3.333e-01 8.053e-01 -0.414
## Q02SC_STARTDATEmore than 12 months ago 4.483e-01 5.624e-01 0.797
## Pr(>|t|)
## (Intercept) 1.11e-06 ***
## Q02SC_STARTDATEbetween 6 and 12 months ago 1.000
## Q02SC_STARTDATEI have not yet started 0.830
## Q02SC_STARTDATEless than 1 month ago 0.681
## Q02SC_STARTDATEmore than 12 months ago 0.430
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.054 on 42 degrees of freedom
## Multiple R-squared: 0.07396, Adjusted R-squared: -0.01424
## F-statistic: 0.8386 on 4 and 42 DF, p-value: 0.5085
anova(survey_model2)
## Analysis of Variance Table
##
## Response: Q04SCL_ENTPRFEEL
## Df Sum Sq Mean Sq F value Pr(>F)
## Q02SC_STARTDATE 4 3.729 0.93233 0.8386 0.5085
## Residuals 42 46.696 1.11181
#Hypothesis #3: Do financial resources affect feeling as entrepreneur?
survey_data_model3 <-
survey_data %>%
drop_na()
survey_model3 <-
lm(Q04SCL_ENTPRFEEL ~ Q06SCL01_FINANCE,
data = survey_data_model3)
summary(survey_model3)
##
## Call:
## lm(formula = Q04SCL_ENTPRFEEL ~ Q06SCL01_FINANCE, data = survey_data_model3)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.2387 -0.4591 -0.2387 0.5960 1.9817
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 2.9081 0.3675 7.913 4.62e-10 ***
## Q06SCL01_FINANCE 0.1102 0.1130 0.975 0.335
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.048 on 45 degrees of freedom
## Multiple R-squared: 0.02069, Adjusted R-squared: -0.00107
## F-statistic: 0.9508 on 1 and 45 DF, p-value: 0.3347
anova(survey_model3)
## Analysis of Variance Table
##
## Response: Q04SCL_ENTPRFEEL
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL01_FINANCE 1 1.043 1.0434 0.9508 0.3347
## Residuals 45 49.382 1.0974
#Hypothesis #4: Does business knowledge affect feeling as entrepreneur?
survey_data_model4 <-
survey_data %>%
drop_na()
survey_model4 <-
lm(Q04SCL_ENTPRFEEL ~ Q06SCL02_KNOWLEDGE,
data = survey_data_model4)
summary(survey_model4)
##
## Call:
## lm(formula = Q04SCL_ENTPRFEEL ~ Q06SCL02_KNOWLEDGE, data = survey_data_model4)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.49281 -0.49281 -0.05845 0.50719 2.37590
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.7554 0.4955 3.543 0.000935 ***
## Q06SCL02_KNOWLEDGE 0.4344 0.1396 3.111 0.003230 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9603 on 45 degrees of freedom
## Multiple R-squared: 0.177, Adjusted R-squared: 0.1588
## F-statistic: 9.681 on 1 and 45 DF, p-value: 0.00323
anova(survey_model4)
## Analysis of Variance Table
##
## Response: Q04SCL_ENTPRFEEL
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL02_KNOWLEDGE 1 8.927 8.9273 9.6807 0.00323 **
## Residuals 45 41.498 0.9222
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #5: Does business network affect feeling as entrepreneur?
survey_data_model5 <-
survey_data %>%
drop_na()
survey_model5 <-
lm(Q04SCL_ENTPRFEEL ~ Q06SCL03_NETWORK,
data = survey_data_model5)
summary(survey_model5)
##
## Call:
## lm(formula = Q04SCL_ENTPRFEEL ~ Q06SCL03_NETWORK, data = survey_data_model5)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.08265 -0.58265 -0.08265 0.47264 1.91735
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.7485 0.5599 3.123 0.00313 **
## Q06SCL03_NETWORK 0.4447 0.1621 2.744 0.00868 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9798 on 45 degrees of freedom
## Multiple R-squared: 0.1434, Adjusted R-squared: 0.1243
## F-statistic: 7.531 on 1 and 45 DF, p-value: 0.008682
anova(survey_model5)
## Analysis of Variance Table
##
## Response: Q04SCL_ENTPRFEEL
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL03_NETWORK 1 7.229 7.2288 7.5306 0.008682 **
## Residuals 45 43.197 0.9599
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #6: Does confidence affect feeling as entrepreneur?
survey_data_model6 <-
survey_data %>%
drop_na()
survey_model6 <-
lm(Q04SCL_ENTPRFEEL ~ Q06SCL04_CONFIDENCE,
data = survey_data_model6)
summary(survey_model6)
##
## Call:
## lm(formula = Q04SCL_ENTPRFEEL ~ Q06SCL04_CONFIDENCE, data = survey_data_model6)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.8497 -0.5445 0.1503 0.4555 2.1503
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 0.7653 0.4678 1.636 0.109
## Q06SCL04_CONFIDENCE 0.6948 0.1273 5.459 1.97e-06 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.8211 on 45 degrees of freedom
## Multiple R-squared: 0.3984, Adjusted R-squared: 0.385
## F-statistic: 29.8 on 1 and 45 DF, p-value: 1.968e-06
anova(survey_model6)
## Analysis of Variance Table
##
## Response: Q04SCL_ENTPRFEEL
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL04_CONFIDENCE 1 20.090 20.0896 29.801 1.968e-06 ***
## Residuals 45 30.336 0.6741
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #1_1: Does number of employees affect confidence in feeling as entrepreneur?
survey_data_model1_1 <-
survey_data %>%
drop_na()
survey_model1_1 <-
lm(Q06SCL04_CONFIDENCE ~ Q03SC_NOEMPLOYEE,
data = survey_data_model1_1)
summary(survey_model1_1)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q03SC_NOEMPLOYEE, data = survey_data_model1_1)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.3333 -0.3333 0.0000 0.6667 1.6667
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.33333 0.15307 21.777 <2e-16 ***
## Q03SC_NOEMPLOYEE10-19 1.33333 0.53024 2.515 0.0159 *
## Q03SC_NOEMPLOYEE20-49 0.66667 0.53024 1.257 0.2158
## Q03SC_NOEMPLOYEE5-9 0.06667 0.42198 0.158 0.8752
## Q03SC_NOEMPLOYEE50-100 1.16667 0.64032 1.822 0.0758 .
## Q03SC_NOEMPLOYEEabove 100 1.66667 0.89252 1.867 0.0690 .
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.8793 on 41 degrees of freedom
## Multiple R-squared: 0.2383, Adjusted R-squared: 0.1454
## F-statistic: 2.565 on 5 and 41 DF, p-value: 0.04145
anova(survey_model1_1)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q03SC_NOEMPLOYEE 5 9.917 1.98340 2.5653 0.04145 *
## Residuals 41 31.700 0.77317
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #2_2: Does longer time of entrepreneurial activity affect confidence?
survey_data_model2_2 <-
survey_data %>%
drop_na()
survey_model2_2 <-
lm(Q06SCL04_CONFIDENCE ~ Q02SC_STARTDATE,
data = survey_data_model2_2)
summary(survey_model2_2)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q02SC_STARTDATE, data = survey_data_model2_2)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.8571 -0.7241 0.2759 0.2759 1.3333
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.75000 0.45031 8.328 1.96e-10
## Q02SC_STARTDATEbetween 6 and 12 months ago 0.25000 0.63683 0.393 0.697
## Q02SC_STARTDATEI have not yet started -0.89286 0.56449 -1.582 0.121
## Q02SC_STARTDATEless than 1 month ago -1.08333 0.68786 -1.575 0.123
## Q02SC_STARTDATEmore than 12 months ago -0.02586 0.48036 -0.054 0.957
##
## (Intercept) ***
## Q02SC_STARTDATEbetween 6 and 12 months ago
## Q02SC_STARTDATEI have not yet started
## Q02SC_STARTDATEless than 1 month ago
## Q02SC_STARTDATEmore than 12 months ago
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9006 on 42 degrees of freedom
## Multiple R-squared: 0.1814, Adjusted R-squared: 0.1035
## F-statistic: 2.327 on 4 and 42 DF, p-value: 0.07185
anova(survey_model2_2)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q02SC_STARTDATE 4 7.550 1.88753 2.3271 0.07185 .
## Residuals 42 34.067 0.81112
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #3_3: Do financial resources affect confidence?
survey_data_model3_3 <-
survey_data %>%
drop_na()
survey_model3_3 <-
lm(Q06SCL04_CONFIDENCE ~ Q06SCL01_FINANCE,
data = survey_data_model3_3)
summary(survey_model3_3)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q06SCL01_FINANCE, data = survey_data_model3_3)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.04953 -0.56414 -0.04953 0.43586 1.95047
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 2.7922 0.3135 8.907 1.71e-11 ***
## Q06SCL01_FINANCE 0.2573 0.0964 2.669 0.0105 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.8935 on 45 degrees of freedom
## Multiple R-squared: 0.1367, Adjusted R-squared: 0.1175
## F-statistic: 7.124 on 1 and 45 DF, p-value: 0.01054
anova(survey_model3_3)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL01_FINANCE 1 5.688 5.6881 7.1242 0.01054 *
## Residuals 45 35.929 0.7984
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #4_4: Does business knowledge affect confidence?
survey_data_model4_4 <-
survey_data %>%
drop_na()
survey_model4_4 <-
lm(Q06SCL04_CONFIDENCE ~ Q06SCL02_KNOWLEDGE,
data = survey_data_model4_4)
summary(survey_model4_4)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q06SCL02_KNOWLEDGE, data = survey_data_model4_4)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.8867 -0.3269 0.1133 0.5535 1.2329
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.6475 0.3981 4.139 0.000151 ***
## Q06SCL02_KNOWLEDGE 0.5598 0.1122 4.991 9.48e-06 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.7716 on 45 degrees of freedom
## Multiple R-squared: 0.3563, Adjusted R-squared: 0.342
## F-statistic: 24.91 on 1 and 45 DF, p-value: 9.479e-06
anova(survey_model4_4)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL02_KNOWLEDGE 1 14.829 14.8288 24.91 9.479e-06 ***
## Residuals 45 26.788 0.5953
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #5_5: Does business network affect confidence?
survey_data_model5_5 <-
survey_data %>%
drop_na()
survey_model5_5 <-
lm(Q06SCL04_CONFIDENCE ~ Q06SCL03_NETWORK,
data = survey_data_model5_5)
summary(survey_model5_5)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q06SCL03_NETWORK, data = survey_data_model5_5)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.74040 -0.30966 -0.02503 0.40570 1.69034
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.1636 0.4077 2.854 0.00651 **
## Q06SCL03_NETWORK 0.7154 0.1180 6.061 2.53e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.7135 on 45 degrees of freedom
## Multiple R-squared: 0.4495, Adjusted R-squared: 0.4372
## F-statistic: 36.74 on 1 and 45 DF, p-value: 2.531e-07
anova(survey_model5_5)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q06SCL03_NETWORK 1 18.706 18.7061 36.741 2.531e-07 ***
## Residuals 45 22.911 0.5091
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
#Hypothesis #7: Does family support affect confidence?
survey_data_model7 <-
survey_data %>%
drop_na()
survey_model7 <-
lm(Q06SCL04_CONFIDENCE ~ Q09SCL01_PRTFAM,
data = survey_data_model7)
summary(survey_model7)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q09SCL01_PRTFAM, data = survey_data_model7)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.5558 -0.5558 0.4217 0.4611 1.4667
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.52207 0.30500 11.548 4.75e-15 ***
## Q09SCL01_PRTFAM 0.01125 0.09792 0.115 0.909
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9615 on 45 degrees of freedom
## Multiple R-squared: 0.0002934, Adjusted R-squared: -0.02192
## F-statistic: 0.01321 on 1 and 45 DF, p-value: 0.909
anova(survey_model7)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q09SCL01_PRTFAM 1 0.012 0.01221 0.0132 0.909
## Residuals 45 41.605 0.92455
#Hypothesis #8: Does friends and acquiantances support affect confidence?
survey_data_model8 <-
survey_data %>%
drop_na()
survey_model8 <-
lm(Q06SCL04_CONFIDENCE ~ Q09SCL02_FRNDACQ,
data = survey_data_model8)
summary(survey_model8)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q09SCL02_FRNDACQ, data = survey_data_model8)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.6267 -0.4938 0.1074 0.5062 1.6392
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.2279 0.2851 11.322 9.24e-15 ***
## Q09SCL02_FRNDACQ 0.1330 0.1020 1.303 0.199
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.944 on 45 degrees of freedom
## Multiple R-squared: 0.03636, Adjusted R-squared: 0.01495
## F-statistic: 1.698 on 1 and 45 DF, p-value: 0.1992
anova(survey_model8)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q09SCL02_FRNDACQ 1 1.513 1.51339 1.6982 0.1992
## Residuals 45 40.104 0.89119
#Hypothesis #9: Does government initiative affect confidence?
survey_data_model9 <-
survey_data %>%
drop_na()
survey_model9 <-
lm(Q06SCL04_CONFIDENCE ~ Q09SCL03_GOVTINIT,
data = survey_data_model9)
summary(survey_model9)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q09SCL03_GOVTINIT, data = survey_data_model9)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.5784 -0.5290 0.3228 0.5204 1.5204
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.38078 0.28067 12.045 1.12e-15 ***
## Q09SCL03_GOVTINIT 0.09882 0.13960 0.708 0.483
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9564 on 45 degrees of freedom
## Multiple R-squared: 0.01101, Adjusted R-squared: -0.01096
## F-statistic: 0.5011 on 1 and 45 DF, p-value: 0.4826
anova(survey_model9)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q09SCL03_GOVTINIT 1 0.458 0.45836 0.5011 0.4826
## Residuals 45 41.159 0.91464
#Hypothesis #10: Does private organization support affect confidence?
survey_data_model10 <-
survey_data %>%
drop_na()
survey_model10 <-
lm(Q06SCL04_CONFIDENCE ~ Q09SCL04_PRVTORG,
data = survey_data_model10)
summary(survey_model10)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q09SCL04_PRVTORG, data = survey_data_model10)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.511 -0.575 0.361 0.489 1.489
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.44699 0.27661 12.462 3.43e-16 ***
## Q09SCL04_PRVTORG 0.06399 0.14376 0.445 0.658
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9596 on 45 degrees of freedom
## Multiple R-squared: 0.004384, Adjusted R-squared: -0.01774
## F-statistic: 0.1981 on 1 and 45 DF, p-value: 0.6584
anova(survey_model10)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q09SCL04_PRVTORG 1 0.182 0.18245 0.1981 0.6584
## Residuals 45 41.435 0.92077
#Hypothesis #11: Does belief in statement 1 affect confidence?
survey_data_model11 <-
survey_data %>%
drop_na()
survey_model11 <-
lm(Q06SCL04_CONFIDENCE ~ Q11SCL01_QZCULTURE,
data = survey_data_model11)
summary(survey_model11)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q11SCL01_QZCULTURE, data = survey_data_model11)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.5359 -0.6099 0.2422 0.5381 1.4641
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.38789 0.29730 11.40 7.43e-15 ***
## Q11SCL01_QZCULTURE 0.07399 0.11748 0.63 0.532
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9575 on 45 degrees of freedom
## Multiple R-squared: 0.008738, Adjusted R-squared: -0.01329
## F-statistic: 0.3967 on 1 and 45 DF, p-value: 0.532
anova(survey_model11)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q11SCL01_QZCULTURE 1 0.364 0.36366 0.3967 0.532
## Residuals 45 41.253 0.91674
#Hypothesis #12: Does belief in statement 2 affect confidence?
survey_data_model12 <-
survey_data %>%
drop_na()
survey_model12 <-
lm(Q06SCL04_CONFIDENCE ~ Q11SCL02_CHALLENGE,
data = survey_data_model12)
summary(survey_model12)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q11SCL02_CHALLENGE, data = survey_data_model12)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.6051 -0.4942 0.2841 0.5058 1.5058
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.8268 0.3066 12.480 3.26e-16 ***
## Q11SCL02_CHALLENGE -0.1109 0.1108 -1.001 0.322
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9512 on 45 degrees of freedom
## Multiple R-squared: 0.02176, Adjusted R-squared: 2.424e-05
## F-statistic: 1.001 on 1 and 45 DF, p-value: 0.3224
anova(survey_model12)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q11SCL02_CHALLENGE 1 0.906 0.9057 1.0011 0.3224
## Residuals 45 40.711 0.9047
#Hypothesis #13: Does belief in statement 3 affect confidence?
survey_data_model13 <-
survey_data %>%
drop_na()
survey_model13 <-
lm(Q06SCL04_CONFIDENCE ~ Q11SCL03_COMMUNITY,
data = survey_data_model13)
summary(survey_model13)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q11SCL03_COMMUNITY, data = survey_data_model13)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.2000 -0.6931 0.1426 0.6356 1.4713
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.0356 0.3454 8.788 2.53e-11 ***
## Q11SCL03_COMMUNITY 0.1644 0.1008 1.631 0.11
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9345 on 45 degrees of freedom
## Multiple R-squared: 0.05579, Adjusted R-squared: 0.03481
## F-statistic: 2.659 on 1 and 45 DF, p-value: 0.1099
anova(survey_model13)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q11SCL03_COMMUNITY 1 2.322 2.32197 2.6591 0.1099
## Residuals 45 39.295 0.87322
#Hypothesis #14: Does belief in statement 4 affect confidence?
survey_data_model14 <-
survey_data %>%
drop_na()
survey_model14 <-
lm(Q06SCL04_CONFIDENCE ~ Q11SCL04_LIFEBALANCE,
data = survey_data_model14)
summary(survey_model14)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q11SCL04_LIFEBALANCE, data = survey_data_model14)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.6554 -0.5290 0.2182 0.6606 1.5974
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.9082 0.3291 11.876 1.82e-15 ***
## Q11SCL04_LIFEBALANCE -0.1264 0.1064 -1.189 0.241
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9469 on 45 degrees of freedom
## Multiple R-squared: 0.03044, Adjusted R-squared: 0.008893
## F-statistic: 1.413 on 1 and 45 DF, p-value: 0.2408
anova(survey_model14)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q11SCL04_LIFEBALANCE 1 1.267 1.26678 1.4128 0.2408
## Residuals 45 40.350 0.89667
#Hypothesis #15: Does belief in statement 5 affect confidence?
survey_data_model15 <-
survey_data %>%
drop_na()
survey_model15 <-
lm(Q06SCL04_CONFIDENCE ~ Q11SCL05_ADVANTAGE,
data = survey_data_model15)
summary(survey_model15)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q11SCL05_ADVANTAGE, data = survey_data_model15)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.4523 -0.6104 0.2316 0.5477 1.5477
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.24157 0.31836 10.182 2.94e-13 ***
## Q11SCL05_ADVANTAGE 0.10537 0.09693 1.087 0.283
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9493 on 45 degrees of freedom
## Multiple R-squared: 0.02559, Adjusted R-squared: 0.003934
## F-statistic: 1.182 on 1 and 45 DF, p-value: 0.2828
anova(survey_model15)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q11SCL05_ADVANTAGE 1 1.065 1.06489 1.1817 0.2828
## Residuals 45 40.552 0.90116
#Hypothesis #16: Does sector has affect on confidence?
survey_data_model16 <-
survey_data %>%
drop_na()
survey_model16 <-
lm(Q06SCL04_CONFIDENCE ~ Q01SC_SECTOR,
data = survey_data_model16)
summary(survey_model16)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q01SC_SECTOR, data = survey_data_model16)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.6250 -0.4167 0.0000 0.3750 1.5000
##
## Coefficients:
## Estimate
## (Intercept) 4.0000
## Q01SC_SECTORcommerce 0.2500
## Q01SC_SECTORconsulting -0.6667
## Q01SC_SECTOReducation -0.3750
## Q01SC_SECTORgastronomy and tourism -1.5000
## Q01SC_SECTORhealth 1.0000
## Q01SC_SECTORlight industry (incl. food processing, textiles, consumer goods, machinery, construction) -0.7500
## Q01SC_SECTORmedia, culture and IT -0.5000
## Q01SC_SECTORАрендодатель -1.0000
## Q01SC_SECTORвнешнеэкономическая деятельность -2.0000
## Q01SC_SECTORПси -1.0000
## Std. Error
## (Intercept) 0.5152
## Q01SC_SECTORcommerce 0.6815
## Q01SC_SECTORconsulting 0.7286
## Q01SC_SECTOReducation 0.5614
## Q01SC_SECTORgastronomy and tourism 0.8146
## Q01SC_SECTORhealth 0.8146
## Q01SC_SECTORlight industry (incl. food processing, textiles, consumer goods, machinery, construction) 0.6041
## Q01SC_SECTORmedia, culture and IT 0.6310
## Q01SC_SECTORАрендодатель 1.0304
## Q01SC_SECTORвнешнеэкономическая деятельность 1.0304
## Q01SC_SECTORПси 1.0304
## t value
## (Intercept) 7.764
## Q01SC_SECTORcommerce 0.367
## Q01SC_SECTORconsulting -0.915
## Q01SC_SECTOReducation -0.668
## Q01SC_SECTORgastronomy and tourism -1.841
## Q01SC_SECTORhealth 1.228
## Q01SC_SECTORlight industry (incl. food processing, textiles, consumer goods, machinery, construction) -1.241
## Q01SC_SECTORmedia, culture and IT -0.792
## Q01SC_SECTORАрендодатель -0.970
## Q01SC_SECTORвнешнеэкономическая деятельность -1.941
## Q01SC_SECTORПси -0.970
## Pr(>|t|)
## (Intercept) 3.36e-09
## Q01SC_SECTORcommerce 0.7159
## Q01SC_SECTORconsulting 0.3663
## Q01SC_SECTOReducation 0.5084
## Q01SC_SECTORgastronomy and tourism 0.0738
## Q01SC_SECTORhealth 0.2276
## Q01SC_SECTORlight industry (incl. food processing, textiles, consumer goods, machinery, construction) 0.2225
## Q01SC_SECTORmedia, culture and IT 0.4333
## Q01SC_SECTORАрендодатель 0.3383
## Q01SC_SECTORвнешнеэкономическая деятельность 0.0601
## Q01SC_SECTORПси 0.3383
##
## (Intercept) ***
## Q01SC_SECTORcommerce
## Q01SC_SECTORconsulting
## Q01SC_SECTOReducation
## Q01SC_SECTORgastronomy and tourism .
## Q01SC_SECTORhealth
## Q01SC_SECTORlight industry (incl. food processing, textiles, consumer goods, machinery, construction)
## Q01SC_SECTORmedia, culture and IT
## Q01SC_SECTORАрендодатель
## Q01SC_SECTORвнешнеэкономическая деятельность .
## Q01SC_SECTORПси
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.8924 on 36 degrees of freedom
## Multiple R-squared: 0.3112, Adjusted R-squared: 0.1198
## F-statistic: 1.626 on 10 and 36 DF, p-value: 0.1385
anova(survey_model16)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q01SC_SECTOR 10 12.950 1.2950 1.6263 0.1385
## Residuals 36 28.667 0.7963
#Hypothesis #17: Relation of needing more business knowledge to increase to confidence?
survey_data_model17 <-
survey_data %>%
drop_na()
survey_model17 <-
lm(Q06SCL04_CONFIDENCE ~ Q08SCL07_KNOWLEDGE,
data = survey_data_model17)
summary(survey_model17)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q08SCL07_KNOWLEDGE, data = survey_data_model17)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.4433 -0.6155 0.3271 0.4419 1.6715
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.7876 0.2835 13.359 <2e-16 ***
## Q08SCL07_KNOWLEDGE -0.1148 0.1210 -0.948 0.348
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9522 on 45 degrees of freedom
## Multiple R-squared: 0.0196, Adjusted R-squared: -0.002188
## F-statistic: 0.8996 on 1 and 45 DF, p-value: 0.348
anova(survey_model17)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q08SCL07_KNOWLEDGE 1 0.816 0.81565 0.8996 0.348
## Residuals 45 40.801 0.90670
#Hypothesis #18: Relation of needing more business network to increase to confidence?
survey_data_model18 <-
survey_data %>%
drop_na()
survey_model18 <-
lm(Q06SCL04_CONFIDENCE ~ Q08SCL08_NETWORK,
data = survey_data_model18)
summary(survey_model18)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q08SCL08_NETWORK, data = survey_data_model18)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.5607 -0.5607 0.3221 0.4393 1.6738
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.7951 0.2955 12.841 <2e-16 ***
## Q08SCL08_NETWORK -0.1172 0.1264 -0.928 0.359
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9526 on 45 degrees of freedom
## Multiple R-squared: 0.01876, Adjusted R-squared: -0.003046
## F-statistic: 0.8603 on 1 and 45 DF, p-value: 0.3586
anova(survey_model18)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q08SCL08_NETWORK 1 0.781 0.78069 0.8603 0.3586
## Residuals 45 40.836 0.90747
#Hypothesis #19: Relation of needing more finances to increase to confidence?
survey_data_model19 <-
survey_data %>%
drop_na()
survey_model19 <-
lm(Q06SCL04_CONFIDENCE ~ Q08SCL01_FINANCE,
data = survey_data_model19)
summary(survey_model19)
##
## Call:
## lm(formula = Q06SCL04_CONFIDENCE ~ Q08SCL01_FINANCE, data = survey_data_model19)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.4946 -0.6126 0.3480 0.5054 1.6628
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 3.7307 0.3140 11.880 1.81e-15 ***
## Q08SCL01_FINANCE -0.0787 0.1247 -0.631 0.531
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 0.9575 on 45 degrees of freedom
## Multiple R-squared: 0.008771, Adjusted R-squared: -0.01326
## F-statistic: 0.3982 on 1 and 45 DF, p-value: 0.5312
anova(survey_model19)
## Analysis of Variance Table
##
## Response: Q06SCL04_CONFIDENCE
## Df Sum Sq Mean Sq F value Pr(>F)
## Q08SCL01_FINANCE 1 0.365 0.36504 0.3982 0.5312
## Residuals 45 41.252 0.91671
Note that the echo = FALSE parameter was added to the
code chunk to prevent printing of the R code that generated the
plot.