Thesis of BBA-04


Chapter 4

MACON

4.2 Cross Tabulations
Income*Mostly_Purchased Crosstabulation                                                                      
Count
Mostly_Purchased
Total
Bashundara
Shah
Crown
Holcim
Lafarge Surma
Fresh
Tiger
Akij
Others
Income
lessthan 20000
1
7
5
4
0
2
0
2
10
31
20000-50000
3
7
3
1
3
5
1
2
8
33
51000-75000
2
3
0
2
0
2
3
1
2
15
76000-125000
0
0
2
0
1
1
1
1
4
10
126000-200000
0
0
0
0
0
0
0
0
1
1
Total
6
17
10
7
4
10
5
6
25
90
Table: 19
According to this table customer mostly purchased shah cement when their income is less than 50000tk. Respondent  purchased crown cement when income is less than 20000 taka. Respondent  purchased shah cement when income is 76000-125000 taka. 
Profession * Which_Cement_Suggest_Others Crosstabulation
Count
Which_Cement_Suggest_Others
Total
Bashundara
Shah
Crown
Holcim
Lafarge Surma
Fresh
Tiger
Akij
Others
Profession
Engineers
1
0
0
0
1
1
1
1
1
6
Business Man
0
4
0
1
1
3
1
1
5
16
Masons
1
3
1
2
0
0
1
1
5
14
Students
0
1
0
0
1
0
0
0
2
4
Job
1
3
2
3
1
1
0
2
17
30
Housewife
0
0
0
0
0
0
0
0
1
1
Retired
3
3
1
1
0
1
0
1
9
19
Total
6
14
4
7
4
6
3
6
40
90
Table: 20
In this table we found that business men are mostly suggest shah cement. Masons suggest others cement. Job holder suggests Holcim and others cement. Retired mostly suggest Bashundara and shah cement.

Profession * Most_Preferred_Cement Crosstabulation
Count
Most_Preferred_Cement
Total
Bashundara
Shah
Crown
Holcim
Lafarge Surma
Fresh
Tiger
Akij
Others
Profession
Engineers
1
0
0
0
1
1
1
1
1
6
Business Man
1
4
0
1
1
3
2
1
3
16
Masons
1
4
1
2
0
1
2
1
2
14
Students
0
1
1
0
0
0
0
0
2
4
Job
1
3
4
4
2
4
0
2
10
30
Housewife
0
0
0
0
0
0
0
0
1
1
Retired
2
5
4
0
0
1
0
1
6
19
Total
6
17
10
7
4
10
5
6
25
90
Table: 21
According to this table Retired parsons are mostly preferred Shah Cement. Business man  mostly preferred Shah and Fresh cement. Masons are mostly preferred Shah, Holcim, Tiger. Job holders mostly preferred crown, Holcim and other cement.
Profession* Factor_1
Count
Factor_1
Total
Family Member
Peers
TV Ads
Point Of sales
Engineers
Masons
Real Estate Companies
Retailers
Profession
Engineers
0
0
1
0
1
2
0
2
6
Business Man
2
0
2
0
3
7
1
1
16
Masons
1
1
0
0
6
1
0
5
14
Students
0
0
2
0
0
1
1
0
4
Job
5
1
1
1
7
13
1
1
30
Housewife
1
0
0
0
0
0
0
0
1
Retired
1
0
3
0
2
9
1
3
19
Total
10
2
9
1
19
33
4
12
90
Table: 22
In this table business man and job holder mostly heard information from Masons. Masons are mostly heard information from engineers and retailers. Retired are mostly heard information  from Tv Ads and masons.
Profession* Factor_2
Count
Factor_2
Total
Family members
peers
TV Ads
Point Of Sales
Engineers
Masons
Real Estate Companies
Retailers
Profession
Engineers
0
0
1
1
2
1
0
1
6
Business Man
2
2
4
1
2
3
1
1
16
Masons
0
1
6
1
2
1
1
2
14
Students
1
2
0
0
0
0
0
1
4
Job
6
3
7
0
5
5
1
3
30
Housewife
0
0
0
0
0
1
0
0
1
Retired
5
0
5
0
3
5
0
1
19
Total
14
8
23
3
14
16
3
9
90
Table: 23
According to this table factor -2 masons mostly heard information from TV Ads. Retired mostly heard information from family members, masons and TV Ads. Job holders are mostly heard information from family members, engineers, masons and TV Ads.

Profession* Factor_3
Count
Factor_3
Total
Family Members
Peers
TV Ads
Point Of Sales
Engineers
Masons
Real Estate Companies
Retailers
9
Profession
Engineers
2
2
1
0
0
0
1
0
0
6
Business Man
1
1
4
4
1
3
0
2
0
16
Masons
0
3
4
0
1
2
2
2
0
14
Students
1
0
2
0
0
0
0
1
0
4
Job
7
0
11
2
0
5
2
3
0
30
Housewife
0
0
1
0
0
0
0
0
0
1
Retired
1
0
9
0
1
3
1
3
1
19
Total
12
6
32
6
3
13
6
11
1
90
Table: 24
In this table factor -3 Job holders are mostly heard information from TV Ads, family members, masons. Retired mostly heard information from masons and TV Ads. Business man are mostly heard information from point of sales, masons and TV Ads.
Income * Standard_Price_Range Crosstabulation
Count
Standard_Price_Range
Total
300-350
351-400
401-450
451-500
Income
Less than 20000
11
12
8
0
31
20000-50000
7
13
11
2
33
51000-75000
1
5
8
1
15
76000-125000
1
5
2
2
10
126000-200000
0
1
0
0
1
Total
20
36
29
5
90
Table: 25
According to this table respondents think standard price of cement is 351 to 400 when their income level is less than 50000. Here 29 respondent think standard price of cement is 401-450 when income is 20000-50000 taka.

4.3 Hypothesis Testing
            4.3.1 t-Test Analysis
            4.3.2 Regression Analysis
Based on the dependent variable of overall employee satisfaction with the performance appraisal system and a total of 10 independent variables, regression analysis has been done to check the degree of relationship among the variables.
Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
.329a
.109
-.004
.601
a. Predictors: (Constant), Ads_Change_Buying_Decision, High_Price_Quality_good, Avilable, Consider_Country_Of_Origin, Benefits_Expected, Attractive_Pack, Reasonable_Cost, Pack_Important_Purchasing, Quality_Depend_Brand_Name, Durability

ANOVAb
Model
Sum of Squares
df
Mean Square
F
Sig.
1
Regression
3.477
10
.348
.962
.483a
Residual
28.568
79
.362
Total
32.045
89
a. Predictors: (Constant), Ads_Change_Buying_Decision, High_Price_Quality_good, Avilable, Consider_Country_Of_Origin, Benefits_Expected, Attractive_Pack, Reasonable_Cost, Pack_Important_Purchasing, Quality_Depend_Brand_Name, Durability
b. Dependent Variable: Satisfaction_bangladesh_Cement
The table shows that the value of R-square is .109 that indicates more than 10% of the variation in the dependent variable can be accounted for by the variation in independent variables. The adjusted R-square is -.004that indicates data representation of independent variables will be around .04% if the number of independent variables and sample size is adjusted. The overall significance score of ANOVA is 0.483 that exceeds the limit to reject the null hypothesis at 0.05 level. This situation along with the score of F value shows that the variables might have interrelationships that need to be reduced to some factors.
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
3.318
.756
4.387
.000
High_Price_Quality_good
.047
.062
.086
.761
.449
Attractive_Pack
.059
.079
.087
.747
.457
Quality_Depend_Brand_Name
-.036
.075
-.059
-.485
.629
Consider_Country_Of_Origin
.045
.072
.071
.628
.532
Benefits_Expected
.032
.082
.044
.389
.698
Reasonable_Cost
.094
.074
.146
1.265
.209
Pack_Important_Purchasing
.032
.068
.054
.472
.638
Avilable
-.093
.088
-.127
-1.056
.294
Durability
-.023
.090
-.032
-.259
.796
Ads_Change_Buying_Decision
.087
.071
.144
1.226
.224
a. Dependent Variable: Satisfaction_bangladesh_Cement

The table shows different coefficients associated with each variable. From the table it can be seen that 10 variables have significance score over than 0.05 indicating the rejection of null hypothesis that independent variables have no impact on the employee satisfaction of performance appraisal system. The variables can be shown in an equation as follows:
Satisfied with cement brand = 3.318 + 0.047 (High price) + .059(Attractive Pack) - 0.036 (Cement quality) + 0.045 (country of origin) + 0.032 (expected benefit) + .094 (Reasonable Cost) + 0.032 (important of packaging) - .093 (Available) - 0.023 (Durability) + .087 (Ads_Change_Buying_Decision)

4.2 Factor Analysis
In this study, 10 variables have been taken into consideration. The variables are derived from reviewing the literature on related subject matter. And for the factor analysis to be appropriate, the variables must have to be correlated. These variables are as follows:
V1 – High Price
V2 – Attractive Packing
V3 – Cement Quality
V4 – Country of origin
V6 – Reasonable Cost
V7– Importance of packaging
V8 – Availability
V9 – Durability
V10 – Advertising
Bartlett’s test of sphericity has been used to test the null hypotheses that the variables in the study are not correlated. In other words, the null hypothesis states that the population correlation matrix is an identity matrix. In an identity matrix, all the diagonal terms are 1 and all off-diagonal terms are 0. The test statistic for sphericity is based on a chi-square transformation of the determinant of the correlation matrix. A large value of the test statistic will favor the rejection of the null hypotheses. If this hypothesis cannot be rejected, the appropriateness of the factors will be questioned. Another useful statistic is the Kaiser-Meyer-Olkin (KMO) measure of sampling adequacy. This index compares the magnitudes of the observed correlation coefficients to the magnitudes of the partial correlation coefficients. Small values (below 0.5) of the KMO statistic indicate that the correlations between pairs of variables cannot be explained by other variables and that factor analysis may not be appropriate. 
KMO and Bartlett's Test
Kaiser-Meyer-Olkin Measure of Sampling Adequacy.
.431
Bartlett's Test of Sphericity
Approx. Chi-Square
75.595
Df
45
Sig.
.003
Table 2: KMO and Bartlett’s Test
Consequently, from the above table, it is apparent that factor analysis is appropriate. Here, the KMO value is .431, which is between 0.5 and 1.0, and the approximate chi-square statistic is 75.595 with 45 degrees of freedom, which is significant at the 0.05 levels. Therefore, the null hypotheses can be rejected and the alternative hypotheses that all variables are correlated to each other can be accepted. To analyze the variables ranging from V1 to V5, factor analysis has been used for data reduction. This analysis divulges the most important factors that contribute to satisfaction of Cement brand preference in Bangladesh.
Total Variance Explained
Component
Initial Eigenvalues
Extraction Sums of Squared Loadings
Rotation Sums of Squared Loadings
Total
% of Variance
Cumulative %
Total
% of Variance
Cumulative %
Total
% of Variance
Cumulative %
1
1.754
17.539
17.539
1.754
17.539
17.539
1.558
15.583
15.583
2
1.373
13.729
31.268
1.373
13.729
31.268
1.319
13.190
28.773
3
1.304
13.037
44.305
1.304
13.037
44.305
1.307
13.074
41.847
4
1.259
12.593
56.899
1.259
12.593
56.899
1.282
12.816
54.663
5
1.003
10.029
66.928
1.003
10.029
66.928
1.226
12.265
66.928
6
.910
9.102
76.030
7
.753
7.525
83.555
8
.723
7.228
90.784
9
.519
5.191
95.975
10
.403
4.025
100.000
Extraction Method: Principal
Table 3: Total Variance Explained
From the above table, only 5 factors have been extracted, as cumulative percentage is greater than 70% at this point and eigenvalue is greater than 1.0 (it is recommended that factors with eigenvalues greater than 1.0 should be retained) that indicates the adequacy of the analysis using derived factors.
Rotated Component Matrixa
Component
1
2
3
4
5
High_Price_Quality_good
-.173
.560
-.253
.065
-.198
Attractive_Pack
.059
.847
.081
.078
.053
Quality_Depend_Brand_Name
.129
.205
.256
-.371
.692
Consider_Country_Of_Origin
.042
-.249
-.109
.290
.791
Benefits_Expected
.198
.147
-.110
.781
.051
Reasonable_Cost
.721
-.197
.026
.219
-.165
Pack_Important_Purchasing
.622
.336
.071
-.144
.121
Avilable
-.277
.439
.583
.599
-.031
Durability
.123
-.066
.896
-.108
.050
Ads_Change_Buying_Decision
.684
-.081
-.002
.028
.179
Extraction Method: Principal Component Analysis.
 Rotation Method: Varimax with Kaiser Normalization.
a. Rotation converged in 9 iterations.

 Table 4: Rotated Component Matrix
The extracted 5 factors can be interpreted in terms of the variables that load high coefficients. From the rotated component matrix table, factor 1 has high coefficients for Reasonable cost (.510), Important of packaging (.546), Advertising (.639). Thus, factor 1 can be entitled as “Promotional ActivitiesFactor 2 has high coefficients for High Price (.489). Factor 3 has high coefficients for Cement Quality (-.531), Expected Benefits (.754).  Hence, this can be tagged as “Expected value”. Again, Factor 4 has high coefficients for Attractive Packaging (.638) Availability (.557) and Durability (.508). So, this factor can be named “”. Finally, Factor 5 has very high coefficients for Country of origin (.717).


No comments