From the course: AI in Fintech Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Optimization and AI

Optimization and AI

From the course: AI in Fintech Essential Training

Start my 1-month free trial

Optimization and AI

- Once we've collected our data, whether in Excel or any other program. The next step in any data analysis project is always to go through and examine that data. And this is where AI can be very helpful. Let me show you how it's been done traditionally. So assuming that I had my data on say, economic variables, already put into Excel, and in columns B and C I've got the U.S Federal Reserve fund rate, and GDP per capita. Well if I wanted to go through, and calculate some sort of a correlation on these, I might go through and highlight these two columns, and either calculate it based on a formula, or use the data analysis tool pack under the data tab. That data analysis tool pack if you don't have this over on the far right could be added through file, options, scrolling down to add ins, magic cell add ins, and clicking go, and then you check the analysis tool pack. And it should now be available. And there's a lot of…

Contents