Search results “Excel 2013 data analysis download”

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

Download files: http://people.highline.edu/mgirvin/excelisfun.htm
See how to Download & Install Power Query in Excel 2013

Views: 47950
ExcelIsFun

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

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

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

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

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

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

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

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

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

How to install Toolpak using Microsoft Excel 2015 on a Mac.

Views: 86962
Joseph C.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
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

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

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.

Views: 13485
Excel, Word and PowerPoint Tutorials from Howtech

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

Writing article service

Unsolicited cover letter for fresh graduates salary

Diversity officer cover letter

Picture of a resume cover letter

© 2018 Intrusion detection exchange architecture

Diving Boards. Pool Decks. A simple and classic look to surround your pool. Colored and stamped concrete. multiple colors and stamp patterns are available Concrete cantilever edge. Add a beautiful finished concrete edge around your pool Rubber safety surfacing. A gorgeous slip resistant safety surface for your pool area or patio Barkman pavers. Be Inspired. POOL CLEANERS. Create atmosphere with pool lights and controls on your pool. From a simple white light to multiple-multi color LED lights to create a light show in your back yard, we have a pool lighting system to elevate your pool after dark. The walk in pool stair is a must for any in ground pool. Whether you want a simple white walk in stair or a jetted lagoon stair, the stair is not only for the ease of access into the pool but a gathering place in your pool for friends and family. Safety Covers.