title
Data Analysis In Excel- 1 | Excel Data Analysis Tutorial | Excel Tutorial For Beginners |Simplilearn
description
🔥Data Analyst Master's Program (Discount Coupon: YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=DataAnalysisinExcel1-2xxMJEj4Oyg&utm_medium=Descriptionff&utm_source=youtube
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=DataAnalysisinExcel1-2xxMJEj4Oyg&utm_medium=Descriptionff&utm_source=youtube
🔥 Professional Certificate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=DataAnalysisinExcel1-2xxMJEj4Oyg&utm_medium=Descriptionff&utm_source=youtube
🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=DataAnalysisinExcel1-2xxMJEj4Oyg&utm_medium=Descriptionff&utm_source=youtube
This video on Data Analysis in Excel will help you understand how to install and use the Data Analysis Tool. You will learn to derive and analyze descriptive statistics. You will get an idea to perform a correlation analysis. You will see how to create histograms. Finally, you will understand the sampling techniques in Excel.
00:00 Descriptive Statistics
07:45 Histogram
12:00 Correlation
16:52 Sampling
🔥Free Data Analytics Course: https://www.simplilearn.com/learn-data-analytics-for-beginners-skillup?utm_campaign=DataAnalysisinExcel1&utm_medium=Description&utm_source=youtube
Start learning today's most in-demand skills for FREE. Visit us at https://www.simplilearn.com/skillup-free-online-courses?utm_campaign=BusinessAnalysis&utm_medium=Description&utm_source=youtube
Choose over 300 in-demand skills and get access to 1000+ hours of video content for FREE in various technologies like Data Science, Cybersecurity, Project Management & Leadership, Digital Marketing, and much more.
âś…Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH
⏩ Check out the Business Analytics tutorial videos: https://bit.ly/3hQFfDP
#DataAnalysisInExcel #ExcelDataAnalysisTutorial #DataAnalysis #ExcelForDataAnalysis #ExcelForBeginners #ExcelBasicsForBeginners #ExcelTutorial #ExcelTutorialForBeginners #BusinessAnalystCourse #BusinessAnalyst #BusinessAnalytics #Simplilearn
Post Graduate Program in Business Analysis:
Get your business analysis career started with our Post Graduate Program in Business Analysis, in partnership with Purdue University. This business analysis certification program helps you build extensive business expertise with real-world projects and prepares you for the business analyst role. This Post Graduate Program in Business Analysis will help you master business analysis techniques, Agile Scrum methodologies, SQL database, and visualization tools, including Excel, Power BI, and Tableau. You will learn about business analysis planning and monitoring, build interactive dashboards and understand the competencies of a Business Analyst.
Program Details:
Jumpstart your career as a Business Analysis Professional with this comprehensive curriculum covering the concepts of business analysis tools and techniques, statistics fundamentals, interaction with databases using SQL, and data visualization using excel, Power BI, and Tableau.
Key Features:
âś… Purdue Post Graduate Program Certification
âś… Purdue Alumni Association Membership
âś… Masterclasses from Purdue faculty
✅ Enrollment in Simplilearn’s JobAssist
âś… Get noticed by the top hiring companies
âś… Case Studies from Harvard Business Publishing Education
âś… Obtain 35 IIBA PDs/CDUs and 25 PMI PDUs
âś… 170+ hours of Applied Learning
âś… 11+ hands-on projects
âś… Capstone project in 3 domains
Learn more at: http://bit.ly/2KqseoV
For more information about Simplilearn’s courses, visit:
- Facebook: https://www.facebook.com/Simplilearn
- LinkedIn: https://www.linkedin.com/company/simplilearn
- Website: https://www.simplilearn.com
Get the Android app: http://bit.ly/1WlVo4u
Get the iOS app: http://apple.co/1HIO5J0
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
detail
{'title': 'Data Analysis In Excel- 1 | Excel Data Analysis Tutorial | Excel Tutorial For Beginners |Simplilearn', 'heatmap': [{'end': 95.075, 'start': 48.949, 'weight': 0.731}, {'end': 784.995, 'start': 769.102, 'weight': 0.809}], 'summary': 'Learn to utilize excel add-ins for descriptive analysis, obtain descriptive statistics, create histograms, and perform correlation analysis for variables like temperature, ice cream price, and units sold, with specific examples and quantifiable data.', 'chapters': [{'end': 85.709, 'segs': [{'end': 85.709, 'src': 'embed', 'start': 8.666, 'weight': 0, 'content': [{'end': 13.755, 'text': 'hi, everyone, welcome to this tutorial on microsoft excel.', 'start': 8.666, 'duration': 5.089}, {'end': 21.147, 'text': "let's quickly see some more examples of doing data analysis using excel,", 'start': 13.755, 'duration': 7.392}, {'end': 28.178, 'text': 'and for that we can Use some inbuilt add ins which can be added to our excel sheet.', 'start': 21.147, 'duration': 7.031}, {'end': 30.919, 'text': 'so, for example, if you would want to do a descriptive.', 'start': 28.178, 'duration': 2.741}, {'end': 42.002, 'text': 'analytics or descriptive analysis on your data, say, for example, getting your descriptive statistics, such as your mean median mode and so on.', 'start': 31.659, 'duration': 10.343}, {'end': 44.983, 'text': 'so we can do that and we can use excel for it.', 'start': 42.002, 'duration': 2.981}, {'end': 48.949, 'text': 'So, for example, you can, if you are given some data,', 'start': 45.407, 'duration': 3.542}, {'end': 56.132, 'text': 'say I have temperature price of ice cream units sold and I would want to have descriptive statistics on this.', 'start': 48.949, 'duration': 7.183}, {'end': 64.736, 'text': 'What I can do is I can click on file and here in file, you can click on options and within options, click on add-ins.', 'start': 56.612, 'duration': 8.124}, {'end': 70.059, 'text': 'Now within add-ins, you have Excel add-ins, which is selected here.', 'start': 65.477, 'duration': 4.582}, {'end': 78.985, 'text': 'so click on, say go, for example, and that shows what add-ins are available and you can choose which ones are you interested in.', 'start': 70.58, 'duration': 8.405}, {'end': 85.709, 'text': 'so, for example, i have chosen analysis tool pack and solver add-in and click on.', 'start': 78.985, 'duration': 6.724}], 'summary': 'Tutorial covers using excel for data analysis with inbuilt add-ins for descriptive statistics and analytics.', 'duration': 77.043, 'max_score': 8.666, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg8666.jpg'}], 'start': 8.666, 'title': 'Utilizing excel for data analysis', 'summary': 'Provides guidance on leveraging excel add-ins to perform descriptive analysis, including mean, median, and mode statistics, demonstrated through the selection of analysis tool pack and solver add-in.', 'chapters': [{'end': 85.709, 'start': 8.666, 'title': 'Using excel for data analysis', 'summary': 'Demonstrates how to utilize excel add-ins for performing descriptive analysis, such as obtaining mean, median, and mode statistics, on given data, exemplified by selecting the analysis tool pack and solver add-in.', 'duration': 77.043, 'highlights': ['By utilizing Excel add-ins like the analysis tool pack and solver add-in, users can perform descriptive analysis on data, obtaining statistics such as mean, median, and mode.', "The process involves clicking on 'File', then 'Options', followed by 'Add-ins', and finally selecting the desired add-ins from the available options.", 'Examples of data analysis using Excel are presented, highlighting the potential to derive descriptive statistics for various parameters like temperature, price, and units sold.']}], 'duration': 77.043, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg8666.jpg', 'highlights': ['Users can perform descriptive analysis using Excel add-ins like the analysis tool pack and solver add-in.', "The process involves clicking on 'File', then 'Options', followed by 'Add-ins', and selecting the desired add-ins.", 'Examples of data analysis using Excel are presented, showcasing the potential to derive descriptive statistics for various parameters.']}, {'end': 535.963, 'segs': [{'end': 113.517, 'src': 'embed', 'start': 85.709, 'weight': 1, 'content': [{'end': 89.752, 'text': 'ok, now that basically should add more options to your excel.', 'start': 85.709, 'duration': 4.043}, {'end': 95.075, 'text': 'so if you click on data, so here you see data analysis and solver,', 'start': 89.752, 'duration': 5.323}, {'end': 101.41, 'text': 'And this is what we would want to use to get our descriptive statistics for these three columns.', 'start': 96.027, 'duration': 5.383}, {'end': 108.314, 'text': "So for example, let's say temperature or you can even give the names later.", 'start': 101.95, 'duration': 6.364}, {'end': 110.615, 'text': 'Once you get your descriptive statistics.', 'start': 108.514, 'duration': 2.101}, {'end': 113.517, 'text': "So for example, let's go for data analysis.", 'start': 111.115, 'duration': 2.402}], 'summary': 'Add more options to excel for data analysis and descriptive statistics.', 'duration': 27.808, 'max_score': 85.709, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg85709.jpg'}, {'end': 214.353, 'src': 'embed', 'start': 191.186, 'weight': 3, 'content': [{'end': 201.746, 'text': 'so this one is our range should be only the values, numeric values, on which we would want the descriptive statistics.', 'start': 191.186, 'duration': 10.56}, {'end': 203.787, 'text': 'we have output range already selected.', 'start': 201.746, 'duration': 2.041}, {'end': 214.353, 'text': 'we have summary statistics and now you can click on ok, and that basically gives your descriptive statistics for temperature.', 'start': 203.787, 'duration': 10.566}], 'summary': 'Descriptive statistics for temperature: numeric range, summary statistics, output range.', 'duration': 23.167, 'max_score': 191.186, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg191186.jpg'}, {'end': 275.682, 'src': 'embed', 'start': 247.025, 'weight': 4, 'content': [{'end': 251.328, 'text': 'Data analysis, descriptive statistics, say OK.', 'start': 247.025, 'duration': 4.303}, {'end': 253.609, 'text': 'Now you need to give a range.', 'start': 252.008, 'duration': 1.601}, {'end': 258.291, 'text': 'So here I will change my range to these values.', 'start': 254.029, 'duration': 4.262}, {'end': 261.392, 'text': 'Output range is already selected.', 'start': 258.851, 'duration': 2.541}, {'end': 264.655, 'text': 'Now we are interested in summary statistics.', 'start': 262.053, 'duration': 2.602}, {'end': 265.676, 'text': 'Click on OK.', 'start': 264.916, 'duration': 0.76}, {'end': 269.758, 'text': 'And this says output range will overwrite existing data.', 'start': 266.196, 'duration': 3.562}, {'end': 272.2, 'text': 'Press OK to overwrite data in range.', 'start': 269.939, 'duration': 2.261}, {'end': 274.061, 'text': 'I will say cancel.', 'start': 272.92, 'duration': 1.141}, {'end': 275.682, 'text': "No, that's not what we want to do.", 'start': 274.181, 'duration': 1.501}], 'summary': 'Utilize descriptive statistics for data analysis and choose appropriate range to avoid overwriting existing data.', 'duration': 28.657, 'max_score': 247.025, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg247025.jpg'}, {'end': 494.056, 'src': 'embed', 'start': 465.611, 'weight': 0, 'content': [{'end': 469.893, 'text': "Now let's look at one more example of data analysis,", 'start': 465.611, 'duration': 4.282}, {'end': 477.957, 'text': 'where we may want to look at the frequency of values or frequency of values occurring in a range of values.', 'start': 469.893, 'duration': 8.064}, {'end': 481.801, 'text': 'So, for example, if you have been given temperatures,', 'start': 478.516, 'duration': 3.285}, {'end': 494.056, 'text': 'you have been given some bins where you would want to identify how many values fall into the range of zero to 2020, to 3030, to 4040 to 50,', 'start': 481.801, 'duration': 12.255}], 'summary': 'Data analysis example: identifying frequency of temperature values in specified ranges.', 'duration': 28.445, 'max_score': 465.611, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg465611.jpg'}], 'start': 85.709, 'title': 'Using excel for descriptive statistics and data analysis', 'summary': 'Covers using excel to obtain descriptive statistics for different columns, including input and output ranges, summary statistics, confidence levels, as well as performing data analysis such as generating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'chapters': [{'end': 245.808, 'start': 85.709, 'title': 'Using excel for descriptive statistics', 'summary': 'Explains how to use excel to obtain descriptive statistics for different columns, including input and output ranges, and options like summary statistics, confidence levels, and altering ranges.', 'duration': 160.099, 'highlights': ['Explaining how to use Excel to obtain descriptive statistics for different columns The transcript provides a detailed explanation of using Excel to obtain descriptive statistics for different columns, such as temperature and price of ice cream.', 'Input and output ranges in Excel for obtaining descriptive statistics The transcript explains the process of defining input and output ranges in Excel to obtain descriptive statistics, using temperature as an example.', 'Options like summary statistics, confidence levels, and altering ranges in Excel The transcript highlights the various options available in Excel for obtaining descriptive statistics, such as summary statistics, confidence levels, and altering input ranges to exclude non-numeric data.']}, {'end': 535.963, 'start': 247.025, 'title': 'Performing data analysis in excel', 'summary': 'Explains how to use excel for data analysis, including selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'duration': 288.938, 'highlights': ['The chapter covers the process of selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'The transcript provides a detailed explanation of using Excel for data analysis, including the process of selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'It demonstrates how to select ranges, generate descriptive statistics, and create histograms in Excel to analyze the frequency of values occurring in a range and the relationships between variables.']}], 'duration': 450.254, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg85709.jpg', 'highlights': ['The chapter covers the process of selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'The transcript provides a detailed explanation of using Excel for data analysis, including the process of selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'Explaining how to use Excel to obtain descriptive statistics for different columns The transcript provides a detailed explanation of using Excel to obtain descriptive statistics for different columns, such as temperature and price of ice cream.', 'The transcript explains the process of defining input and output ranges in Excel to obtain descriptive statistics, using temperature as an example.', 'It demonstrates how to select ranges, generate descriptive statistics, and create histograms in Excel to analyze the frequency of values occurring in a range and the relationships between variables.', 'Options like summary statistics, confidence levels, and altering ranges in Excel The transcript highlights the various options available in Excel for obtaining descriptive statistics, such as summary statistics, confidence levels, and altering input ranges to exclude non-numeric data.']}, {'end': 723.393, 'segs': [{'end': 561.616, 'src': 'embed', 'start': 536.563, 'weight': 1, 'content': [{'end': 546.268, 'text': 'or you would want to do different kind of analysis, and in certain cases we may want to first do analysis on one single variable,', 'start': 536.563, 'duration': 9.705}, {'end': 548.669, 'text': 'look at the frequency of values.', 'start': 546.268, 'duration': 2.401}, {'end': 554.132, 'text': 'might we also look at the defects, and for which we can use something like Pareto chart,', 'start': 548.669, 'duration': 5.463}, {'end': 560.075, 'text': 'so we can go for histogram and that basically gives us the frequency of values.', 'start': 554.132, 'duration': 5.943}, {'end': 561.616, 'text': 'now, how do we do that?', 'start': 560.075, 'duration': 1.541}], 'summary': 'Analyzing single variable frequency of values using pareto chart and histogram.', 'duration': 25.053, 'max_score': 536.563, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg536563.jpg'}, {'end': 723.393, 'src': 'embed', 'start': 589.199, 'weight': 0, 'content': [{'end': 593.5, 'text': "so, for example, i can select this, and that's my bin range.", 'start': 589.199, 'duration': 4.301}, {'end': 602.511, 'text': "i am selecting or the option labels, because i'm using the first row, Which has the headings such as temperature and bins.", 'start': 593.5, 'duration': 9.011}, {'end': 604.774, 'text': 'Now we need to give an output range.', 'start': 602.951, 'duration': 1.823}, {'end': 610.861, 'text': "So, for example, let's say I would want my data here and that becomes my output range.", 'start': 605.074, 'duration': 5.787}, {'end': 616.549, 'text': 'So you can have a sorted histogram or basically a Pareto chart.', 'start': 611.322, 'duration': 5.227}, {'end': 626.188, 'text': "so, If that's what you're interested in, looking at the frequencies for your different ranges and here I'm also selecting chart output,", 'start': 616.549, 'duration': 9.639}, {'end': 630.612, 'text': 'because I would want to have a visual histogram which gives us the frequency', 'start': 626.188, 'duration': 4.424}, {'end': 632.614, 'text': "And it's as simple as this.", 'start': 631.212, 'duration': 1.402}, {'end': 633.755, 'text': 'Just click on OK.', 'start': 632.794, 'duration': 0.961}, {'end': 636.577, 'text': 'And now you get your bins.', 'start': 634.255, 'duration': 2.322}, {'end': 641.837, 'text': 'So it basically tells you frequency of values, which is Basically 20.', 'start': 637.278, 'duration': 4.559}, {'end': 650.121, 'text': 'but that does not mean it is only talking about the values 20, it is basically talking as a range of zero to 20..', 'start': 641.837, 'duration': 8.284}, {'end': 655.624, 'text': 'So we have zero to 20 that is two so we can basically say there is 120 here.', 'start': 650.121, 'duration': 5.503}, {'end': 660.226, 'text': 'With the 20 being the maximum value, and then there is one more 20.', 'start': 656.184, 'duration': 4.042}, {'end': 662.187, 'text': "so that's your zero to 20.", 'start': 660.226, 'duration': 1.961}, {'end': 665.869, 'text': 'then you have 20 to 30, which shows three values.', 'start': 662.187, 'duration': 3.682}, {'end': 669.725, 'text': 'so might be in that case I can say 26..', 'start': 665.869, 'duration': 3.856}, {'end': 678.573, 'text': "Is one thing, then I can say 30, that's the second one, and then basically I can look at 22.", 'start': 669.725, 'duration': 8.848}, {'end': 685.219, 'text': 'so basically, this one does not select 20 as the lower range, but it basically selects 30 as the higher range.', 'start': 678.573, 'duration': 6.646}, {'end': 688.723, 'text': 'So I do see 20 to 30 there are three entries.', 'start': 685.72, 'duration': 3.003}, {'end': 699.093, 'text': 'Similarly, we can see values of 40 and 50 And since we have selected Pareto or sorted histogram that shows in a descending order,', 'start': 689.163, 'duration': 9.93}, {'end': 704.315, 'text': 'what is the highest frequency of values within a particular range.', 'start': 699.093, 'duration': 5.222}, {'end': 711.938, 'text': 'So that shows me highest frequency is five and then you have three and three and then two.', 'start': 705.635, 'duration': 6.303}, {'end': 719.501, 'text': 'So this is how we can create a histogram and we can perform analysis on a single variable.', 'start': 712.498, 'duration': 7.003}, {'end': 723.393, 'text': 'now, as discussed earlier.', 'start': 720.43, 'duration': 2.963}], 'summary': 'Demonstration of creating a histogram and analyzing frequency of values within ranges, with maximum frequency of 5 and descending order presentation.', 'duration': 134.194, 'max_score': 589.199, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg589199.jpg'}], 'start': 536.563, 'title': 'Creating histograms for data analysis', 'summary': 'Discusses the process of creating histograms for frequency analysis using data analysis tools, selecting input and bin ranges, and generating visual histograms with frequencies of 20, 5, 3, and 2.', 'chapters': [{'end': 641.837, 'start': 536.563, 'title': 'Creating histograms for frequency analysis', 'summary': 'Discusses the process of creating a histogram for frequency analysis using data analysis tools, selecting input and bin ranges, and generating a visual histogram with a frequency of 20.', 'duration': 105.274, 'highlights': ['The process involves using data analysis tools to create a histogram for frequency analysis.', 'Selecting the input range, bin range, and output range are key steps in creating the histogram.', 'Generating a visual histogram provides a clear representation of the frequency of values, which in this case is 20.']}, {'end': 723.393, 'start': 641.837, 'title': 'Creating histogram for data analysis', 'summary': 'Explains how to create a histogram for data analysis, showing the frequency of values within different ranges, with the highest frequency being five, followed by three and two.', 'duration': 81.556, 'highlights': ['The histogram shows the highest frequency of values within a particular range, with the highest frequency being five, followed by three and two.', 'It explains the process of organizing values into different ranges and determining the frequency within each range.', 'The range of zero to 20 has the maximum value of 20 and a total of 120 entries, with 20 being the maximum value and three instances of it.', 'The range of 20 to 30 shows three values with possible entries of 26, 30, and 22, and selects 30 as the higher range, with a total of three entries.']}], 'duration': 186.83, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg536563.jpg', 'highlights': ['Generating a visual histogram provides a clear representation of the frequency of values, which in this case is 20.', 'The process involves using data analysis tools to create a histogram for frequency analysis.', 'Selecting the input range, bin range, and output range are key steps in creating the histogram.', 'The histogram shows the highest frequency of values within a particular range, with the highest frequency being five, followed by three and two.', 'The range of zero to 20 has the maximum value of 20 and a total of 120 entries, with 20 being the maximum value and three instances of it.', 'The range of 20 to 30 shows three values with possible entries of 26, 30, and 22, and selects 30 as the higher range, with a total of three entries.', 'It explains the process of organizing values into different ranges and determining the frequency within each range.']}, {'end': 929.033, 'segs': [{'end': 749.498, 'src': 'embed', 'start': 723.393, 'weight': 0, 'content': [{'end': 732.903, 'text': 'as i said, sometimes we may be interested in finding out the correlation between different variables, such as say here we have temperature,', 'start': 723.393, 'duration': 9.51}, {'end': 743.111, 'text': 'price of ice cream and units sold, and we may want to Find out the correlation between one variable to another variable,', 'start': 732.903, 'duration': 10.208}, {'end': 747.095, 'text': 'or we would want to find out the relationship between variables.', 'start': 743.111, 'duration': 3.984}, {'end': 749.498, 'text': 'Are they linearly related.', 'start': 747.996, 'duration': 1.502}], 'summary': 'Finding correlation between temperature, ice cream price, and units sold to assess linear relationship.', 'duration': 26.105, 'max_score': 723.393, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg723393.jpg'}, {'end': 792.821, 'src': 'heatmap', 'start': 769.102, 'weight': 0.809, 'content': [{'end': 775.828, 'text': "So, for example, if I search for something like correlation and let's search.", 'start': 769.102, 'duration': 6.726}, {'end': 778.81, 'text': 'So there is a function called correlation which we can use.', 'start': 775.848, 'duration': 2.962}, {'end': 784.995, 'text': 'and we can use this to calculate the correlation of temperature and units sold.', 'start': 779.37, 'duration': 5.625}, {'end': 788.578, 'text': "so, for example, let's select this and that's the function.", 'start': 784.995, 'duration': 3.583}, {'end': 792.821, 'text': 'so it says give me an first array and a second array.', 'start': 788.578, 'duration': 4.243}], 'summary': "The function 'correlation' can be used to calculate the correlation of temperature and units sold.", 'duration': 23.719, 'max_score': 769.102, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg769102.jpg'}, {'end': 826.411, 'src': 'embed', 'start': 797.145, 'weight': 1, 'content': [{'end': 805.94, 'text': "so let's select the range of values for temperature And then I'm interested in finding out the correlation of temperature and units sold.", 'start': 797.145, 'duration': 8.795}, {'end': 807.401, 'text': "So let's select this.", 'start': 806.26, 'duration': 1.141}, {'end': 810.722, 'text': 'And that basically gives me a range of values.', 'start': 808.081, 'duration': 2.641}, {'end': 815.385, 'text': 'It gives me the correlation value, which is 0.2859.', 'start': 810.983, 'duration': 4.402}, {'end': 816.206, 'text': 'Say OK.', 'start': 815.385, 'duration': 0.821}, {'end': 817.446, 'text': "And that's your value.", 'start': 816.506, 'duration': 0.94}, {'end': 822.229, 'text': 'So similarly, we can do it for temperature and price ice cream.', 'start': 818.267, 'duration': 3.962}, {'end': 826.411, 'text': "So let's go for correlation.", 'start': 822.689, 'duration': 3.722}], 'summary': 'Correlation between temperature and units sold is 0.2859.', 'duration': 29.266, 'max_score': 797.145, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg797145.jpg'}, {'end': 907.699, 'src': 'embed', 'start': 878.723, 'weight': 2, 'content': [{'end': 881.504, 'text': 'And here you have the option called correlation.', 'start': 878.723, 'duration': 2.781}, {'end': 882.985, 'text': "Let's select this.", 'start': 881.544, 'duration': 1.441}, {'end': 885.826, 'text': 'Now that basically needs an input range.', 'start': 883.545, 'duration': 2.281}, {'end': 887.887, 'text': 'So we need the range.', 'start': 886.346, 'duration': 1.541}, {'end': 895.07, 'text': 'Now I might be interested in finding out the correlation between temperature and price of ice cream and units sold.', 'start': 888.207, 'duration': 6.863}, {'end': 898.052, 'text': "So I've selected all the columns here.", 'start': 895.551, 'duration': 2.501}, {'end': 900.714, 'text': 'we will say group by columns.', 'start': 898.812, 'duration': 1.902}, {'end': 905.938, 'text': 'obviously we need to select labels in first row, because that is basically taking care of.', 'start': 900.714, 'duration': 5.224}, {'end': 907.699, 'text': 'the first row is heading.', 'start': 905.938, 'duration': 1.761}], 'summary': 'Using correlation to find relationship between temperature, ice cream price, and units sold.', 'duration': 28.976, 'max_score': 878.723, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg878723.jpg'}], 'start': 723.393, 'title': 'Correlation analysis in data', 'summary': 'Explains the importance of correlation analysis in determining the relationship between variables like temperature, price of ice cream, and units sold, using formulas to find correlations. it also covers the process of calculating correlations and utilizing data analysis add-in in excel to obtain correlation values.', 'chapters': [{'end': 775.828, 'start': 723.393, 'title': 'Correlation analysis in data', 'summary': 'Explains the importance of correlation analysis and its application in determining the relationship between variables, such as temperature, price of ice cream, and units sold, using a formula to find correlations.', 'duration': 52.435, 'highlights': ['Using correlation analysis to determine the relationship between variables like temperature, price of ice cream, and units sold.', 'Explaining the importance of finding out the correlation between different variables for data analysis.', 'Application of a formula to find the correlation between temperature and units sold.']}, {'end': 849.718, 'start': 775.848, 'title': 'Calculating correlation of temperature and sales', 'summary': 'Explains the process of calculating the correlation between temperature and units sold and temperature and price of ice cream, resulting in correlation values of 0.2859 and [value], respectively.', 'duration': 73.87, 'highlights': ['The chapter demonstrates how to use the correlation function to calculate the correlation of temperature and units sold, resulting in a correlation value of 0.2859.', 'It explains the process of using the correlation function to find the correlation value between temperature and the price of ice cream.']}, {'end': 929.033, 'start': 849.798, 'title': 'Correlation analysis with data analysis add-in', 'summary': 'Discusses how to use the data analysis add-in in excel to calculate the correlation between temperature, price of ice cream, and units sold, using all columns as input and obtaining the correlation values.', 'duration': 79.235, 'highlights': ['The chapter discusses using the data analysis add-in in Excel to calculate the correlation between temperature, price of ice cream, and units sold, using all columns as input and obtaining the correlation values. This is important as it demonstrates a practical application of data analysis in Excel.', 'To perform the correlation analysis, the speaker explains the steps of going into the data tab, clicking on data analysis, selecting the correlation option, choosing the input range, group by columns, and setting the output range, providing practical guidance for the audience.', 'The speaker emphasizes the importance of selecting labels in the first row to ensure the correct interpretation of the data, which is essential for accurate analysis and decision-making.']}], 'duration': 205.64, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg723393.jpg', 'highlights': ['Using correlation analysis to determine the relationship between variables like temperature, price of ice cream, and units sold.', 'The chapter demonstrates how to use the correlation function to calculate the correlation of temperature and units sold, resulting in a correlation value of 0.2859.', 'The chapter discusses using the data analysis add-in in Excel to calculate the correlation between temperature, price of ice cream, and units sold, using all columns as input and obtaining the correlation values.']}, {'end': 1259.073, 'segs': [{'end': 1039.714, 'src': 'embed', 'start': 983.361, 'weight': 0, 'content': [{'end': 992.946, 'text': "now might be, i'm interested in price of ice cream and units sold and if that's what i'm interested in, then i will give a range of b2 to B8,", 'start': 983.361, 'duration': 9.585}, {'end': 998.929, 'text': 'C2 to C8 and similarly you can get your analysis or correlation values.', 'start': 992.946, 'duration': 5.983}, {'end': 1011.217, 'text': "So it's very simple in Excel and you can use either the data analysis tab and get your correlation or you can use formulas and do that.", 'start': 999.61, 'duration': 11.607}, {'end': 1016.891, 'text': 'Now one more important part of data analysis is doing your sampling.', 'start': 1012.21, 'duration': 4.681}, {'end': 1020.932, 'text': 'Now sampling could be periodic sampling or random sampling.', 'start': 1017.151, 'duration': 3.781}, {'end': 1029.772, 'text': 'So sometimes you may want to look at a variable and you may want to get some values based on periodic data.', 'start': 1021.412, 'duration': 8.36}, {'end': 1033.614, 'text': "That means might be I'm interested in the range of values.", 'start': 1029.813, 'duration': 3.801}, {'end': 1039.714, 'text': "I'm interested in seeing a sample of values for a particular period.", 'start': 1033.794, 'duration': 5.92}], 'summary': 'Data analysis in excel includes price and units sold, with sampling methods like periodic and random sampling.', 'duration': 56.353, 'max_score': 983.361, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg983361.jpg'}, {'end': 1259.073, 'src': 'embed', 'start': 1234.264, 'weight': 3, 'content': [{'end': 1243.412, 'text': 'So we can use Excel to do a simple sampling and we can choose whether we would want to go for periodic sampling or random sampling.', 'start': 1234.264, 'duration': 9.148}, {'end': 1245.534, 'text': 'Thank you and keep learning.', 'start': 1243.973, 'duration': 1.561}, {'end': 1256.788, 'text': 'Hi there, if you like this video, subscribe to the Simply Learn YouTube channel and click here to watch similar videos.', 'start': 1250.333, 'duration': 6.455}, {'end': 1259.073, 'text': 'To nerd up and get certified, click here.', 'start': 1257.089, 'duration': 1.984}], 'summary': 'Excel can be used for sampling, choose periodic or random sampling. subscribe to simply learn youtube channel.', 'duration': 24.809, 'max_score': 1234.264, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg1234264.jpg'}], 'start': 929.033, 'title': 'Correlation and sampling in excel', 'summary': 'Demonstrates correlation analysis in excel for temperature, ice cream price, and units sold, alongside data sampling techniques, providing insights on correlation values and process simplicity, with specific examples and quantifiable data.', 'chapters': [{'end': 1011.217, 'start': 929.033, 'title': 'Correlation analysis in excel', 'summary': 'Demonstrates how to conduct correlation analysis in excel to determine the relationship between temperature, price of ice cream, and units sold, providing insights on the correlation values and the simplicity of the process.', 'duration': 82.184, 'highlights': ['The chapter emphasizes the process of conducting correlation analysis in Excel to determine the relationship between temperature, price of ice cream, and units sold, showcasing the correlation values as 0.96149 and 0.2859.', 'It highlights the ease of performing correlation analysis in Excel, demonstrating the process of using formulas or the data analysis tab to obtain correlation values for further analysis.']}, {'end': 1259.073, 'start': 1012.21, 'title': 'Data sampling techniques', 'summary': 'Explains the importance of data sampling in data analysis, covering periodic and random sampling techniques using excel, demonstrating the process and outcomes with specific examples and quantifiable data.', 'duration': 246.863, 'highlights': ['The chapter emphasizes the importance of data sampling in data analysis, covering periodic and random sampling techniques. This is the main focus of the chapter, highlighting the significance of data sampling in the context of data analysis.', 'Demonstrates the process of periodic sampling using Excel, including selecting a range of values, specifying the number of samples, and obtaining the output. Provides a detailed explanation of the process of periodic sampling, including specific steps and quantifiable data such as selecting a range of values and specifying the number of samples.', 'Illustrates the process of random sampling using Excel, specifying the number of random samples and demonstrating the outcome. Explains the process of random sampling, including quantifiable data such as specifying the number of random samples and demonstrating the outcome.']}], 'duration': 330.04, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/2xxMJEj4Oyg/pics/2xxMJEj4Oyg929033.jpg', 'highlights': ['The chapter emphasizes the process of conducting correlation analysis in Excel for temperature, ice cream price, and units sold, showcasing correlation values as 0.96149 and 0.2859.', 'It highlights the ease of performing correlation analysis in Excel, demonstrating the process of using formulas or the data analysis tab to obtain correlation values for further analysis.', 'The chapter emphasizes the importance of data sampling in data analysis, covering periodic and random sampling techniques.', 'Demonstrates the process of periodic sampling using Excel, including selecting a range of values, specifying the number of samples, and obtaining the output.', 'Illustrates the process of random sampling using Excel, specifying the number of random samples and demonstrating the outcome.']}], 'highlights': ['The chapter emphasizes the process of conducting correlation analysis in Excel for temperature, ice cream price, and units sold, showcasing correlation values as 0.96149 and 0.2859.', 'The chapter demonstrates how to use the correlation function to calculate the correlation of temperature and units sold, resulting in a correlation value of 0.2859.', 'The chapter discusses using the data analysis add-in in Excel to calculate the correlation between temperature, price of ice cream, and units sold, using all columns as input and obtaining the correlation values.', 'The process involves using data analysis tools to create a histogram for frequency analysis.', 'Selecting the input range, bin range, and output range are key steps in creating the histogram.', 'The histogram shows the highest frequency of values within a particular range, with the highest frequency being five, followed by three and two.', 'The range of zero to 20 has the maximum value of 20 and a total of 120 entries, with 20 being the maximum value and three instances of it.', 'The range of 20 to 30 shows three values with possible entries of 26, 30, and 22, and selects 30 as the higher range, with a total of three entries.', 'The chapter covers the process of selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'The transcript provides a detailed explanation of using Excel for data analysis, including the process of selecting ranges, generating descriptive statistics, and creating histograms to analyze relationships between variables and frequency of values occurring in a range.', 'Explaining how to use Excel to obtain descriptive statistics for different columns The transcript provides a detailed explanation of using Excel to obtain descriptive statistics for different columns, such as temperature and price of ice cream.', 'The transcript explains the process of defining input and output ranges in Excel to obtain descriptive statistics, using temperature as an example.', 'It demonstrates how to select ranges, generate descriptive statistics, and create histograms in Excel to analyze the frequency of values occurring in a range and the relationships between variables.', 'Options like summary statistics, confidence levels, and altering ranges in Excel The transcript highlights the various options available in Excel for obtaining descriptive statistics, such as summary statistics, confidence levels, and altering input ranges to exclude non-numeric data.', 'Users can perform descriptive analysis using Excel add-ins like the analysis tool pack and solver add-in.', "The process involves clicking on 'File', then 'Options', followed by 'Add-ins', and selecting the desired add-ins.", 'Examples of data analysis using Excel are presented, showcasing the potential to derive descriptive statistics for various parameters.']}