Producing hundreds of Multiple Regression analysis scenarios simultaneously

Have you tried using Excel's built in worksheet functions for this?

The regression and several of those statistics can be computed using the LINEST() function https://support.office.com/en-us/art...a-fa7abf772b6d .
The other statistics can usually be computed from the LINEST() results or other statistical functions: https://support.office.com/en-us/art...rs=en-US&ad=US
I cannot tell what you used for the input ranges for each individual regression, but it looks like you want to separate the the "colored" blocks. With the right combination of relative and absolute references and/or clever uses of the OFFSET() function, you can enter the LINEST() and other functions once, then copy and paste.

I posted an example of using LINEST() and other statistics functions in this way here: http://www.excelforum.com/excel-gene...ml#post4349407

You have a lot of answers on this sheet. How are you generating them and which ones do you want to look at?

LINEST might work for some of this, but I suggest that instead of using fixed ranges, you use an array formula to decide what data to look at.

The way I would set this up is to put two pivot tables against the data - one for role and one for country. This will give me a unique list of names for each. Then set up the LINEST formulas based on ranges driven by a country and role selection. Then loop through country and role and change these cells.

I could set this up if you will tell me which LINEST values you want to look at. Basically I'm confused by all the stuff in columns L on.

Rule 08: Cross-posting Without Links

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.