Microsoft Office Tutorials and References

In Depth Information

**Syntax**

11. Total the number of independent variables and add one. This is

the number of columns the results of the regression will occupy.

In the snow cone cart example, that is four columns.

22. Figure out how many rows the result of the regression will oc-

cupy. Because you plan to ask for statistics in the snow cone

example, this is five rows. LINEST returns one row of results

and four rows of statistics, as shown in
Figure 14.16
.

Figure 14.16.

Figure 14.16.
When you have the

results, you can perform many more

tests and charts that test how good the regression model is.

When you have the LINEST

LINEST results, you can perform many more

tests and charts that test how good the regression model is.

33. Off to the side of the data, select a range that is four columns

wide by five columns tall. This size is determined by the results

of the first two steps.

44. Start to type the formula =LINEST(

=LINEST(.

55. For the known_y's, use the sales data in column E; this is

E4:E95.

66. For the known_x's, use the values for temperature, weekend, and

rain. This is B4:D95. Note that the dates in column A are not being

used as an independent variable. The amusement park is an es-

tablished park, and there is nothing to indicate that attendance

rises over the course of the season.