Development and Comparison of Regression Models Predicting Wine Quality using Excel - From a Profit Maximization Perspective

Abstract

Wine reviewers and the general public usually determine the quality of the wine. There is a great deal of subjec-tivity in such reviews and differences in the reviewers' preferences, making it difficult for the winery to obtain favorable information. This paper will use Excel to build a related model of chemical substances in wine and wine quality. Both linear and logistic regression is used in this article to predict wine quality. In addition, differ-ent from past literature that indicates the quality of red wine based on chemical substances, this paper creatively constructs a profit model based on predicting wine quality. It thus helps wine sellers to make model selections. All these can help producers understand how to make good wine and get higher profits.