The coded years (0-7) will be placed in the X ranges representing the independent variable. The first cell title will also be included with this template. Excel QM provides analysts with simple linear regression analysis as shown in FIGURE 1-3. FIGURE 1-3 Simple Linear Regression Analysis Analysts will enter the following information into a simple linear regression model provided in Excel QM using a simple linear regression formula Yi =b_0+ b_1 X_1. The highlighted Coefficients are provided in FIGURE 1-3. The b_0 is -18.3975 and the b_1 is 26.3479, these coefficients are added to the formula shown in Figure 1-4. FIGURE 1-4 (Simple Linear Regression Model) Once the coded year is entered, the formula can predict each year's global iPhone sales including 2015, which is projected to be 192.39 million units. With this information you can also display a scatter plot. This is highlighted in Figure 1-5.FIGURE 1-5 Scatterplot (Simple Linear Regression) The next model is the quadratic trend model. The quadratic formula uses the least squares method to make predictions and can be written as Yi =b_0+ b_1 X_1+ b_2 X_2. In this formula the only difference is that b_2 X_2 represents the estimated quadratic effect on Y. Figure 1-6 represents the comparison between the linear and quadratic effect