AF AG AH Al AJ AK AL AM AN AO AP AQ QUESTION - What would be the best forecasting number of units sold new BMW i7? Target Selling Price = $93,000 REGRESSION MODELING: CORRELATION= ** USE CORRELATION EQUATION =CORREL(J2:J7,K2:K7) CORRELATION = *** USE REGRESSION ANALYSIS SLOPE = INTERCEPT = SAMPLE OBSERVATIONS = REGRESSION ANALYSIS & VALIDATION METHOD: UNIT PRICE (X) = FORECAST UNITS SOLD (Y) = Simple Regression Analysis = b+bx X Calculated Y Y Difference % Difference $48,800 586,000 $49,560 458,400 $52,000 320,000 $56,800 258,000 $63,200 248,000 $72,400 186,000 $74,700 120,662 $86,650 86,000 $92,350 75,875 $96,540 72,550 $109,650 45,890 Average $72,968 #DIV/0! 223,398 #DIV/0! #DIV/0!