Best fit plane in Excel

Hi, there
Does anyone have the code to get a best fit plane in VBA?

Thanks.
Best regards,
Lily

Best-fit plane to a bunch of points {x,y,z}? You can use LINEST to regress z=ax+by+c. Post a workbook if you need help.

Like this:

       --D--- ---E--- ---F--- G --H-- --------------------I--------------------
   6     x       y       z       fit                                           
   7       12      53      98   71.22 H7 and down: =$E$15*D7 + $D$15*E7 + $F$15
   8       12      76      87   82.28                                          
   9       41      89      54   69.18                                          
  10       63      87      78   53.55                                          
  11       34      56       9   57.99                                          
  12       45      23      43   34.79                                          
  13                                                                           
  14                                                                           
  15   0.4808 -0.6670 53.7416         D15:F15: {=LINEST(F7:F12, D7:E12)}

Note that (1) D15:F15 is an array formula, (2) the coefficients appear in the order opposite the arguments in LINEST, and (3) it's not a great fit.

In your workbook, select D15:F15

Paste =LINEST(F7:F12, D7:E12) in the formula bar, but DON'T press Enter. Instead, press and hold the Ctrl and Shift keys, then press Enter.

Amit,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread