Microsoft Office Forums Can you make a Cumulative Percent of Percentages?
 User Name Remember Me? Password
 Register FAQ Search Today's Posts Mark Forums Read

 Thread Tools Display Modes
#1
05-26-2022, 09:18 AM
 ChrisOK Windows 10 Office 2019 Advanced Beginner Join Date: Sep 2016 Posts: 54
Can you make a Cumulative Percent of Percentages?

I was given a ppt slide with an embedded chart holding percents. Those are manually keyed in from another large table that calculates the % of Matched data against the full set of data in a bucket of data. For example, in OCT 97% of the data from bucket 1 matched up to bucket 2. I need help with the large "Overall Assurance" percent of "94.3" - it is a manually entered in a text box and the black slider is also manual. ** I need to understand how to come up with the proper figure that will replace that "94.3" -- Need to update it now that I have updated the lower table with all new figures.

I've looked up How to do a Cum% but in most cases, there's a frequency involved like how many times the dice roll turned up a "6" and so on..

Is it possible to create a formula that calculates the percent cum of a row of percents like this (attchd image)? I believe what they're trying to show the client is similar to an Average... (your data has matches XX% of the time -- and of course the higher the %, the better!)

Not sure how to accomplish this in that embedded area? You can't just SUM up a row of percents it seems to make anything meaningful - need a percent expert's help on this.. THANK YOU
Attached Images
 CumulativePercentofPercents 2022-05-26 105602.jpg (116.6 KB, 13 views)
#2
05-28-2022, 12:00 AM
 Pecoflyer Windows 7 64bit Office 2010 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,577

Please post a sample sheet with 10-20 rows of data and an example of expected results. Thx ( Pictures are utterly useless)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

 Tags cumulative percent

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post SSayan Project 1 10-11-2018 01:51 AM philzar Excel 1 07-13-2015 09:54 AM Brotein Excel 1 10-29-2013 05:35 AM fabthi Excel 3 04-13-2012 12:08 PM Tom0822 Excel 0 03-05-2012 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:13 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft