Home

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: 250989 Quantitative Specialists

02:22:43
Views: 436491 ExcelIsFun

19:28
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:21) What Is / Are Statistics? Define Statistics 2. (02:42) Descriptive Statistics and Inferential Statistics 3. (05:00) Collect, analyze and present raw data on Yahoo Stock Price: Search the internet, download, create formulas and crate a Chart and present the information in a useful way. 4. (06:05) Get Data from http://finance.yahoo.com/ 5. (06:43) Copy and paste data from internet into an Excel spreadsheet. Learn about Paste Special, Text 6. (07:28) Download a “.csv” file. “.csv” and “.txt” file types (file extensions) are text files. When you open them, they look like Excel, but it is not. We can copy and paste into a real Excel file. Text files are common files types that allow raw data to be transferred from one system to another. Text files are intermediate steps between the original Database and your Excel Spreadhseet. 7. (07:46) Control Panel, Folder Options, View Tab, Uncheck “Hide extensions for known file types” 8. (08:47) Highlight whole table keyboard is Ctrl + * 9. (09:50) Calculate maximum stock price with MAX function, minimum stock price with MIN and Mean using the AVERAGE function. 10. (11:30) Keyboard shortcuts for highlighting ranges that are not next to each other (noncontiguous ranges): Ctrl + Mouse Click 11. (12:15) Create Line Chart from Historical Data 12. (13:58) Page Setup 13. (17:52) Example of Inferential Statistics
Views: 39505 ExcelIsFun

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

01:15
Views: 38607 ExcelIsFun

41:36
Views: 166943 ExcelIsFun

33:32
Download files: http://people.highline.edu/mgirvin/excelisfun.htm This video covers how to create Frequency Distributions and Appropriate Charts for Categorical Data using Formulas, PivotTables, Column Charts, Bar Charts and Pie Charts: 1. (00:32) Overview with diagram of tables and charts we will create in this video 2. (01:01) Notes in Workbook that you can print out and read 3. (02:05) Define Frequency Distribution 4. (03:55) Frequency Distribution create from Cell Phone Sales Data 5. (04:00) Advanced Filter to get a Unique List for Frequency Distribution 6. (05:55) Using COUNTIFS function to Create Frequency Distribution 7. (07:00) Formulas to create Relative Frequency 8. (09:36) TRUNC function to show that Number Formatting does NOT remove decimals 9. (11:00) Why Relative Frequencies add up to 1: Collectively Exhaustive and Mutually Exclusive Categories 10. (11:20) Formulas to create Percent Frequency with Number Formatting 11. (13:24) Formulas to create Percent Frequency with Times 100 12. (14:54) Add Borders using Format Cells Dialog Box: Solid Top Border and Double Bottom Border 13. (16:38) Use PivotTable to create Frequency Distribution 14. (17:38) Create Relative Frequency & Percent Frequency using the “Show Values As” feature and the “% of Column Total” option 15. (19:30) Compare and Contrast Formulas and PivotTables 16. (21:09) Column Chart for Frequency Distribution with Categorical Data 17. (23:59) Column Chart for Percent Frequency Distribution with Categorical Data 18. (25:10) Bar Chart for Frequency Distribution with Categorical Data 19. (25:44) Pie Chart for Percent Frequency Distribution with Categorical Data 20. (27:30) Chart from PivotTable with Many Columns of Calculations (Trouble) 21. (28:57) Create Individual PivotTables and PivotCharts to solve “Trouble”. Frequency Distribution create from Boomerang Product Sales Data. 22. (31:11) Discrete Quantitative Data (Numbers) should be charted with a Column that has Gaps. 23. (31:55) Pareto Chart Tabular & Graphical Displays For Categorical Variables
Views: 49183 ExcelIsFun

03:39
Views: 49306 ExcelIsFun

20:17
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:43) Categorical Data vs. Quantitative Data 2. (02:00) Scales of Measurement (Levels of Measurement): Nominal, Ordinal, Interval, Ratio 3. (14:42) Cross Sectional Data vs. Time Series Data 4. (15:48) Graphical Display of types of Data 5. (16:22) How to Enter Data into the spreadsheet and use the Auto Complete (Auto Text) to your benefit 6. (18:50) How to create a new Excel Workbook to do your Homework from the Textbook
Views: 35948 ExcelIsFun

00:21
Views: 85 Maydina rini

00:40
This brief video shows how to load the Data Analysis Add-in in Microsoft Excel 2016. Same procedure applies in Excel 2013.
Views: 20627 Joshua Emmanuel

02:44
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: 229467 ExcelIsFun

16:06
Views: 8356 David Dunaetz

04:21
Views: 177128 Excel Campus - Jon

02:20
Views: 116035 BIA 2610 and 3621

11:28
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Intro to Exponential Probability Distribution 2. (03:05) Average time between Arrivals at Dick’s Hamburger Restaurant example with EXPON.DIST function 3. (07:02) Average time to wait in a Disney Line example using EXPON.DIST function and formulas.
Views: 6575 ExcelIsFun

09:41
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Accounting Example with Expected Value and Standard Deviation calculated from a Discrete Probability Distribution 2. (04:48) Finance Example with Expected Value and Standard Deviation calculated from a Discrete Probability Distribution
Views: 11411 ExcelIsFun

05:01
Download files: http://people.highline.edu/mgirvin/excelisfun.htm This video covers skew in a distribution of data points and the SKEW function.
Views: 8403 ExcelIsFun

09:02
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:16) Over View of File Import and Histogram Creation 2. (00:56) Look at Zipped Folder from class download then unzip it with Right-click, “Extract All” 3. (01:15) Text Files for communication between databases and data analysis programs like Excel 4. (02:06) Use Power Query to Import Multiple Files 5. (02:10) Get External Data Tab in Power Query, From File Button, From Folder Button 6. (02:33) We only need to keep “Content” Column, so right-click “Content” Field Name and point to “Remove Other Columns” 7. (02:51) To reveal data in imported tables, click the button with the Two Downward Point Arrows. 8. (02:58) Filter out Field Name. 9. (04:10) Name Query 10. (04:17) Close and Load To a cell in our worksheet (this brings table of data from the Power Query editor window into our worksheet) 11. (04:51) Build Frequency Distribution with a PivotTable 12. (05:28) Use Find and Replace feature to create non-ambiguous labels in a Grouped Decimal Number PivotTable. 13. (06:31) Add a Slicer for the Year Variable to the PivotTable 14. (07:26) Create Histogram
Views: 13934 ExcelIsFun

24:08
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:11) Using Handwritten notes, discuss characteristics of the Normal (Bell) Distribution, how to calculate probabilities using Excel functions and the four situations for calculating probabilities and x or z values. 2. (12:18) Excel Chart Example for family of Normal (Bell) Curves. 3. (15:04) Calculate probability on the low end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values. 4. (17:50) Calculate probability on the high end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values. 5. (19:22) Calculate probability between two values using NORM.DIST function with x values and NORM.S.DIST function with z values. 6. (21:51) Find x values using NORM.INV function function or find z value using NORM.S.INV function
Views: 29262 ExcelIsFun

23:45
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:24) Look at Data Set that exhibits the characteristics of a Poisson Experiment and compare it to the results of the POISSON.DIST to helps us understand why when can use this function to make probability predictions. 2. (05:57) Chart a POISSON Distribution with a column chart 3. (09:16) Discussion of POISSON experiment and POISSON.DIST Discrete Probability Distribution 4. (12:23) Use POISSON.DIST for arrivals at Dick’s Hamburger Restaurant 5. (17:14) Use POISSON.DIST for arrivals at an Accounting Tutoring Center 6. (18:20) Use POISSON.DIST for water line breaks in a 100 Mile stretch of pipe
Views: 8783 ExcelIsFun

01:34
Views: 4553 FREE LEARNING

32:40
Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm This video teaches: 1. Proper Data Set (00:50 min) 2. Data Analysis (01:04 min) 3. What does a PivotTable do? (01:20 min) 4. PivotTable Field List (02:39 min) 5. Visualize PivotTable before you start (02:58 min) 6. Create Pivot with one condition (01:59) 7. PivotTable keyboard: Alt, N, V (02:14 min) 8. Value Field Settings to add Number Formatting (so format follows the field if you Pivot) (05:48 min) 9. Design, Report Layout, Show in Tabular Form (07:21 min) 10. Create Cross Tabulated PivotTable (08:29 min) 11. Show empty cells as zeroes (11:05 min) 12. Pivot, Filter and Change Function in a PivotTable (12:05 min) 13. Three Functions (Sum, Count Numbers and Average) (17:39 min) 14. Difference between Count and Count Numbers functions in a PivotTable (19:30 min) 15. Copy and Paste a PivotTable (21:06 min) 16. Drop Text Value in Values area and make calculation with Count function on text data (21:27 min) 17. Group by Month and Year (22:15 min) 18. Filre Area in a PivotTable (24:52 min) 19. Filter Slicer (26:25 min) 20. Filter Timeline (28:06 min) 21. Formulas vs. PivotTable (30:49 min) Highline Community College Busn 216 Computer Applications Class Office 2013 (Fun With Computers) taught by Michael Girvin. Excel Basics. Learn Excel, How To Excel. Excel 2013 Pivot Tables. Excel 2013 PivotTables
Views: 32203 ExcelIsFun

25:55
Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm This video teaches: 1. Data Analysis: Sort, Filter, PivotTable (00:21 min) 2. Proper Data Set required for Data Analysis features (01:20 min) 3. Single Cell selected BEFORE clicking Sort, or Filter, or PivotTable (01:37 min) 4. Sort A to Z for single column with button (02:20 min) 5. Sort Z to A for single column with button (03:11 min) 6. Sort Z to A on single column and have whole data set sort (03:31 min) 7. Sort data with NO FIELD NAME (04:56 min) 8. Sort by Color (05:47 min) 9. Add a second level of sorting in Dialog Box (07:22 min) 10. Reorder Sort in Sort dialog box (07:50 min) 11. Sort based on Multiple Columns. Sort whole data set based on ONE column (08:10 min) 12. Sort upon two columns with buttons (Major Sort Last) (08:41 min) 13. Sort upon two columns with Sort dialog box (Major Sort on Top) (10:44 min) 14. Sort data set based on three columns (12:44 min) 15. Filter (14:02 min) 16. Filter with Filter check box to Extract Records to a new location (14:48 min) 17. Date Filter to Extract Records to a new location (16:10 min) 18. Top 10 Number Filter to Extract Records to a new location (16:49 min) 19. Filter with three AND criteria to extract records to a new location (17:32 min) 20. Filter with two OR Criteria to extract records to a new location (19:23 min) 21. Filter and get zero records in your data set: 1) Incorrect Q or 2) There are no records that match (20:13 min) 22. Search Filter (21:31 min) 23. Excel Table feature: Totals row to make calculations based on a Filter or Criteria (22:07 min) 24. Add new record when you have a Total Row in your Excel Table (24:57 min) Excel Table Total Row to make calculations with Criteria or Conditions Highline Community College Busn 216 Computer Applications Class Office 2013 (Fun With Computers) taught by Michael Girvin. Excel Basics. Learn Excel, How To Excel.
Views: 40928 ExcelIsFun

24:15
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:32) Introduction to averages as typical values that represent a single value that represents all the data points 2. (01:17) Introduction to Location 3. (03:55) Sample Statistics are point estimators for the population parameters 4. (05:28) Mean using AVERAGE function 5. (09:16) Median using sorting or the MEDIAN function 6. (15:54) Mode for Categorical data using COUNTIFS and MODE for quatitative data using MODE.SNGL. Discussion about Bi-modal and multiple modes and why using a PivotTable rather than MODE.SNGL is wise. 7. (21:42) Relationship between Mean, Median and Mode and skew.
Views: 11508 ExcelIsFun

29:59
Views: 17772 ExcelIsFun

37:51
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:11) Discussion about Binominal Experiments and Probability Distributions 2. (11:00)Example 1: Experiment is attempting four sales calls. This example show how to create the Binomial Distribution in Table and Column Chart. This example show the 5 possibilities for comparative operators while using the BINOM.DIST function. 3. (24:10) Example 2: Experiment concerns late airline flights. This example show the 5 possibilities for comparative operators while using the BINOM.DIST function. 4. (29:47) Example 3: Experiment concerns West Seattle Bridge “Stuck in Traffic”. 5. (31:39)Example 4: Experiment concerns Student’s probability of withdrawing from Accounting 202. This example show how to use two BINOM.DIST function to calculate probabilities between two values. 6. (35:24) As number of trials get large, distribution approaches a Bell Shape. As the probability approaches 0.5, the distribution approaches a Bell Shape.
Views: 12416 ExcelIsFun

14:29
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Discussion of Slope and y-intercept formulas 2. (03:30) X Y Scatter Chart / Plot 3. (05:00) Calculate Slope and Intercept 4. (09:55) Use equation to predict 5. (10:48) Example 2 for calculating Slope and Intercept
Views: 6784 ExcelIsFun

03:26
Download files: http://people.highline.edu/mgirvin/excelisfun.htm This video covers how to create Frequency Distributions and Appropriate Charts for Continuous Quatitative Data using Formulas, PivotTables and Histogram Column Charts: 1. (00:33) Remove unnecessary zeros in vertical axis using Number Format 2. (01:15) Chart Labels defaulted to zero decimals and we wanted to show two decimals. We use Number Formatting for the Percentage Chart Labels and increase decimals. 3. (01:49) Fix Chart Label Overlap 4. (02:00) Remove Leader Lines 5. (02:20) Capitalization error in Chart Tile that in linked to cell. When we edited the cell content, all the Chart Titles update
Views: 16732 ExcelIsFun

32:08
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Discussion about Discrete Probability Distributions, Random Variables, Continuous Random Variables, Discrete Random Variables, Discrete Probability Functions, Steps for creating Discrete Probability Distributions and calculating Expected Value (Mean) and Standard Deviation from a Discrete Probability Distributions. 2. (12:50) Create Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day 3. (15:14) Calculate Expected Value (Mean) from Discrete Probability Distributions using SUMPRODUCT. 4. (16:55) Test to see if Expected Value formula works by calculating Mean for original Data Set 5. (17:15) Calculate Standard Deviation from Discrete Probability Distributions Long Hand. 6. (20:32) Test to see if Standard Deviation formula works by calculating Standard Deviation for original Data Set using STDEV.P 7. (21:28) Calculate Standard Deviation from Discrete Probability Distributions in a single cell using SUMPRODUCT and SQRT functions 8. (24:49) Calculate Probabilities from Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day 9. (26:12) Create Discrete Probability Distributions and calculate Expected Value and Standard Deviation and calculate probabilities from Discrete Probability Distributions For Dick’s Hamburger Drive In Customer Arrival Data
Views: 10112 ExcelIsFun

26:57
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Chapter explanation 2. (01:57) Discussion about Samples, Point Estimates and Sampling Error 3. (03:50) Why take samples rather than use all the population items? 4. (05:10) What do we use samples for? Answering Research Questions! 5. (06:01) Learn about Sample Population and Target Population 6. (08:58) What is a Frame? Frame = List of items in population 7. (10:58) Simple Random Sampling: use when you have a finite population where you can create a frame. 8. (11:33) Random Sampling: use when you have a finite population or on-going process where you cannot create a frame. Two important points must hold true before selecting n items in a random way: 1) All items must be from same population (Samples = Target) and 2) Items must be selected Independently (without bias) 9. (13:25) Define Simple Random Sampling and do a few tests in Excel to prove to ourselves that the definition makes sense. We will look at one sample and the sampling error, then we will list all possible samples and then calculate the probability that we could get any one sample. 10. (16:20) Use VLOOKUP to list all numbers for all possible samples 11. (17:58) Calculate Sample Mean, Xbar, for every one of the possible samples 12. (18:18) Calculate probability of each sample (part of definition of Simple Random Sample) 13. (19:30) Introduction to RAND function 14. (20:36) Create Simple Random Sample using RAND Excel function (0 greater than or equal to 15 digit Number less than 1), the Sort Feature and Copy & Paste. 15. (23:12) Create Simple Random Sample using RAND, SMALL and VLOOKUPO Excel functions 16. (25:53) Conclusion
Views: 12339 ExcelIsFun

19:23
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:15) Review of different X-Y Scatter 2. (02:42) Add Xbar Line and Ybar Line to X Y Scatter Chart to help interpret how Covariance is calculated and why the math behind the calculation makes sense 3. (08:36) Formulas and Calculations for Covariance and Correlation Coefficient (Long Hand) 4. (12:38) COVARIANCE.S Excel function for calculation Sample Covariance 5. (13:41) Correlation Coefficient & PEARSON Excel function for calculation Correlation Coefficient 6. (16:11) CORREL Excel function for calculation Correlation Coefficient 7. (18:50) Summary
Views: 15574 ExcelIsFun

31:54
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Calculate z score. Z Score is the Number of Standard Deviations a particular value is away from the mean. Deviation divided by Standard Deviation formula or STANDARDIZE function. 2. (08:15) Chebshev’s Rule: 5 Examples 3. (14:03) Empirical Rule: 12 Examples
Views: 12715 ExcelIsFun

31:07
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Review Handwritten PDF Notes about Probability, Random Events, Sample Points, Sample Space, Count Rule For Size of Sample Space, Listing all Sample Points with Tree Diagram and Table, Methods of Probability such as Classical, Relative Frequency and Subjective, Requirements for Probability, Events and Probability of Events 2. (14:30) In Excel: Experiment of Flipping Coin Three Times: Find all Sample Points, Calculate Probabilities and practice finding Probabilities of Events by listing all the sample points and then adding all the probabilities for each Sample Point to get the Probability of the Event 3. (21:09) Frequency Distribution Built from Sample Space in order to find Probabilities for Events 4. (23:46) In Excel: Experiment of Rolling Two Die: Find all Sample Points, Calculate Probabilities and practice finding Probabilities of Events by listing all the sample points and then adding all the probabilities for each Sample Point to get the Probability of the Event
Views: 16130 ExcelIsFun

25:27
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:13) Discuss Handwritten notes for Adding Laws For Probability and cover the terms: Venn Diagram, Complement, Union, Intersection. 2. (08:25) Excel: Counting for AND Events use COUNTIFS with Two Criteria 3. (09:40) Excel: Counting for OR Events that are Mutually Exclusive use multiple COUNTIFS with One Condition/Criteria and simply add them. P(A OR B) = COUNTIFS(range,A)+COUNTIFS(range,B). 4. (11:23)Excel: Counting for OR Events that are NOT Mutually Exclusive use multiple COUNTIFS with One Condition/Criteria and simply add them, then subtract a COUNTIFS with AND Criteria. P(A OR B) = COUNTIFS(range,A)+COUNTIFS(range,B) – COUNTIFS(rangeA,A,rangeB,B). 5. (15:26) Compliment Rule 6. (16:30) Adding Probabilities from Frequency Distribution 7. (17:38) Adding Probabilities from Cross Tabulated Table with % of Grand Totals (Joint Probability Table) 8. (21:32) Frequency Distributions contain Mutually Exclusive categories. Examples of OR Events and Complement Events 9. (22:57) Adding events that are not Mutually Exclusive when you have just the Marginal and AND (Joint) probabilities. How to add when you don’t have original data set, a frequency distribution or a Cross Tabulated Table.
Views: 8325 ExcelIsFun

15:05
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:10) Introduction to Uniform Probability Distribution including a look at source data sets. 2. (02:24) Formulas for Uniform Probability Distribution 3. (05:10) Example on paper: calculating probability of waiting on hold on the phone for customer support 4. (07:00) Example with Excel: calculating probability of waiting on hold on the phone for customer support 5. (12:10) Golf Driving Example using Excel
Views: 6241 ExcelIsFun

50:06
Views: 263845 ExcelIsFun

13:05
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:16) VLOOKUP to Add New Region Field to Table 2. (06:14) Create Cross Tabulation based on the Grouped Revenue Field and the Region Field (Quantitative and Categorical Variables) 3. (08:01) VLOOKUP to Add New Price Field to Table 4. (09:58) Revenue Formula 5. (10:48) Create Frequency Distribution based on the Grouped Revenue Field (Quantitative Variables)
Views: 10601 ExcelIsFun

02:49
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:25) Dot Plot 2. (01:37) Stem and Leaf Charts Reference Videos: Excel 2010 Statistics #20: Stem and Leaf Chart with REPT and COUNTIFS functions https://www.youtube.com/watch?v=tvEgMBrPw-E Excel 2010 Statistics #19: Dot Plot Chart with REPT and COUNTIFS functions https://www.youtube.com/watch?v=GK5NgLzLmpc
Views: 12125 ExcelIsFun

09:01
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Compare and contrast the Discrete Probability Distribution to the Continuous Probability Distribution 2. (01:53) Whereas with Discrete Probability Distribution we can calculate probability of an exact x value and probability between two x values, with Continuous Probability Distribution we are only calculating probability between two x values. 3. (06:55) Briefly look at example for Normal Distribution, Uniform Distribution and Exponential Distribution.
Views: 4902 ExcelIsFun

14:02
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:35) Remind ourselves of what we did in Chapter 7: Population Mean & Standard Deviation Known and we compared Sample Mean (Xbar) to Sampling Distribution of Xbar. 2. (02:20) What we will do in Chapter 8: Population Mean not known so we create Confidence Intervals from Sample Mean (Xbar) and Margin of Error and estimate the probability that the Population Mean will lie within our Confidence Interval. 3. (03:33) Compare Chapter 8 to Chapter 7 with Printer Cartridge Company Example. 4. (05:48) Look at Visual that shows 100 Confidence Intervals and how most Intervals contains Population Mean, but a small number do not. 5. (07:13) Examples when it is impossible to calculate Population Means and thus we must use Sample Means (Xbar) 6. (08:04) Definition of Confidence Interval and Level of Significance / Alpha (Level of risk that the Interval will not contain the population mean) 7. (09:09) Formulas for building Confidence Intervals
Views: 4669 ExcelIsFun

07:02
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:10) What is Dot Plot 2. (00:58) Create Dot Plot 3. (01:20) Create Sequential Numbers 0 to 10 4. (01:40) Change Column Widths & Style Formatting 5. (02:15) Cell Chart Formula 6. (02:30) COUNTIFS to Count with one condition / Criteria 7. (03:04) REPT function to Repeat dots 8. (04:19) Cell Formatting Dialog Box for Aligning Dots in cell vertically 9. (05:02) Copy and Paste Cell Chart and Quick Ways to Edit and Change Cell Ranges in Formulas
Views: 12247 ExcelIsFun

01:43:05
Views: 270321 ExcelIsFun

33:18
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:25) Conditional Probability (3 Examples) 2. (10:30) Rule of Independence 3. (12:13) Multiplying Law of Probability 4. (13:49) Multiplying Rule for Events that are NOT Independent, One Sample Point. Multiplication Law for calculating probability of pulling three straight queens 5. (17:06) Multiplying Rule for Events that are NOT Independent, One Sample Point. Multiplication Law for calculating probability of pulling Queen, Not Queen, Queen (calculating probability for single Sample Point). 6. (18:40) Multiplying Rule for Events that are NOT Independent, More Than One Sample Point. Multiplication and Adding rules to calculate Probability of the Event “pulling two Queens in Three Tries” by calculating the probability for each sample point, then adding to get the probability for the Event. 7. (21:10) Multiplying Rule for Events that are NOT Independent, More Than One Sample Point. Calculating Conditional Probability using HYPGEOM.DIST function. 8. (23:00) Multiplying Rule for Events that ARE Independent, One Sample Point. (2 Examples) 9. (24:24) Multiplying Rule for Events that ARE Independent, More Than One Sample Point by calculating all the Sample Points than adding to get the probability of the Event. 10. (26:00) Multiplying Rule for Events that ARE Independent, More Than One Sample Point with BINOM.DIST function. 11. (27:00) Calculate Conditional Probability using the Multiplication Rule 12. (28:40) Calculate AND, OR and Conditional Probability From Cross Tabulated Tables and Joint Probability Tables. 13. (32:30) Summary
Views: 6345 ExcelIsFun

01:06
Views: 14672 Dwight Stoll

11:45
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Five Number Summary: Min, Quartile 1, Quartile 2, Quartile 3 and Max 2. (02:41) Box Plots: Visual Summary of the Five Number Summary. How to calculate numbers with Excel and draw chart on paper 3. (07:55) +/- 3 Standard Deviation Outliers 4. (08:37) ABS function to find outliers 5. (09:17) +/- 3 Standard Deviation Outliers, COUNTIFS to count TRUE values 6. (10:08) +/- 3 Standard Deviation Outliers, Conditional Formatting to highlight Outliers
Views: 14689 ExcelIsFun

04:25
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to install add-ins in this Excel video tutorial. You will learn how to install add-ins such as the Analysis Toolpak and Solver in Excel. This is a very good tutorial to learn if you just upgraded to Excel 2007 or just need to find out where to install add-ins in Excel. Installing the Analysis toolpak will allow you to perform regression analysis and t-stat and anova analysis in Excel in a much more efficient fashion than just using functions such as LINEST(). For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Views: 86727 TeachExcel

38:09
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:39) Define Hypothesis Testing and example of questions we can ask. 2. (07:13) 5 Steps in Hypothesis Testing 3. (08:30) Review of variables we use in Hypothesis Testing 4. (8:30) Example of 1 tail test to the right (upper end) when sigma is known 5. (10:59) Step 1: Setting up Null and Alternative Hypothesis 6. (19:40) Step 2: Select Alpha, Level of Significance, Error of rejecting Null even though it is true. 7. (26:08) Step 3: Take Sample, Calculate Test Statistic, Draw Picture 8. (29:16) Test 4: Calculate Critical Value and/or P-value 9. (36:45) Make written concluding statement
Views: 12782 ExcelIsFun

20:55
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:24) Percentile where position is calculated with P%*(n+1) 2. (04:26) PERCENTILE.EXC function 3. (05:18) What percentile tells you 4. (06:09) QUARTILE.EXC function 5. (06:59) PERCENTILERANK.EXC function 6. (07:45) Median 7. (08:48) Quartile 1, 2, 3 8. (09:34) Quintiles 9. (10:03) Deciles 10. (10:24) Percentile rank for whole data set 11. (11:24) PERCENTILE.INC, QUARTILE.INC functions 12. (14:13) Five Number Summary 13. (14:40) Big Data Set to see that PERCENTILE.INC and PERCENTILE.EXC are very close if not exactly the same. 14. (16:29) Ranking. RANK,EQ and RANK.AVE functions 15. (18:46) ) PERCENTILERANK.INC function 16. (19:00) Data Ribbon Tab, Analysis group, Data Analysis, Rank and Percentile feature
Views: 14064 ExcelIsFun

11:49
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:14) Weighted Mean Quiz Score Example and Weighted Mean calculation using a Helper Column 2. (02:47) SUMPRODUCT and SUM function for single Cell Formula 3. (04:47) Calculate Weighted Average for Accounting COGS and End Inventory 4. (08:10)Calculate Weighted Average or “Expected Value” given a Percent Frequency Table
Views: 11536 ExcelIsFun