Further Considerations on Spreadsheet - Based Automatic Trend Lines

Annals of the Constantin Brancusi University of Targu Jiu, Economy Series, Special Issue ECO-TREND 2015 - Performance, Competitiveness, Creativity

11 Pages Posted: 15 Feb 2016

See all articles by Daniel Homocianu

Daniel Homocianu

Alexandru Ioan Cuza University, Faculty of Economics and Business Administration, Department of Accounting, Business Information Systems and Statistics

Date Written: January 1, 2016

Abstract

Most of the nowadays business applications working with data sets allow exports to the spreadsheet format. This fact is related to the experience of common business users with such products and to the possibility to couple what they have with something containing many models, functions and possibilities to process and represent data, by that getting something in dynamics and much more than a simple static less useful report.

The purpose of Business Intelligence is to identify clusters, profiles, association rules, decision trees and many other patterns or even behaviors, but also to generate alerts for exceptions, determine trends and make predictions about the future based on historical data. In this context, the paper shows some practical results obtained after testing both the automatic creation of scatter charts and trend lines corresponding to the user’s preferences and the automatic suggesting of the most appropriate trend for the tested data mostly based on the statistical measure of how close they are to the regression function.

Keywords: Spreadsheets, Business Intelligence (BI), Microsoft (MS) Office Excel trends, Google Sheets Trends

JEL Classification: C130, D810, D830

Suggested Citation

Homocianu, Daniel, Further Considerations on Spreadsheet - Based Automatic Trend Lines (January 1, 2016). Annals of the Constantin Brancusi University of Targu Jiu, Economy Series, Special Issue ECO-TREND 2015 - Performance, Competitiveness, Creativity. Available at SSRN: https://ssrn.com/abstract=2732512 or http://dx.doi.org/10.2139/ssrn.2732512

Daniel Homocianu (Contact Author)

Alexandru Ioan Cuza University, Faculty of Economics and Business Administration, Department of Accounting, Business Information Systems and Statistics ( email )

Romania

Register to save articles to
your library

Register

Paper statistics

Downloads
23
Abstract Views
197
PlumX Metrics