Machine learning toolkit for Excel
$begingroup$
Do you know of any machine learning add-ins that I could use within Excel? For example I would like to be able to select a range of data and use that for training purposes and then use another sheet for getting the results of different learning algorithms.
machine-learning neural-network
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
$endgroup$
|
show 1 more comment
$begingroup$
Do you know of any machine learning add-ins that I could use within Excel? For example I would like to be able to select a range of data and use that for training purposes and then use another sheet for getting the results of different learning algorithms.
machine-learning neural-network
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
$endgroup$
2
$begingroup$
Are there any specific reasons to do the analysis inside Excel? Maybe exporting the data to a data science tool is more appropriate.
$endgroup$
– Amir Ali Akbari
Jan 27 '15 at 16:04
$begingroup$
I basically have Excel spreadsheets where we do a lot of our analysis and fed up of exporting the data to other tools. I just want to do the analysis in Excel.
$endgroup$
– Dimitris
Jan 27 '15 at 16:21
1
$begingroup$
Mathematica has some machine learning algorithms and can read Excel spreadsheets directly.
$endgroup$
– image_doctor
Jan 27 '15 at 17:38
$begingroup$
If you really want to use an Excel add-in, the XLMiner package is a solid option, although expensive: solver.com/xlminer-data-mining
$endgroup$
– Paul
Jan 28 '15 at 19:02
$begingroup$
Take a look at bettersheet.com This product allows you to do machine learning directly in Excel
$endgroup$
– Matt Bolds
Jun 28 '17 at 0:46
|
show 1 more comment
$begingroup$
Do you know of any machine learning add-ins that I could use within Excel? For example I would like to be able to select a range of data and use that for training purposes and then use another sheet for getting the results of different learning algorithms.
machine-learning neural-network
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
$endgroup$
Do you know of any machine learning add-ins that I could use within Excel? For example I would like to be able to select a range of data and use that for training purposes and then use another sheet for getting the results of different learning algorithms.
machine-learning neural-network
machine-learning neural-network
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
asked Jan 27 '15 at 15:13
DimitrisDimitris
131115
131115
2
$begingroup$
Are there any specific reasons to do the analysis inside Excel? Maybe exporting the data to a data science tool is more appropriate.
$endgroup$
– Amir Ali Akbari
Jan 27 '15 at 16:04
$begingroup$
I basically have Excel spreadsheets where we do a lot of our analysis and fed up of exporting the data to other tools. I just want to do the analysis in Excel.
$endgroup$
– Dimitris
Jan 27 '15 at 16:21
1
$begingroup$
Mathematica has some machine learning algorithms and can read Excel spreadsheets directly.
$endgroup$
– image_doctor
Jan 27 '15 at 17:38
$begingroup$
If you really want to use an Excel add-in, the XLMiner package is a solid option, although expensive: solver.com/xlminer-data-mining
$endgroup$
– Paul
Jan 28 '15 at 19:02
$begingroup$
Take a look at bettersheet.com This product allows you to do machine learning directly in Excel
$endgroup$
– Matt Bolds
Jun 28 '17 at 0:46
|
show 1 more comment
2
$begingroup$
Are there any specific reasons to do the analysis inside Excel? Maybe exporting the data to a data science tool is more appropriate.
$endgroup$
– Amir Ali Akbari
Jan 27 '15 at 16:04
$begingroup$
I basically have Excel spreadsheets where we do a lot of our analysis and fed up of exporting the data to other tools. I just want to do the analysis in Excel.
$endgroup$
– Dimitris
Jan 27 '15 at 16:21
1
$begingroup$
Mathematica has some machine learning algorithms and can read Excel spreadsheets directly.
$endgroup$
– image_doctor
Jan 27 '15 at 17:38
$begingroup$
If you really want to use an Excel add-in, the XLMiner package is a solid option, although expensive: solver.com/xlminer-data-mining
$endgroup$
– Paul
Jan 28 '15 at 19:02
$begingroup$
Take a look at bettersheet.com This product allows you to do machine learning directly in Excel
$endgroup$
– Matt Bolds
Jun 28 '17 at 0:46
2
2
$begingroup$
Are there any specific reasons to do the analysis inside Excel? Maybe exporting the data to a data science tool is more appropriate.
$endgroup$
– Amir Ali Akbari
Jan 27 '15 at 16:04
$begingroup$
Are there any specific reasons to do the analysis inside Excel? Maybe exporting the data to a data science tool is more appropriate.
$endgroup$
– Amir Ali Akbari
Jan 27 '15 at 16:04
$begingroup$
I basically have Excel spreadsheets where we do a lot of our analysis and fed up of exporting the data to other tools. I just want to do the analysis in Excel.
$endgroup$
– Dimitris
Jan 27 '15 at 16:21
$begingroup$
I basically have Excel spreadsheets where we do a lot of our analysis and fed up of exporting the data to other tools. I just want to do the analysis in Excel.
$endgroup$
– Dimitris
Jan 27 '15 at 16:21
1
1
$begingroup$
Mathematica has some machine learning algorithms and can read Excel spreadsheets directly.
$endgroup$
– image_doctor
Jan 27 '15 at 17:38
$begingroup$
Mathematica has some machine learning algorithms and can read Excel spreadsheets directly.
$endgroup$
– image_doctor
Jan 27 '15 at 17:38
$begingroup$
If you really want to use an Excel add-in, the XLMiner package is a solid option, although expensive: solver.com/xlminer-data-mining
$endgroup$
– Paul
Jan 28 '15 at 19:02
$begingroup$
If you really want to use an Excel add-in, the XLMiner package is a solid option, although expensive: solver.com/xlminer-data-mining
$endgroup$
– Paul
Jan 28 '15 at 19:02
$begingroup$
Take a look at bettersheet.com This product allows you to do machine learning directly in Excel
$endgroup$
– Matt Bolds
Jun 28 '17 at 0:46
$begingroup$
Take a look at bettersheet.com This product allows you to do machine learning directly in Excel
$endgroup$
– Matt Bolds
Jun 28 '17 at 0:46
|
show 1 more comment
7 Answers
7
active
oldest
votes
$begingroup$
As far as I know, currently there are not that many projects and products that allow you to perform serious machine learning (ML) work from within Excel.
However, the situation seems to be changing rapidly due to active Microsoft's efforts in popularizing its ML cloud platform Azure ML (along with ML Studio). The recent acquisition of R-focused company Revolution Analytics by Microsoft (which appears to me as more of acqui-hiring to a large extent) is an example of the company's aggressive data science market strategy.
In regard to ML toolkits for Excel, as a confirmation that we should expect most Excel-enabled ML projects and products to be Azure ML-focused, consider the following two projects (the latter is an open source):
Excel DataScope (Microsoft Research): https://www.microsoft.com/en-us/research/video/excel-datascope-overview/
Azure ML Excel Add-In (seems to be Microsoft sponsored): https://azuremlexcel.codeplex.com
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
$endgroup$
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
add a comment |
$begingroup$
(Most) Machine Learning algorithms are essentially optimization problems where you minimize/maximize an objective function subject to certain constraints. Excel comes with the Solver add-in which is pretty handy for lightweight problems, so it is entirely possible for you to build a Machine Learning model within Excel! (I've done it myself)
If your data size is reasonably small (say <10k rows and not too many columns), it is in fact pretty quick and easy to build certain ML models within Excel. All you need is to learn how to use the Excel Solver, and the built-in matrix functions for vectorized computations.
For example, Neural Networks and Logistic Regressions are particularly easy to build due to the simplicity of their objective function. If you are really inclined to try you could refer to the following link:
http://www.xlpert.com/ebook/Build_Neural_Network_With_MS_Excel_sample.pdf
Now, Excel does has major limitations. There are numerical stability issues, it is tricky to write loops (without VBA), it is a pain to write lengthy functions in Excel and there's no concept of structure so I wouldn't try to build things like Random Forest. That being said, there is still a good amount of algorithms you can implement with Excel for fun.
Of course, for serious analysis, I would still recommend you to use proper tools for that.
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
$endgroup$
add a comment |
$begingroup$
First of all, let me tell you that Excel shouldn't be used for machine learning or any data analysis complicated enough that you wouldn't be comfortable doing it on paper. Why? Here is a list of resources to tell you why:
- You shouldn’t use a spreadsheet for important work (I mean it)
- Destroy Your Data Using Excel With This One Weird Trick!
- Using Excel for Statistical Data Analysis - Caveats
- Problems with Excel
- Spreadsheet Addiction
Now, if you really really want to do heavy calculations without exporting your data, I suggest using xlwings. Basically, this allows two-way communication between Excel and Python. Watch the video in the homepage for a quick introduction. In this way, you would be able to use numpy, pandas and scikit-learn (or other machine learning library that you may prefer) without exporting your data first.
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
$endgroup$
1
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
1
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
1
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
1
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
add a comment |
$begingroup$
Nobody does serious machine learning in Excel; that's not what it's for. Fortunately, you can directly import Excel files into better platforms like python. In particular, there's a great package called pandas, which makes work very pleasant. Here's a demo.
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
$endgroup$
2
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
2
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
add a comment |
$begingroup$
Weka can import CSV files, and allows you to choose which columns and rows you want to use in your analysis. It's not an "add-in" for Excel per-se, but it might work for you.
answered Jan 28 '15 at 4:34
alexwalexw
1335
$endgroup$
add a comment |
$begingroup$
You can find an Excel and VBA implementation of Random Forest using the open source ALGLIB Library here
answered Oct 10 '17 at 14:39
purbanipurbani
1
$endgroup$
add a comment |
$begingroup$
Vortarus Technologies LLC here also have an Excel Add-In that can do various intermediate ML tasks from SVM to Neural Nets to CART etc. The free trial is open ended but has some function limits.
answered 8 mins ago
purbanipurbani
1
$endgroup$
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "557"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f4957%2fmachine-learning-toolkit-for-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
7 Answers
7
active
oldest
votes
7 Answers
7
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
As far as I know, currently there are not that many projects and products that allow you to perform serious machine learning (ML) work from within Excel.
However, the situation seems to be changing rapidly due to active Microsoft's efforts in popularizing its ML cloud platform Azure ML (along with ML Studio). The recent acquisition of R-focused company Revolution Analytics by Microsoft (which appears to me as more of acqui-hiring to a large extent) is an example of the company's aggressive data science market strategy.
In regard to ML toolkits for Excel, as a confirmation that we should expect most Excel-enabled ML projects and products to be Azure ML-focused, consider the following two projects (the latter is an open source):
Excel DataScope (Microsoft Research): https://www.microsoft.com/en-us/research/video/excel-datascope-overview/
Azure ML Excel Add-In (seems to be Microsoft sponsored): https://azuremlexcel.codeplex.com
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
$endgroup$
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
add a comment |
$begingroup$
As far as I know, currently there are not that many projects and products that allow you to perform serious machine learning (ML) work from within Excel.
However, the situation seems to be changing rapidly due to active Microsoft's efforts in popularizing its ML cloud platform Azure ML (along with ML Studio). The recent acquisition of R-focused company Revolution Analytics by Microsoft (which appears to me as more of acqui-hiring to a large extent) is an example of the company's aggressive data science market strategy.
In regard to ML toolkits for Excel, as a confirmation that we should expect most Excel-enabled ML projects and products to be Azure ML-focused, consider the following two projects (the latter is an open source):
Excel DataScope (Microsoft Research): https://www.microsoft.com/en-us/research/video/excel-datascope-overview/
Azure ML Excel Add-In (seems to be Microsoft sponsored): https://azuremlexcel.codeplex.com
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
$endgroup$
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
add a comment |
$begingroup$
As far as I know, currently there are not that many projects and products that allow you to perform serious machine learning (ML) work from within Excel.
However, the situation seems to be changing rapidly due to active Microsoft's efforts in popularizing its ML cloud platform Azure ML (along with ML Studio). The recent acquisition of R-focused company Revolution Analytics by Microsoft (which appears to me as more of acqui-hiring to a large extent) is an example of the company's aggressive data science market strategy.
In regard to ML toolkits for Excel, as a confirmation that we should expect most Excel-enabled ML projects and products to be Azure ML-focused, consider the following two projects (the latter is an open source):
Excel DataScope (Microsoft Research): https://www.microsoft.com/en-us/research/video/excel-datascope-overview/
Azure ML Excel Add-In (seems to be Microsoft sponsored): https://azuremlexcel.codeplex.com
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
$endgroup$
As far as I know, currently there are not that many projects and products that allow you to perform serious machine learning (ML) work from within Excel.
However, the situation seems to be changing rapidly due to active Microsoft's efforts in popularizing its ML cloud platform Azure ML (along with ML Studio). The recent acquisition of R-focused company Revolution Analytics by Microsoft (which appears to me as more of acqui-hiring to a large extent) is an example of the company's aggressive data science market strategy.
In regard to ML toolkits for Excel, as a confirmation that we should expect most Excel-enabled ML projects and products to be Azure ML-focused, consider the following two projects (the latter is an open source):
Excel DataScope (Microsoft Research): https://www.microsoft.com/en-us/research/video/excel-datascope-overview/
Azure ML Excel Add-In (seems to be Microsoft sponsored): https://azuremlexcel.codeplex.com
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
edited Sep 7 '18 at 3:24
Stephen Rauch
1,52751129
1,52751129
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
answered Jan 28 '15 at 10:33
Aleksandr Blekh♦Aleksandr Blekh
5,91811747
5,91811747
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
add a comment |
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
That's what I was asking for.
$endgroup$
– Dimitris
Jan 28 '15 at 10:39
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
$begingroup$
@Dimitris: You're welcome. Glad that you like my answer.
$endgroup$
– Aleksandr Blekh♦
Jan 28 '15 at 11:03
add a comment |
$begingroup$
(Most) Machine Learning algorithms are essentially optimization problems where you minimize/maximize an objective function subject to certain constraints. Excel comes with the Solver add-in which is pretty handy for lightweight problems, so it is entirely possible for you to build a Machine Learning model within Excel! (I've done it myself)
If your data size is reasonably small (say <10k rows and not too many columns), it is in fact pretty quick and easy to build certain ML models within Excel. All you need is to learn how to use the Excel Solver, and the built-in matrix functions for vectorized computations.
For example, Neural Networks and Logistic Regressions are particularly easy to build due to the simplicity of their objective function. If you are really inclined to try you could refer to the following link:
http://www.xlpert.com/ebook/Build_Neural_Network_With_MS_Excel_sample.pdf
Now, Excel does has major limitations. There are numerical stability issues, it is tricky to write loops (without VBA), it is a pain to write lengthy functions in Excel and there's no concept of structure so I wouldn't try to build things like Random Forest. That being said, there is still a good amount of algorithms you can implement with Excel for fun.
Of course, for serious analysis, I would still recommend you to use proper tools for that.
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
$endgroup$
add a comment |
$begingroup$
(Most) Machine Learning algorithms are essentially optimization problems where you minimize/maximize an objective function subject to certain constraints. Excel comes with the Solver add-in which is pretty handy for lightweight problems, so it is entirely possible for you to build a Machine Learning model within Excel! (I've done it myself)
If your data size is reasonably small (say <10k rows and not too many columns), it is in fact pretty quick and easy to build certain ML models within Excel. All you need is to learn how to use the Excel Solver, and the built-in matrix functions for vectorized computations.
For example, Neural Networks and Logistic Regressions are particularly easy to build due to the simplicity of their objective function. If you are really inclined to try you could refer to the following link:
http://www.xlpert.com/ebook/Build_Neural_Network_With_MS_Excel_sample.pdf
Now, Excel does has major limitations. There are numerical stability issues, it is tricky to write loops (without VBA), it is a pain to write lengthy functions in Excel and there's no concept of structure so I wouldn't try to build things like Random Forest. That being said, there is still a good amount of algorithms you can implement with Excel for fun.
Of course, for serious analysis, I would still recommend you to use proper tools for that.
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
$endgroup$
add a comment |
$begingroup$
(Most) Machine Learning algorithms are essentially optimization problems where you minimize/maximize an objective function subject to certain constraints. Excel comes with the Solver add-in which is pretty handy for lightweight problems, so it is entirely possible for you to build a Machine Learning model within Excel! (I've done it myself)
If your data size is reasonably small (say <10k rows and not too many columns), it is in fact pretty quick and easy to build certain ML models within Excel. All you need is to learn how to use the Excel Solver, and the built-in matrix functions for vectorized computations.
For example, Neural Networks and Logistic Regressions are particularly easy to build due to the simplicity of their objective function. If you are really inclined to try you could refer to the following link:
http://www.xlpert.com/ebook/Build_Neural_Network_With_MS_Excel_sample.pdf
Now, Excel does has major limitations. There are numerical stability issues, it is tricky to write loops (without VBA), it is a pain to write lengthy functions in Excel and there's no concept of structure so I wouldn't try to build things like Random Forest. That being said, there is still a good amount of algorithms you can implement with Excel for fun.
Of course, for serious analysis, I would still recommend you to use proper tools for that.
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
$endgroup$
(Most) Machine Learning algorithms are essentially optimization problems where you minimize/maximize an objective function subject to certain constraints. Excel comes with the Solver add-in which is pretty handy for lightweight problems, so it is entirely possible for you to build a Machine Learning model within Excel! (I've done it myself)
If your data size is reasonably small (say <10k rows and not too many columns), it is in fact pretty quick and easy to build certain ML models within Excel. All you need is to learn how to use the Excel Solver, and the built-in matrix functions for vectorized computations.
For example, Neural Networks and Logistic Regressions are particularly easy to build due to the simplicity of their objective function. If you are really inclined to try you could refer to the following link:
http://www.xlpert.com/ebook/Build_Neural_Network_With_MS_Excel_sample.pdf
Now, Excel does has major limitations. There are numerical stability issues, it is tricky to write loops (without VBA), it is a pain to write lengthy functions in Excel and there's no concept of structure so I wouldn't try to build things like Random Forest. That being said, there is still a good amount of algorithms you can implement with Excel for fun.
Of course, for serious analysis, I would still recommend you to use proper tools for that.
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
answered Nov 29 '16 at 20:33
aranelladenaranelladen
615
615
add a comment |
add a comment |
$begingroup$
First of all, let me tell you that Excel shouldn't be used for machine learning or any data analysis complicated enough that you wouldn't be comfortable doing it on paper. Why? Here is a list of resources to tell you why:
- You shouldn’t use a spreadsheet for important work (I mean it)
- Destroy Your Data Using Excel With This One Weird Trick!
- Using Excel for Statistical Data Analysis - Caveats
- Problems with Excel
- Spreadsheet Addiction
Now, if you really really want to do heavy calculations without exporting your data, I suggest using xlwings. Basically, this allows two-way communication between Excel and Python. Watch the video in the homepage for a quick introduction. In this way, you would be able to use numpy, pandas and scikit-learn (or other machine learning library that you may prefer) without exporting your data first.
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
$endgroup$
1
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
1
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
1
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
1
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
add a comment |
$begingroup$
First of all, let me tell you that Excel shouldn't be used for machine learning or any data analysis complicated enough that you wouldn't be comfortable doing it on paper. Why? Here is a list of resources to tell you why:
- You shouldn’t use a spreadsheet for important work (I mean it)
- Destroy Your Data Using Excel With This One Weird Trick!
- Using Excel for Statistical Data Analysis - Caveats
- Problems with Excel
- Spreadsheet Addiction
Now, if you really really want to do heavy calculations without exporting your data, I suggest using xlwings. Basically, this allows two-way communication between Excel and Python. Watch the video in the homepage for a quick introduction. In this way, you would be able to use numpy, pandas and scikit-learn (or other machine learning library that you may prefer) without exporting your data first.
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
$endgroup$
1
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
1
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
1
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
1
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
add a comment |
$begingroup$
First of all, let me tell you that Excel shouldn't be used for machine learning or any data analysis complicated enough that you wouldn't be comfortable doing it on paper. Why? Here is a list of resources to tell you why:
- You shouldn’t use a spreadsheet for important work (I mean it)
- Destroy Your Data Using Excel With This One Weird Trick!
- Using Excel for Statistical Data Analysis - Caveats
- Problems with Excel
- Spreadsheet Addiction
Now, if you really really want to do heavy calculations without exporting your data, I suggest using xlwings. Basically, this allows two-way communication between Excel and Python. Watch the video in the homepage for a quick introduction. In this way, you would be able to use numpy, pandas and scikit-learn (or other machine learning library that you may prefer) without exporting your data first.
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
$endgroup$
First of all, let me tell you that Excel shouldn't be used for machine learning or any data analysis complicated enough that you wouldn't be comfortable doing it on paper. Why? Here is a list of resources to tell you why:
- You shouldn’t use a spreadsheet for important work (I mean it)
- Destroy Your Data Using Excel With This One Weird Trick!
- Using Excel for Statistical Data Analysis - Caveats
- Problems with Excel
- Spreadsheet Addiction
Now, if you really really want to do heavy calculations without exporting your data, I suggest using xlwings. Basically, this allows two-way communication between Excel and Python. Watch the video in the homepage for a quick introduction. In this way, you would be able to use numpy, pandas and scikit-learn (or other machine learning library that you may prefer) without exporting your data first.
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
edited Jan 28 '15 at 17:00
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
answered Jan 28 '15 at 4:42
Robert SmithRobert Smith
69547
69547
1
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
1
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
1
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
1
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
add a comment |
1
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
1
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
1
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
1
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
1
1
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
$begingroup$
I work with many clients who do a lot of their work in Excel. You can mess up your R scripts like you can mess up in Matlab or anything else. I totally disagree.
$endgroup$
– Dimitris
Jan 28 '15 at 9:55
1
1
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
$begingroup$
The fact that other people do it doesn't mean it is the right to thing to do. It is not about messing up because as you said, it is quite possible to make mistakes in R or Python. However, the difference is that you are more likely to mess up in Excel than in other tools more suitable to analytics, statistics or machine learning. I added some more links in case you need convincing.
$endgroup$
– Robert Smith
Jan 28 '15 at 16:57
1
1
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
I have been using and customising Excel for all sorts of things for the last 15 years. I am sure you can produce 100 links discussing how bad it can be but from personal experience I know you can control it and use all its capabilities without messing up anything. Visual programming which is what Excel offers is a brilliant concept. Just because something is trendy like Python at the moment doesn't necessarily mean is the best option.
$endgroup$
– Dimitris
Jan 28 '15 at 17:08
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
$begingroup$
And how do you know you're not messing up anything? People make mistakes precisely because they are not easy to spot. Again, this happens in all sorts of environments, but it is more likely in Excel. However, if you want to keep using Excel for heavy calculations, go ahead.
$endgroup$
– Robert Smith
Jan 28 '15 at 18:18
1
1
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
$begingroup$
I know I am not messing up anything because I design the entire thing and have control. So far I haven't had any difficult situation in Excel. I guess Microsoft Research looking into using Excel Add-ins says something to you.
$endgroup$
– Dimitris
Jan 28 '15 at 19:20
add a comment |
$begingroup$
Nobody does serious machine learning in Excel; that's not what it's for. Fortunately, you can directly import Excel files into better platforms like python. In particular, there's a great package called pandas, which makes work very pleasant. Here's a demo.
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
$endgroup$
2
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
2
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
add a comment |
$begingroup$
Nobody does serious machine learning in Excel; that's not what it's for. Fortunately, you can directly import Excel files into better platforms like python. In particular, there's a great package called pandas, which makes work very pleasant. Here's a demo.
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
$endgroup$
2
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
2
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
add a comment |
$begingroup$
Nobody does serious machine learning in Excel; that's not what it's for. Fortunately, you can directly import Excel files into better platforms like python. In particular, there's a great package called pandas, which makes work very pleasant. Here's a demo.
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
$endgroup$
Nobody does serious machine learning in Excel; that's not what it's for. Fortunately, you can directly import Excel files into better platforms like python. In particular, there's a great package called pandas, which makes work very pleasant. Here's a demo.
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
answered Jan 28 '15 at 5:53
EmreEmre
8,51011935
8,51011935
2
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
2
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
add a comment |
2
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
2
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
2
2
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
I guess you haven't had the experience I had with a lot of my clients working in Excel. "Nobody does serious ML in Excel", really??? That's the best you can do?
$endgroup$
– Dimitris
Jan 28 '15 at 9:56
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
$begingroup$
If you want to make your work difficult, be my guest :) Once I was asked to deliver an ML presentation at a company that used Excel. They liked the content but were initially taken aback by the software. Well, I had better things to do than try to craft a silk purse out of a sow's ear. Give pandas a try; you'll quickly come to like it.
$endgroup$
– Emre
Jan 28 '15 at 15:12
2
2
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
$begingroup$
I have worked with Pandas and I regularly use R however I cannot dismiss Excel simply because there is a perception out there that its old, cumbersome and must go. I think there is a lot you can do with it and our clients rely on it.
$endgroup$
– Dimitris
Jan 28 '15 at 16:52
add a comment |
$begingroup$
Weka can import CSV files, and allows you to choose which columns and rows you want to use in your analysis. It's not an "add-in" for Excel per-se, but it might work for you.
answered Jan 28 '15 at 4:34
alexwalexw
1335
$endgroup$
add a comment |
$begingroup$
Weka can import CSV files, and allows you to choose which columns and rows you want to use in your analysis. It's not an "add-in" for Excel per-se, but it might work for you.
answered Jan 28 '15 at 4:34
alexwalexw
1335
$endgroup$
add a comment |
$begingroup$
Weka can import CSV files, and allows you to choose which columns and rows you want to use in your analysis. It's not an "add-in" for Excel per-se, but it might work for you.
answered Jan 28 '15 at 4:34
alexwalexw
1335
$endgroup$
Weka can import CSV files, and allows you to choose which columns and rows you want to use in your analysis. It's not an "add-in" for Excel per-se, but it might work for you.
answered Jan 28 '15 at 4:34
alexwalexw
1335
answered Jan 28 '15 at 4:34
alexwalexw
1335
answered Jan 28 '15 at 4:34
alexwalexw
1335
answered Jan 28 '15 at 4:34
alexwalexw
1335
1335
add a comment |
add a comment |
$begingroup$
You can find an Excel and VBA implementation of Random Forest using the open source ALGLIB Library here
answered Oct 10 '17 at 14:39
purbanipurbani
1
$endgroup$
add a comment |
$begingroup$
You can find an Excel and VBA implementation of Random Forest using the open source ALGLIB Library here
answered Oct 10 '17 at 14:39
purbanipurbani
1
$endgroup$
add a comment |
$begingroup$
You can find an Excel and VBA implementation of Random Forest using the open source ALGLIB Library here
answered Oct 10 '17 at 14:39
purbanipurbani
1
$endgroup$
You can find an Excel and VBA implementation of Random Forest using the open source ALGLIB Library here
answered Oct 10 '17 at 14:39
purbanipurbani
1
answered Oct 10 '17 at 14:39
purbanipurbani
1
answered Oct 10 '17 at 14:39
purbanipurbani
1
answered Oct 10 '17 at 14:39
purbanipurbani
1
1
add a comment |
add a comment |
$begingroup$
Vortarus Technologies LLC here also have an Excel Add-In that can do various intermediate ML tasks from SVM to Neural Nets to CART etc. The free trial is open ended but has some function limits.
answered 8 mins ago
purbanipurbani
1
$endgroup$
add a comment |
$begingroup$
Vortarus Technologies LLC here also have an Excel Add-In that can do various intermediate ML tasks from SVM to Neural Nets to CART etc. The free trial is open ended but has some function limits.
answered 8 mins ago
purbanipurbani
1
$endgroup$
add a comment |
$begingroup$
Vortarus Technologies LLC here also have an Excel Add-In that can do various intermediate ML tasks from SVM to Neural Nets to CART etc. The free trial is open ended but has some function limits.
answered 8 mins ago
purbanipurbani
1
$endgroup$
Vortarus Technologies LLC here also have an Excel Add-In that can do various intermediate ML tasks from SVM to Neural Nets to CART etc. The free trial is open ended but has some function limits.
answered 8 mins ago
purbanipurbani
1
answered 8 mins ago
purbanipurbani
1
answered 8 mins ago
purbanipurbani
1
answered 8 mins ago
purbanipurbani
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Data Science Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f4957%2fmachine-learning-toolkit-for-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
$begingroup$
Are there any specific reasons to do the analysis inside Excel? Maybe exporting the data to a data science tool is more appropriate.
$endgroup$
– Amir Ali Akbari
Jan 27 '15 at 16:04
$begingroup$
I basically have Excel spreadsheets where we do a lot of our analysis and fed up of exporting the data to other tools. I just want to do the analysis in Excel.
$endgroup$
– Dimitris
Jan 27 '15 at 16:21
1
$begingroup$
Mathematica has some machine learning algorithms and can read Excel spreadsheets directly.
$endgroup$
– image_doctor
Jan 27 '15 at 17:38
$begingroup$
If you really want to use an Excel add-in, the XLMiner package is a solid option, although expensive: solver.com/xlminer-data-mining
$endgroup$
– Paul
Jan 28 '15 at 19:02
$begingroup$
Take a look at bettersheet.com This product allows you to do machine learning directly in Excel
$endgroup$
– Matt Bolds
Jun 28 '17 at 0:46