Пікірлер
@themarvel6214
@themarvel6214 29 күн бұрын
Awesome video please do more on forcasting and time series
@catalina-ioana
@catalina-ioana 2 ай бұрын
I watched a lot of videos and yours was the most helpful! Thank you!
@AnalyticsVoyage
@AnalyticsVoyage Ай бұрын
Glad it helped!
@thegreatestfortniteplayer
@thegreatestfortniteplayer 5 ай бұрын
Thank you kind lady!
@AnalyticsVoyage
@AnalyticsVoyage Ай бұрын
Glad it helped!
@nurulain4167
@nurulain4167 7 ай бұрын
What if the value of RMSE and MAPE are too high? Any idea why it happened?
@TuttiFrutti159
@TuttiFrutti159 7 ай бұрын
wow, this was really helpful! urgently waiting for the multiple linear regression.
@rehnumahossain3691
@rehnumahossain3691 7 ай бұрын
I haven't understood anything in the university class, but this video made it easy. THANKS, A LOT ...
@p.j.882
@p.j.882 7 ай бұрын
Using analysis tool pack is great for those without math. LINEST is better and simpler.
@waseemakram8633
@waseemakram8633 8 ай бұрын
Please analysis correlation of any data and upload video
@shabnamahmadiandevari
@shabnamahmadiandevari 8 ай бұрын
Great!
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Thanks 😊
@shabnamahmadiandevari
@shabnamahmadiandevari 8 ай бұрын
Very helpful!!
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Glad it was helpful!
@lucifersgamingtv
@lucifersgamingtv 8 ай бұрын
Nice info video
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
So nice of you
@kamilakio
@kamilakio 8 ай бұрын
I love this video , i hope you keep making good videos like these !!
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Thank you, I will 😊
@Xmorrison536
@Xmorrison536 8 ай бұрын
Thanks
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Welcome. Thanks for watching
@stuntman4d
@stuntman4d 8 ай бұрын
Real interesting and educational, cool content!
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Thanks for watching. Happy that you enjoyed
@LifestylebyPegah
@LifestylebyPegah 8 ай бұрын
Uh!!! I had searched a lot for a video like this!!! Thank you 🙏🏻
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Glad it was helpful! 😁
@user-ru7ti4re8q
@user-ru7ti4re8q 8 ай бұрын
Very interesting and educational video
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Thanks for visiting
@Hodhod23
@Hodhod23 8 ай бұрын
Thanks for sharing the spreadsheet with us...very helpful :)
@AnalyticsVoyage
@AnalyticsVoyage 8 ай бұрын
Glad it was helpful!
@friendsforever715
@friendsforever715 9 ай бұрын
More tutorial for stat analysis🙏
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Sure. Coming soon 😊
@yavuzselimhasturk
@yavuzselimhasturk 9 ай бұрын
thank you so much :) :)
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
You’re more than welcome 😊
@Hodhod23
@Hodhod23 9 ай бұрын
It is a must in any field these days....
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Absolutely!
@NargessOvesy-fl7be
@NargessOvesy-fl7be 9 ай бұрын
Linear regression! I am gonna recommend this video to my students
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Thank you! I appreciate your support and hope the video proves helpful for your students.
@NargessOvesy-fl7be
@NargessOvesy-fl7be 9 ай бұрын
SQL is a must these days! Thanks for quick tutorial
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Thank you! I'm glad you found this tutorial helpful. If you have any more questions or need further assistance, feel free to ask. Happy coding!
@NargessOvesy-fl7be
@NargessOvesy-fl7be 9 ай бұрын
Super helpful! Thanks for great instructions
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
You're very welcome!
@Fatemeh018
@Fatemeh018 9 ай бұрын
Very helpful video, Thank you for sharing
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Glad it was helpful!
@fay.m.n
@fay.m.n 9 ай бұрын
🎉🎉🎉
@Jose.a240
@Jose.a240 9 ай бұрын
this video is awesome. just helped me with my homework <3
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Glad I could help!
@Jose.a240
@Jose.a240 9 ай бұрын
Very good. Short and to the point. It helped me a lot. Thanks.
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Great to hear!
@hedyehvaseli4563
@hedyehvaseli4563 9 ай бұрын
Thanks for this tutorial. Are you planning to have a video on multiple linear regression analysis?
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Yes, definitely. Will be posted soon.
@Hodhod23
@Hodhod23 9 ай бұрын
Perfect, thanks
@Hodhod23
@Hodhod23 9 ай бұрын
Awesome
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Thanks 😊
@Hodhod23
@Hodhod23 9 ай бұрын
🧠🧠
@hedyehvaseli4563
@hedyehvaseli4563 9 ай бұрын
😎😎😎
@mavisacheampomaa2983
@mavisacheampomaa2983 9 ай бұрын
Good we want more videos
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Thanks! More videos coming your way! 🎥👍
@Hodhod23
@Hodhod23 9 ай бұрын
Thanks a lot...that is exactly what I was looking for today.....
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Glad I could help!
@HVAS90
@HVAS90 9 ай бұрын
Was going crazy when I couldn't find the Data Analysis, didn't know it was an add on! Thank you so much for the help!
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Happy to help!
@HVAS90
@HVAS90 9 ай бұрын
Thank you so much. Worked perfectly in 6 minutes, along with the video. Keep up.
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Great to hear!
@augustdays81
@augustdays81 9 ай бұрын
One more! What data can we analyze using this tool? Does the statistics distribution matter?
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Certainly! Descriptive statistics in Excel can be used to analyze a wide range of data. You can employ these tools to summarize and interpret the main features of any dataset. This is incredibly useful for understanding central tendencies, spread, and overall distribution of your data. Whether you're working with financial data, survey results, scientific measurements, or any other type of numerical data, descriptive statistics in Excel provide valuable insights into the patterns and characteristics of your dataset. The choice of statistical distribution matters when interpreting the results. Different types of data might follow different distributions (e.g., normal, skewed, bimodal), and understanding the distribution helps in choosing appropriate statistical measures and drawing meaningful conclusions from the analysis.
@augustdays81
@augustdays81 9 ай бұрын
When do we use median and when do we use mean? In a survey in our organization, they mesures the satisfaction level of employees in each department in this organization. The satisfaction level of departments are from 30 percent to 85 percent. Department 1: 34 Department 2: 50 Department 3: 53 Department 4: 58 Department 5: 85 Is average a good number to represent the satisfaction of the all employees of this organization ? I don’t think so, I would say they should have used median number. Am I right? How do we decide on what metric to pick?
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
👍 Great breakdown! It's essential to choose the right measure of central tendency based on the data and context. Mean is handy for symmetrical data, but beware of outliers skewing results. Median is perfect for handling skewed data and outliers, providing a more robust representation of the data's center. When it comes to employee satisfaction levels like in this survey, ranging from 30% to 85%, using the median seems like a smart choice to accurately reflect the typical satisfaction amidst potential variations and outliers. Understanding the distribution and context is key! 📊
@augustdays81
@augustdays81 9 ай бұрын
What sort of data we can analyze using this tool? I’m very beginner 🫣
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Great question! The Excel Analysis ToolPak is perfect for beginners looking to analyze various types of data. You can use this tool to analyze numerical data, such as sales figures, survey responses, test scores, or any data that involves numbers. It helps you calculate measures of central tendency like mean, median, and mode, which give you an idea of the typical values in your data. Additionally, you can determine measures of dispersion like standard deviation and variance to understand the spread or variability of your data. The tool also assists in creating histograms, frequency distributions, and conducting hypothesis testing. It's a versatile tool that provides a solid foundation for summarizing and understanding data effectively in Excel. Hope this helps you get started with your data analysis journey!
@augustdays81
@augustdays81 9 ай бұрын
Why would I need to download this?
@AnalyticsVoyage
@AnalyticsVoyage 9 ай бұрын
Thanks for watching! MySQL Workbench is indeed a fantastic tool for managing and optimizing MySQL databases. It's perfect for database design, running queries, administration, and more. If you have any specific questions or need help with any aspect of MySQL Workbench, feel free to ask!