Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula
About
No channel description available.
Video Description
Download files: https://people.highline.edu/mgirvin/AllClasses/210Excel2013/Ch02/Excel2013StatisticsChapter02.xlsx Topics in this video: 1. (00:09) Overview of % Cumulative Frequency 2. (00:42) Formulas to create Cumulative Frequency Distribution and % Cumulative Frequency Distribution. 3. (04:17) % Cumulative Frequency (Ogive) Chart using X-Y Scatter Chart 4. (07:36) PivotTable to create Frequency Distribution and % Cumulative Frequency Distribution. 5. (10:30) Combine Chart that shows Frequency Distribution as a Column Chart with No Gap width and % Cumulative Frequency as a Line. 6. (11:43) Custom Number Formatting to hide all values using three semi-colons
Essential Camera Gear Upgrade
AI-recommended products based on this video
NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN
SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN
SENDEFN Leather Wristlet Clutch Small Women Crossbody Shoulder Bag Wallet Purses RIFD Card Slots
FuninCrea Mens Sling Bag, Oxford Chest Bag Shoulder Bag with Adjustable Shoulder Straps
VNINE Small Sling Crossbody Backpack Shoulder Bag for Men Women, Lightweight One Strap Back Pack Sling Bag Backpack for Hiking Walking Biking Travel Cycling with Headphone Port
OSOCE RFID Mens Sling Bag, Anti-theft Crossbody Shoulder Bag Travel Cycling Sport Hiking Bags for Men Women Casual Daypack(2.0Black-S)
