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: 104023 Me ee
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: 233428 Quantitative Specialists
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: 1553026 ExcelIsFun
Views: 271478 ozanteaching
We demonstrate installing Data Analysis ToolPak excel addin and how to build a Karl Pearson Correlation Matrix easily. The data set used can be downloaded from http://www.learnanalytics.in/blog/?p=150 . Please subscribe to our channel to receive updates and also join our Linkedin Group for latest training videos and articles @http://www.linkedin.com/groups/Learn-Analytics-step-time-4240061
Views: 118629 Learn Analytics
Business Analytics with excel training has been designed to help initiate you to the world of analytics. For this we use the most commonly used analytics tool i.e. Microsoft Excel. The training will equip you with all the concepts and hard skills required to kick start your analytics career. If you already have some experience in the IT or any core industry, this course will quickly teach you how to understand data and take data driven decisions relative to your domain using Microsoft excel. Data Science Certification Training - R Programming: https://www.simplilearn.com/big-data-and-analytics/data-scientist-certification-sas-r-excel-training?utm_campaign=Data-Excel-W3vrMSah3rc&utm_medium=SC&utm_source=youtube For a new-comer to the analytics field, this course provides the best required foundation. The training also delves into statistical concepts which are important to derive the best insights from available data and to present the same using executive level dashboards. Finally we introduce Power BI, which is the latest and the best tool provided by Microsoft for analytics and data visualization. What are the course objectives? This course will enable you to: 1. Gain a foundational understanding of business analytics 2. Install R, R-studio, and workspace setup. You will also learn about the various R packages 3. Master the R programming and understand how various statements are executed in R 4. Gain an in-depth understanding of data structure used in R and learn to import/export data in R 5. Define, understand and use the various apply functions and DPLYP functions 6. Understand and use the various graphics in R for data visualization 7. Gain a basic understanding of the various statistical concepts 8. Understand and use hypothesis testing method to drive business decisions 9. Understand and use linear, non-linear regression models, and classification techniques for data analysis 10. Learn and use the various association rules and Apriori algorithm 11. Learn and use clustering methods including K-means, DBSCAN, and hierarchical clustering Who should take this course? There is an increasing demand for skilled data scientists across all industries which makes this course suited for participants at all levels of experience. We recommend this Data Science training especially for the following professionals: IT professionals looking for a career switch into data science and analytics Software developers looking for a career switch into data science and analytics Professionals working in data and business analytics Graduates looking to build a career in analytics and data science Anyone with a genuine interest in the data science field Experienced professionals who would like to harness data science in their fields Who should take this course? There is an increasing demand for skilled data scientists across all industries which makes this course suited for participants at all levels of experience. We recommend this Data Science training especially for the following professionals: 1. IT professionals looking for a career switch into data science and analytics 2. Software developers looking for a career switch into data science and analytics 3. Professionals working in data and business analytics 4. Graduates looking to build a career in analytics and data science 5. Anyone with a genuine interest in the data science field 6. Experienced professionals who would like to harness data science in their fields For more updates on courses and tips follow us on: - Facebook : https://www.facebook.com/Simplilearn - Twitter: https://twitter.com/simplilearn Get the android app: http://bit.ly/1WlVo4u Get the iOS app: http://apple.co/1HIO5J0
Views: 30871 Simplilearn
Lecture Starts at: 8:25 Business data presents a challenge for the data analyst. Business data is often aggregated, recorded over time, and tends to exhibit autocorrelation. Additionally, and most problematically, the amount of business data is usually quite limited. These characteristics lead to a situation where many of the tools in the analyst's tool belt (e.g., regression) aren't ideal for the task. Despite these challenges, proper analysis of business data represents a fundamental skill required of Business/Data Analysts, Product/Program Managers, and Data Scientists. At this meetup presenter Dave Langer will show how to get started analyzing business data in a robust way using Excel – no programming or statistics required! Dave will cover the following during the presentation: • The types of business data and why business data is a unique analytical challenge. • Requirements for robust business data analysis. • Using histograms, running records, and process behavior charts to analyze business data. • The rules of trend analysis. • How to properly compare business data across time, organizations, geographies, etc.Where you can learn more about the tools and techniques. *Excel spreadsheets can be found here: https://code.datasciencedojo.com/datasciencedojo/tutorials/tree/master/Business%20Data%20Analysis%20with%20Excel **Find out more about David here: https://www.meetup.com/data-science-dojo/events/236198327/ -- Learn more about Data Science Dojo here: https://hubs.ly/H0f8xWx0 See what our past attendees are saying here: https://hubs.ly/H0f8xGd0 -- Like Us: https://www.facebook.com/datasciencedojo/ Follow Us: https://plus.google.com/+Datasciencedojo Connect with Us: https://www.linkedin.com/company/data-science-dojo Also find us on: Google +: https://plus.google.com/+Datasciencedojo Instagram: https://www.instagram.com/data_science_dojo/ Vimeo: https://vimeo.com/datasciencedojo
Views: 49156 Data Science Dojo
Download Start Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-05-Visualizations-Start.xlsx Download Finished Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-05-Visualizations-Finished.xlsx Pdf notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-05-Visualizations.pdf This video teaches about how to visualize in Excel with Tables, Conditional Formatting, Column and Bar Charts, Cross Tab Char (Clustered Column / Bar & Stacked Column / Bar), Line Chart, X Y Scatter Chart and Dashboards. Comprehensive Dashboard Example at end. This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more. Topics: 1. (00:15) Introduction to topics, downloading files and visualizing examples in video. 2. (01:48) Why Visualize? Table or Visualization? 3. (03:47) Edward R. Tufte and High Data/Ink Ratio Rule and “No Chart Junk Rule” 4. (05:57) Tables Formatting Rules 5. (12:05) Conditional Formatting 6. (15:45) Column and Bar Charts 7. (24:04) Cross Tab Chart: Clustered Column / Bar & Stacked Column / Bar 8. (27:10) Line Chart: 1 Number 9. (29:47) Line Chart and IF Function for line chart that shows revenue and emphasizes promotions for company. 10. (35:40) X-Y Scatter Chart: 2 Numbers 11. (37:02) Comprehensive Dashboard example with PivotTables and Charts. Print Setup to allow printing. 12. (39:26) PivotTable Custom Style 13. (53:44) Summary The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 10089 ExcelIsFun
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: 155565 ExcelIsFun
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Views: 6836603 Excel Campus - Jon
Download Excel Files: Start File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcel.xlsm Finished File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcelFinished.xlsm Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm 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: 226383 ExcelIsFun
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: 28153 Dr. Todd Grande
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: 25872 ExcelIsFun
Learn how MATLAB can supplement the capabilities of Microsoft Excel. Get a Free Trial: https://goo.gl/C2Y9A5 Get Pricing Info: https://goo.gl/kDvGHt Ready to Buy: https://goo.gl/vsIeA5 Many technical professionals find that they run into limitations using Excel for their data analysis applications. This webinar will show you how MATLAB can supplement the capabilities of Microsoft Excel by providing access to thousands of pre-built mathematical and advanced analysis functions, versatile visualization tools, and the ability to automate your analysis workflows. With MATLAB, you can efficiently explore, analyze, and visualize your data. Through product demonstrations, you will see how to: -Access data from files and Excel spreadsheets -Visualize data and customize figures -Perform statistical analysis and fitting -Generate reports and automate workflows -Share analysis tools as standalone applications or Excel add-ins This session is intended for people who are new to MATLAB. Experienced users may also benefit from the session, as the engineer will be showing capabilities from recent releases of MATLAB including the new ways to store and manage data commonly found in spreadsheets.
Views: 58101 MATLAB
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: 39433 Eugene O'Loughlin
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: 14194 Efficiency 365
Knowledge Varsity (www.KnowledgeVarsity.com) is sharing this video with the audience.
Views: 134857 KnowledgeVarsity
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: 42924 Docmo
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: 5036 Eugene O'Loughlin
https://www.datastrategywithjonathan.com Free YouTube Playlist https://www.youtube.com/playlist?list=PL8ncIDIP_e6vQ0uQofezvKv3yPnL5Unxe From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours If you use Excel for any type of reporting or analytics then this course is for you. There are a lot of great courses teaching R for statistical analysis and data science that can sometimes make R seem a bit too advanced for every day use. Also since there are many different ways of using R that can often add to the confusion. The reality is that R can be used to make your every day reporting analytics that you do in Excel much faster and easier without requiring any complex statistical techniques while at the same time giving you a solid foundation to expand into those areas if you so wish. This course uses the Tidyverse standards for using R which provides a single, comprehensive and easy to understand method for using R without complicating things via multiple methods. It's designed to build upon the the skills you are already familiar with in Excel to shortcut your learning journey. If you're looking to learn Advanced Excel, Excel VBA or Databases then you need to check out this video series. In this videos series, I will show you how to use Microsoft Excel in different ways that will make you far more effective at working with data. I'm also going to expand your knowledge beyond Excel and show you tips, tricks, and tools from other top data analytics tools such as R Tidyverse, Python, Data Visualisation tools such as Tableau, Qlik View, Qlik Sense, Plotly, AWS Quick Sight and others. We'll start to touch on areas such as big data, machine learning, and cloud computing and see how you can develop your data skills to get involved in these exciting areas. Excel Formulas such as vlookup and sumifs are some of the top reasons for slow spreadsheets. Alternatives for vlookup include power query (Excel 2010 and Excel 2013) which has recently been renamed to Get and Transform in Excel 2016. Large and complex vlookup formulas can be also done very efficiently in R. Using the R Tidyverse libraries you can use the join functions to merge millions of records effortlessly. In comparison to Excel Vlookup, R Tidyverse Join can pull on multiple columns all at the same time. Microsoft Excel Power Query and R Tidyverse Joins are similar to the joins that you do in databases / SQL. The benefit that they have over relational databases such as Microsoft Access, Microsoft SQL Server, MySQL, etc is that they work in memory so they are actually much faster than a database. Also since they are part of an analytics tool instead of a database it is much faster and easier to build your analysis and queries all in the same tools. My very first R Tidyverse program was written to replace a Microsoft Access VBA solution which was becoming complicated and slow. Note that Microsoft Access is very limited in analytics functions and is missing things as simple as Median. Even though I had to learn R programming from scratch and completely re-write the Microsoft Access VBA solution it was so much easier and faster. It blew my mind how much easier R programming with R Tidyverse was than Microsoft Access VBA or Microsoft Excel VBA. If you have any VBA skills or are looking to learn VBA you should definitely checkout my videos on R Tidyverse. To understand why R Tidyverse is so much easier to work with than VBA. R Tidyverse is designed to work directly with your data. So If you want to add a calculated column that’s around one line of script. In Excel VBA, the VBA is used to control the DOM (Document Object Model). In Excel that means that you VBA controls things like cells and sheets. This means your VBA is designed to capture the steps that you would normally do manually in Microsoft Excel or Microsoft Access. VBA is not actually designed to work directly with your data. Note the most efficient path is to reduce the data pulled down from the database in the first place. This is referring to the amount of data you are pulling down from your data warehouse or data lake. It makes no sense to pull data from a data warehouse / data lake to pull into another database to query add joins / lookups to then pull it into Excel or other analysis tool. Often analyst build these intermediate databases because they either don’t have control of the data warehouse or they need to join additional information. All of these operations are done significantly faster in a tool such as R Tidyverse or Microsoft Excel Power Query.
Views: 11999 Jonathan Ng
Learn how to visualize your data and get automated charts, totals and tables from selected data in a spreadsheet in Excel 2016 by simply clicking on one button. For more information, see also our website: http://kaceli.com More details on the video: The Quick Analysis tool will display charts, conditional formatting, pivot tables and and be able to display this data in a chart within each cell next to it. Learn more at http://learn.kaceli.com. Direct links to the videos: Excel 2016 Tutorial: https://youtu.be/8lXerL3DHRw Word 2016 Tutorial: https://youtu.be/TxLuuNprjXg PowerPoint 2016 Tutorial: https://youtu.be/lbc1HX8Jccw Access 2016 Tutorial: https://youtu.be/1IA4SeajZRw If you like the videos, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series. Keep in touch: Website: http://kaceli.com YouTube Channel: http://youtube.com/skaceli If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.
Views: 13074 Sali Kaceli
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: 32065 Microsoft Power BI
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: 142412 geekannex
This webinar highlights how MATLAB can work with Excel. Get a Free MATLAB Trial: https://goo.gl/C2Y9A5 Ready to Buy: https://goo.gl/vsIeA5 Learn MATLAB for Free: https://goo.gl/xIiHyG Many technical professionals find that they run into limitations using Excel for their data analysis applications. This webinar highlights how MATLAB can supplement the capabilities of Excel by providing access to thousands of pre-built engineering and advanced analysis functions and versatile visualization tools. Learn more about using MATLAB with Excel: http://goo.gl/3vkFMW Learn more about MATLAB: http://goo.gl/YKadxi Through product demonstrations you will see how to: • Access data from spreadsheets • Plot data and customize figures • Perform statistical analysis and fitting • Automatically generate reports to document your analysis • Freely distribute your MATLAB functions as Excel add-ins This webinar will show new features from the latest versions of MATLAB including new data types to store and manage data commonly found in spreadsheets. Previous knowledge of MATLAB is not required. About the Presenter: Adam Filion holds a BS and MS in Aerospace Engineering from Virginia Tech. His research involved nonlinear controls of spacecraft and periodic orbits in the three-body problem. After graduating he joined the MathWorks Engineering Development Group in 2010 and moved to Applications Engineering in 2012.
Views: 237522 MATLAB
Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Math146-Excel2013PivotTables&ChartsForDescriptiiveStatistics-AustinRoberts.xlsx Using Excel 2013 see how to create tabular and graphical summaries of Categorical and Quantitative data For Highline Math 146 Statistics Class: 1. (00:48) Descriptive Statistics and Data Analysis (Raw Data into Useful Information) 2. (02:31) Define Proper Data Set 3. (04:49) Example 1: From Categorical/Qualitative Data (Phone preferences data) create Frequency Distribution and Column/Bar Chart using PivotTable feature and Charting feature 4. (14:23) Example 2: From Categorical/Qualitative Data (Hospital survey data) create Percent Frequency Distribution and Pie Chart using PivotTable feature and Charting feature 5. (20:17) Page setup for printing your table and chart 6. (23:39) Example 3: From Continuous Quantitative Data (Age of Customer) create a Frequency Distribution and a Histogram Chart using PivotTable feature and Charting feature. In this example see how to with Grouped Age Data (Class Intervals) using the Grouping feature in a PivotTable. Also see how to change the gap width in a column chart to create a Histogram. 7. (30:17) Example 4: From Continuous Quantitative Data (Transaction Sales Total) create a Frequency Distribution and a Histogram Chart using PivotTable feature and Charting feature. See how to group numbers in a PivotTable and change gap width in a Column Chart to create a Histogram. 8. (35:40) Example 5: Crate a Cross tabulated Table using the PivotTable feature. Create a column Chart from a Cross Tab Report. 9. (39:30) Summary of Topics 10. (40:23) Homework Problems
Views: 29753 ExcelIsFun
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Install Data Analysis Add-in For Amazing Excel Statistical Tools in Excel 2013.
Views: 37610 ExcelIsFun
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: 54576 Dr. Todd Grande
Completing data analysis on open-ended questions using Excel. For analyzing multiple responses to an open-ended question see Part 2: https://youtu.be/J_whxIVjNiY Note: Selecting "HD" in the video settings (click on the "gear" icon) makes it easier to view the data entries
Views: 165050 Jacqueline C
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: 792 Chris Olson
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: 11888 Dr. Todd Grande
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.xlsx Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.pdf This video introduces the topics that will be covered in this Highline College BI 348 Class: Name of Class: BI 348 – Microsoft Power Tools for Data Analysis: • Power Query • Power Pivot • DAX • Power BI Desktop • Excel For Creating: • Data Models, Reports, Dashboards and Analytics Taught by Mike excelisfun Girvin, Excel MVP 2013-2018 • A class about connecting to multiple source of data, transforming the data into a refreshable & dynamic data model, and building reports and dashboards to provide insightful and actionable information. Prerequisites for this class: • Busn 216: Excel Basics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k • Busn 218: Advanced Excel, https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw • Busn 210: Business Statistics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj What Version of Excel: • Office 365 (updated each month) What Version of Power BI Desktop: • Free Tool we will download (update each month) Over View of Topics for the class: 1. Data Analysis / Business Intelligence terms and concepts that we will learn in this class: • Proper Data Set • Fact Table • Dimension Tables • Relationships • Star Schema • ETL • Measures • Dashboards • SQL • Data Warehousing 2. Learn how to use Excel Power Query: • Import Data from multiple sources • Clean and Transform Data • Create Data Components for Star Schema Data Models • Load Data To Excel, the Data Model and Connection Only • Replace Complicated Excel Solutions with Power Query Solution • Use the Power query User Interface to create Power Query Solutions • Learn about the Case Sensitive, Function-based M Code Language that is behind the scenes in Power Query 3. Learn how to use Excel Power Pivot: • Excel Power Pivot provides: i. Data Model where we can have multiple tables, formulas and relationships (Star Schema) ii. Columnar Database to hold "Big Data" and process quickly over that "Big Data" iii. New Formula Language called DAX: 1. Many More Calculations than in Standard PivotTable 2. Build One Formula that can work in many reports 3. Add Number Formatting to Formulas • Excel Power Pivot to: i. Replace VLOOKUP Formulas and Single Flat PivotTable Data Source with Multiple Tables, Relationships in the Data Model to create more efficient Reports & Dashboards ii. Use Power Pivot Columnar Database to hold millions of rows of data iii. DAX formulas have more Power than Standard PivotTable Calculations 4. Learn about Building Star Schema Data Models: a. Why they are important in Power Pivot and Power BI Desktop b. How to build them using: i. Power Query ii. Power Pivot iii. DAX iv. Power BI Desktop 5. Learn how to author DAX Formulas for Excel’s Power Pivot & Power BI Desktop: a. Calculated Column Formulas for Data Model b. Measure Formulas for PivotTables c. DAX Functions like SUMX, CALCULATE, RELATED, and Much More… d. Lean why we must create Explicit rather than Implicit formulas e. Learn how Row Context works in formulas f. Learn how Filter Context works in formulas g. Learn about Scalar & Table Functions h. Use DAX Studio to visualize and analyze DAX Formulas 6. Learn how to use Power BI Desktop: a. Power Query to import, clean, transform and create Star Schema Data Models b. Create Relationships c. Create DAX Formulas d. Build Interactive Visualizations e. Build Dashboards 7. Learn how to use Excel: • Spreadsheet Formulas & Functions • Standard PivotTables • Power Query • Power Pivot • Build Data Model PivotTables and the resultant Reports, Dashboards and Analytics 8. Building Refreshable, Insightful Dashboards a. Build Excel Dashboards b. Build Power BI Dashboards 9. Case Studies to practice using Power Pivot & Power BI Desktop for Reporting, Building Dashboards and Building Business Analytics Solutions The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 28009 ExcelIsFun
Visit us at http://www.statisticshowto.com for more Excel and statistics videos and tips.
Views: 22246 Stephanie Glen
Many more great Excel tutorials linked below: http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Technically you should say Fail to Reject Ho because you have determined there is a lack of evidence against Ho. You have not proven Ho in any significant way. With that said, many introductory courses teach students that they can conclude that we Accept Ho. Please be aware of the nuance regardless of how you choose to phrase the conclusion. Reject Ho, however, is a stronger statement that we can justifiably make using the laws of probability and the level of significance of the test. When we Reject Ho we are concluding that there is enough evidence against Ho with the state level of significance used. We are willing to accept the chance of making a Type I Error, but we are very clear about the probability of its occurrence, i.e., it is equal to alpha (at least nominally).
Views: 273805 Jalayer Academy
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: 25356 Dr. Todd Grande
Download Notes from Video: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-01-IntroductionToClass.pptx Full class web site: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/EDAB.htm This video is an introduction to the : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Des Topics: 1. (00:00) Intro Song 2. (00:12) Intro to First video in class 3. (01:36) Instructor 4. (01:59) Scope of Class 5. (02:40) Version of Excel 6. (03:30) Define Data Analysis & Business Intelligence 7. (06:00) Goals of Class 8. (09:31) Videos Topics Presented In Class 9. (10:33) Files for you to Download 10. (10:59) What You Will Gain After Taking This Class 11. (12:17) Summary The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!
Views: 15415 ExcelIsFun
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: 38425 David Dunaetz
Click this link for more information on correlation coefficients plus more FREE Excel videos and tips: http://www.statisticshowto.com/what-is-the-pearson-correlation-coefficient/
Views: 41073 Stephanie Glen