• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

LINEST

LINEST calculates a straight line that best fits your data, using the “least squares” method (see Figure 16.19).

Figure 16.19. LINEST results in both the slope (M) of the straight line and y-intercept (b) that fits the data.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint