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.
Search JabSto ::




Custom Search