how to call a column of data from excel into matlab

2 views (last 30 days)
I need to take the mean median and mode from a column of data in excel
first i tried using fopen filename but i keep getting back -1
xlsread RealEstate.xls ??? Error using ==> xlsread at 214 XLSREAD unable to open file RealEstate.xls. File C:\Program Files\Dell\DellDock\RealEstate.xls not found.

Accepted Answer

Srinivas on 8 May 2012
yourdata = xlsread(your file name);
then you can process it
help mean
help xlsread
help importfile
Srinivas on 9 May 2012
is 'RealEstate.xls' in the same folder, if not include path
yourdata = xlsread(your file name with complete path)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!