Awesome video please do more on forcasting and time series
@catalina-ioana2 ай бұрын
I watched a lot of videos and yours was the most helpful! Thank you!
@AnalyticsVoyageАй бұрын
Glad it helped!
@thegreatestfortniteplayer5 ай бұрын
Thank you kind lady!
@AnalyticsVoyageАй бұрын
Glad it helped!
@nurulain41677 ай бұрын
What if the value of RMSE and MAPE are too high? Any idea why it happened?
@TuttiFrutti1597 ай бұрын
wow, this was really helpful! urgently waiting for the multiple linear regression.
@rehnumahossain36917 ай бұрын
I haven't understood anything in the university class, but this video made it easy. THANKS, A LOT ...
@p.j.8827 ай бұрын
Using analysis tool pack is great for those without math. LINEST is better and simpler.
@waseemakram86338 ай бұрын
Please analysis correlation of any data and upload video
@shabnamahmadiandevari8 ай бұрын
Great!
@AnalyticsVoyage8 ай бұрын
Thanks 😊
@shabnamahmadiandevari8 ай бұрын
Very helpful!!
@AnalyticsVoyage8 ай бұрын
Glad it was helpful!
@lucifersgamingtv8 ай бұрын
Nice info video
@AnalyticsVoyage8 ай бұрын
So nice of you
@kamilakio8 ай бұрын
I love this video , i hope you keep making good videos like these !!
@AnalyticsVoyage8 ай бұрын
Thank you, I will 😊
@Xmorrison5368 ай бұрын
Thanks
@AnalyticsVoyage8 ай бұрын
Welcome. Thanks for watching
@stuntman4d8 ай бұрын
Real interesting and educational, cool content!
@AnalyticsVoyage8 ай бұрын
Thanks for watching. Happy that you enjoyed
@LifestylebyPegah8 ай бұрын
Uh!!! I had searched a lot for a video like this!!! Thank you 🙏🏻
@AnalyticsVoyage8 ай бұрын
Glad it was helpful! 😁
@user-ru7ti4re8q8 ай бұрын
Very interesting and educational video
@AnalyticsVoyage8 ай бұрын
Thanks for visiting
@Hodhod238 ай бұрын
Thanks for sharing the spreadsheet with us...very helpful :)
@AnalyticsVoyage8 ай бұрын
Glad it was helpful!
@friendsforever7159 ай бұрын
More tutorial for stat analysis🙏
@AnalyticsVoyage9 ай бұрын
Sure. Coming soon 😊
@yavuzselimhasturk9 ай бұрын
thank you so much :) :)
@AnalyticsVoyage9 ай бұрын
You’re more than welcome 😊
@Hodhod239 ай бұрын
It is a must in any field these days....
@AnalyticsVoyage9 ай бұрын
Absolutely!
@NargessOvesy-fl7be9 ай бұрын
Linear regression! I am gonna recommend this video to my students
@AnalyticsVoyage9 ай бұрын
Thank you! I appreciate your support and hope the video proves helpful for your students.
@NargessOvesy-fl7be9 ай бұрын
SQL is a must these days! Thanks for quick tutorial
@AnalyticsVoyage9 ай бұрын
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-fl7be9 ай бұрын
Super helpful! Thanks for great instructions
@AnalyticsVoyage9 ай бұрын
You're very welcome!
@Fatemeh0189 ай бұрын
Very helpful video, Thank you for sharing
@AnalyticsVoyage9 ай бұрын
Glad it was helpful!
@fay.m.n9 ай бұрын
🎉🎉🎉
@Jose.a2409 ай бұрын
this video is awesome. just helped me with my homework <3
@AnalyticsVoyage9 ай бұрын
Glad I could help!
@Jose.a2409 ай бұрын
Very good. Short and to the point. It helped me a lot. Thanks.
@AnalyticsVoyage9 ай бұрын
Great to hear!
@hedyehvaseli45639 ай бұрын
Thanks for this tutorial. Are you planning to have a video on multiple linear regression analysis?
@AnalyticsVoyage9 ай бұрын
Yes, definitely. Will be posted soon.
@Hodhod239 ай бұрын
Perfect, thanks
@Hodhod239 ай бұрын
Awesome
@AnalyticsVoyage9 ай бұрын
Thanks 😊
@Hodhod239 ай бұрын
🧠🧠
@hedyehvaseli45639 ай бұрын
😎😎😎
@mavisacheampomaa29839 ай бұрын
Good we want more videos
@AnalyticsVoyage9 ай бұрын
Thanks! More videos coming your way! 🎥👍
@Hodhod239 ай бұрын
Thanks a lot...that is exactly what I was looking for today.....
@AnalyticsVoyage9 ай бұрын
Glad I could help!
@HVAS909 ай бұрын
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!
@AnalyticsVoyage9 ай бұрын
Happy to help!
@HVAS909 ай бұрын
Thank you so much. Worked perfectly in 6 minutes, along with the video. Keep up.
@AnalyticsVoyage9 ай бұрын
Great to hear!
@augustdays819 ай бұрын
One more! What data can we analyze using this tool? Does the statistics distribution matter?
@AnalyticsVoyage9 ай бұрын
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.
@augustdays819 ай бұрын
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?
@AnalyticsVoyage9 ай бұрын
👍 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! 📊
@augustdays819 ай бұрын
What sort of data we can analyze using this tool? I’m very beginner 🫣
@AnalyticsVoyage9 ай бұрын
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!
@augustdays819 ай бұрын
Why would I need to download this?
@AnalyticsVoyage9 ай бұрын
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!