Category: Excel

Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch07-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch07-ESA.pdf
Learn about one of the most power rules in statistics: the Central Limit Theorem by building a Sampling Distribution of Sample Means (Xbar). Learn how to calculate the Mean and Standard Deviation (Standard Error) for the Sampling Distribution of Sample Means (Xbar). Then see how the Central Limit Theorem is used to make business decisions using Hypothesis Testing, Confidence Intervals and the Excel worksheet functions NORM.DIST, NORM.S.DIST, NORM.S.INV and T.INV. Learn about the z distribution and the t distribution as models to represent the Sampling Distribution Continue reading “Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar” →

Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar)

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch07-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch07-ESA.pdf
Learn about Sampling & Sampling Distribution of Sample Means (Xbar).
Topics:
1. (00:00) Introduction
2. (24:36) Chapter 7 Content
3. (00:58) Where we have come from, this chapter and next chapter
4. (02:13) Population, Sample and Sample Error, First Look
5. (03:22) Sampling Distribution of Xbar is model to help determine is an Xbar is reasonable
6. (04:06) Why do we take and need Samples?
7. (06:17) Sampled Population and Target Population
8. (09:15) What is a Frame?
9. (11:12) Sampling Methods: Simple Random Sampling and Random Sampling
10. (13:33) Definition of Simple Random Sampling
11. (14:13) Excel: Continue reading “Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar)” →

BI 348 – Microsoft Power Tools – Highline College Spring 2022: Introduction Video

Posted on by Annie D

BI 348 – Microsoft Power Tools – Spring 2022: Introduction Video
Free YouTube Classes for this topic:
Data Analysis basics: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT
Data Analysis Advanced: https://www.youtube.com/playlist?app=desktop&list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1
Highline College class web site for matriculating students: https://people.highline.edu/mgirvin/AllClasses/348/348/Spring2021BI348.htm

Excel Statistical Analysis for Business – Busn 210 – Spring 2022 Quarter Introductory Video

Posted on by Annie D

Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in spring quarter, 2022.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
The videos for this class will be released each week over the next few months.

Highline web site for this class: https://people.highline.edu/mgirvin/AllClasses/B210/M365ESA.htm
Free YouTube Class for this class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Busn 135 – Business Math – Spring 2022 Introduction Video

Posted on by Annie D

Highline College Class. Busn 135 – Business Math – Spring 2022: Introduction Video. Class taught my Michael excelisfun Girvin at Highline College.
Highline web site for this class for matriculating students: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
Free YouTube Class for this class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0kMy6GdNvsecPSOP5Tc_ydL

Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about calculating probabilities from the Exponential Probability Distribution and the EXPON.DIST function.
Topics:
1. (00:00) Introduction
2. (00:26) Notes about Exponential Probability Distribution
3. (03:17) Dick’s Hamburgers example with math formula and EXPON.DIST function
4. (07:15) Disneyland Ride wait time example with math formula and EXPON.DIST function
5. (11:06) Summary of video
6. (11:25) Closing and Video Links

Security Risk Microsoft Has Blocked Macros From Running – 2485

Posted on by Annie D

A new pink bar warning is appearing in Excel, Word, and PowerPoint telling you that there is a security risk and that your VBA macros have been blocked.
This warning is designed to make you ask, “Is there a valid reason for this person to be sending me a macro?” If there is, I will show you the easy steps to unblock the workbook.
This is called the Mark of the Web.
Kevin Lehrbass Word Game is here: https://www.myspreadsheetlab.com/word-game/

Table of Contents
(0:00) Kevin Lehrbass has a Wordle game in Excel but the macros are blocked with the pink bar.
(1:08) Continue reading “Security Risk Microsoft Has Blocked Macros From Running – 2485” →

Excel Statistical Analysis 34: Answering Probability Questions With NORM.DIST Function

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about solving questions using the Normal Bell Curve and the NORM.DIST and NORM.S.DIST Excel Probability Functions.
Topics:
1. (00:00) Introduction
2. (00:24) Answering an Accounting example with the NORM.DIST Function
3. (03:13) Answering a Gas Prices example with the NORM.DIST Function
4. (05:45) Answering a Manufacturing example with the NORM.DIST Function
5. (08:14) Summary of video
6. (08:40) Closing and Video Links

Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about how to create a Normal Bell Curve Chart in Excel using Area Chart. Other Charting tricks also.
Topics:
1. (00:00) Introduction
2. (00:26) Create Data for Chart
3. (00:45) Create X Values. SEQUENCE function.
4. (01:55) Create Probabilities with NORM.DIST function
5. (02:55) Create Area Chart for Normal Bell Curve
6. (04:37) Create Z Values
7. (05:10) Label for Probability Less Than an X Value. Text Formula and the ROUND function.
8. (06:45) Create Probability Less Than an X Value using the IF Function
9. (07:55) Add Second Column of Probabilities to Area Chart Continue reading “Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart” →

BMX & Skate Park Adventure #14: Lake Stevens, Sunday, Sunday, March 27, 2022

Posted on by Annie D

(00:00) Start, (00:04) Nick Roth ride, (00:3) Nathon Ride, (00:53) Magic ride (excelisfun), (01:23) Isaac “Iceman” Girvin ride. Blue Grass Music Played throughout : )
Two Old Guys on BMX Bikes: Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 68” Roth. Two Young Dudes on Skateboards: Isaac “Iceman” Girvin and Nathon.
Washington BMX Old Guy Adventure 14.

Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the Normal (Bell) Probability Distribution and the Excel worksheet functions to calculate probability and x values: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV.
Topics:
1. (00:00) Introduction
2. (00:22) pdf notes: characteristics of Normal Bell Probability Distribution.
3. (04:40) pdf notes: Math Formulas for Normal (Bell) Probability Distribution
4. (05:14) pdf notes: X values or Z-score (Standard Value)?
5. (05:50) pdf notes: notes on Excel Functions for Normal (Bell) Probability Distribution: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV
6. (08:49) pdf notes: Professor observes a bell shape (normal) distribution.
7. (09:07) pdf notes: 3 Types of Probability Calculations: Continue reading “Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV” →

Excel Statistical Analysis 31: Uniform Probability Distribution

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the formulas and calculating probabilities for the Uniform Probability Distribution.
Topics:
1. (00:00) Introduction
2. (00:23) Understanding what a Uniform Distribution is and how it is related to the data behind it.
3. (02:36) Formulas for Uniform Distribution
4. (05:22) Paper Example for Waiting Times on Customer Service Phone Calls
5. (07:11) Excel Example for Waiting Times on Customer Service Phone Calls
6. (12:16) Golf Example using Excel Formulas
7. (14:40) Summary of video
8. (14:58) Closing and Video Links