My Learning Space by Abefe
My Learning Space by Abefe
  • Видео 126
  • Просмотров 127 935
DATA CLEANING SERIES FOR BEGINNERS | HOW TO CLEAN DATA WITH EXCEL | VIDEO 2
Hello everyone and welcome to another video.
In this video, we will be learning about the several types of tips and techniques that are important for data cleaning as a beginner in microsoft excel. I hope this video will be useful and you also enjoy the video :)
IMPORTANT LINKS
Link to Dataset
drive.google.com/drive/folders/1wE3EUhiKoAsdCnAQdgPT7ievV4zI7vzs?usp=drive_link
How to anakyze a dataset video
ruclips.net/video/U2ACDG5qVWc/видео.htmlsi=iYoy4n-Dr9QVNqhK
Follow me on twitter (X)
starboy_abefe
Follow me on Linkedln
www.linkedin.com/in/ajiboye-yusuf-a73b23173/details/experience/
TIME STAMPS
00:00 - INTRODUCTION
02:33 - DELETING UNNECESSARY ROWS/ COLUMNS
04:09 - AUTO FIT ROW WIDTH AND ...
Просмотров: 450

Видео

DATA CLEANING SERIES FOR BEGINNERS | HOW TO CLEAN DATA WITH EXCEL
Просмотров 897Месяц назад
Hello everyone and welcome to another video. In this video, we will be learning about the several types of tips and techniques that are important for data cleaning as a beginner in microsoft excel. I hope this video will be useful and you also enjoy the video :) IMPORTANT LINKS Follow me on twitter (X) starboy_abefe Follow me on Linkedln www.linkedin.com/in/ajiboye-yusuf-a73b23173/d...
SAMPLING TECHNIQUES AND IT TYPES | FOR DATA ANALYSIS AND RESEARCH
Просмотров 90Месяц назад
Hello everyone and welcome to another video. In this video, we will be learning about the types of sampling tecniques used in research and data analysis in general. I hope you enjoy the video :) IMPORTANT LINKS Follow me on twitter (X) starboy_abefe Follow me on Linkedln www.linkedin.com/in/ajiboye-yusuf-a73b23173/details/experience/
What exactly is the job of a DATA ANALYST?
Просмотров 191Месяц назад
Hello everyone and welcome to another video. In this video, we will be talking about the job and roles of data analyst. This is a question that alot of beginners have asked me over time and i have decided to take the liberty to answer it in my best way. I hope you enjoy the video :) IMPORTANT LINKS How to analyze a dataset ruclips.net/video/U2ACDG5qVWc/видео.html How to visualize dataset ruclip...
I quit YOUTUBE..... for some time period and HERE IS WHY?
Просмотров 247Месяц назад
Hello everyone and welcome to another video. In this video i will be talking about the 2 months sudden break i took from youtube. SO yeah, this is not a video on statistics, data analysis or tech... it is just me talking and vibing with my audience. I miss y'all
TIME SERIES ANALYSIS ; MOVING AVERAGE | MOVING AVERAGE WITH EXCEL| MD, MAD, MSE, RMSE, MAPE
Просмотров 2294 месяца назад
Hello everyone and welcome to another video, in this video we will be talking about one of the simplest yet powerful time series forecasting technique - MOVING AVERAGE. We will be discussing this technique in general, how important it is in the stock market, it features and how to work with it using microsoft excel. TIME STAMPS 00:00 - INTRODUCTION 01:16 - WHAT IS MOVING AVERAGE ? 04:19 - MATHE...
WHAT EXACTLY IS P VALUE ?| P VALUE EXPLAINED
Просмотров 2224 месяца назад
Hello everyone and welcome to another video. In this video, i would be talking about one of the most important value when it comes to hypothesis test and statistical inference in general - P VALUE IMPORTANT LINKS AND TIME STAMPS WHAT IS HYPOTHESIS TEST ruclips.net/video/iJGekJiJR6I/видео.htmlsi=cfi-CvGQH0SVhaBB 00:00 - INTRODUCTION 01:31 - WHAT IS A P VALUE ? 07:18 - DECISION RULE 09:55 - WHERE...
STATISTICS OF DECISION MAKING : WHAT IS HYPOTHESIS TESTING ?
Просмотров 3764 месяца назад
Hello everyone and welcome to another video, and in this video we will be discussing one of the very important statistics technique - HYPOTHESIS TESTING which is under statistical inference. IMPORTANT LINKS Analysis of superstore dataset ruclips.net/video/U2ACDG5qVWc/видео.htmlsi=r3JGhZw4h8bxRHXC STATISTICAL TESTS ruclips.net/video/_BV_Wf9YsGQ/видео.htmlsi=06pCXaQorggUIcw2 TIME STAMPS 00:00 - I...
HOW TO ANALYZE A SURVEY DATA (WITH A LIKERT SCALE) LIKE A PRO: Analysis of Qualitative Data
Просмотров 7214 месяца назад
Hello everyone and welcome to another video. Today video will be about me teaching you how to analyze a SURVEY DATA with IBM SPSS. This is also the analysis of a qualitative data with a likert scale. IMPORTANT LINKS SURVEY DATA AND AIMS AND OBJECTIVES drive.google.com/drive/folders/1ig9T8GTd7yqq-lM6p5nukcw3deoI_xbK?usp=sharing IBM SPSS PLAYLIST ruclips.net/video/6nvT3DW295g/видео.html TIME STAM...
The Ultimate guide to Data Visualization : The Statistics of Data Visualization
Просмотров 4824 месяца назад
Hello everyone and welcome to another video. In this video we will be talking about one of the most vital aspect of data analysis - DATA VISUALIZATION. TIME STAMPS INTRODUCTION - 00:00 BAR CHART - 06:31 PIE CHART - 12:59 HISTOGRAM - 15:25 LINE CHART - 18:39 SCATTERPLOT - 22:57 BOX PLOT - 23:58 OUTRO - 25:42 IMPORTANT LINKS Data visualization for data analyst playlist ruclips.net/video/ABwMbowlt...
How to analyze an ECONOMIC DATASET like a PRO - Full Data analysis tutorial (Excel and SPSS).
Просмотров 1,1 тыс.4 месяца назад
Hello everyone and welcome to another video. Today will be another full data analysis tutorial on how to analyze an economic dataset with excel and SPSS. TIME STAMPS INTRODUCTION - 00:00 ABOUT THE DATASET - 02:10 OUTRO - 46:25 IMPORTANT LINKS LINK TO THE NIGERIAN ECONOMIC DATASET www.kaggle.com/datasets/ogbuzurukelechi/nigeria-economy-growth-1990-2023 HOW TO ANALYZE A DATA SET ruclips.net/video...
What is a Machine learning model ? | Machine learning and it types explained
Просмотров 1894 месяца назад
Hello everyone and welcome to another youtube video. Today's video will be about the concept of MACHINE LEARNING, TYPES OF MACHINE LEARNING, MACHINE LEARNING ALGORITHMS AND MACHINE LEARNING MODELS. TIME STAMPS INTRODUCTION - 00:00 WHAT IS MACHINE LEARNING - 01:01 MACHINE LEARNING MODELS - 05:58 MACHINE LEARNING ALGORITHM - 08:36 TYPES OF MACHINE LEARNING - 09:57
How to analyze a dataset like a PRO - FULL DATA ANALYSIS TUTORIAL
Просмотров 9 тыс.5 месяцев назад
Hello everyone and welcome to another video. In this video, we will be discussing DATA ANALYSIS and how to analyze a dataset as a beginner using MICROSOFT EXCEL. TIME STAMPS INTRODUCTION - 00:00 WHAT YOU NEED TO KNOW - 01:10 ANALYZING WITH EXCEL - 14:32 OUTRO - 49:47 IMPORTANT LINKS TO VIDEOS AND PLAYLIST LINK TO DATASET ON KAGGLE www.kaggle.com/datasets/vivek468/superstore-dataset-final TYPES ...
Data Analysis Techniques : Time series analysis and forecasting explained in 20 minutes ⏰
Просмотров 5435 месяцев назад
Hello everyone and welcome to another video. In this video we will be discussing one of the most very vital technique in data analysis - TIME SERIES ANALYSIS AND FORECASTING. We will be talking about the general overview of time series analysis and time series data, the component of time series data and the types of forecasting models for time series data. IMPORTANT LINKS 🚨 TYPES OF DATA IN STA...
Get better at Data Analysis: 4 Pro tips for Beginner Data Analyst
Просмотров 5675 месяцев назад
Hey everyone and we have another video here. In this video, we will be talking about 4 pro tips (with 1 bonus tip) that can help beginner data analyst become a better analyst. These tips are some that the pro data analyst used when they were beginners and are still using some of them as we speak. Make sure you wait till the end of the video to catch the bonus tip and if you did, do not forget t...
Unlocking the secrets: My journey freelancing as a data analyst
Просмотров 8805 месяцев назад
Unlocking the secrets: My journey freelancing as a data analyst
The Ultimate Data Analysis Guide: Road Map 2024
Просмотров 8555 месяцев назад
The Ultimate Data Analysis Guide: Road Map 2024
DATA ANALYSIS MISCONCEPTIONS YOU NEED TO KNOW
Просмотров 5345 месяцев назад
DATA ANALYSIS MISCONCEPTIONS YOU NEED TO KNOW
HOW MUCH STATISTICS DO YOU NEED FOR DATA ANALYSIS ?
Просмотров 9346 месяцев назад
HOW MUCH STATISTICS DO YOU NEED FOR DATA ANALYSIS ?
WHAT IS A Z SCORE | Z SCORE EXPLAINED | NORMAL AND STANDARD NORMAL DISTRIBUTIONS
Просмотров 916 месяцев назад
WHAT IS A Z SCORE | Z SCORE EXPLAINED | NORMAL AND STANDARD NORMAL DISTRIBUTIONS
CONTINOUS PROBABILITY DISTRIBUTIONS AND IT TYPES (Normal distribution, exponential distribution)
Просмотров 3016 месяцев назад
CONTINOUS PROBABILITY DISTRIBUTIONS AND IT TYPES (Normal distribution, exponential distribution)
WHAT IS A CONTINOUS PROBABILITY DISTRIBUTION ?
Просмотров 2157 месяцев назад
WHAT IS A CONTINOUS PROBABILITY DISTRIBUTION ?
TYPES OF STATISTICAL ANALYSIS | DESCRITIVE ANALYSIS| EXPLORATORY ANALYSIS| PREDICTIVE ANALYSIS
Просмотров 3708 месяцев назад
TYPES OF STATISTICAL ANALYSIS | DESCRITIVE ANALYSIS| EXPLORATORY ANALYSIS| PREDICTIVE ANALYSIS
REGRESSION MODELS AND IT TYPES
Просмотров 4738 месяцев назад
REGRESSION MODELS AND IT TYPES
WHICH STATISTICAL TEST SHOULD I USE?| Z TEST, T TEST, CHI SQUARE, ANOVA | HYPOTHESIS TEST
Просмотров 3268 месяцев назад
WHICH STATISTICAL TEST SHOULD I USE?| Z TEST, T TEST, CHI SQUARE, ANOVA | HYPOTHESIS TEST
REGRESSION MODEL WITH EXCEL| IT IS SIMPLE
Просмотров 6328 месяцев назад
REGRESSION MODEL WITH EXCEL| IT IS SIMPLE
Beginner to Pro: The Ultimate guide to become a data analyst
Просмотров 3,1 тыс.8 месяцев назад
Beginner to Pro: The Ultimate guide to become a data analyst
HYPERGEOMETRIC DISTRIBUTION with EXCEL, SPSS and R| Probabiility and cummulative distribution.
Просмотров 1549 месяцев назад
HYPERGEOMETRIC DISTRIBUTION with EXCEL, SPSS and R| Probabiility and cummulative distribution.
DATA ANALYST v STATISTICAL ANALYST - Are they really different ?
Просмотров 4959 месяцев назад
DATA ANALYST v STATISTICAL ANALYST - Are they really different ?
POISSON DISTRIUTION WITH R | CUMMULATIVE DENSITY FUCNTION | PROBABILITY DENSITY FUCNTION
Просмотров 2189 месяцев назад
POISSON DISTRIUTION WITH R | CUMMULATIVE DENSITY FUCNTION | PROBABILITY DENSITY FUCNTION

Комментарии

  • @erdooabanyi5166
    @erdooabanyi5166 4 часа назад

    This video was really worth the while

  • @erdooabanyi5166
    @erdooabanyi5166 4 часа назад

    Will really love it if you could help us with learning communities.

  • @Chigod2002
    @Chigod2002 8 дней назад

    Could you help with a video on how to calculate std deviation. Thank you

    • @MLS_byAbefe
      @MLS_byAbefe 4 дня назад

      Here you go ruclips.net/video/6g9GMjIRiQU/видео.htmlsi=o70DG3R1lCI-12td

  • @juliaecheonwu1691
    @juliaecheonwu1691 21 день назад

    This is extremely beginner friendly and easy to follow thank you.

    • @MLS_byAbefe
      @MLS_byAbefe 21 день назад

      I am so glad you enjoyed it

  • @jahbuikemanderson8109
    @jahbuikemanderson8109 21 день назад

    This is topnotch

    • @MLS_byAbefe
      @MLS_byAbefe 21 день назад

      Thanks for the kind words sir

  • @prosper_amed
    @prosper_amed 24 дня назад

    I learnt alot from this video. So after analysis how can someone post this online for the public to get access to the report example like on Platform on GitHub. Also which platform is suitable for writing reports

  • @frankiyaji9851
    @frankiyaji9851 25 дней назад

    Thank you for this wonderful video. Really, I learnt something new and amazing from the video.

  • @spiritchants5665
    @spiritchants5665 26 дней назад

    Boss, can we get a link to the example used in the video....the life dataset

  • @favourifeoluwa8586
    @favourifeoluwa8586 26 дней назад

    I reall enjoyed this and it was enlightening

  • @makav3li665
    @makav3li665 28 дней назад

    Amazing video. For the sake of analysis tho, I think it would be better to split the "department" column to get a "locations" column.

  • @agboolaoluranti5675
    @agboolaoluranti5675 28 дней назад

    Amazing👏👏

  • @aniefiokbassey4771
    @aniefiokbassey4771 28 дней назад

    This was an enlighting one. I just started my data analytics journey, pls is there any good learning platform or bootcamp in Nigeria that you can recomend. I will be happy to know. Thanks.

  • @juliaecheonwu1691
    @juliaecheonwu1691 Месяц назад

    Thank you so much this is very useful.

  • @video_insight1043
    @video_insight1043 Месяц назад

    Great insight 🙏

  • @m1stylark
    @m1stylark Месяц назад

    Hi there. I really, really need your help and advice. May i share my spss problem with you? i have this warnng message : "Unexpected singularities in the Hessian matrix are encountered. This indicates that either some predictor variables should be excluded or some categories should be merged. The NOMREG procedure continues despite the above warning(s). Subsequent results shown are based on the last iteration. Validity of the model fit is uncertain'. I am not sure how to troubleshoot this sir. I am a newbie. Google, youtube, researchgate and reddit could not help me =(

  • @jahbuikemanderson8109
    @jahbuikemanderson8109 Месяц назад

    Thanks for this... It is enlightening

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Thanks for your kind words.

  • @oluwatominiyicaleb377
    @oluwatominiyicaleb377 Месяц назад

    Educative! Thanks for dropping this. I'll like to know if the next Data cleaning episode will talks more on different techniques on how to fill a missing value/blanks. Thanks once again.

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Handling missing values is subjective and can be a separate topic of it own entirely. But I would make something on it

  • @anoroemmanuel
    @anoroemmanuel Месяц назад

    Great video tutorial 💯

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Thank you for your kind words

  • @JohnAnalyzeThis
    @JohnAnalyzeThis Месяц назад

    Thanks for dropping this....

  • @marcprudhomme451
    @marcprudhomme451 Месяц назад

    Hello, Thanks for this very good video. As for the 3 sectors, they represent the value added of the each of the sectors to the country's GDP at basic prices. You will notice when added, they equal GDP @ basic prices.

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Thank you so much. I totally appreciate

  • @akandesekinat739
    @akandesekinat739 Месяц назад

    Hi Abefe ,my question is can you make a video on amble you started as a freelancer data analyst or tips

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Here is a video ruclips.net/video/i7FVFT6v-oA/видео.htmlsi=7gZT0MLJqMse_7uG

  • @raphaelugwoke8283
    @raphaelugwoke8283 Месяц назад

    Hello Mr Abafe I am Raphael a data analyst newbie, your videos resonates with me, I'd like to connect

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Hello sir and good day. Kindly send me a dm on Twitter. The username is “Abefe- the statistics guy”

    • @raphaelugwoke8283
      @raphaelugwoke8283 Месяц назад

      @@MLS_byAbefe alright sir

  • @sweetie7367
    @sweetie7367 Месяц назад

    Can you please work us through how to apply chi square,t test,ANOVA in a business data set.pls🙏

  • @yakubuquadri5042
    @yakubuquadri5042 Месяц назад

    Welcome back ❤ Na me miss ur video pass Ano fit cry when ano see videos on confidence interval,empirical rule hypothesis test on one sample mean........ Even Anova n co Please we need an extensive n well detailed video on inferential statistics

    • @yakubuquadri5042
      @yakubuquadri5042 Месяц назад

      Am a fan I really wish to learn from you @abefe

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Thanks for your kind words sir. It really means a lot to me. And yeah, I’m back to shooting videos and all of the things you mentioned

  • @saniahmad9484
    @saniahmad9484 Месяц назад

    Thank you sir.

  • @afeniforoprogress
    @afeniforoprogress Месяц назад

    Welcome back

  • @hillarymutembei1249
    @hillarymutembei1249 Месяц назад

    Welcome back

  • @JoshuaAlani
    @JoshuaAlani Месяц назад

    @abefe i hope Real Time with T & M is also coming back

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Yeah… we are definitely 👍

  • @jahbuikemanderson8109
    @jahbuikemanderson8109 Месяц назад

    Big Finance is needed in this difficult times in Nigeria. Welcome back

  • @Hespee_TCBA
    @Hespee_TCBA Месяц назад

    Welcome back boss.

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Thank you. It is good to be back

  • @abrahamabidemi6271
    @abrahamabidemi6271 Месяц назад

    Welcome back! We miss watching your videos too😁

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      Thank you Abidemi. It is good to be back 😊

  • @asmaakhtar3419
    @asmaakhtar3419 Месяц назад

    You did not apply test of parallel lines which is also a necessary assumption for proportional ordinal logistic modelling. 2ndly what about the minus sign, it should indicate an inverse relationship with a significant p-value. ?

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

    Thanks man

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

    it's all good, but it's better without the background music

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      I would pay attention to that next time. Thanks for your input

  • @user-lg6fq1yt4g
    @user-lg6fq1yt4g 2 месяца назад

    ❤👏👏

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

    Please l want to freelance as a data analyst

    • @MLS_byAbefe
      @MLS_byAbefe Месяц назад

      I have a video on my channel discussing that.

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

    ❤❤❤

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

    Thank you for the expose. Will it be safe to say that while the roles and responsibilities of a data analyst and a statistical analyst overlap, their major distinction is in how much of specific tool set (and skills) is required of each field at the bearest minimum? It seems to me that although a junior data analyst may not be called a statiscal anylyst, a more experienced senior data analyst with vast knowledge of statistical methods and tool can also qualify as a statistical analyst

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

    Thank you for sharing. The explanation is well detailed and clear. Can you please share links to the reading materials you recommended in your response to @ras7646 (pdf materials will be preferred). There are many materials online that leaves one confused on one to download Thank you

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

    Great channel, great content. Thank you @Abefe

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

    Very insightful. Thank you ❤

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

    Great video Abafe 👍

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

    Hi. Great video, but the sound is off from around 3:56 to around 6:26. During this gap video captions show that you talk about multivariate analysis, which is a topic of particular interest to me. Is there anything which you can do about the missing sound?

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

    Thank you sir, how much do you teach data analysis and is it with certificate?

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

      Please send me a dm on Twitter The username is @starboy_abefe

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

    Really insightful video.. Thank you Abefe

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

    nice

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

    abefe from twitter space yesterday thanks

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

    Jesus, I understood this video like a baby. Well, all the months of learning also helped but you piece the pieces together so beautifully like a pro that you are. You are not just an analyst you are a great teacher also. Keep it up!

  • @FEMIOWOEYE-ch8ks
    @FEMIOWOEYE-ch8ks 2 месяца назад

    Mr Abefe you really kill this video I must confess and I feel like watching this over and over again. This is awesome.

  • @FEMIOWOEYE-ch8ks
    @FEMIOWOEYE-ch8ks 2 месяца назад

    Mr Abefe you really kill this video I must confess and I feel like watching this over and over again. This is awesome.