SIMPLE LINIER CORRELATION AND REGRESSION ANALYSIS USING MICROSOFT EXCEL AND ITS APPLICATION IN MARKETING MANAGEMENT

Abstract

The research entitled "Correlation Analysis and Simple Linear Regression Using Microsoft Excel and Its Application to Marketing Management" aims to calculate the correlation coefficient and simple linear regression equation using MS-excel and its application in the field of marketing management. This research was conducted using a personal computer with an existing MS Office application, especially the MS-excel application. Applications in MS-Excel are used to perform statistical calculations as a substitute for manual calculations, especially for calculating correlation coefficients and regression constants. The results showed that the calculation of the correlation coefficient and simple linear regression equation can be done with the MS-excel application easily, quickly, and efficiently. The calculations use the facilities and commands in MS-Excel and the functions in it. Applied to marketing management shows that there is a positive correlation between promotion and sales with a very strong relationship. Each additional promotion results in an additional sales value.