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

Question:

# Question:Q: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

Question marked as Solved

Will this work?

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

Question marked as Solved

Will this work?

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

Hello Barry,

Yes. It works perfectly well. You're a genius.

I cannot thank you enough!

THANK YOU A LOT BARRY 🙂

Mar 11, 2018 10:09 AM

User profile for user: DanielDay

Question: Assigning Weights (Math Calculation with Apple Numbers)