Validity and Reliability Test with EXCEL
This video explains the validity and reliability tests using Excel. In addition to explaining the basic concepts of validity and reliability testing, in this video. I will also perform validity and reliability tests using Excel, not forgetting the complete interpretation of the output of the validity and reliability tests. The data in the video was obtained from distributing questionnaires using a Likert scale assessment, therefore it can be said by testing the validity and reliability of the questionnaire with Excel.
The validity test aims to determine the validity of the questionnaire used by researchers in measuring and obtaining research data from respondents. While the reliability test aims to determine the level of consistency of the questionnaire. In short, the questionnaire validity test is used to find out whether the statement items in the questionnaire are valid or not. The method used in the validity test is the Pearson Correlation validity test.
Meanwhile, the reliability test of the questionnaire was used to determine whether the questionnaire was reliable or not. The reliability test used was the Cronbach alpha method.
Watch until the end, my friends, this video discusses the Instrument Test, both testing the validity and reliability of the questionnaire with Excel or testing the Product Moment validity with Excel and the Cronbach Alpha reliability test.