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.