Question

In many states, the weekly unemployment compensation is a certain percentage of the average week's salary calculated by taking the total of the two highest-salaried quarters and dividing by 26. A quarter is three consecutive months. In the spreadsheet below, the user enters the two highest quarter salaries and the state unemployment compensation percentage in the indicated cells. Write a spreadsheet formula that will calculate the weekly unemployment compensation.

a) Weekly Unemployment Compensation=26(Quarter 1 Salary+Quarter 2 Salary)​
b) Weekly Unemployment Compensation=13(Quarter 1 Salary+Quarter 2 Salary)​
c) Weekly Unemployment Compensation=State Unemployment Compensation Percentage(Quarter 1 Salary+Quarter 2 Salary)​
d) Weekly Unemployment Compensation=(Quarter 1 Salary+Quarter 2 Salary)×26

Answer 1

The formula to calculate weekly unemployment compensation is to multiply the sum of the two highest quarter salaries by the state unemployment compensation percentage and then divide by 26.

Step-by-step explanation:

The correct spreadsheet formula to calculate the weekly unemployment compensation is based on the average week's salary from the two highest-salaried quarters, divided by 26 weeks. Given that this calculation involves the state unemployment compensation percentage, the formula would be:

Weekly Unemployment Compensation = (State Unemployment Compensation Percentage/100) * ((Quarter 1 Salary + Quarter 2 Salary) / 26)

This accounts for the percentage of the average salary one would receive as part of their unemployment benefits. Make sure to divide the percentage by 100 since it is entered as a whole number in the spreadsheet and not as a decimal.