Catalytic cracking yield prediction method based on Matlab and Excel

Provided is a catalytic cracking yield prediction method based on Matlab and Excel. Historical catalytic cracking raw material property analysis and historical yield data in a device production process are used, and correlation coefficients are built for dry gas, liquefied gas, gasoline, diesel, slurry oil and coke respectively to obtain a yield prediction model; an Excel language is used for proposing a yield prediction model expression, and when the catalytic cracking raw material properties change, the built yield prediction model is used for predicting the catalytic cracking yields of thedry gas, the liquefied gas, the gasoline, the diesel, the slurry oil and the coke separately. According to the method, under the condition that the catalytic cracking reaction temperature and the catalyst variety do not change, the catalytic cracking yields can be fast predicted according to change of the catalytic cracking raw material properties, and an accurate calculation basis is provided forselecting suitable raw ma