Property tax was the first tax levied in the state of Washington and its collection accounts for about 30% of Washingtonâs total state and local revenue. It continues to be the most important revenue source for public schools, fire protection, libraries, parks and recreation, and other special-purpose districts.
Using the Name tool, you can define a constant, such as a tax rate, that you frequently use in Excel formulas. Go to Insert | Name | Define and type a nameTaxRate, for example. In the Refers to area, type the constant value and click on OK. For a 7 percent tax rate, you would enter 0.07. Now you can write a formula like =SalePrice*TaxRate and Excel will use the constant value you defined for TaxRate.
Letâs use Excel to calculate the covariance of this simple example. Open Excel and enter the returns of these two assets as they are shown above. Format Column B & Column C to percentage. In a new cell B9, use the COVAR function to calculate the covariance. Change the format of cell B9 to percentage (up to 3 decimal places). Enter the first parameter Array 1, B3 to B7 (B3:B7) Enter the second parameter Array 2, C3 to C7 (C3:C7) After entering the formula press the ENTER key to see the Covariance value.