Data Analysis with MATLAB for Excel Users

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

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

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

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

  • @thomasberger8952
    @thomasberger8952 5 лет назад +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.

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

    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

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

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

  • @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.

  • @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.

  • @umerkhalid8171
    @umerkhalid8171 9 лет назад +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

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

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

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

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

  • @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.

  • @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.

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

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

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

    Outstanding tutorial. Thank you.

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

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

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

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

  • @joelchapman8943
    @joelchapman8943 7 лет назад +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.

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

    Very dense, informative video!

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

    A wonderful introduction

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

    What a beautiful explanation!

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

    wow seems like a killer program! So useful

  • @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?

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

    thank you. very good lesson.

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

    Excellent presentation. Thanks a lot.

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

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

  • @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...

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

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

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

    convert spreadsheet date to datenum in import tool is not there

  • @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.

  • @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

  • @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?

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

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

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

    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.

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

    great video to begginers on matlab

  • @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.

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

    please you can help me to solve nonlinear equation

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

    What exactly is the formula for solar ratio?

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

    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

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

    Many thanks

  • @puaixynci6623
    @puaixynci6623 11 месяцев назад

    I never knew matlab is so easy to use !

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

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

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

    Can you share the excel file?. Thanks

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

    permossion to learn sir

  • @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?

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

    great intro video

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

    Thanks a lot..!

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

    Thank you for sharing knowledge....

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

    Really amazing , thanks so much

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

    great 59 minutes tutorial

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

    Thank youuuu!!!

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

    Thank you very much

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

    Great video thx

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

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

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

    Thank you :-)

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

    Very useful video..

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

    And if some data is missing in the row

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

    omg.. I had no idea matlab was this cool

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

    My graph is not getting smooth curve

  • @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?

  • @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.

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

    I thought you were sal khan for a minute there

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

    activate subtitles, tks

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

    Great

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

    manca il traduttore in automatico

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

    不错。nice

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

    super

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

    3blue1brown?