Calculate A Forecast For October Using Your Regression Formula
Calculate A Forecast For October Using Your Regression Formula . =forecast.linear (50, c2:c24, b2:b24) the second option is to use the corresponding cell number for the first x value and drag the equation down to each subsequent cell. (round your answer to 2 decimal places.) c. Chap14 multiple regression model building from www.slideshare.net By building a regression model to predict the value of y, you’re trying to get an equation like this for an output, y given inputs x1, x2, x3…. 114 + 119 + 137 = 370. Sales forecasting is a very broad topic, and i won’t go into it any further in this article.