 FURTHER CONSIDERATIONS ON SPREADSHEET-BASED AUTOMATIC TREND LINESAnnals - Economy Series, 2015, vol. 6Special, 274-284 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 behaviours, 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 (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:cbu:jrnlec:y:2015:v:6special:p:274-284 Access Statistics for this article More articles in Annals - Economy Series from Constantin Brancusi University, Faculty of Economics Contact information at EDIRC. |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.