Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2022, 09:18 AM
ChrisOK ChrisOK is offline Can you make a Cumulative Percent of Percentages? Windows 10 Can you make a Cumulative Percent of Percentages? Office 2019
Advanced Beginner
Can you make a Cumulative Percent of Percentages?
 
Join Date: Sep 2016
Posts: 54
ChrisOK is on a distinguished road
Question 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
File Type: jpg CumulativePercentofPercents 2022-05-26 105602.jpg (116.6 KB, 13 views)
Reply With Quote
  #2  
Old 05-28-2022, 12:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Can you make a Cumulative Percent of Percentages? Windows 7 64bit Can you make a Cumulative Percent of Percentages? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,577
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
Reply

Tags
cumulative percent

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Baseline Cumulative Work and Cumulative Actual Work not avaialble SSayan Project 1 10-11-2018 01:51 AM
Missing percentages in a range philzar Excel 1 07-13-2015 09:54 AM
Can you make a Cumulative Percent of Percentages? Formulas for cumulative value and cumulative %? Brotein Excel 1 10-29-2013 05:35 AM
Can you make a Cumulative Percent of Percentages? How to calculate percentages??? fabthi Excel 3 04-13-2012 12:08 PM
Charting percentages within a percent 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.


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