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.
Sergio E. Obando (2023). 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 CompatibilityWindows macOS Linux
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!