Financial Forecasting TREND Function Student Name udent Number (Predict the cxpected incomc based on actual incomc) Class Work 17: The following income data for Ahmad Company, which start 1/1/2010, its income grow on a regular basis (linear regression) during the first 12 months of its operation Required: Usc TREND Function to predict the expected income for the following 6 months. Month TREND(known v's,known x's.new x's.const) Income 11,245.12 12,.272.73 12,344.55 12,481.82 12,557.27 12,645.45 12,134.12 12,829.09 12.899.09 13,020.91 13,090.91 13.208.18 where: Known-y's: is the set of y-values you already know in the relationship y-mx + b. Known_x's:is an optional set of x-values that you may already know in the relationship y mx b. New x's are new x-values for which you want TREND to return corresponding y-values. Const: is a logical value specifying whether to force the constant b to equal 0. 10 12 13 14 15 16 17 18