(11C) Percent of Total [%T]
05-08-2018, 03:42 AM (This post was last modified: 03-31-2020 09:20 AM by Gamo.)
Post: #3
 Gamo Senior Member Posts: 706 Joined: Dec 2016
RE: (11C) Percent of Total [%T]
Accumulating Statistics [Σ+] with Percent of Total [%T]

Calculate for Total, Percent of Total, and Average.

Example:

Five groups of a department have submitted the budgets shown below.
Determine the department's total budget, each group's percent of the total, and the average budget size.

Group #1 Budget 30,168
Group #2 Budget 75,550
Group #3 Budget 52,600
Group #4 Budget 27,800
Group #5 Budget 41,750

Procedure: Assume the program Percent of Total is at [LBL A]

Clear Σ // to clear Statistic Registers

30168 [Σ+] > 1
75550 [Σ+] > 2
52600 [Σ+] > 3
27800 [Σ+] > 4
41750 [Σ+] > 5

Total Budget > RCL 3 > 227,868

Each group percent of total
#1. 30168 > f A > 13.24%
#2. [←] 75550 > f A > 33.16%
#3. [←] 52600 > f A > 23.08%
#4. [←] 27800 > f A > 12.20%
#5. [←] 41750 > f A > 18.32%

Average Budget > g [X-bar] > 45,573.60

Gamo
 « Next Oldest | Next Newest »

 Messages In This Thread (11C) Percent of Total [%T] - Gamo - 04-18-2018, 05:09 AM RE: (11C) Percent of Total [%T] - Gamo - 05-08-2018 03:42 AM

User(s) browsing this thread: 1 Guest(s)