Cub-paw, the most basic of your policies, is a liability only insurance policy t
ID: 3004648 • Letter: C
Question
Cub-paw, the most basic of your policies, is a liability only insurance policy that is available only to undergraduate students who are permanent residents of the State of Maine and also to those making less than $15,000 annually. Its base rate is ½ of the Mini-paw policy and is the most economical offering that the company can provide.
Thia is for my excel class i need to type formulas and figure out answer s i cant figur it out can someone help?
$600.00
Name Status Budget Income Residency Accidents Total Accidents Past Five Years Vehicle Type Vehicle Color Mileage Cub MiniExplanation / Answer
*
The basic percentage formula is as follows:
(Part/Whole)*100 = Percentage
*
*
Excel formula for percentage change (percentage increase / decrease)
To calculate percent change between values A and B, use the following formula:
(B - A) / A = Percent Change
When applying this formula to real data, it is important that you correctly determine which value is A and which is B. For example, yesterday you had 80 apples and how you have 100, meaning that now you have 20 apples more than before, which is 25% increase. If you had 100 apples and now you have 80, your number of apples has reduced by 20, which is 20% decrease.
Considering the above, our Excel formula for percentage change takes the following shape:
(New Value - Old Value) / Old Value = Percent Change
*
To increase an amount by a percentage, use this formula:
= Amount * (1 + %)
For example, the formula =A1*(1+20%) increases the value in cell A1 by 20%.
To decrease an amount by a percentage:
= Amount * (1 - %)
For instance, the formula =A1*(1-20%) reduces the value in cell A1 by 20%.
In our example, if A2 is your current expenditures and B2 is the percentage you want to increase or reduce that amount by, here are the formulas you'd enter in cell C2:
Increase by percentage: =A2*(1+B2)
Reduce by percentage: =A2*(1-B2)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.