Code covered by the BSD License  

Highlights from
Data Analysis with MATLAB for Excel Users

4.42857

4.4 | 9 ratings Rate this file 29 Downloads (last 30 days) File Size: 350.07 KB File ID: #14215
image thumbnail

Data Analysis with MATLAB for Excel Users

by Michael Agostini

 

09 Mar 2007 (Updated 13 Oct 2009)

Materials for public seminar of the same name (slides and demos)

| Watch this File

File Information
Description

Contains the slides and demos for the seminar entitled "Data Analysis with MATLAB for Excel Users", which was delivered on March 7th at the Newton Marriott in Newton, MA.

While a clever person could certainly make sense out of this material without having attended the seminar, it is designed to augment the live performance (not replace it). This means there are no detailed descriptions on how to run the various demos. Some of them require specific toolboxes to function.

Demo 1: Energy Prediction for a Power Plant -- Illustrates MATLAB's capabilities as a tool for data analysis. Shows features from MATLAB, Curve Fitting Toolbox, Statistics Toolbox, and Compiler.

Demo 2: Motor Noise Demo -- Illustrates two of MATLAB's integration methods with Excel including, Excel Link and Builder for Excel. This is actually a subset of the MATLAB for Excel Users webinar. Watch it here if interested (free, recorded):

http://www.mathworks.com/cmspro/req13810.html?eventid=40421

Demo 3: Introduction to MATLAB COM Interface -- shows the basics for using MATLAB as an activex client to connect to Excel. MATLAB can also be a server, though that is not shown here. The nice part about this section is nothing is required besides basic MATLAB.

Acknowledgements
This submission has inspired the following:
Files used in "Matlab For Excel Users" (Japanese version) / 「ExcelユーザのためのMATLAB」Webセミナーのファイル
Required Products Curve Fitting Toolbox
Spreadsheet Link EX
MATLAB Builder EX
MATLAB Compiler
Statistics Toolbox
MATLAB release MATLAB 7.4 (R2007a)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (9)
25 Apr 2007 melanie vanloocke  
25 Jun 2007 Marc Pelletier  
19 Jul 2007 Peter Sheppard

Thankyou for making the material available

19 Sep 2007 Peng Zhang  
26 Apr 2008 zied trabelsi

(file.m) for optimal inclination of photovoltaic panel and monthly solar irradiance

01 May 2008 zied trabelsi

(file.mdl)for optimal inclination of photovoltaic panel and monthly solar irradiance

02 May 2008 zied trabelsi

(file.m) mppt + photovoltaic

06 Nov 2008 haider daod

hellow can u help me plz i want to download this file can u send it to my mail thanx (file.m) mppt + photovoltaic haider_5566@yahoo.com

26 Jan 2010 muk  
Please login to add a comment or rating.
Updates
31 Jul 2009

Updated copyright notices.

07 Oct 2009

Cleaned up some text.

13 Oct 2009

Updated some comments in the files. No code changes.

Tag Activity for this File
Tag Applied By Date/Time
external interface Michael Agostini 22 Oct 2008 09:03:24
excel com activex builder Michael Agostini 22 Oct 2008 09:03:24
photovoltaic thanasis 04 May 2011 16:39:25

Contact us at files@mathworks.com