0% found this document useful (0 votes)
5 views3 pages

Correlation and Reliability Analysis Report

The document describes analyzing data from an Excel file containing reliability variables. It reads the data, computes a total reliability score, analyzes correlations between the variables, and calculates the reliability of the scale. The analysis found moderate to strong correlations between most of the reliability variables and an acceptable overall scale reliability of 0.705.

Uploaded by

ROI GENIAL PURBA
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views3 pages

Correlation and Reliability Analysis Report

The document describes analyzing data from an Excel file containing reliability variables. It reads the data, computes a total reliability score, analyzes correlations between the variables, and calculates the reliability of the scale. The analysis found moderate to strong correlations between most of the reliability variables and an acceptable overall scale reliability of 0.705.

Uploaded by

ROI GENIAL PURBA
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd

GET DATA

/TYPE=XLS
/FILE='E:\kualitas riset\[Link]'
/SHEET=name 'reliabel'
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
DATASET NAME DataSet1 WINDOW=FRONT.
COMPUTE Total_Reliabil=reliabil_6+reliabil_7+reliabil_8+reliabil_9+reliabil_10.
EXECUTE.
CORRELATIONS
/VARIABLES=reliabil_6 reliabil_7 reliabil_8 reliabil_9 reliabil_10 Total_Reliabil
/PRINT=TWOTAIL NOSIG
/MISSING=PAIRWISE.

Correlations
Notes
Output Created

15-Feb-2014 05:15:29

Comments
Input

Active Dataset

DataSet1

Filter

<none>

Weight

<none>

Split File

<none>

N of Rows in Working Data

100

File
Missing Value Handling

Definition of Missing

User-defined missing values are


treated as missing.

Cases Used

Statistics for each pair of variables are


based on all the cases with valid data
for that pair.

Syntax

CORRELATIONS
/VARIABLES=reliabil_6 reliabil_7
reliabil_8 reliabil_9 reliabil_10
Total_Reliabil
/PRINT=TWOTAIL NOSIG
/MISSING=PAIRWISE.

Resources

Processor Time

00:00:00.031

Elapsed Time

00:00:00.015

[DataSet1]

Correlations
reliabil_6
reliabil_6

Pearson Correlation

Sig. (2-tailed)
N

100

reliabil_7

reliabil_8

reliabil_9

reliabil_10

Total_Reliabil

.092

.076

.014

-.118

.326**

.364

.450

.889

.244

.001

100

100

100

100

100

reliabil_7

reliabil_8

reliabil_9

reliabil_10

Total_Reliabil

.629**

.586**

.658**

.873**

.000

.000

.000

.000

100

100

100

100

**

**

.779**

.000

.003

.000

100

100

100

**

.774**

.000

.000

100

100

100

.291**

.398**

.616**

.000

.003

.000

100

100

100

100

100

100

**

**

**

**

**

Pearson Correlation

.092

Sig. (2-tailed)

.364

100

100

Pearson Correlation

.076

**

Sig. (2-tailed)

.450

.000

100

100

100

Pearson Correlation

.014

**

**

Sig. (2-tailed)

.889

.000

.000

100

100

100

Pearson Correlation

-.118

.658**

Sig. (2-tailed)

.244

N
Pearson Correlation

.326

.629

.586

.873

.567

.567

.779

.774

.291

.398

.000

.616

Sig. (2-tailed)

.001

.000

.000

.000

.000

100

100

100

100

100

**. Correlation is significant at the 0.01 level (2-tailed).

RELIABILITY
/VARIABLES=reliabil_6 reliabil_7 reliabil_8 reliabil_9 reliabil_10
/SCALE('ALL VARIABLES') ALL
/MODEL=ALPHA
/SUMMARY=TOTAL.

Reliability
Notes
Output Created

15-Feb-2014 05:16:10

Comments
Input

Active Dataset

DataSet1

Filter

<none>

Weight

<none>

Split File

<none>

N of Rows in Working Data

100

File
Matrix Input
Missing Value Handling

Definition of Missing

User-defined missing values are


treated as missing.

Cases Used

Statistics are based on all cases with


valid data for all variables in the
procedure.

100

Syntax

RELIABILITY
/VARIABLES=reliabil_6 reliabil_7
reliabil_8 reliabil_9 reliabil_10
/SCALE('ALL VARIABLES') ALL
/MODEL=ALPHA
/SUMMARY=TOTAL.

Resources

Processor Time

00:00:00.000

Elapsed Time

00:00:00.000

[DataSet1]

Scale: ALL VARIABLES


Case Processing Summary
N
Cases

Valid
Excludeda
Total

%
100

100.0

.0

100

100.0

a. Listwise deletion based on all variables in the


procedure.

Reliability Statistics
Cronbach's
Alpha

N of Items
.705

Item-Total Statistics
Corrected Item-

Cronbach's

Scale Mean if

Scale Variance

Total

Alpha if Item

Item Deleted

if Item Deleted

Correlation

Deleted

reliabil_6

10.99

5.606

.032

.813

reliabil_7

11.11

3.452

.754

.515

reliabil_8

11.01

3.828

.597

.594

reliabil_9

10.95

3.806

.584

.599

reliabil_10

10.26

4.841

.443

.669

Common questions

Powered by AI

The correlation between 'reliabil_9' and 'Total_Reliabil' is 0.774, which is statistically significant at the 0.01 level. This high positive correlation indicates that 'reliabil_9' is a strong contributor to the composite score 'Total_Reliabil'. This reflects good construct validity for 'Total_Reliabil', as 'reliabil_9' effectively represents part of the total reliability being measured by the composite score [DataSet1].

The item-total statistics suggest several potential improvements to the reliability scale. For instance, removing 'reliabil_6' might improve the scale's reliability, as it has a low corrected item-total correlation and its deletion increases the Cronbach’s Alpha substantially to 0.813. This indicates that a reevaluation of the included items and reassessing others that may provide stronger contributions could optimize the scale's reliability, focusing on those with stronger item-total correlations [DataSet1].

If 'reliabil_7' were to be deleted, the Cronbach's Alpha would drop from 0.705 to 0.515, indicating that the removal of 'reliabil_7' would significantly lower the internal consistency of the scale. The corrected item-total correlation for 'reliabil_7' is 0.754, showing it is a strong item on the scale. This suggests that 'reliabil_7' is a critical component that enhances the reliability of the overall scale and its deletion would be detrimental [DataSet1].

The corrected item-total correlation for 'reliabil_6' is 0.032, which is very low, suggesting that 'reliabil_6' does not correlate well with the overall scale and does not contribute significantly to its reliability. This indicates that 'reliabil_6' may not be a well-aligned measure of the underlying construct intended by the scale, potentially affecting the overall scale's reliability negatively [DataSet1].

The significance level used for determining correlation in the dataset is 0.01 (2-tailed). This implies that correlations marked with a double asterisk (**) are statistically significant at this level, suggesting that there is a less than 1% probability that these correlations occurred by chance. This level of significance underscores the strength and reliability of the relationships between these variables in the study [DataSet1].

The correlation analysis employs pairwise deletion for handling missing data, which means each pair of variables is analyzed based on the available data, disregarding cases with missing values only for the pair being analyzed. This approach maximizes the use of available data without imposing strict exclusion criteria, potentially leading to higher statistical power but may introduce inconsistencies in the results if patterns of missingness are related to the variables, thereby impacting the validity of the findings [DataSet1].

The inter-correlation among 'reliabil_7' (0.629** with 'reliabil_8' and 0.586** with 'reliabil_9'), 'reliabil_8' (0.567** with 'reliabil_9'), and 'reliabil_9' suggests that these items are highly inter-related, contributing significantly to the composite score 'Total_Reliabil'. The high correlations among these items support the internal consistency of the scale, thereby enhancing the reliability of 'Total_Reliabil' [DataSet1].

Cronbach's Alpha is used in this analysis to measure the internal consistency or reliability of the scale comprising multiple items (reliabil_6 to reliabil_10). A Cronbach's Alpha of 0.705 indicates acceptable reliability, suggesting that the items have moderately good internal consistency and are likely measuring the same underlying concept or construct [DataSet1].

Inter-item correlation, which shows how similarly items on a scale measure the construct in question, directly influences the interpretation of overall scale reliability. In this dataset, strong inter-item correlations among 'reliabil_7', 'reliabil_8', and 'reliabil_9' suggest a consistent measure of the construct, reflecting a reliable scale. Higher internal consistency implies that the scales work congruently, making the overall measure more reliable given the high Cronbach's Alpha when these items are included [DataSet1].

Among the individual reliability variables, 'reliabil_10' has the weakest relationship with 'Total_Reliabil', with a Pearson correlation of 0.616**, although it is still statistically significant at the 0.01 level. This implies that while 'reliabil_10' contributes to the total reliability, its contribution is less pronounced compared to other variables like 'reliabil_7' or 'reliabil_8', which may suggest 'reliabil_10' measures some aspects of reliability not fully captured by the total score [DataSet1].

You might also like