Solved

Can I debug into Stats functions in Microsoft Excel

Posted on 2012-04-05
2
349 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

688 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