5 Awesome Data Analysis Tricks on Excel

Рет қаралды 155,643

Күн бұрын

Learn 5 awesome data analysis tools on Excel ranging from regression to correlation analysis.
🔥 Download FREE Excel Chart Templates from Hubspot: clickhubspot.com/3nn
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/64144e...
LEARN:
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
In this video you'll learn five data analysis tools on Excel.
First, we cover forecasting in Excel using the forecast sheet feature. For this we use a hotel resort's revenue historical figures to forecast into the future. The tools are descriptive statistics, linear regression, multiple regression, correlation analysis, and forecasting.
Second, we cover correlation analysis using the data analysis feature on excel. Correlation analysis allows us to see if there's a correlation between different stocks we wan to invest in.
Third, we cover descriptive statistics, which helps us find essential statistics for our values such as the average, count, min, max, and more.
Fourth, we cover a simple linear regression to see the relationship between 2 variables. For this we use a scatter plot with the equation of a line and the r squared.
Lastly, we cover a multiple regression, where we get the adjusted r squared, the coefficients, the p values and more.
SOCIALS:
🎬 My Company KZfaq Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:14 - Forecast Sheet
1:53 - Correlation Analysis
4:56 - Descriptive Statistics
6:07 - Linear Regression
7:39 - Multiple Regression
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 82

@KenjiExplains Жыл бұрын

🔥 Download FREE Excel Chart Templates from Hubspot: clickhubspot.com/3nn

@donnavolz6268 Жыл бұрын

Thanks! I really needed these. Love you videos by the way. Very informative and easy to follow.

@kloanenicholasace1315 Жыл бұрын

Great work Sir, yes it would truly be an honour to learn more from you. Thank you.

@salmaneconometricscorner8364 Жыл бұрын

Awesome videos very interest Kenji dada

@grumpus23 Жыл бұрын

Yes, I would love to learn more about the multiple regression statistics

@KenjiExplains Жыл бұрын

Noted thanks for the comment!

@church2k Жыл бұрын

Yes please, learnt more with your video than with a semester in college

@mihai980 Жыл бұрын

Hey, Kenji, i am interested too, i have an work issue that involves the same product but different revenue results and try to forcast revenue base on some correlations so i am very interested in learning more on statistics analizing

@CompletedReview Жыл бұрын

Please do the regression stats!

@richardgordon Жыл бұрын

Amazing Kenzie! Without a doubt the clearest and best teacher on the internet. In 10 minutes you’ve shown us five powerful functions that span statistics, data analysis, and financial forecasting that eliminates all the hard work of these essential disciplines, and you’ve managed to throw in some advertising for a useful product as well. And made it interesting! Not many people can accomplish that. Well done!

@zakhelembhele7046 Жыл бұрын

You are just brilliant Kenji. I feel like I a seasoned analyst already!

@mauriciobori 10 ай бұрын

Thanks for sharing these concepts. Hopefully people will be less scared about stats and numbers in general with content like this that makes it accessible in simple terms what you showed is very powerful yet simple to learn.

@fahimistihadanik1495 Жыл бұрын

I remember struggling so much with doing a risk, return analysis with efficient frontier during my undergrad. I wish i came across something like this earlier wouldn’t have to learn in the hard way and messy way. Good stuff keep up the good work.

@danlm8559 Жыл бұрын

Thanks for the video. Amazing. Extremely useful!

@providencewilliams8064 6 ай бұрын

This is my favorite KZfaq channel. no jokes. buying the Excel course soon, love your tricks and detailing. 👍👍👍👍💕💕❤❤

@junaidimtiaz2394 Ай бұрын

I would love to learn more about statistical analysis especially regression analysis. Youre lessons are the most concise and time efficient lessons on youtube , so would really appreciate if you could make the requested video.

@rokaya7045 Ай бұрын

Cool tools. I find your vids so helpful. Thanks

@julius_galih 8 ай бұрын

Thanks Kenzie!

@UChiiL 5 ай бұрын

Brilliant! Just Brilliant!

@Arpitr1697 2 ай бұрын

thankyou, very well explained and very precise

@camlex6310 Жыл бұрын

Really helpful!!

@michaelquach6655 Жыл бұрын

Great fundamental Excel trick with the quick regression. Great work Kenji!

@KenjiExplains Жыл бұрын

Cheers!

@lookforbriansjazz7832 Жыл бұрын

Yes. Thanks!!

@rizwanalishinwari1 Жыл бұрын

I have watched many of your tutorials, and they all are very much informative. Thank you so much for that. I am a PHD, and did my research on qualitative data. Now, I want to shift to quantitative data analysis, and your tutorials are helping me a lot. One thing more, I am using MS Excel from Mac, and I could not find the forecast sheet in it. I wish it was there.

@champagne_mami Жыл бұрын

Thank you so much I’d like for you to explain the other statistics

@zahidulhaquekowshik9336 10 ай бұрын

great video Kenji! can you please start a playlist on statistics for data analysis using Excel?? that would be great! thank you!

@bismarkackaah250 2 ай бұрын

Powerful presentation

@gikanganjugi6116 Жыл бұрын

Great education sir thankyou

@nicksanchez1964 Жыл бұрын

Mutilple regressions are amazing! Use at work all the time to validate why we do things.

@KenjiExplains Жыл бұрын

Love to hear it!

@ikennaewurum6415 Жыл бұрын

Of course I want more of the regression analysis.

@RefaatIbrahimXIT Жыл бұрын

Thank you

@qaziusman85 Жыл бұрын

Well explained 👏👏👏

@vikramadityarathore97 Жыл бұрын

Keep the good job up mate! Informative and insightful!

@KenjiExplains Жыл бұрын

Thank you!

@siddhikelshikar9968 6 ай бұрын

Thanks for the video. Will you please make a video explaining the metrics of regression analysis table.

@newday8074 Жыл бұрын

You are just amazing, straight to the point with awsome tips

@newday8074 Жыл бұрын

I would like to know more aout the multiple regression, thank you

@iriica Жыл бұрын

Very useful 👍 Kenji

@meeknessgospelmissionmgmlu3473 Жыл бұрын

Thanks a lot

@leislylorainelopezlevi 11 ай бұрын

Amazing. I do want more information, please make another video explaning the last part.

@ghamykamy8426 Жыл бұрын

Excellent 👍

@Luskesko Жыл бұрын

Always enjoying your videos! Is it possible to make forecast for multiple items based on several months?

@dodgecarlincila879 Жыл бұрын

you have explained it better than my data science professor.

@dimitarmihaylov2145 Жыл бұрын

Hi, please explain in more detail the ratio from regression analysis.

@Nubesitas001 Жыл бұрын

As always, your videos are very interesting. I would like more videos regarding multiple regressions ❤

@JeffreyJeffersonUK Жыл бұрын

I second this! Excellent video

@vogelchiara 8 ай бұрын

thank you

@billyjaybelotindos1653 Жыл бұрын

I never thought I could finish this video

@emperordesk2794 11 ай бұрын

Thanks kenji, your page has been very helpful. I would like to get certified, any tips on an international certification?

@careerprinciples Жыл бұрын

Nice!

@oluwatobibalogun9761 Жыл бұрын

Thumbs UP!

@MohammadAminParnianPour 11 ай бұрын

please cover the statistics in the multi regression

@user-zj2dg4mk8y 4 ай бұрын

Every morning watching your videos and practicing along side has become the 1st priority task for me, thanks for such a nice content❤

@KenjiExplains 4 ай бұрын

That’s awesome to hear! 🚀

@muhammadhasanraza1606 Ай бұрын

awesome

@bismarkackaah250 2 ай бұрын

I need more on regression

@mahfoud837 Жыл бұрын

Would like to explain deeprr those econometrics

@sonerguney3225 Жыл бұрын

Super

@Techguru563 Жыл бұрын

I like your videos dude...❤❤❤❤

@KenjiExplains Жыл бұрын

Glad you like them!

@GamingGirlDestiny Жыл бұрын

I need a video on how to make a dependable and searchable drop dowm list

@KSMVideos Жыл бұрын

how to deal with non-numerical data when using the data analysis tools?

@anastasiasaparet4067 Жыл бұрын

is a forecast sheet for Mac or is it ony for windows?

@ksltechnology Ай бұрын

greAT

@mrym_data 10 ай бұрын

whats the program you use for editing video

@fabean9097 Жыл бұрын

i didnt see forecast sheet on my excel though i used the same file ? is my excel version too old ?

@anonfinally1692 Жыл бұрын

Are these doable in sheets?

@juantray Жыл бұрын

The p-value for the newspaper ads coefficient seems to not be statistically significant whereas online ads does.

@excel168 10 ай бұрын

❤

@mohanedpharma2883 11 ай бұрын

Wow , Now I can replace SPSS app with these excel features

@makeuplily Жыл бұрын

How can I add the forecast sheet to my ribbon? I tried searching for in under customization and don't see it. I don't even have the forecast section to begin. I would really appreciate the help, thank you in advance

@rizwanalishinwari1 Жыл бұрын

I am facing the same problem. If you are suing Excel from MacBook, you will probably not find it.

@DanielRamirezZaldivar 11 ай бұрын

I've got the same problem, don't know how to add it on MacBook

@fizzy3949 Жыл бұрын

As a kid I used to wonder what career would need me to know these things....now I know 😂

@avocadotalks1426 Жыл бұрын

Only available in 365?

@pony44 Жыл бұрын

More videos like this please! Can you make a video doing some multiple correlation graphics? Please ? Like gold silver and cuper vs mining company revenues? Ty bro