Analysis of data processing ability using ms excel for final-year students of teuku umar university

Abstract

Ms. Excel is a worksheet application that provides a data processing menu. The data processing application on Ms. Excel can be activated for free on the Toolbar menu, namely the Analysis ToolPak menu. Based on the analysis menu, almost all statistical data can be solved similarly by using current paid statistical applications. If students are able to use Ms. Excel optimally, it certainly makes it very easy in terms of data processing in the final project research. This study aims to determine the ability to analyze data using Ms. Excel in final year students at Teuku Umar University. Capability data is obtained through data processing questions that are done on Ms. Excel worksheets. The questions include descriptive statistical material, data presentation, instrument testing and hypothesis testing. From the results of the study, it was found that students were able to calculate descriptive statistics by 34%, data presentation 43%, 13% on instrument testing and finally 10% on hypothesis testing. Cumulatively, Ms. Excel-based processing abilities in the final students of Teuku Umar University are in the medium category.