[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

Can I debug into Stats functions in Microsoft Excel

Dear Experts,
I need to know the specifics of how one of Excel's statistics operations works (to give you the very gory details I need to know how they calculate the standard error of the coefficients in a multivariate regression).

Can I debug into the regression procedure in Visual Basic?  If so can somebody tell me the steps?
Best Wishes,
Phil
0
PTRUSCOTT
Asked:
PTRUSCOTT
1 Solution
 
CodeCruiserCommented:
I don't think you can. With .NET, you can get the disassemble the IL code and get back C#/VB.NET code but Excel is written in C++ (probably) so I don't see a chance.
0
 
PTRUSCOTTAuthor Commented:
Really - what about if I find a way to install an earlier version of Excel.  I remember editing macros in Excel 2003 in VB.  Is there no way to do that with stats functions like regression?
-Phil
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now