Category: Excel

Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch08-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch08-ESA.pdf
Learn about theory for why and how we use Confidence Intervals to estimate Population Parameters
Topics:
1. (00:00) Introduction
2. (00:22) Compare what we did in Chapter 7 (Compare Sample Mean to Sampling Distribution Of Sample Means or Standard Normal Curve) and Chapter 8 (Build Confidence Interval to estimate Reasonable Range for Population Parameter)
3. (05:47) Pictorial Example of risk associated with estimating Population Mean with a Confidence Interval
4. (07:19) Examples when Population Mean cannot be calculated
5. (08:09) Define Confidence Intervals
6. (12:01) Excel Worksheet Functions to create Confidence Intervals
7. (13:53) Continue reading “Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter” →

Excel Statistical Analysis 38: Normal Bell Curve to Estimate Range of Sample Proportions

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 using the Normal Bell Curve to estimate a reasonable range of Sample Proportions.
Topics:
1. (00:00) Introduction
2. (00:21) Formulas for using Normal Bell Curve to estimate a reasonable range of Sample Proportion Values.
3. (02:42) Proportion of Americans who balance checkbook example.
4. (07:08) Proportion of insurance policies that fall within a two standard deviation margin of error
5. (09:56) Summary of video
6. (10:09) Closing, Next Video and Video Links

VLOOKUP Into “Vendor – URL” With TEXTBEFORE – 2486

Posted on by Annie D

Today’s Excel question from Willie at the UCF Accounting Conference:
I am using a vlookup to get some information from a vendor info database that comes from the credit card website.
 
My issue is that the vendor name sometimes comes with additional info at the end like …. “Contoso – cadet.biz” and in the table where I do the lookup the name is just “Contoso”.
 
I was wondering if you think I can use the “TEXTBEFORE” function with the Vlookup formula to make the formula to look in the table only for the first word of the info coming from the credit Continue reading “VLOOKUP Into “Vendor – URL” With TEXTBEFORE – 2486″ →

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