Data Analysis with MATLAB for Excel Users

Поделиться
HTML-код
  • Опубликовано: 1 фев 2025

Комментарии • 86

  • @masso172
    @masso172 9 лет назад +108

    I have learned more about Matlab in the past 59 minutes than I have in class in the past two semesters. Wow...

  • @Speed001
    @Speed001 3 года назад +9

    6:43
    9:45 a classic problem when making a program like Matlab
    11:08 Import/Upload
    11:40 Import tool 12:16
    13:07 13:36
    16:31 18:03
    18:27
    19:22 19:54
    20:14
    20:57 21:43 22:05
    23:10 23:33 24:34
    24:44 gen code=save graph template
    25:17 25:30 25:57 *(So far this is just a really long way of doing the same templates you quickly do in Excel* but you have to:
    1. Properly format data in Excel (Format it in a new Excel file as XYZ without data above if you have a lot of rows) before importing it because you can't move/edit it,
    2. Import/Upload File (Hope it isn't too large or else it doesn't always work, if nothing happens it's too large. Again best you make a new Excel file to import.) And select columns/rows to import selected.
    3. then Plot tab it,
    4. edit plot format,
    5. then File>Generate Code while on the graph,
    6. then save the code as another MatLab code file,
    7a. (Repeat step 2 AKA) Make a new Excel sheet from your new data, format it, then Upload, open file, select data you want, right-click>import selection. To use any other new data.
    7b. then you can type the formula name and your new variable labels (with the properly formatted associated data in the worksheet if the MatLab code file is in your current folder)
    26:42 can color using the variable associated with the other properly formated data table.
    27:34 read the green text to learn.
    28:37 29:19
    30:29 What to do with blank data from Excel 30:46 You can make a rule to replace with text or to exclude it.
    31:43 Generate Function to get code with your rules (Excel must all have the same layout) to import Excel Data. Use to automate step 2.
    33:00 _Single Purple Quote means literal text, not a variable_
    32:54 Automation of Step 2.
    _33:53__ right-click>help on selection for formula explanation_
    34:42 (The fewer rows in this example are due to his rule to exclude empty cells) Can select and plot data in the variable's table.
    35:35 I guess tables are good for data (I'm still not sold on this over Excel)
    _36:41__ Up Arrow, __36:47__ __37:07__ Tab is autocomplete when you start typing, like in Excel._
    He did steps 7a and 7b again.
    37:50 What you've learned.
    38:23 38:37 Try to predict data. Test predicted data by predicting data you have.
    38:52 Split data using "Logical Indexing", (same type of indexing in Excel)
    39:10 Matrix Variable label(Row#,Column#) leads to> "Subscript Indexing" 39:19 39:29 Variable label([Row#,Column#],WholeColumn#) leads to> question 39:49
    then action
    Index on a variable range. 40:05
    Variable Label (VL)
    40:24 "VL=a

    • @christopherneufelt8971
      @christopherneufelt8971 3 года назад

      Thanks for the great work! But I can't find the part where epstein didn't kill himself.

    • @Speed001
      @Speed001 3 года назад

      @@christopherneufelt8971 That's at 69:42

  • @thomasberger8952
    @thomasberger8952 6 лет назад +6

    What a superb teacher! A pleasure to listen to, thoroughly professional and what great material he teaches. Brilliant, I learnt more in an hour than the combined tutorials I found on the net over the last 2 weeks. I would love to see more stuff from Adam....Bravo!

  • @sirespiloytv5272
    @sirespiloytv5272 3 года назад +1

    Got here because of finding the comparison of excel from matlab. First few minutes of watching I download the file, then few minutes of watching I subscribed to the channel, then few more minutes I click like button and now I commented. Very well said and clear discussing the basic in matlab. You are a more help to teachers like us.

  • @wsteve
    @wsteve 8 лет назад +1

    This is one of the best videos I have ever watched. I just hope python would quickly get rid of R so that no one would ever ask me to use R again.

  • @rostamr4096
    @rostamr4096 2 месяца назад

    I just came across this video. It's very helpful. Thank you. I hope you post more topics like this by this presenter.

    • @MATLAB
      @MATLAB  2 месяца назад

      Thanks for watching and for the kind words!

  • @deadapostle
    @deadapostle 8 лет назад +3

    This is exactly the video that I needed. I've been working with huge data sets in Excel and my job finally bought me Matlab and I basically just need to know how to make the transition. You've done that and also shown me just how much more powerful of a tool this can be for my needs.

  • @zecsv
    @zecsv 4 года назад

    You deserve to say "Thanks Kind Man!". Keep sharing your knowledge! I will do because you did!

  • @merrin0
    @merrin0 9 лет назад +4

    Great video! I think I could watch it many times and learn new steps as I learn more about MATLAB.

  • @bmcr104
    @bmcr104 8 лет назад +9

    I really wanted him to correct IMport to Import. I was going a little crazy every time his mouse moved towards the word.
    Really great video - thanks so much.

  • @gambu4810
    @gambu4810 6 лет назад +1

    You are simply the Best! I've never had such an effective programming lesson before in my life. Can I please suggest that you you specify your videos with a very distinct naming system that will make it Just stand out from all other similer youtube lectures. Salute to you! Nkululeko from South Africa.

  • @Speed001
    @Speed001 3 года назад +1

    I feel this video has helped me to become slightly more familiar with MatLab.
    I have an extensive background in Excel and basically no background in MatLab.
    When I take a course on MatLab I'll at least have some idea of where some of the basic features are and a few syntax things.

  • @kapilsaxena1
    @kapilsaxena1 8 лет назад +1

    one of the best tutorial, exactly what my students needed. Thanks a lot for this wonderful presentation.

  • @sarun777
    @sarun777 9 лет назад +1

    Great tutorial. Hoping for more in-depth tutorial on other tools such as Neural Network.

  • @CFAinNoVA
    @CFAinNoVA 10 лет назад +4

    Outstanding tutorial. Thank you.

  • @InebriatedEscapist
    @InebriatedEscapist 9 лет назад +1

    Outstanding introduction to MATLAB, even if you're not coming from EXCEL.

  • @blaze4404
    @blaze4404 7 лет назад +3

    this is amazing, how did it take me this long to use this tool.

  • @umerkhalid8171
    @umerkhalid8171 10 лет назад +19

    Can you please upload the excel data file also, it would be much better to practice on that same file while watching the video

  • @maheshkurtkoti5241
    @maheshkurtkoti5241 4 года назад

    Very clear explanation!! Thanks for the perfect introduction to matlab..

  • @Tim_moh
    @Tim_moh 2 года назад

    Very good teacher, thank you !! it's very nice, :) , in 2022 we use your video, it's very easy that i thought !

  • @benuastha7628
    @benuastha7628 6 лет назад +1

    Well although you knew the model to be fitted, the sse is quite high and adj r square is low.
    So when I don't have a predefined model, and my adj r square is low for most of the models I try, then how can I predict which model is the best one?

  • @belleyedan
    @belleyedan 7 лет назад +1

    Really Useful video. I hv a doubt : At time 26:55, why he used AvgRelHum variable as input for color code? How does that affects solratio data in Z scale? It looks like representation of relationship between 4 variables in 3D plot.

  • @joelchapman8943
    @joelchapman8943 8 лет назад +2

    Is it possible that I can get the data that you used so I can practice with it?

  • @soumitradas3714
    @soumitradas3714 2 года назад

    Amazingly helpful video. Thanks a lot.

  • @ahmedridwan5800
    @ahmedridwan5800 4 года назад

    What a beautiful explanation!

  • @davyraeder
    @davyraeder 6 лет назад +1

    thank you. very good lesson.

  • @ManuelRamsaier
    @ManuelRamsaier 9 лет назад +1

    Very dense, informative video!

  • @iornemsaautaverisaac7660
    @iornemsaautaverisaac7660 7 лет назад +1

    A wonderful introduction

  • @SNPolka56
    @SNPolka56 9 лет назад +1

    Excellent presentation. Thanks a lot.

  • @croozermonu
    @croozermonu 9 лет назад +1

    At time 23.32 i have a found a mistake in x axis because it should be hours in day because day of the year should be at y axis not in x axis according to me please clarify it.
    Thanks

  • @LOLMAN22
    @LOLMAN22 9 лет назад +2

    wow seems like a killer program! So useful

  • @LiChengqi
    @LiChengqi 6 лет назад +1

    convert spreadsheet date to datenum in import tool is not there

  • @klazzi6
    @klazzi6 7 лет назад +1

    My "Import Selection" does not have the option to choose "Generate Function", how do I get this? Cannot find it anywhere...

  • @dineosefemo4470
    @dineosefemo4470 10 лет назад +1

    great video to begginers on matlab

  • @meemalli3328
    @meemalli3328 9 лет назад +1

    Hi Nice explanation, Numbers version 3.6 (2557) mac spreadsheet. When i import it to Matlab. i am not getting the data rather getting some symbols. Can you help me?

  • @MrLexingtonSteele
    @MrLexingtonSteele 9 лет назад +2

    What exactly is the formula for solar ratio?

  • @kapilsaxena1
    @kapilsaxena1 8 лет назад

    Hi, Trying to change the marker colour according to its z value, but the drop-down menu that you have selected is not there in Matlab 2016b, can you please tell me where it is hiding. can't do it from the more properties as well.

  • @richardking3197
    @richardking3197 8 лет назад +3

    Is there an option download the same data in this video for practice?

  • @nileshpatil5644
    @nileshpatil5644 8 лет назад +1

    how to show two simulations in two different axes but in one gui?

  • @kiranjojare8451
    @kiranjojare8451 4 года назад

    At 21.57 you shows how to colour data in plot according to its Z Value. I tried it in 2020 but the property inspector is not the same as the one you showed. Can you help me in how to colour data in plot based on z value in 2020?

  • @localguy123
    @localguy123 3 года назад

    I have data according to time. So I have voltage, power and current and their times. How do i plot that?

  • @muhammadal-sandoqachi8882
    @muhammadal-sandoqachi8882 8 лет назад +1

    please you can help me to solve nonlinear equation

  • @sachinsshende
    @sachinsshende 8 лет назад +1

    Many thanks

  • @ericarnaud5062
    @ericarnaud5062 10 лет назад +1

    Thank you for sharing knowledge....

  • @gebrewoldteklay9286
    @gebrewoldteklay9286 8 лет назад +1

    Really amazing , thanks so much

  • @wiscgaloot
    @wiscgaloot 2 года назад

    I would do this, except that my Excel file has all the variable names in the first column, not the first row. I tried saving a transposed version of the file that had all the variable names in the first row--and MATLAB did the idiotic thing of transposing my entire file so that once again, the variable names are in the first column. Very frustrating. I think I will stick with Excel for now.

  • @tekbahadurchhetri179
    @tekbahadurchhetri179 Год назад

    Thanks a lot..!

  • @VasanthBattula
    @VasanthBattula 4 года назад

    I am having my energy consumption data in csv format 1440 time stamps. For each day individual file is created how can I make it as single file

  • @puaixynci6623
    @puaixynci6623 Год назад

    I never knew matlab is so easy to use !

  • @AHMADKELIX
    @AHMADKELIX 2 года назад

    permossion to learn sir

  • @OscarSotomayor
    @OscarSotomayor 5 лет назад +1

    Can you share the excel file?. Thanks

  • @aysegulihsan1136
    @aysegulihsan1136 3 года назад

    Great video thx

  • @Akshay221991
    @Akshay221991 10 лет назад +1

    Very useful video..

  • @dogbadjaze600
    @dogbadjaze600 7 лет назад +2

    Can you share the excel file, please!!

    • @CheerDesigns
      @CheerDesigns 7 лет назад +1

      Just google "Beyond Excel: Enhancing Your Data Analysis with MATLAB" and download "Example Code" on the Matlab page.

    • @kingsleywen82
      @kingsleywen82 5 лет назад

      @@CheerDesigns Hi, I googled it but I got a different file from the website. Can you share the website?

  • @tgee7485
    @tgee7485 8 лет назад +1

    in desperate need of help with making a model if anyone could help that would be great

  • @sumbaltasawwar
    @sumbaltasawwar 7 лет назад +2

    Thank youuuu!!!

  • @dalilahnordin354
    @dalilahnordin354 8 лет назад +2

    Thank you :-)

  • @VasanthBattula
    @VasanthBattula 4 года назад

    And if some data is missing in the row

  • @vinayjanagama
    @vinayjanagama 4 года назад

    Thank you very much

  • @nurshafinaz2831
    @nurshafinaz2831 9 лет назад +1

    how about lidar data. can matlab read it? how?

    • @rawalc
      @rawalc 9 лет назад +1

      +Nur Shafinaz Yes it can. It depends on how your lidar hardware produces data. ASCII formats can be read using txtread, or fscanf. You may also be able to connect your hardware's output directly to a computer for live streaming. Check the Data Acquisition Toolbox: www.mathworks.com/products/daq/

    • @nurshafinaz2831
      @nurshafinaz2831 9 лет назад

      +Chetan Rawal I have .las data that need to be input to matlab and do some processing. What about the coding for las data types?

    • @rawalc
      @rawalc 9 лет назад +1

      +Nur Shafinaz Once the data is in, the coding really depends on what you're trying to do. Check out resources on www.mathworks.com to learn more about your use-case.

    • @nurshafinaz2831
      @nurshafinaz2831 9 лет назад

      +Chetan Rawal thank you for your response. Really appreciate.

  • @biohazardsk8er69
    @biohazardsk8er69 8 лет назад +1

    great intro video

  • @hb-cuo
    @hb-cuo 3 года назад

    My graph is not getting smooth curve

  • @SumeetSahani
    @SumeetSahani 6 лет назад +1

    great 59 minutes tutorial

  • @raffaelerimorso9671
    @raffaelerimorso9671 6 лет назад +1

    activate subtitles, tks

  • @reubenroy
    @reubenroy 3 года назад

    omg.. I had no idea matlab was this cool

  • @wilmerquispe8223
    @wilmerquispe8223 9 лет назад +1

    Great

  • @trevorladd3044
    @trevorladd3044 9 лет назад +4

    I thought you were sal khan for a minute there

  • @prealbatausha2961
    @prealbatausha2961 8 лет назад +2

    manca il traduttore in automatico

  • @lingniousconstant5448
    @lingniousconstant5448 9 лет назад +1

    不错。nice

  • @sudeepkumarathunga7110
    @sudeepkumarathunga7110 2 года назад

    super

  • @etamlevy3034
    @etamlevy3034 5 лет назад +1

    3blue1brown?