linest function on Mac

  • Thread starter Thread starter oshiroty
  • Start date Start date
O

oshiroty

For a regular PC, the following is done to fit a set of data:

1) =linest(y's, x's, true/false, true/false)
2) Enter
3) Highlight 2x5 box
4) F2
5) Control, Shift, Enter

For some reason, steps 4 and 5 do not perform the right operation on
Mac. Do you know if the last two steps' key strokes are different?

Thank you so much
 
1) =linest(y's, x's, true/false, true/false)

Just a guess, but make sure the last argument is set to True to return
additional information. When you say "2x5", I believe you meant that it is
a 5 x 2, meaning 5 Rows & 2 Columns.

HTH
 
When MS ported XL from the Mac to the PC, they changed the Edit Cell
shortcut from CTRL-u to F2, and the array-enter from CMD-RETURN to
CTRL-SHIFT-ENTER. Don't ask me why...

You can find other keyboard shortcuts in Mac XL Help.
 
Back
Top