You can find the average, or mean value, of a dataset. You can also calculate the standard deviation, which tells you how spread out the values in your dataset are.
- [Instructor] When you gather data over time,…you can use statistical measures to get information…about that data.…For example, you can find the average value…which is also called the mean.…You can also calculate the standard deviation…which tells you how spread out the values…in your data set are.…In this movie, I'll demonstrate how to calculate…and interpret averages and standard deviations.…My sample file is Normal 0302 and that's a workbook…you can find in the chapter three folder…of the exercise files collection.…
This workbook contains a single worksheet…and I'm going to be basing my calculations…on the data in the table that you can see…on the left side of the screen in columns A and B.…That table contains 365 days worth of data.…So rather than work with the cell range,…I have created it as an Excel table.…Because I want to refer to that Excel table,…in my formula I need to find out its name…so I'll click any cell in the Excel table…and then go to the Design contextual tab on the ribbon…and look at the left side of the ribbon tab.…
- 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
Excel 2016: Business Process Analysiswith Curt Frye1h 25m Intermediate
1. Introducing the Art of Scenario Planning
2. Manage Scenarios in Excel
3. Establish Parameter Value Ranges
4. Present Scenarios Using PivotTables
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.Cancel
Take 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.