Once you know the average and standard deviation of a dataset, you can estimate how likely it is that you’ll see values in a given range.
- [Narrator] Once you know the average…and standard deviation of a dataset,…you can estimate how likely it is…that you will see values in a given range.…For example, you would know…that you are only likely to see values…only one standard deviation above the mean 16% of the time.…No estimate is perfect, but they can give you an idea…of how likely a given value is to occur.…In this movie, I will demonstrate…how to calculate the likelihood of a given value…or less occurring or a given value or more occurring.…
My sample file is normal_03_03…and you can find it in the chapter three folder…of your exercise files collection.…The scenario I'm working with here…looks at contract labor expenses,…and over the years I've found that we have had a mean,…monthly, of 250,000 dollars…with a standard deviation of 86,000 dollars…as our specific hiring needs go up and down.…So the question is how likely is it…that we will spend at 275,000 dollars or less…in a given month.…
To create this calculation,…I need to use the NORM.DIST function.…
Author
Released
11/28/2017- Designing a scenario-planning exercise
- Estimating scenario plausibility and outcomes
- Establishing parameter value ranges
- Calculating the standard deviation of a dataset
- Indicating the probability of a scenario value occurring
- Walking through a scenario presentation
- Performing retrospective analysis using a PivotTable
- Changing PivotTable summary operations
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2016: Business Process Analysis
with Curt Frye1h 25m Intermediate -
Excel: Power Query (Get & Transform)
with Oz du Soleil1h 49m Intermediate
-
Introduction
-
Welcome1m 3s
-
-
1. Introducing the Art of Scenario Planning
-
2. Manage Scenarios in Excel
-
3. Establish Parameter Value Ranges
-
4. Present Scenarios Using PivotTables
-
Define PivotTable dataset6m 23s
-
Filter PivotTable data5m 10s
-
Link a macro to a shape6m 27s
-
-
Conclusion
-
Next steps1m 16s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Indicate the probability of a scenario value occurring