Skip to main content

Sales Prediction Using Linear and KNN Regression

  • Conference paper
  • First Online:
Advances in Machine Learning and Computational Intelligence

Abstract

An important part of present-day business intelligence is sales prediction. Sales prediction can be termed a complex problem, and it gets harder in the case of lack of data or missing data values, and the presence of outliers. Sales prediction is more of a regression problem than time series. Using machine learning algorithms, we can find complicated patterns in the sales dynamics including various risk variables as well, using supervised machine learning methods. Sales forecasting plays a huge role in a company’s success. An accurate sales prediction model can help businesses find potential risks and make better knowledgeable decisions. This paper aims to analyze the Rossmann sales data using predictive models such as linear regression and KNN regression. An accurate sales prediction can benefit a business by helping save money on excess inventory, planning properly for the future, and increasing the profit earned. Thus, it is also important to evaluate the model using statistical methods like RMSE and MAPE. The results are used in understanding which is a more suitable classifier for sales prediction.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 219.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. V. Kavya, S. Arumugam, A review on predictive analytics in data mining. Int. J. Chaos Control Modell. Simul. (IJCCMS) 5(1/2/3) (2016)

    Google Scholar 

  2. R.R. Shelke, R.V. Dharaskar, V.M. Thakare, Data mining for supermarket sale analysis using association rule. Int. J. Trend Sci. Res. Dev. 1(4). ISSN: 2456-6470

    Google Scholar 

  3. T. Wilson, S. Asthana, Predictive Modelling for Assessing the Sales Potential of the Customer. https://www.academia.edu/28362014/Predictive_Modelling_for_Assessing_the_Sales_Potential_of_the_Customer (2016)

  4. J. Gonzalez, Sales Forecasting and the Role of Predictive Analytics, (July 18, 2017), [Online]. Avaliable: https://vortini.com/blog/forecasting-predictive-analytics

  5. S. Makridakis, E. Spiliotis, V. Assimakopoulos, The accuracy of machine learning (ML) forecasting methods versus statistical ones: extending the results of the M3-competition (2017)

    Google Scholar 

  6. M. Xue, C. Zhu, Applied research on data mining algorithm in network intrusion detection 275–277. https://doi.org/10.1109/jcai.2009.25 (2009)

  7. Y.M. Khaing, M.M. Yee, E. Ei, Forecasting stock market using multiple linear regression Aung. Int. J. Trend Sci. Res. Dev. (IJTSRD) 3(5) (2019)

    Google Scholar 

  8. B.M. Pavlyshenko, Machine-learning models for sales time series forecasting, Lviv, Ukraine 21–25 August 2018, pp 3–11

    Google Scholar 

  9. G. Nguyen, Kedia, Jai, Snyder, Ryan, Pasteur, R., Wooster, R. Sales Forecasting Using Regression and Artificial Neural Networks. (2013)

    Google Scholar 

  10. A. Aima, WALMART sales data analysis & sales prediction using multiple linear regression in R programming Language, [Online], Available: https://medium.com/@arneeshaima/walmart-sales-data-analysis-sales-prediction-using-multiple-linear-regression-in-r-programming-adb14afd56fb (March 19)

  11. P. Mekala, B. Srinivasan, Time series data prediction on shopping mall. Int. J. Res. Comput. Appl. Robot. 2(8), 92–97 (2014). ISSN 2320-7345

    Google Scholar 

  12. M. Krause-Traudes, S. Scheider, S. Rüping, Spatial data mining for retail sales forecasting, in 11th AGILE International Conference on Geographic Information Science (2008)

    Google Scholar 

  13. W. Huang, Q. Zhang, W. Xu, H. Fu, M. Wang, X. Liang, A novel trigger model for sales prediction with data mining techniques. Data Sci. J. 14, 15 (2015). https://doi.org/10.5334/dsj-2015-015

    Article  Google Scholar 

  14. E. Bank, How to develop & use a regression model for sales forecasting, Updated September 26, 2017. https://bizfluent.com/how-7298496-develop-regression-model-sales-forecasting.html. Accessed 4 Oct 2019

  15. Rossmann Store Sales|Kaggle, Kaggle.com, 2019. [Online]. Available: https://www.kaggle.com/c/rossmann-store-sales/data. Accessed 07 Sept 2019

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Gracia Tabitha Godwin .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Kohli, S., Godwin, G.T., Urolagin, S. (2021). Sales Prediction Using Linear and KNN Regression. In: Patnaik, S., Yang, XS., Sethi, I. (eds) Advances in Machine Learning and Computational Intelligence. Algorithms for Intelligent Systems. Springer, Singapore. https://doi.org/10.1007/978-981-15-5243-4_29

Download citation

  • DOI: https://doi.org/10.1007/978-981-15-5243-4_29

  • Published:

  • Publisher Name: Springer, Singapore

  • Print ISBN: 978-981-15-5242-7

  • Online ISBN: 978-981-15-5243-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics