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.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- 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