Microsoft Office Tutorials and References
In Depth Information
You will find these examples in the Excel Chapter 12 file:
1. On the HHold Income sheet, create names for the ranges A2:A1001 (HHol-
d_Income) and B2:B1001 (Purchases).
2. Use the names HHold_Income and Purchases you just created and calculate the
Slope, Intercept, and RSQ, using the Excel function Shift
3. Use the Forecast function to calculate the forecasted value if the Household
income is $60,000 and $150,000.
1. You may want
the entire range A1:B1001 by pressing the
* keys, and apply Create from selection with Excel 2010 or 2007
under the Formula ribbon or Insert
Create with Excel 2003 or
3. $229.65 and $463.65.