Excel is a powerful tool but its usefulness can be expanded even further with the use of a data analysis tool Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial will show you how to get excel data analysis tool which can greatly expand the functionality of Excel. Step # 1 -- Open Options Start Excel and click on the "File" button in the top left hand corner. This will present you with a menu and you need to click on "Options". The "Excel Options" window will then load. Step # 2 -- Accessing Add-Ins Settings In this window you need to navigate to the "Add-Ins" option in the left hand menu. This will provide you with a list of all the available add ins for Excel. At the bottom there is a button called "Go...", click on this. This will open the "Add-Ins" window. Step # 3 -- Locating Data Analysis This window will give you several checkbox options. You need to click in the checkbox next to the "Analysis ToolPak" option then click "OK". That is essentially how to get excel data analysis tool and to access it you need to navigate to the "Data" tab and you will see a new box called "Analysis" and within it the "Data Analysis" option.
Views: 123560 Excel, Word and PowerPoint Tutorials from Howtech
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: 232995 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: 1551991 ExcelIsFun
Learn how to create a histogram in Excel 2010 by using the Data Analysis Toolpak. Easy to do.
Views: 52319 J. Fox
Prepare your information for advanced analysis! Check out this short video from our course:
Views: 181 Learn iT! Training
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See how to add the Data Analysis Add-in in Excel 2010. 2. Add-in for Statistics This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Views: 105725 ExcelIsFun
in this video we will examine a way to create a trendline to analyze data in excel 2010
Views: 32278 LearningGivesGrowth
Learn how to use the Subtotal function in Excel to help you sort and analyse your data in easy to learn steps.
Views: 54899 Eugene O'Loughlin
This is a tutorial on how to enter the results of your questionnaires in Excel 2010. It then shows you how to create frequency tables (using the countif function not the frequency function). The next stage is creating charts.
Views: 365867 Deirdre Macnamara
Use Excel's Data Analysis Toolpak to calculate Student's t statistic to compare the means of two samples.
Views: 116172 Eugene O'Loughlin
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: 155503 ExcelIsFun
Data analysis is one of the most common tasks performed in Excel. Whether for reviewing your personal accounts or presenting findings to your business, it is an essential skill for modern knowledge workers. In recent years, some of the major changes in Excel have been designed to extend its data analysis capabilities. As well as improvements to PivotTables, including the introduction of the Power Pivot Add-in, several new data visualisation features have been added as has Power Query. In addition, a few months ago a free, standalone Business Intelligence program was released: Power BI. This webinar will show you the key tools and functions to use when conducting data analysis in Excel 2016. By the end of the webinar you'll be able to handle data sets - from the very small to the very large - and present your findings using the most appropriate charts. We will look at Excel's main data analysis features: - PivotTables - Power Pivot - Visualisation features including Power Map - Recent additions and developments https://filtered.com/
Views: 29854 Filtered
LearnAnalytics demonstrates use of Multiple Linear Regression on Excel 2010. (Data Analysis Toolpak). Data set referenced in video can be downloaded at www.learnanalytics.in/blog/wp-content/uploads/2014/02/car_sales.xlsx
Views: 63509 Learn Analytics
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Sort with Buttons 2. Sort with Dialog box 3. Sort two columns 4. Sort by Color 5. Turn On Filter keyboard = Ctrl + Shift + L 6. Filter 7. Filter By Color 8. Filter and Extract Data 9. Number Filter 10. Date Filter 11. Between Criteria Filter 12. Text Filter
Views: 184142 ExcelIsFun
http://alphabench.com/data/linear-regression.html Demonstration of linear regression in Excel using the data analysis toolpak, with a discussion of the output generated from the regression tool. This video was shot in Excel 2007, but the technique is the same for Excel 2008, 2010, 2013 and 2016. All statistics and interpretations are the same regardless of Excel version. It would work for Excel 2011 if Microsoft hadn't removed the Data Analysis Toolpak from that version. By the way, if you are trying to do this in Excel 2011 for MAC OS you can download a free companion software called StatPlusLE. Linear regression is one of the most common statistical techniques in use for making predictions and forecasting behavior. This Tutorial explains the notable statistics and how to use the linear model in making predictions. See our visual take on regression: http://alphabench.com/data/visual-linear-regression.html
Views: 107843 Matt Macarty
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels -- Column Headers 4. Row Labels -- Row Headers 5. Value Area -- this is where the calculation goes 6. Cross tabulation (row label and column label) 7. Double Click to create new sheet with data 8. Filter area -- filters whole report 9. Slicers 10. Value Field Settings Dialog box 11. Number Format For Value Field in Value Field Settings Dialog box 12. SUM function 13. Change Function in Value Field Settings Dialog box 14. Average Function 15. Format PivotTable 16. Layout For PivotTable 17. Multiple calculations: just drop field into value area multiple times and change function 18. Change Field Names in Value Field Settings Dialog box 19. Frequency Table to Count 20. Group By Dates
Views: 575721 ExcelIsFun
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Ogive Chart and Cumulative Frequencies -- Formulas (1:40 min) 2. Ogive Chart and Cumulative Frequencies -- PivotTable Pivot Table(21:00 min) 3. Pareto Chart (Sorted Column Chart for Categorical Data with Cumulative Percent Line) (28:20 min) 4. Ogive w Data Analysis Toolpak Add-in (30:51 mins) This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Views: 28808 ExcelIsFun
This video will show steps to enable data analysis tool pak in excel 2007.
Views: 9996 HowTo
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Use the Data Analysis Add-in Descriptive Statistics tool to quick calculate Numerical descriptive statistics like, Mean, Median, Mode, Standard Deviation, Range. Min, Max This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin
Views: 68464 ExcelIsFun
Views: 1019 UrbConEducation
Visit us at http://www.statisticshowto.com for more Excel and statistics videos and tips.
Views: 22218 Stephanie Glen
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: 6827219 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: 226320 ExcelIsFun
An Excel Data Table is a great way to see the results of substituting two values in a formula. For example, to see what your monthly payment will be by changing BOTH the Interest Rate and the amount that you borrow. However, reading about how to set up an Excel Data Table can be confusing. Where, exactly, do you place the Row Inputs and the Column Inputs? Seeing how a Data Table is constructed is SO much easier. I invite you to watch this short Excel Training Video Lesson to see how to set up and use an Excel Data Table to analyze your data. You can find additional resources on my website: www.thecompanyrocks.com - I look forward to your comments.
Views: 623979 Danny Rocks
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: 103788 Me ee
Download Start Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-02-Start-DataTablesFilterLogicTest.xlsx Download Finished Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-02-Finished-DataTablesFilterLogicTest.xlsx Pdf notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/E-DAB-02-DataTablesFilterLogicTest.pdf This video #2 in our class teaches about Data, Data Types, Proper Data Sets, Excel Tables, Soring, Filtering and Logical Tests. 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:12) Introduction 2. (01:14) What is Excel? What about the Data in the Cells? 3. (08:30) What is Data, Raw Data? 4. (10:01) Understanding the Difference Between Data & Information. 5. (10:45) Define Proper Data Set. 6. (in pdf notes) Why Proper Data Sets are Mandatory. 7. (14:25) Tables are not Charts 8. (14:50) Use Excel Tables For Dynamic Data. Learn about Excel Table Feature. 9. (20:00) Data Types in Proper Data Sets in Various Tools 10. (24:00) How to Sort Data. 11. (26:07) Filtering & Extracting Data. 12. (28:47) Understand & Use AND Logical Tests and OR Logical Tests 13. (34:35) 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: 10344 ExcelIsFun
A quick screencast on how to install the Data Analysis ToolPak in Excel 2007/2010.
Views: 44629 Joseph Baltrus
Views: 271124 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: 118543 Learn Analytics
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Terminology for Data sets 2. Element = Primary Key 3. Variable = Field = Column Header 4. Observation = Record 5. PivotTable to Create List of Elements or "Unique List" 6. Alt Keyboard shortcut for PivotTable on New Sheet: Alt, N, V, T, Enter 7. Excel Table Feature For Dynamic Ranges 8. Cross Sectional Data = One Date, Many Categories 9. Time Series data= Many Times, One or More Categories This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Views: 24383 ExcelIsFun
In this video, you’ll learn more about using What-if Analysis in Excel 2010. Visit https://www.gcflearnfree.org/excel2010/using-whatif-analysis/1/ for our text-based lesson. This video includes information on: • Using What-if Analysis • Using Goal Seek • Other types of What-if Analysis We hope you enjoy!
Views: 225234 GCFLearnFree.org
Download all files to follow along with video and do homework is zipped folder here: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/DownloadFilesForEDAB07.zip To download individual files, visit class web site here: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/EDAB/EDAB.htm This video teaches how to take raw data and perform Data Modeling so that you have the correct set of Proper Data Sets that allow you to efficiently and effectively perform Data Analysis. See how to Data Model with: 1) Spreadsheet formulas, 2) Power Query, and 3) Power Pivot’s Relationship feature and Implicit Measures. 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:12) Introduction 2. (00:27) What is Data Modeling? 3. (01:08) Download Files 4. (01:30) Topics Hyperlink List 5. (01:50) When to use VLOOKUP, Power Query or Power Pivot Relationships for Data Modeling 6. (02:48) When to use VLOOKUP, Power Query or Power Pivot Relationships for Data Modeling when you have Multiple Tables 7. (05:05) Spreadsheet Formulas and VLOOKUP Function to create a Data Model for Standard PivotTable Reports. See VLOOKUP, Table Formula Nomenclature and PivotTables. 8. (17:43) Power Query to import Data from an Access Database 9. (24:120 Power Query and the Merge Feature 10. (28:26) Power Query to Add Columns 11. (30:03) Load Power Query Transformation to Standard PivotTable Cache and create PivotTable 12. (31:11) Power Pivot Relationships for Multiple Tables for a Standard PivotTable Report 13. (36:15) Create Data Model PivotTable 14. (38:18) Power Pivot Com Add-in. Show Power Pivot Ribbon Tab in Excel. 15. (39:15) Look at Power Pivot Data Model 16. (41:25) Implicit vs. Explicit DAX Measures 17. (43:53) 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: 7644 ExcelIsFun
Use Excel to generate a Simple Regression Equation and to add a line of best fit to compare two sets of data. Excel also gives you an R-squared value to show how strong the correlation is between the two sets of data.
Views: 191989 Eugene O'Loughlin
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See examples of Descriptive and Inferential Statistics. 2. Learn about the terms population and sample This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Views: 20782 ExcelIsFun
Learn how to use Excel 2010 to calculate simple moving averages in Time Series Analysis. You can use this to predict future behaviour, reduce variation, and smooth data.
Views: 120627 Eugene O'Loughlin
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Column Headers 2. Row Headers 3. Cells 4. Scroll Bars = Expose more of the workbook 5. Worksheets = All The Cells 6. Sheet Tab Names = Name of Worksheet 7. Workbooks = All Worksheets 8. File = Workbook 9. File Extensions: .xlsm 10. Ribbon Tabs 11. QAT - Quick Access Toolbar 12. Excel does 4 things: a. Store Raw Data b. Make Calculations c. Data Analysis d. Charts 13. Keyboard Shortcuts 14. Move Through Sheets = Ctrl + PageUp/PageDown 15. Show File Extension: Folder Options, View Tab, Uncheck "Hide Extensions for Known File Types" 16. Undo = Ctrl + Z This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Views: 119346 ExcelIsFun