File Exchange

image thumbnail

Beyond Excel: Enhancing Your Data Analysis with MATLAB (August 2017)

version 1.0.0.0 (5.95 MB) by Sergio
These are the files for the Webinar "MATLAB for Excel Users" which was presented in August 2017.

34 Downloads

Updated 28 Aug 2017

View License

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.

Comments and Ratings (6)

Sergio

@Oscar Sotomayor: I think you are referring to a different version of this webinar. That video and files (including DavisDaily) can be found here: https://www.mathworks.com/videos/matlab-for-excel-users-81634.html

Where is Davis.Daily.xlsx file I cannot find it in the documentation. Can somebody share it with me?

Sergio

@Carlos Meneses: Los archivos del webinario están adjuntos en el zip folder (dataXLS) a través del botón de Download en la parte superior. Los acabo de descargar para verificar el contenido. Cualquier problema por favor contactarnos directamente usando el enlace de soporte técnico. Gracias.

Buenas noches, no encuentro la carpeta con los archivos usados en el webinario. La verdad me gustaría practicar reproduciendo todos los pasos. ¿Podrían colgarlo en está página o escribir el link?

Muchas gracias.

Sergio

@VaCaballero: You can find several versions of the raw original files. Please check https://www.fueleconomy.gov/feg/download.shtml or https://www.epa.gov/compliance-and-fuel-economy-data/data-cars-used-testing-fuel-economy

VaCaballero

Could you post the raw xlsx file?

MATLAB Release Compatibility
Created with R2017a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Categories

MATLAB_for_Excel_Users/Demo_Files/