That's an excellent question. You could ask Claude in Excel using any model to perform a correlation analysis by generating a scatterplot across two datasets. You'd have to specify a column to join on, that may or not be able to be joined.
For instance, figuring out how to line up monthly measurements against daily measurements would be very difficult, but in Correlation Studio you can simply specify your join keys in the Dataset Wizard's Column Editor and coerce them to Date.
But researchers need more than that. They need to find & harvest datasets. They need scale. They need sample sizes, filtering rules and discovery capabilities. They need Correlation Studio for that.
For instance, you wouldn't be able give Excel & Claude a hundred files with millions of rows & gigabytes of data & have them perform full-matrix correlation analysis across every column pair to discover previously unseen correlations, which is where we excel. Depending on your dataset sizes column counts that's potentially many gigabytes of output, most of it noise. Not something you can work with in Excel.
For the Correlation Studio rollout, building Corrie's corpus, I took 20 commodity datasets and combined them with each other, but also dozens of other leading economic indicator datasets like S&P 500, GDP, price of oil, etc. It was around 50 files total. That generated 2.3K Experiments yielding 23K Discoveries that are all live on the website in just a few clicks.
The Discoveries were also filtered by Experiment rules that specify an absolute r threshold, sample size and filtering requirements ensuring empty or invalid results are not included. Each one lives an interactive scatterplot or line-chart on the web, with dataset drill-down using a simple mouse lasso - even plotted on a map if there's geospatial data. Correlation Studio also adds best-fit regression formulas Lead/Lag analysis & Rolling Regression charts instantly. One more click gets you Granger Causality and AI Analysis that takes all of the column and other dataset attributes into consideration, as well as the time frame of the datasets, to produce analysis that Excel Claude cannot provide.
I've added some images and a live link for reference. Correlation Studio provides for the acquisition of the data with its Remote Dataset Wizard, mapping of column metadata for datasets, Experiment creation & Discovery output. Building on top of that, it provides a mechanism to compile all of your work into a Portfolio that also lives on the site where users can Like, Rate and Comment on every part of it.
It's like combining Excel Claude Powerpoint SQL Cloud Storage Python and Sharepoint into a web app for discovering correlations. That's what we did. Add our Remote Dataset Wizard on the front and Corrie our chatbot on the back and you have a unique value proposition. There's nothing else like it on the market.
correlationstudio.com/welcom…