Beyond Excel: Enhancing Your Data Analysis with MATLAB (August 2017)
The webinar highlights how MATLAB can supplement the capabilities of Excel by providing access to thousands of pre-built engineering and advanced analysis functions and versatile visualization tools.
The code demonstrates the following concepts using vehicle fuel economy data:
• Access data from spreadsheets
• Plot data and customize figures
• Perform statistical analysis and fitting
• Automatically generate reports to document your analysis
• Create your own Apps and distribute them
Main script is "MainAnalysisLive.mlx" and requires the data folder "dataXLS" to be on the same path.
Additional file (AutomateAnalysis) shows how to run model over multiple files and collect the results.
Cite As
Sergio E. Obando (2024). Beyond Excel: Enhancing Your Data Analysis with MATLAB (August 2017) (https://www.mathworks.com/matlabcentral/fileexchange/64219-beyond-excel-enhancing-your-data-analysis-with-matlab-august-2017), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Acknowledgements
Inspired: Data analysis and visualization
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
MATLAB_for_Excel_Users/Demo_Files/
MATLAB_for_Excel_Users/Demo_Files/
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |