Microsoft Office Tutorials and References
In Depth Information
Review Questions
REVIEW QUESTIONS
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
F3.
3. Use the Forecast function to calculate the forecasted value if the Household
income is $60,000 and $150,000.
þ
ANSWERS
1. You may want
to select
the entire range A1:B1001 by pressing the
CRTL
* keys, and apply Create from selection with Excel 2010 or 2007
under the Formula ribbon or Insert
þ
Shift
þ
.
Name
.
Create with Excel 2003 or
earlier versions.
2. Slope
¼
0.0039. Intercept
¼
4.3532. RSQ
¼
0.4895.
3. $229.65 and $463.65.
 
Search JabSto ::




Custom Search