Home
Search results “Excel data analysis 2010”

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

01:03

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: 1599308 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: 250113 Quantitative Specialists

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

01:06
Views: 14663 Dwight Stoll

23:14
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Learn how to sort a data set with 1 click 2. Learn the basics of creating PivotTables 3. See how to create a cross tabulated table (calculation with 2 criteria) 4. See how to calculate Sum, Average and Standard Deviation with one criteria using a PivotTable 5. See how to count the number of times an item occurs in a filed by droping the same field in the Row Labels area and the Values area This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Views: 83444 ExcelIsFun

09:10
Views: 122426 Learn Analytics

18:26
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: 185392 ExcelIsFun

31:08
Views: 12670 Tom Gallagher

10:31
Please visit our website http://elkhartgroup.com for more advanced solutions. Using 3 different terms of data and Excel 2010 to perform ANOVA to determine if there is a significant difference in the progression term-over-term at alpha - 0.20 (note that if one were to do year over year there *would* be a significant F-Test - this is why 'static' data is almost useless for modeling change).
Views: 223886 Matt Wiley

04:49
Excel 2010 example with Nicole Virant. You can reach her at [email protected]
Views: 71555 Nicole Virant

15:10
Statistical Analysis Functions with Excel: COUNTIF, COUNTIFS, LARGE, MEDIAN, AVERAGE, MODE, RANK, ROUND, SMALL, STDEV, SUMIF
Views: 21882 Ralph Phillips

24:09
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: 577319 ExcelIsFun

04:08
Learn how to create a histogram in Excel 2010 by using the Data Analysis Toolpak. Easy to do.
Views: 54248 J. Fox

09:18

05:20
How to perform a simple t-test in Microsoft Excel
Views: 1270085 Jim Grange

09:14
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: 67528 Learn Analytics

35:11
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: 28983 ExcelIsFun

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: 157961 ExcelIsFun

14:08
Views: 41246 Tom Gallagher

14:37
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: 381975 Deirdre Macnamara

04:13
Views: 33615 Learn Analytics

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

02:14
Views: 140944 Quantitative Specialists

03:42
Use Excel's Data Analysis tool to display a range of descriptive statistics (such as mean, node, median, range, standard deviation, variance) in one simple step.
Views: 28063 Eugene O'Loughlin

02:20
Views: 115331 BIA 2610 and 3621

07:56
Simple Linear Regression using Microsoft Excel

11:43
How to run a correlation analysis using Excel and write up the findings for a report
Views: 316609 Chris Olson

07:08
Learn how to use the Subtotal function in Excel to help you sort and analyse your data in easy to learn steps.
Views: 55295 Eugene O'Loughlin

07:34
Download this excel file: http://www.codible.com/pages/44 Description: A data table lets you do what-if analysis by computing and displaying formulas for different values of a variable input.
Views: 127392 Codible

14:48
Views: 7365613 Excel Campus - Jon

02:54
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: 68835 ExcelIsFun

04:25
https://alphabench.com/data/excel-descriptive-statistics.html Generate a table of descriptive statistics in Excel for Windows and Excel 2016 for the MAC with the Data Analysis Toolpak Addin. Descriptive statistics or simply descriptives are used to characterize data sets with summary measurements that act as a simple way to summarize data. Descriptives along with a visualization of a data set are the first steps in any data analysis.
Views: 44659 Matt Macarty

05:16
How to calculate the Correlation using the Data Analysis Toolpak in Microsoft Excel is Covered in this Video (Part 2 of 2). Check out our brand-new Excel Statistics Text: https://www.amazon.com/dp/B076FNTZCV In the text we cover the p-value for Correlation and much more. YouTube Channel: https://www.youtube.com/user/statisticsinstructor Channel Description: For step by step help with statistics, with a focus on SPSS (with Excel videos now too). Both descriptive and inferential statistics covered. For descriptive statistics, topics covered include: mean, median, and mode in spss, standard deviation and variance in spss, bar charts in spss, histograms in spss, bivariate scatterplots in spss, stem and leaf plots in spss, frequency distribution tables in spss, creating labels in spss, sorting variables in spss, inserting variables in spss, inserting rows in spss, and modifying default options in spss. For inferential statistics, topics covered include: t tests in spss, anova in spss, correlation in spss, regression in spss, chi square in spss, and MANOVA in spss. New videos regularly posted. Videos series coming soon include: multiple regression in spss, factor analysis in spss, nonparametric tests in spss, multiple comparisons in spss, linear contrasts in spss, and many more. Subscribe today! YouTube Channel: https://www.youtube.com/user/statisticsinstructor
Views: 616863 Quantitative Specialists

07:54
http://www.excelfornoobs.com http://www.subjectmoney.com http://www.subjectmoney.com/articledi... What we have built here is a Microsoft Excel template that can be used to analyze the performance of sales representatives with a focus on restaurant servers (waiters and waitresses). In this example we are analyzing the quarterly performance of the restaurant as a whole, and each sales unit (the servers). We will also take a deeper look into each month that the quarterly sales report consists of: January, February and March. Our goal in analyzing this sales report is to improve the sales performance of our servers.
Views: 94002 Surfwtw

19:05
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: 119593 ExcelIsFun

06:36
This video illustrates the application of ANOVA or analysis of variance in Excel 2010 - a powerful statistical method to analyze whether the data of two (or more) groups is similar. In other words, whether the means are same for the two sample or population.

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: 113331 Me ee

04:32
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: 227477 GCFLearnFree.org

08:46
Analyze data using Excel. Use standard deviation, make a graph with a trendline, include error bars, determine the uncertainty in the slope and y-intercept using LINEST.
Views: 249206 WCEastFZX

06:07
Prepare your information for advanced analysis! Check out this short video from our course:
Views: 191 Learn iT! Training

06:09
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: 109364 Matt Macarty

00:46
This video shows how to enable the Data Analysis toolpak in Excel 2010.
Views: 16864 SCSUEcon

06:43
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: 648513 Danny Rocks

01:08
Installing data analysis toolpak -- Excel 2010 Windows
Views: 551 apethan

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: 156206 Dory Video

01:11
How to activate Data Analysis Add-Ins
Views: 89 Farok Vakil

01:03
Views: 41 Jonathan Miller

12:06
One of my viewers asked for my help in creating an Executive Summary Report - because her manager will not allow her to use a Pivot Table. Here are the tips and techniques that I demonstrate in this lesson: 1) Use Excel's Advanced Filter to Extract a list of unique customer names from a filed with over 4,000 records. 2) Convert a normal range of data cells into an Excel 2007 / 2010 Table (as a List in Excel 2003) - so that range references will update automatically when you append records. 3) Create Named Ranges of Cells that you can use in Formulas & Functions. 4) Use the SUMIF, AVERAGEIF and COUNTIF Functions in the Summary Report. I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video tutorials. Danny Rocks The Company Rocks
Views: 1139888 Danny Rocks