10

Regression analysis is a method used to predict future values by analyzing the relationships between two or more variables. On the Regression worksheet use the Data Analysis add-in to create a regression analysis. Use cells C1:C37 as the Input Y Range. Use cells A1:B37 as the Input X Range. Click the Labels check box and use cell E10 as the Output Range. Adjust the columns as necessary so that all values are visible in the SUMMARY OUTPUT.

11

Excel's Data Analysis add-in provides an easy way to conduct a regression analysis on two or more variables. In cells G3 create a regression equation for the combination of age and gender in cells E3 and F3 respectively. Copy the formula to down to G6.

B C D E G H Gender Age (Nominal) Sales Estimate Sales Revenues 35 $63.76 Age Gender Sales Estimate 45 $181.52 45 2 38 $145.08 50 49 $153.39 55 $233.09 60 2 47 41 $192.25 50 $132.59 5 4 00 46 $130.28 48 $293.97 36 $166.98 47 $165.18 $252.05 46 $161.94 36 $156.14 37 $279.18 43 $261.67 18 47 $261.25 19 49 $262.73 20 38 N N N N N P P P P P P P P P P P P N N N N N P P N N NN PANNAAN $204.02 34 $52.44 32 $61.21 31 $80.12 24 $71.00 32 $85.74 28 $56.27 25 $62.89 19 $42.63 23 $58.35 30 32 $65.74 56 $296.8 32 61 $121.88 60 $177.52 34 64 $184.46 35 56 $190.96 36 61 $222.53 37 57 $232.54 38 SpaTreatments Regression OnlineOrder RaffleAnalysis Sales Trend CorrelationMatrix