Question Info

How to use the forms controls on a worksheet in Excel

More Information.

Einfach SPSS-Korrelationstabelle (nur die Tabelle und nicht den Roh-Datensatz!) an unsere email-Adresse schicken: [email protected] Innerhalb von 3 Werktagen schicken wir Dir die transformierte Excel®*-Korrelationstabelle an die Absender-Emailadresse. In Excel können Sie die Korrelation zwischen zwei Variablen berechnen und so einen Zusammenhang begründen. Dabei hilft Ihnen eine einfache Formel.

exporting pwcorr matrix....I'm confused!

It just hit me, that there may be a simpler way. If you are absolutely sure that each of these variables takes on at least 10 distinct values, you can use -polychoric [varlist], pw- and then retrieve the matrix r R for use with -putexcel-. That's because polychoric does Pearson correlations between any variables that have at least 10 distinct values. But if any of your variables has fewer than 10 distinct values, you will get tetrachohric or polyserial correlations, as the case may be, instead of Pearsons.

SSC or possibly other sites has some commands that might be useful, e. The help for the latter says "mkcorr produces a correlation table in a format that is easy to import into a spreadsheet or word processing document.

I haven't tried any of these so I can't vouch for them. Richard and Clyde have great suggestions. But, given the size of your matrix and assuming I might be wrong that this is a one-off or occasional issue, simply store the log file as. Then you can easily read it into Excel or the equivalent as a fixed-width file, You may need to do a single copy-and-paste to get the last few variables into the matrix.

I like automating everything, but so long as the original data is intact and the steps are easy to repeat, this would be by far the most efficient. If you routinely run a log, turn it off, turn a new one on right before the pwcorr command, then don't forget to close. One quirk -- when looking for text files, I don't think they show up in Excel. So either look for all files, or deliberately rename your. I used to use Stata to generate correlation matrices, then slice-and-dice before bringing into Lisrel after processing in Excel.

So the process is intuitive to me but it's straightforward enough start import at line 14 or whatever and it's pretty good at choosing columns that I think you'll find it a piece of cake. I'll never I've come up with that in a million years! I'll try all the suggestions 'cos I do need the PW Corr matrix. I'll give a feedback on how far I'm able to go Dear, all - I'll make mention of this as it is something that I wanted to accomplish as well.

Fosse, PhD nathanfosse gmail. The weblink is attached, or just type: Here is yet another approach. I am learning more each day with trial and errors, but this is a new field for me in Excel. I like the formula you showed in regards to having a cell from a file show in the masterfile, but how could i modify that formula to instead look at all the files in a specified folder for a certain column?

Or would I need to manually enter in each file as we create them? That's where VBA code would come in to play!! It would then actually open each of those in turn, go to the specified worksheet and grab data from the specified column on that sheet. The folder can be determined in several ways: Then of course, the macro has to know where to put that information, or what to do with it in the way of processing and where to put the results in the master workbook.

One 'trick' to doing this kind of thing is to keep up with what other workbooks or records within them have already been processed so that multiple copies of previously processed data are not generated.

Alternatively, you can create the links using a macro: This, for example, will create multiple links to cells in a workbook that you choose in a dialog without actually opening the file so you need to know the sheet name, and cell addresses, but this is just an example, of course, and similar code can do more. I will check it out and see what I can do with the information you have given me.

As I said before, I am new to this portion of Excel, but I am learning more each day and your help has been more than grateful! Good luck with it all. If you need help, you can usually get it very rapidly through this forum. All of that takes under 1 second to do on this 3. There's also a section in the code that shows how you might open each one of the files found and work with it - but the code is set up to jump over that section just to make sure errors don't occur while trying to process data in a workbook that doesn't have a particular sheet in it.

But that might give you an idea of how to deal with that part of things later. Tell us about your experience with our site. PlasticResources Created on January 23, Good morning, I am trying to develop a spreadsheet for our company at the moment to show real time updates on inventory. We have a folder specifically for inbound and one for outbound, with item codes for each material.

What I am wanting to know is there a way for me to point Excel to Folder A and then to Folder B then get the sum as a real time update?

I know there may be some scripting involved possibly, just wanting to know if this is possible and how I may need to go about doing it. Thanks, Michael Plastic Resources, Inc. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Bernie Deitrick Replied on January 23, Really, just about anything is possible.

You can open and read files using VBA, extract data using data connections that are refreshed, create formulas that read files - the options are pretty wide and the best solution depends on your specifics and how you like to work.

Korrelationskoeffizienten berechnen

In reply to PlasticResources's post on January 23,

Closed On:

One 'trick' to doing this kind of thing is to keep up with what other workbooks or records within them have already been processed so that multiple copies of previously processed data are not generated.

Copyright © 2015

Powered By