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

Wiyono, Wiyono and Christian, Paulus Yayan and Abidin, Abidin (2021) SIMPLE LINIER CORRELATION AND REGRESSION ANALYSIS USING MICROSOFT EXCEL AND ITS APPLICATION IN MARKETING MANAGEMENT. SIMPLE LINIER CORRELATION AND REGRESSION ANALYSIS USING MICROSOFT EXCEL AND ITS APPLICATION IN MARKETING MANAGEMENT, 2 (1). pp. 29-40. ISSN 2541-1268

	Text SIMPLE LINIER CORRELATION AND REGRESSION ANALYSIS USING MICROSOFT EXCEL AND ITS APPLICATION IN MARKETING MANAGEMENT.pdf - Published Version Download (248kB)
	Text TURNITIN SIMPLE LINIER CORRELATION AND REGRESSION ANALYSIS USING MICROSOFT EXCEL AND ITS APPLICATION IN MARKETING MANAGEMENT.pdf - Published Version Download (2MB)

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.

Item Type:	Article
Uncontrolled Keywords:	Ccorrelation Coefficient, Simple Linear Regression, Promotion, Sales
Subjects:	600 Teknologi dan Ilmu Terapan (Bisnis) > 620 Ilmu Teknik > 620.004 Measurement/Teknik Desain, Pengujian, Pengukuran, Kualitas, Perawatan, Pemeliharaan, Perbaikan Universitas Buddhi Dharma > Fakultas Sains & Teknologi > Teknik Industri > 620 Ilmu Teknik > 620.004 Measurement/Teknik Desain, Pengujian, Pengukuran, Kualitas, Perawatan, Pemeliharaan, Perbaikan
Divisions:	Dewey Decimal Classification 23 > 600 Teknologi dan Ilmu Terapan (Bisnis) > 620 Ilmu Teknik > 620.004 Measurement/Teknik Desain, Pengujian, Pengukuran, Kualitas, Perawatan, Pemeliharaan, Perbaikan Fakultas Sains & Teknologi > Teknik Industri > 620 Ilmu Teknik > 620.004 Measurement/Teknik Desain, Pengujian, Pengukuran, Kualitas, Perawatan, Pemeliharaan, Perbaikan
Depositing User:	Muhamad Kemal Prasetyo
Date Deposited:	19 Aug 2024 07:22
Last Modified:	19 Aug 2024 07:22
URI:	http://repositori.buddhidharma.ac.id/id/eprint/2310

Actions (login required)

View Item