Home
Search results “Data analysis tools in excel”

15:51
This video covers a few topics using the data analysis tool. After this video you should be able to: a) Find and use data analysis on excel to calculate statistics b) Calculate the mean, median, mode, standard deviation, range and coefficient variation on a variable set of data in excel. c) Conduct a confidence interval in excel. d) Complete a T-test in excel to help complete a hypothesis test. e) Conduct a linear regression analysis output from excel and create a scatter diagram.
Views: 90298 Me ee

06:02
www.ozanozcan.us
Views: 252501 ozanteaching

05:52
Data Analysis using Microsoft Excel using SUMIF , CHOOSE and DATE Functions
Views: 68537 TEKNISHA

55:13
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( 00:53 min mark) 2. How Data Must Be Setup ( 02:53 min mark) Sort: 3. Sort with 1 criteria ( 04:35 min mark) 4. Sort with 2 criteria or more ( 06:27 min mark) 5. Sort by color ( 10:01 min mark) Filter: 6. Filter with 1 criteria ( 11:26 min mark) 7. Filter with 2 criteria or more ( 15:14 min mark) 8. Filter by color ( 16:28 min mark) 9. Filter Text, Numbers, Dates ( 16:50 min mark) 10. Filter by Partial Text ( 20:16 min mark) Pivot Tables: 11. What is a PivotTable? ( 21:05 min mark) 12. Easy 3 step method, Cross Tabulation ( 23:07 min mark) 13. Change the calculation ( 26:52 min mark) 14. More than one calculation ( 28:45 min mark) 15. Value Field Settings (32:36 min mark) 16. Grouping Numbers ( 33:24 min mark) 17. Filter in a Pivot Table ( 35:45 min mark) 18. Slicers ( 37:09 min mark) Charts: 19. Column Charts from Pivot Tables ( 38:37 min mark) Formulas: 20. SUMIFS ( 42:17 min mark) 21. Data Analysis Formula or PivotTables? ( 45:11 min mark) 22. COUNTIF ( 46:12 min mark) 23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark) Getting Data Into Excel 24. Import from CSV file ( 51:21 min mark) 25. Import from Access ( 54:00 min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 1480422 ExcelIsFun

02:05
Illustrates how to Add-In the Data Analysis ToolPak in Excel. Excel statistics data analysis toolpak. Check out our brand-new Excel Statistics Text: https://www.amazon.com/dp/B076FNTZCV In the text we cover installing the Data Analysis ToolPak and much more. YouTube Channel: https://www.youtube.com/user/statisticsinstructor
Views: 210146 Quantitative Specialists

09:10
Views: 113072 Learn Analytics

02:22:43
Views: 401524 ExcelIsFun

06:37
Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about how to automatically creates statistics for Linear Regression using the Data Analysis Regression feature. See how to automatically create statistics such as: Correlation, R Squared, Standard Error, Slope, Intercept, SST, SSR, SSE, F Test, Test Statistic, t Test Statistics, p-values, predicted vales, residuals, Residual plots and more. Install: File, Options, Add-ins, Data Analysis Toolpak. Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Views: 24117 ExcelIsFun

12:13
Views: 15727 ExcelIsFun

10:40
This video is part of the Analyzing and Visualizing Data with Excel course available on EdX. To sign up for the course, visit: http://aka.ms/edxexcelbi
Views: 385975 DAT206x

42:30
Views: 17774 Simplilearn

12:42
This video demonstrates how to conduct a two-way ANOVA (ANOVA: Two-Factor with Replication) using Excel 2016 Data Analysis Tools. The assumptions for two-way ANOVA are tested using histogram and boxplot graphs.
Views: 22814 Dr. Todd Grande

01:03

01:02:47
In this 1 hour Webinar, Dr. Nitin Paranjape (Office MVP) will show you how to structure and analyze large amount of data in just a few seconds using Excel 2013's Power BI features: Pivot Table, Power Pivot, Power Query and Power View. Topics covered: - Purpose of data analysis (2:30) - Data Analysis process (4:06) - Good data vs Bad data (5:34) - Rules for Good data (9:05) - Common Examples of badly formatted data (10:41) - How to handle cross-tab data with Power Query (14:44) - Gather data from the web with (18:57) - Power Query's Data Catalogue Search (20:00) - Split Column by Delimiter (20:05) - Refresh live data in Power Query (23:20) - Summarize Data in Pivot Tables (24:26) - Do Calculation right inside Pivot Tables with Calculated Fields (27:33) - Avoid Wrong calculations with Get Pivot Data (29:10) - Data Visualization with Conditional Formatting & Quick Analysis (31:12) - Limitations of Pivot Table (34:38) - Why use Power Pivot (35:19) - Analyze 43 million rows of data within Power Pivot (36:40) - Build interactive dashboards with Power View (41:42) - Share Power View reports on Sharepoint (47:15) - Manage viewing rights with Excel's Browser View option - Create 3D map reports in Power Map (49:38) - Power BI Preview (55:20) - Summary: Which tool to use in which scenario? (59:03) - Notes to Developers (59:17) This is a recording of the Data Analytics Webinar for Microsoft, powered by Economic Times. The webinar was conducted by Dr. Nitin Paranjape, Office MVP and Microsoft Regional Director.
Views: 13043 Efficiency 365

04:13
Views: 26471 Learn Analytics

06:25
Microsoft Excel, this list covers all the basics you need to start entering your data and building organized workbooks Main Play list : http://goo.gl/O5tsH2 (70+ Video) Subscribe Now : http://goo.gl/2kzV8M Topics include: 1. What is Excel and what is it used for? 2. Using the menus 3. Working with dates and times 4. Creating simple formulas 5. Formatting fonts, row and column sizes, borders, and more 6. Inserting shapes, arrows, and other graphics 7. Adding and deleting rows and columns 8. Hiding data 9. Moving, copying, and pasting 10. Sorting and filtering data 11. Securing your workbooks 12. Tracking changes
Views: 60518 tutorbeta

01:57

02:44
See how to Install Data Analysis Add-in using Excel Options and the Add-in Feature. This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin
Views: 221545 ExcelIsFun

01:43
The Data Analysis Tool Pack comes with the Excel software, but needs to be added in before you can use it. This video gives you the steps necessary to install-add-in the function. With this tool pack you can run summary - descriptive statistics, correlation, regression, t-tests, ANOVAs, etc.
Views: 659 Chris Olson

01:15
Views: 35985 ExcelIsFun

05:12
Microsoft Certified Trainer Melissa Esquibel shows you how to slice and dice data and present it in an attractive visual package.

05:44
Excel 2010 Data Analysis and Descriptive Statistics
Views: 176717 jjmcgrory

01:46:44
Views: 43205 Data Science Dojo

03:09
Views: 11500 Sali Kaceli

21:04
This video demonstrated the use of some of Excel's tools designed for what-if analysis. It uses the simple example of the PMT function in a loan calculator to demostrate Goal Seek, Data Tables and Conditional Formatting.
Views: 293524 Martin Green

07:21
Excel's Data Analysis Toolpak provides many statistical tools including an option to calculate the t Statistics for Paired/Dependent Samples. In this video you will learn first how to set up the Data Analysis Toolpak, and secondly how to use it to calculate the t Statistic for dependent samples. The data used are pre and post test scores. Participants are tested more than once and there are two groups of scores. IMPORTANT - if you are looking to learn how to manually calculate t, I have a separate video showing you how to do this. Here's the link: http://youtu.be/J5UwIoL2IGo.
Views: 4789 Eugene O'Loughlin

05:41
We will create a Histogram in Excel using the Histogram tool in the Data Analysis ToolPak, and we will let Excel choose the number of classes/bins to use.
Views: 11255 Vickie Dominguez

31:26
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/002-MSPTDA-DataAnalysisBusinessIntelliegence-Terms.xlsx Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/002-MSPTDA-DataAnalysisBusinessIntelliegence-Terms.pdf Buy excelisfun products: https://teespring.com/stores/excelisfun-store Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor. This video defines these terms and concepts: 1. (00:10) Introduction 2. (01:17) Data Analysis, Business Intelligence 3. (02:08) Query 4. (03:03) Goal of Data Analysis and Business Intelligence: 5. (03:30) Raw Data 6. (03:59) Proper Data Set, Field Names / Column Names / Header Names 7. (04:52) Data Type 8. (05:20) Naming things Smartly & Consistently 9. (07:41) Excel Table feature 10. (09:48) Grain or Granularity 11. (12:07) Keys: Primary Key & Foreign Key 12. (14:16) Fact Table / Transaction Table and Dimension Table / Lookup Table / Entity Tables 13. (17:04) Data Models 14. (19:43) Flat Table in Excel 15. (20:11) Relationships 16. (22:30) Star Schema Data Model 17. (23:32) Snow Flake Data Model 18. (25:12) Relational Database = Normalized Database 19. (25:46) Columnar Database 20. (27:52) Clean Raw Data, Transform Data Sets, Import Data 21. (29:00) ETL, Data Warehousing, SQL 22. (30:35) Concluding Picture and Summary
Views: 11482 ExcelIsFun

10:15
This video demonstrates how to conduct and interpret a multiple linear regression (multiple regression) using Microsoft Excel data analysis tools. Multiple regressions return the contribution of multiple predictor variables on one outcome variable. Predicted values for the outcome variable are calculated using the estimated regression equation.
Views: 11045 Dr. Todd Grande

17:50
Visualization of data is a powerful method to see trends and make decisions. Microsoft Excel trending capabilities are tools to visualize large data sets, such as financial information on company performance.
Views: 12834 APMonitor.com

07:56
Simple Linear Regression using Microsoft Excel

21:01
A common task for scientists and engineers is to analyze data from an external source. By importing the data into Python, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. See http://apmonitor.com/che263/index.php/Main/PythonDataAnalysis
Views: 150758 APMonitor.com

03:50
Get your team the right tools for the job. We will make them for you. http://www.mongoosecoding.com Mongoose Coding provides professional Microsoft Excel consulting and development services. This video demonstrates advanced spreadsheet design and showcases Excel features used to make navigable, intuitive data modeling or forecasting spreadsheets. Use macros, vba scripting and advanced formula setups to create a sophisticated forecasting tool. www.mongoosecoding.com
Views: 39370 Docmo

48:04
In this workshop, get an introduction to the latest analysis and visualization capabilities in Excel 2016. See how to import data from different sources, create mash/ups between data sources, and prepare the data for analysis. After preparing the data, learn about how business calculations - from simple to more advanced - can be expressed using DAX, how the result can be visualized and shared.
Views: 28008 Microsoft Power BI

08:54
See how to create a Frequency Distribution, a Cumulative Freqency Distribution, a Histogram Chart and an Ogive Chart with the Data Analysis Add-in. Chapter 02 Busn 210 Business and Economic Statistics and Excel Class This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin
Views: 150750 ExcelIsFun

10:40

03:44
This video explains how to install the Data Analysis Toolpak in Excel 2016 for Mac in order to do statistical calculations. It was prepared for a statistics course using Pagano's Understanding Statistics in the Behavioral Sciences at Azusa Pacific University. After the explanation, there is a biblical reflection linked to the topic. Please skip this final portion if it offends you or does not interest you.
Views: 31537 David Dunaetz

10:10
Learn how to use the new Data Analysis tools in Excel 2016.

02:34
Excel pivot tables are incredible tools that allow you to analyze large data sets many different ways in seconds. Produced by Sara Silverstein ----------------------------------------­---------- Follow BI Video on Twitter: http://bit.ly/1oS68Zs Follow BI Video On Facebook: http://on.fb.me/1bkB8qg Read more: http://www.businessinsider.com/ ----------------------------------------­---------- Business Insider is the fastest growing business news site in the US. Our mission: to tell you all you need to know about the big world around you. The BI Video team focuses on technology, strategy and science with an emphasis on unique storytelling and data that appeals to the next generation of leaders – the digital generation.
Views: 19840 BI Excel

12:03
This video demonstrates how to conduct a one-way ANOVA (ANOVA: Single Factor) using Excel 2016 Data Analysis Tools. The assumptions for one-way ANOVA are tested using histogram and boxplot graphs.
Views: 44957 Dr. Todd Grande

18:47
Views: 238645 Trump Excel

17:05
Knowledge Varsity (www.KnowledgeVarsity.com) is sharing this video with the audience.
Views: 130083 KnowledgeVarsity

06:43
Knowledge Varsity (www.KnowledgeVarsity.com) is sharing this video with the audience. This video shows how we can use Excel's inbuilt data analysis toolkit or toolpak to find out the correlation coeffecient. Infact the toolkit is very handy and should be used for finding out correlation.
Views: 20824 KnowledgeVarsity

05:37
One of the most useful tools in Excel is often the least used. Pivot Tables allow you to quickly manipulate data to draw meaningful analysis. This tutorial walks you through a simple slicing and dicing of the interim results for the 2008 presidential primary.
Views: 140896 geekannex

03:36
This video will guide you through the installation of Analysis ToolPak in Excel on your PC.
Views: 15001 gscoic1

05:33
A tutorial demonstrating how to carry out a T-test in microsoft Excel using the built-in Data analysis tool pack This is part of a series of tutorials designed to help research scientists in the use of certain software applications commonly used in scientific laboratory work. You can find the entire set of tutorial videos here: http://ehealth.kcl.ac.uk/sites/physiology/ The screencast videos have been made by the author (Dr James Clark, King's College London) in response to common questions raised by students on BSc and MSc courses and are recorded using Camtasia Studio. The content is targeted at students of all levels of undergraduate and postgraduate education as well as professional research scientists. If you wish to link to this video on another web site please make sure you credit the author and provide a link to the blog site (shown above) ©2013 James Clark, king's College London. All rights reserved.
Views: 147156 Dory Video

07:31
This video demonstrates how to conduct a two-way ANOVA with one value per combination of the independent variables (ANOVA: Two-Factor without Replication) using Excel Data Analysis Tools.
Views: 10067 Dr. Todd Grande

01:09:45
With the explosion of public health data online, more journalists than ever need analytical tools in their daily work. Using a spreadsheet for simple tasks makes a journalist better at finding a story, fending off bogus ideas and sharpening the questions they can ask. This webinar will teach newcomers how to use a spreadsheet to do simple data cleanup and analysis for journalism. Presenter: Paul Overberg, former data editor of USA Today. For more info and presentation links, visit: http://www.reportingonhealth.org/content/excel-basics-analyzing-health-data

04:34
When you need to select a sample from a population for analysis, it is important that you are sure that the sample is randomly drawn from the population. This will remove bias - if you do not use random selection the sample could favour selection for certain groups, possibly without you even realizing it. Learn how to use Data Analysis tools to let Excel randomly select sample data for you. Requires Excel's Data Analysis Toolpak Add-In.
Views: 34830 Eugene O'Loughlin

59:52