Home
Search results “Excel 2013 data analysis download”
How to Install the Data Analysis ToolPak in Microsoft Excel
 
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: 210438 Quantitative Specialists
Excel 2013 Statistical Analysis #03: Download & Install Power Query for Data Transformation Tools
 
03:39
Download files: http://people.highline.edu/mgirvin/excelisfun.htm See how to Download & Install Power Query in Excel 2013
Views: 47950 ExcelIsFun
Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information
 
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: 37075 ExcelIsFun
Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)
 
02:22:43
Download File: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch00/Excel2013StatisticsChapter00.xlsx All Excel Files for All Video files: http://people.highline.edu/mgirvin/excelisfun.htm. Intro To Excel: Store Raw Data, Data Types, Data Analysis, Formulas, PivotTables, Charts, Keyboards, Number Formatting, Data Analysis & More: (00:08) Introduction to class (00:49) Cells, Worksheets, Workbooks, File Names (02:54) Navigating Worksheets & Workbook (03:58) Navigation Keys (04:15) Keyboard move Active Sheet (05:40) Ribbon Tabs (06:25) Add buttons to Quick Access Tool Bar (07:40) What Excel does: Store Raw Data, Make Calculations, Data Analysis & Charting (08:55) Introduction to Data Analysis (10:37) Data Types in Excel: Text, Numbers, Boolean, Errors, Empty Cells (11:16) Keyboard Enter puts content in cell and move selected cell down (13:00) Data Type DEFAULT Alignments (13:11) First Formula. Entering Cell References in formulas (13:35) Keyboard Ctrl + Enter puts content in cell & keep cell selected (14:45) Why we don’t override DEFAULT Alignments (15:05) Keyboard Ctrl + Z is Undo (17:05) Proper Data Sets & Raw Data (24:21) How To Enter Data & Data Labels (24:21) Stylistic Formatting (26:35) AVERAGE Function (27:31) Format Formulas Differently than Raw Data (28:30) Keyboard Ctrl + C is Copy. Keyboard Ctrl + V is Paste (29:59) Use Eraser remove Formatting Only (29:19) Keyboard Ctrl + B adds Bold (29:57) Excel’s Golden Rule (31:43) Keyboard F2 puts cell in Edit Mode (32:01) Violating Excel’s Golden Rule (34:12) Arrow Keys to put cell references in formulas (35:40) Full Discussion about Formulas & Formulas Elements (37:22) SUM function Keyboard is Alt + = (38:22) Aggregate functions (38:50) Why we use ranges in functions (40:56) COUNT & COUNTA functions (42:47) Edit Formula & change cell references (44:18) Absolute & Relative Cell References (45:52) Use Delete Key, Not Right-click Delete (46:40) Fill Handle & Angry Rabbit to copy formula (47:41) Keyboard F4 Locks Cell Reference (make Absolute) (49:45) Keyboard Tab puts content in Cell and move selected Cell to right (50:55) Order of Operation error (52:17) Range Finder to find formula errors (52:34) Lock Cell Reference after you put cell in Edit Mode (53:58) Quickly copy an edited formula down a column (53:07) F2 key in last cell to find formula errors (54:15) Fix incorrect range in function (54:55) SQRT function & Fractional Exponents (57:20) STDEV.P function (58:10) Navigate Large Data Sets (58:48) Keyboard Ctrl + Arrow jumps to bottom of data set (59:42) Keyboard Ctrl + Shift + Arrow selects to bottom of data set (Current Range) (01:01:41) Keyboard Shift + Enter puts content in Cell and move selected Cell up (01:02:55) Counting with conditions or criteria: COUNTIFS function (01:03:43) Keyboard Ctrl + Backspace jumps back to Active Cell (01:05:31) Counting between an upper & lower limit with COUNTIFS (01:07:36) COUNTIFS copied down column (01:10:08) Joining Comparative Operator with Cell Reference in formula (01:12:50) Data Analysis features in Excel (01:13:44) Sorting (01:16:59) Filtering (01:20:39) Introduction to PivotTables (01:23:39) Create PivotTable dialog box (01:24:33) Dragging & dropping Fields to create PivotTable (01:25:31) Dragging Field to Row area creates a Unique List (01:26:17) Outline/Tabular Layout (01:27:00) Value Field Settings dialog to change: Number Formatting, Function, Name (01:28:12) 2nd & 3rd PivotTable examples (01:31:23) What is a Cross Tabulated Report? (01:33:04) Create Cross Tabulated Report w PivotTable (01:35:05) Show PivotTable Field List (01:36:48) How to Pivot the Report (01:37:50) Summarize Survey Data with PivotTable. (01:38:34) Keyboard Alt, N, V opens PivotTable dialog box (01:41:38) PivotTable with 3 calculations: COUNT, MAX & MIN (01:43:25) Count & Count Number calculations in a PivotTable (01:45:30) Excel 2013 Charts to Visually Articulate Quantitative Data (01:47:00) #1 Rule for Charts: No Chart Junk! (01:47:30) Explain chart types: Column, Bar, Pie, Line and X-Y Scatter Chart (01:51:34) Create Column Chart using Recommended Chart feature (01:53:00) Remove Field Buttons from Pivot Chart (01:54:10) Chart Formatting Task Pane (01:54:45) Vary Fill Color by point (01:55:15) Format Axis with Numbers by Formatting Source Data in PivotTable (01:56:02) Add Data Labels to Chart (01:57:28) Copy Chart & Create Bar Chart (01:57:48) Change Chart Type (01:58:15) Change Gap Width. (01:59:17) Create Pie Chart (01:59:23) Do NOT use 3-D Pie (01:59:42) Add % Data Labels to Pie Chart (02:00:25) Create Line Chart From PivotTable (02:01:20) Link Chart Tile to Cell (02:02:20) Move a Chart (02:02:33) Create an X-Y Scatter Chart (02:03:35) Add Axis Labels (02:05:27) Number Formatting to help save time (02:07:24) Number Formatting is a Façade (02:10:27) General Number Format (02:10:52) Percentage Number Formatting (02:14:03) Don’t Multiply Relative Frequency by 100 (02:17:27) Formula for % Change & End Amount
Views: 401881 ExcelIsFun
Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools
 
01:15
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Install Data Analysis Add-in For Amazing Excel Statistical Tools in Excel 2013.
Views: 35990 ExcelIsFun
Excel Statistics 08: Install Excel 2007 Data Analysis Add-in
 
02:44
See how to Install Data Analysis Add-in using Excel Options and the Add-in Feature. This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin
Views: 221585 ExcelIsFun
Excel 2013 Statistical Analysis #30: Bayes’ Theorem to Calculate Posterior Probabilities
 
16:40
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:11) Define and give example of Bayes’ Theorem with handwritten notes 2. (05:17) Discussion about how Bayes’ Formula is like of earlier Conditional Probability Formulas: (And/Joint Probability)/(Marginal Probability) 3. (08:45) Excel Example 1 with Tree Diagram (Probability Tree) and Table Format for calculating Bayes’ Theorem. CPA Score Example. 4. (12:52) Excel Example 2: Table Format for calculating Bayes’ Theorem. Police Data Example. 5. (14:41) Single Cell Formula for Bayes’ Theorem using SUMPRODUCT function.
Views: 13296 ExcelIsFun
Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
 
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: 25802 ExcelIsFun
Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio
 
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: 32798 ExcelIsFun
Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions
 
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: 11379 ExcelIsFun
Office 2013 Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples)
 
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: 31598 ExcelIsFun
Installing Excel Toolpak (Data Analysis) on Mac
 
00:58
How to install Toolpak using Microsoft Excel 2015 on a Mac.
Views: 86962 Joseph C.
Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variables
 
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: 44726 ExcelIsFun
Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals
 
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: 4259 ExcelIsFun
Excel 2013 Statistical Analysis #07: Subtle Chart Junk
 
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: 15702 ExcelIsFun
Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples)
 
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: 39532 ExcelIsFun
Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables
 
07:22
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:35) Direct (Positive) Relationship for Studying Hours and Test Score X-Y Scatter Chart and Add Terndline 2. (04:03) Inverse (Negative) Relationship for Absences in Class and Grade X-Y Scatter Chart and Add Terndline 3. (05:14) Direct (Positive) Relationship for # of Ads and sales X-Y Scatter Chart and Add Terndline 4. (06:11) No Relationship for Age and Amount Spent X-Y Scatter Chart 5. (06:48) Summarize the different types of Scatter Plot Charts
Views: 17346 ExcelIsFun
Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class
 
02:08
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Learn about the special features of the Excel workbooks we will use for this class.
Views: 56191 ExcelIsFun
Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable
 
41:36
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Overview of Frequency Distributions for Quantitative Variable 2. (02:02) Create Frequency Distribution with PivotTable for Grade Data where NUMBERS ARE DECIMALS (important distinction for grouping feature in a PivotTable) 3. (03:08) Grouping Feature in a PivotTable for creating Classes or Categories for a Decimal Quantitative Variable. Class that are created are 0-10, 10-20, 20-30, etc. Extensive Discussion about how to create classes or categories that are NOT Ambiguous. 4. (05:03) Upper Limit for Class/Category is Not Included when the numbers are Decimals. 5. (05:58) Aggregate Function for Number Values defaults to Count when you have Grouped Numbers in the Row area of the PivotTable. 6. (06:32) Double Click PivotTable to Extract Records that match the criteria from the Row area of the PivotTable 7. (09:16) Use Find and Replace feature to create non-ambiguous labels in a Grouped Decimal Number PivotTable. 8. (10:20) Create Histogram for Quantitative Variable (Grouped Numbers) for Grade Data. This Histogram has Frequencies at the top of each column and the gap width is zero. The colors for each column are different. 9. (13:13) Create Frequency Distribution with PivotTable for Grade Data where numbers are WHOLE NUMBERS (important distinction for grouping feature in a PivotTable) 10. (14:33) Methods for determining Number of Classes and Class Width for a Quantitative Variable 11. (18:19) When grouping Whole Numbers in a PivotTable the classes that are created are not ambiguous. We get classes like: 16-22, 23-29, 30-36. Etc. 12. (20:07) Create Histogram for Quantitative Variable (Grouped Numbers) for Age Data. This Histogram has Frequencies in the vertical axis and the gap width is zero. The colors for each column are the same. 13. (22:00) Discussion about Skew, Histogram shape and Histogram distribution of column heights. 14. (25:37) Relative Frequency and Percent Frequency Distribution built with a PivotTable based on Age Data that is shown as a Whole Number. 15. (27:48) Formulas 16. (27:44) Create Frequency Distribution with Formulas for Grade Data. 17. (30:03) Text Formulas for Category Labels 18. (30:40) COUNTIFS function with Comparative Operators Joined to Lower and Upper Limits from the Cells. 19. (33:17) Relative/Percent Frequency Formula. 20. (34:00) Create Histogram for Grade Data based on Frequency Distribution created with formulas. 21. (35:56) See that we can change the categories be more precise when we use formulas. 22. (38:20) Link Data Labels in Chart to cells in the spreadsheet 23. (39:16) See how formulas allow Frequency Distribution Formulas and Histogram Chart update automatically when raw data change. See different grade distributions with Histogram. 24. (40:45) Summary
Views: 153149 ExcelIsFun
Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year
 
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: 13169 ExcelIsFun
Basic Excel Business Analytics #48: Data Analysis Regression feature
 
06:37
Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about how to automatically creates statistics for Linear Regression using the Data Analysis Regression feature. See how to automatically create statistics such as: Correlation, R Squared, Standard Error, Slope, Intercept, SST, SSR, SSE, F Test, Test Statistic, t Test Statistics, p-values, predicted vales, residuals, Residual plots and more. Install: File, Options, Add-ins, Data Analysis Toolpak. Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Views: 24133 ExcelIsFun
Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient
 
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: 14752 ExcelIsFun
Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location
 
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: 10665 ExcelIsFun
Excel 2013 Statistical Analysis #52: Determine Sample Size for Sample Mean & Sample Proportion
 
07:01
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Overview of formulas for estimating Sample Size. 2. (03:00) Example to estimate sample size for Sample Mean, Xbar. 3. (04:48) Example to estimate sample size for Sample Proportion, Pbar. 4.
Views: 4703 ExcelIsFun
Excel 2013 Statistical Analysis #20: Standard Deviation: How Fairly Does Mean Represent Data Points?
 
29:59
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video are about Variation, Dispersion, Spread in the Data and Standard Deviation: 1. (00:09) Three data sets and charts of each to illustrate the concept of Variability, or Dispersion, or Spread in the Data. 2. (00:20) Set 1 (Hours Worked per Week Data), we ask the question: How fairly does the mean represent its data points? 3. (02:37) Set 2 (Seattle and Burien Gas Prices), we ask the question: How volatile are Prices? 4. (03:17) Set 3 (Supplier Days To Fill Order Data), we ask the question: How reliable is a Supplier? 5. (04:37) Calculate Range: Max - Min 6. (05:50) Calculate Interquartile range: Quartile 3 – Quartile 1 = Middle 50% of the values 7. (07:17) Variance and Standard Deviation Math Formulas for populations and samples. 8. (08:13) Calculate Sample Standard Deviation Long Hand and with STDEV.S for Data Set 3 (Supplier Days To Fill Order Data), were we ask the question: How reliable is a Supplier? 9. (16:45) Alternative Formula for Sample Standard Deviation 10. (17:05) Mean Absolute Error Formula 11. (17:20) Calculate Sample Standard Deviation with STDEV.S for Data Set 1, (Hours Worked per Week Data) were we ask the question: How fairly does the mean represent its data points? 12. (18:06) Calculate Sample Standard Deviation with STDEV.S for Set 2 (Seattle and Burien Gas Prices), were we ask the question: How volatile are Prices? 13. (19:25) Coefficient of Variation 14. (23:25) Using Descriptive Statistics feature to quickly calculate Numerical Measures like Mean, Median, Mode, Standard Deviation and more 15. (24:52) X-Y Scatter Chart to Visually Portray Variation or Dispersion or Spread in the Data. 16. (25:09) Summary of topics in video
Views: 15974 ExcelIsFun
Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD
 
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: 9317 ExcelIsFun
Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation
 
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: 10013 ExcelIsFun
Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank
 
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: 12513 ExcelIsFun
Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula
 
15:48
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:09) Overview of % Cumulative Frequency 2. (00:42) Formulas to create Cumulative Frequency Distribution and % Cumulative Frequency Distribution. 3. (04:17) % Cumulative Frequency (Ogive) Chart using X-Y Scatter Chart 4. (07:36) PivotTable to create Frequency Distribution and % Cumulative Frequency Distribution. 5. (10:30) Combine Chart that shows Frequency Distribution as a Column Chart with No Gap width and % Cumulative Frequency as a Line. 6. (11:43) Custom Number Formatting to hide all values using three semi-colons
Views: 43771 ExcelIsFun
How to install Data Analysis Addin in Excel 2013-2016 (Windows)
 
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: 13169 Joshua Emmanuel
Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)
 
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: 7630 ExcelIsFun
Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabilities
 
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: 14521 ExcelIsFun
Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory
 
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: 11062 ExcelIsFun
Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions
 
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: 4545 ExcelIsFun
Excel 2013 Statistical Analysis #38: Uniform Probability Distribution
 
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: 5848 ExcelIsFun
Excel 2013 Statistical Analysis #53: 5 Steps Hypothesis Testing: P-value & Critical Value Methods
 
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: 11568 ExcelIsFun
Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function
 
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: 8101 ExcelIsFun
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
 
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: 572929 ExcelIsFun
Excel 2013 Statistical Analysis #21: SKEW Function and Asymmetry in a Distribution of Data Points
 
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: 7746 ExcelIsFun
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
 
14:48
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: 6081453 Excel Campus - Jon
Excel 2013 Statistical Analysis #69: ANOVA Tables for Comparing More Than 2 Population Means
 
44:22
Download files: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch10/Ch10.htm Topics in this video: 1. (00:12) Introduction to Completely Randomized Design and Analysis of Variance (ANOVA) for Comparing More Than 2 Population Means 2. (13:02) Formula method – Long Method, including F.INV.RT function for F Critical Value and F.DIST.RT for p-value 3. (29:57) Formula method – Short Method using Array Formulas and SUMPRODUCT function, including F.INV.RT function for F Critical Value and F.DIST.RT for p-value 4. (41:43) “Anova – Single Factor” feature in the Data Analysis add-in
Views: 7292 ExcelIsFun
How to Add the Data Analysis ToolPak in Excel on Mac 2018
 
02:19
In this video I will show you how to find, download, and install the Microsoft Excel Data Analysis Toolpak on a Mac Operating System. ► You want to go to (https://www.xlstat.com/en/download) start downloading the plugin ►Trying to Learn how to use Excel in Data Analytics? Learn at Edureka where over 617,000 people have developed Data Analytics skills --- ( http://bit.ly/2DNnvVJ ) There is a lot of confusion with the data analysis toolpak when you find that you are unable to locate it within excel. I want to show you how to add the data analysis toolpak when you can't find it in the add ins drop down menu. A low of people are asking where is the data analysis toolpak. Some people are saying that the data analysis toolpak excel not showing up, and they are wondering how to install the data analysis toolpak on a mac in Microsoft excel. ► Full Playlist : What is Data Science and Analytics ( https://www.youtube.com/watch?v=_Vi9W_2cxYA&list=PL_9qmWdi19yDhnzqVCAhA4ALqDoqjeUOr ) ► What Does a Data Analyst Actually Do? ( https://youtu.be/0iW5jprTAaY ) ► Get Fully Educated and Become a Data Analyst at Edureka ( http://bit.ly/2yCbsac ) So in this short video I want to quickly show you how to add the data analysis toolpak on a mac in excel 2018. ------- SOCIAL Twitter ► @jobsinthefuture Facebook ►/jobsinthefuture Instagram ►@Jobsinthefuture WHERE I LEARN: (affiliate links) Lynda.com ► http://bit.ly/2rQB2u4 Udemy ► http://fxo.co/52oG Envato ► http://bit.ly/2CSoROx edX.org ► http://fxo.co/4y00 MY FAVORITE GEAR: (affiliate links) Camera ► http://amzn.to/2BWvE9o CamStand ► http://amzn.to/2BWsv9M Compute ► http://amzn.to/2zPeLvs Mouse ► http://amzn.to/2C0T9hq TubeBuddy ► https://www.tubebuddy.com/bengkaiser Host Gator ► http://bit.ly/2CBonPO ( Get 60% off Website Hosting with the link ) ► Download the Ultimate Guide Now! ( https://www.getdrip.com/forms/883303253/submissions/new ) Thanks for Supporting Our Channel! DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!
Views: 5745 Ben G Kaiser
Excel 2013 Statistical Analysis #56: NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known
 
08:55
Excel 2013 Statistical Analysis #56: NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known Download files: http://people.highline.edu/mgirvin/excelisfun.htm See Hypothesis Testing using P-value and Critical Value Methods: 1. (00:11) Upper Tail Test: NORM.S.DIST for p-value, NORM.S.INV for Critical Value Sigma Known 2. (03:38) Lower Tail Test: NORM.S.DIST for p-value, NORM.S.INV for Critical Value Sigma Known 3. (05:38) Two Tail Test: NORM.S.DIST for p-value, NORM.S.INV for Critical Value Sigma Known 4. Hypothesis Testing in Excel
Views: 4394 ExcelIsFun
Excel 2013 Statistical Analysis #35: Hypergeometric Distribution and HYPGEOM.DIST Function
 
07:51
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Hypergeometric Discrete Probability Distribution & HYPGEOM.DIST Function: 1. (00:10) Look at HYPGEOM.DIST Function for calculating probability for events where the sample space changes, events are not independent and the probability changes for each trial. Look at a collection of all the sample points for an event where we use our Probability Laws for Multiplying and Adding and compare that to the HYPGEOM.DIST Function. 2. (03:21) Example 3: Probability of pulling 2 face cards in 5 tries. Build entire distribution for random variable. 3. (05:08) Example 3: Probability of randomly taking a sample and finding certain characteristics in the sample. We use the example of the 2008 Financial Crisis where banks were given money to lend and stimulate the economy, but that did not happen at as high a rate as was desired.
Views: 5441 ExcelIsFun
How to Get Anova on Excel
 
01:15
In this tutorial, we will teach you how to get Anova on Excel. Learn how to install the analysis tool pak. Once the data analysis tools have been configured, you can easily get anova from there. Anova on Excel is part of the analysis tool pak. The Analysis Toolpak provides data analysis tools for statistical and engineering analysis. Step 1 -- Open Excel Options Follow this step by step guide to learn how to get Anova on Excel. First of all, open Microsoft Excel and click on the Microsoft logo button available in the top left corner of the screen. From the drop down menu, click on the excel options button. Step 2 -- Analysis toolpak In the new window, go to add-ins tab available on the left and click once on the analysis toolpak. Once you have selected it, click on the go button at the bottom of the window. Step 3 -- Activate analysis toolpak As a result, the add-ins window will pop up. Over there, check the add-in that you want to enable. For the purpose of this tutorial, we will tick the checkbox for analysis toolpak. Analysis Toolpak provides data analysis tools for statistical and engineering analysis. Once you have checked it, click on the ok button. Step 4 -- Install analysis toolpak You will be prompted with an error that the add-in cannot run. Click on the yes button if you want to install this feature. As a result, the Microsoft Office enterprise setup will open up. It will take some time but will configure itself automatically. Step 5 -- Open data analysis tools Once the configuration process has been completed, go to the data tab and you will notice the analysis group at the extreme right side of the ribbon. Click on the data analysis button and you will be presented with all the analysis tools available in this feature. Amongst these data analysis tools, you will find "Anova: Two-Factor Without Replication". In this manner, you can get Anova on Excel.
Excel 2013 Statistical Analysis #50: t Distribution Confidence Intervals Sigma NOT Known 3 Examples
 
20:15
Download files: http://people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) What is the t Distribution and when do we have to use it? Create Confidence Intervals when Population Standard Deviation is not known 2. (04:13) Formulas for t distribution to build Confidence Intervals when Population Standard Deviation is not known. Math formulas and Excel functions 3. (05:21) Example 1: Printer Manufacturer Example to create Confidence Interval 4. (06:41) Printer Manufacturer Example: Calculate Sample Mean, Sample Standard Deviation, Sample Size, Degrees of Freedom, Standard Error, Alpha and Alpha/2 5. (08:16) Printer Manufacturer Example: T.INV function to calculate t 6. (09:24)Printer Manufacturer Example: CONFIDENCE.T function to calculate Margin of Error 7. (11:38)Printer Manufacturer Example: Data Analysis Descriptive Statistics, Summary Statistics, Confidence Interval for Mean 8. (14:57) Restaurant Rating Example: All 3 Methods: 1) T.INV function, 2) CONFIDENCE.T function, 3) Data Analysis Descriptive Statistics
Views: 6115 ExcelIsFun

Research scientist cover letter examples
Writing article service
Unsolicited cover letter for fresh graduates salary
Diversity officer cover letter
Picture of a resume cover letter