Applied Statistics (Entire Course) - Statistics - 3.3.1 Measures of Relative Position

In this video, we'll explain how to calculate measures of relative position in Excel. We'll cover the concepts of percentile, quartile, and position relative and show you how to use these measures to analyze data. If you're looking to analyze data in a more hands-on way, then this video is for you! We'll take you through a simple example and explain each step. By the end of this video, you'll be able to use Excel measures of relative position to analyze data more efficiently! 0:00 Intro 0:07 Percentiles 1:26 Finding Data Values Given Percentile 4:42 Finding Percentiles Given Data Values 6:15 Finding Quartiles 7:55 Finding Quartiles (Approximation Method) 9:50 Using Excel to find Percentiles and Quartiles 13:01 Calculations using Percentiles - Finding n 15:27 Descriptive Statistics in Excel and their Functions 15:49 Up Next Power Point: https://bellevueuniversity-my.sharepoint.com/:p:/g/personal/kbrehm_bellevue_edu/ESAF15sxuxRHjcn751HUYZ0Bqi-187xuNiMmV_BWFpoYsQ?e=ycQGbv Excel Data: https://bellevueuniversity-my.sharepoint.com/:x:/g/personal/kbrehm_bellevue_edu/ER6HAc45ardGm9cpAOGzcvsBNrB7T2PvQkBMIJIVckEg1Q?e=byoc44 This playlist follows the text, Beginning Statistics, 3rd ed, Warren, Denley, Atchley The playlist can be found here: https://www.youtube.com/playlist?list=PLl-gb0E4MII1dkfGxmdt8YA0Dgabdvdmq