Could not download file: This paper is available to authorised users only.

A LINEAR REGRESSION AND CORRELATION EXCEL TASK WITH ENGINEERING STUDENTS

J. Mendonça1, G. Gonçalves1, L. Babo2, C. Torres2

1Polytechnic of Porto/ISEP (PORTUGAL)
2Polytechnic of Porto/ISCAP (PORTUGAL)
In last years, increasing academic attention has been concerned on the effectiveness of Higher Education in developing relevant abilities and skills to workplace. The MS Excel software is widely used both in academic and professional scope. In Higher Education it is a helpful tool for the teaching of statistic concepts, particularly linear regression and correlation, a common topic in engineering curricula.

In this paper we attempt to address these issues analysing the Excel software capabilities as a teaching tool in a statistic course. We examine the performance and engagement of two samples of 50 students each of Chemical Engineering degree of the School of Engineering of Porto, in the academic years 2015-2016 and 2016-2017, when faced with an Excel task involving the linear regression and correlation content.

This work shows the viability of this approach in the learning of some statistic concepts. Students achieved the task proposed goals and applied appropriately the concepts of linear regression and correlation in an engaged way.