Solved

Can I debug into Stats functions in Microsoft Excel

Posted on 2012-04-05
2
323 Views
Last Modified: 2012-06-27
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
Comment
Question by:PTRUSCOTT
2 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 37810279
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
 
LVL 1

Author Comment

by:PTRUSCOTT
ID: 37818254
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now