Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Assigning Weights (Math Calculation with Apple Numbers)

Hi Friends,


I am trying to do the following and it's easier said than done.


STORY: There are 10 assignments (quizzes, tests, etc). Now, first 5 assignments are worth total of 25% of students grade with each assignment having 25% higher importance (higher weight) than the first one. The first 5 assignments with their corresponding weights will be worth a total of 25% of students grade. The remaining 5 assignments (6, 7, 8, 9, 10) will each be worth 75% than previous assignment, but the sum of all assignments (1-10) will total 100.


Assignments Importance
1
2 25% higher than assignment 1
3 25% higher than assignment 2
4 25% higher than assignment 3
5 25% higher than assignment 4
6 75% higher than assignment 5
7 75% higher than assignment 6
8 75% higher than assignment 7
9 75 % higher than assignment 8
10 75% higher than assignment 9


Does anyone have any idea how to calculate this in Apple Numbers?

iMac (27-inch, Late 2013), macOS Sierra (10.12.1)

Posted on

Reply
Question marked as Solved
Answer:
Answer:

Will this work?

User uploaded file


Formulas:

C3: =C2*1.25

Fill down to C6


C7: =C6*1.75

Fill down to C11


Add a Footer row to the table (row 12)

C12: =SUM(C)


D12: =100/C12


Enter 1 in C2


Select D12. Copy.


Select C2

Go Edit > Paste Formula Result.


Done.


Regards,

Barry

Posted on

Page content loaded

Question marked as Solved

Mar 10, 2018 12:40 PM in response to DanielDay In response to DanielDay

Will this work?

User uploaded file


Formulas:

C3: =C2*1.25

Fill down to C6


C7: =C6*1.75

Fill down to C11


Add a Footer row to the table (row 12)

C12: =SUM(C)


D12: =100/C12


Enter 1 in C2


Select D12. Copy.


Select C2

Go Edit > Paste Formula Result.


Done.


Regards,

Barry

Mar 10, 2018 12:40 PM

Reply Helpful
User profile for user: DanielDay

Question: Assigning Weights (Math Calculation with Apple Numbers)