Use the Revenue Analysis Template to display the data in your research from the Revenue Worksheet.? Also, report the means and standard deviations as whole dollars.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Use the Revenue Analysis Template to display the data in your research from the Revenue Worksheet.
Also, report the means and standard deviations as whole dollars.
After filling in the template,
Answer 3 questions:
1) Which set of data shows the highest variation and which shows the lowest variation?
2) Which state shows the highest and lowest variations in total income and total sales tax collections?
3) Which state’s tax collections are more consistent and fluctuate the least?
Two sets
| MONTHLY TAX COLLECTIONS, State A | MONTHLY TAX COLLECTIONS, State B | |||||
| TOTAL INCOME TAXES | TOTAL SALES TAX | TOTAL INCOME TAXES | TOTAL SALES TAX | |||
| Jan-82 | $14,531,501 | $21,861,976 | Jan-82 | $53,098,735 | $45,532,739 | |
| Feb-82 | $32,395,154 | $22,771,358 | Feb-82 | $50,583,156 | $42,888,320 | |
| Mar-82 | $17,915,617 | $23,596,205 | Mar-82 | $60,558,426 | $49,895,982 | |
| Apr-82 | $17,767,683 | $23,129,779 | Apr-82 | $100,208,770 | $50,247,098 | |
| May-82 | $30,999,456 | $22,123,132 | May-82 | $74,625,196 | $50,445,240 | |
| Jun-82 | $5,075,984 | $23,162,066 | Jun-82 | $48,448,392 | $51,842,300 | |
| Jul-82 | $30,092,322 | $24,212,157 | Jul-82 | $46,849,723 | $52,830,024 | |
| Aug-82 | $36,386,379 | $19,253,248 | Aug-82 | $70,965,216 | $56,417,487 | |
| Sep-82 | $12,067,267 | $21,368,313 | Sep-82 | $49,523,591 | $52,566,626 | |
| Oct-82 | $27,501,011 | $23,880,509 | Oct-82 | $48,205,911 | $46,796,220 | |
| Nov-82 | $66,830,891 | $25,464,492 | Nov-82 | $54,724,037 | $50,989,214 | |
| Dec-82 | $27,045,761 | $26,238,678 | Dec-82 | $88,496,321 | $56,837,355 | |
| Jan-83 | $23,137,640 | $26,006,163 | Jan-83 | $52,978,187 | $45,044,604 | |
| Feb-83 | $31,375,199 | $25,888,123 | Feb-83 | $52,880,178 | $46,431,277 | |
| Mar-83 | $20,115,656 | $26,280,525 | Mar-83 | $63,768,821 | $51,527,459 | |
| Apr-83 | $23,670,417 | $26,315,695 | Apr-83 | $119,944,619 | $52,338,028 | |
| May-83 | $32,809,318 | $24,867,436 | May-83 | $86,979,822 | $54,634,617 | |
| Jun-83 | $6,540,732 | $22,809,926 | Jun-83 | $53,208,336 | $55,133,513 | |
| Jul-83 | $32,086,702 | $27,703,329 | Jul-83 | $52,816,052 | $55,232,093 | |
| Aug-83 | $42,132,513 | $20,772,219 | Aug-83 | $53,208,336 | $55,133,513 | |
| Sep-83 | $14,508,375 | $23,781,009 | Sep-83 | $52,816,052 | $55,232,093 | |
| Oct-83 | $31,053,626 | $24,968,327 | Oct-83 | $73,051,642 | $57,734,274 | |
| Nov-83 | $77,786,792 | $26,818,033 | Nov-83 | $52,986,920 | $54,961,470 | |
| Dec-83 | $24,912,495 | $25,753,615 | Dec-83 | $86,579,871 | $63,538,565 | |
| Jan-84 | $28,402,575 | $26,802,246 | Jan-84 | $56,794,415 | $48,218,630 | |
| Feb-84 | $36,542,348 | $28,817,475 | Feb-84 | $60,556,276 | $52,325,532 | |
| Mar-84 | $21,210,689 | $27,445,065 | Mar-84 | $71,780,951 | $54,332,724 | |
| Apr-84 | $30,137,950 | $27,861,523 | Apr-84 | $119,662,914 | $56,915,741 | |
| May-84 | $36,412,036 | $27,264,289 | May-84 | $89,175,207 | $55,570,321 | |
| Jun-84 | $7,054,596 | $24,323,752 | Jun-84 | $57,419,916 | $58,021,826 | |
| Jul-84 | $43,065,816 | $31,352,059 | Jul-84 | $55,680,139 | $60,049,604 | |
| Aug-84 | $67,680,167 | $24,285,559 | Aug-84 | $80,371,266 | $57,935,418 | |
| Sep-84 | $33,727,943 | $24,786,135 | Sep-84 | $62,952,979 | $56,405,779 | |
| Oct-84 | $41,565,940 | $26,531,964 | Oct-84 | $52,900,152 | $55,449,486 | |
| Nov-84 | $64,230,415 | $26,724,812 | Nov-84 | $63,010,665 | $53,729,301 | |
| Dec-84 | $43,719,819 | $27,184,474 | Dec-84 | $111,029,032 | $63,538,565 | |
| Jan-85 | $27,242,528 | $28,705,276 | Jan-85 | $56,727,127 | $48,247,590 | |
| Feb-85 | $26,341,130 | $29,433,589 | Feb-85 | $69,238,258 | $61,844,665 | |
| Mar-85 | $43,632,704 | $28,652,335 | Mar-85 | $76,566,738 | $59,512,040 | |
| Apr-85 | $28,120,373 | $29,196,420 | Apr-85 | $132,496,019 | $58,925,307 | |
| May-85 | $26,824,448 | $28,545,506 | May-85 | $93,633,191 | $59,275,276 | |
| Jun-85 | $30,222,363 | $27,168,426 | Jun-85 | $71,866,040 | $67,474,127 | |
| Jul-85 | $44,305,590 | $31,606,635 | Jul-85 | $62,780,819 | $63,243,330 | |
| Aug-85 | $24,003,218 | $27,014,220 | Aug-85 | $94,986,654 | $65,168,521 | |
| Sep-85 | $45,315,669 | $28,043,412 | Sep-85 | $66,183,185 | $63,121,063 | |
| Oct-85 | $44,615,332 | $29,168,133 | Oct-85 | $55,892,073 | $58,684,486 | |
| Nov-85 | $65,904,368 | $30,086,293 | Nov-85 | $63,160,781 | $61,827,719 | |
| Dec-85 | $48,813,481 | $28,726,071 | Dec-85 | $108,369,916 | $67,056,592 | |
| Jan-86 | $30,091,635 | $32,078,478 | Jan-86 | $58,168,036 | $53,685,649 | |
| Feb-86 | $31,439,652 | $30,560,407 | Feb-86 | $75,986,956 | $61,050,140 | |
| Mar-86 | $47,263,560 | $33,932,454 | Mar-86 | $87,769,645 | $59,694,581 | |
| Apr-86 | $31,842,621 | $32,132,084 | Apr-86 | $123,884,948 | $60,509,919 | |
| May-86 | $33,100,075 | $28,534,538 | May-86 | $114,214,549 | $60,545,647 | |
| Jun-86 | $33,508,641 | $28,047,170 | Jun-86 | $75,554,351 | $68,644,443 | |
| Jul-86 | $51,305,168 | $32,836,664 | Jul-86 | $62,023,680 | $63,641,379 | |
| Aug-86 | $39,297,617 | $25,938,485 | Aug-86 | $103,051,948 | $67,389,584 | |
| Sep-86 | $38,405,242 | $27,161,429 | Sep-86 | $73,586,040 | $63,535,098 | |
| Oct-86 | $47,334,538 | $30,247,400 | Oct-86 | $63,338,765 | $62,480,456 | |
| Nov-86 | $76,048,077 | $29,192,333 | Nov-86 | $69,180,390 | $58,693,516 | |
| Dec-86 | $53,868,302 | $30,687,878 | Dec-86 | $126,248,752 | $68,723,163 | |
| Jan-87 | $34,548,901 | $31,871,046 | Jan-87 | $58,748,964 | $55,234,873 | |
| Feb-87 | $33,804,019 | $31,948,263 | Feb-87 | $78,591,411 | $60,126,868 | |
| Mar-87 | $50,164,606 | $32,308,976 | Mar-87 | $83,680,489 | $60,069,910 | |
| Apr-87 | $34,464,990 | $32,247,021 | Apr-87 | $125,779,857 | $64,817,382 | |
| May-87 | $33,652,130 | $29,817,800 | May-87 | $124,581,222 | $71,335,460 | |
| Jun-87 | $36,508,678 | $32,802,125 | Jun-87 | $78,230,097 | $75,168,178 | |
| Jul-87 | $56,707,753 | $34,806,811 | Jul-87 | $65,445,716 | $77,856,019 | |
| Aug-87 | $39,822,331 | $28,217,398 | Aug-87 | $112,434,392 | $77,088,333 | |
| Sep-87 | $41,147,106 | $29,508,832 | Sep-87 | $69,580,051 | $75,290,705 | |
| Oct-87 | $48,581,309 | $32,848,482 | Oct-87 | $69,766,546 | $70,638,150 | |
| Nov-87 | $83,821,557 | $32,227,905 | Nov-87 | $77,903,312 | $74,175,366 | |
| Dec-87 | $54,427,798 | $33,624,628 | Dec-87 | $112,867,149 | $80,235,129 | |
| Jan-88 | $38,163,616 | $34,081,855 | Jan-88 | $68,391,706 | $65,949,402 | |
| Feb-88 | $37,240,375 | $34,584,859 | Feb-88 | $79,255,103 | $75,883,000 | |
| Mar-88 | $56,448,465 | $37,129,179 | Mar-88 | $105,351,237 | $74,171,631 | |
| Apr-88 | $40,184,537 | $33,278,482 | Apr-88 | $142,104,385 | $78,292,831 | |
| May-88 | $37,978,992 | $33,124,169 | May-88 | $130,049,223 | $77,389,257 | |
| Jun-88 | $35,237,695 | $36,224,966 | Jun-88 | $73,717,272 | $84,549,842 | |
| Jul-88 | $70,988,752 | $51,908,733 | Jul-88 | $75,112,458 | $82,088,856 | |
| Aug-88 | $40,722,401 | $43,461,582 | Aug-88 | $112,579,978 | $80,735,811 | |
| Sep-88 | $46,150,823 | $44,550,799 | Sep-88 | $76,207,057 | $88,754,599 | |
| Oct-88 | $55,914,170 | $46,948,574 | Oct-88 | $78,170,287 | $77,645,005 | |
| Nov-88 | $94,542,405 | $48,014,509 | Nov-88 | $85,437,767 | $79,073,887 | |
| Dec-88 | $68,658,364 | $45,972,701 | Dec-88 | $143,161,984 | $81,625,468 | |
| Jan-89 | $45,584,698 | $56,253,446 | Jan-89 | $83,470,584 | $64,677,822 | |
| Feb-89 | $40,400,471 | $50,815,600 | Feb-89 | $90,246,539 | $80,315,980 | |
| Mar-89 | $71,150,781 | $50,411,919 | Mar-89 | $108,011,166 | $88,449,815 | |
| Apr-89 | $45,891,545 | $50,655,063 | Apr-89 | $158,290,122 | $80,546,412 | |
| May-89 | $40,493,408 | $46,645,404 | May-89 | $136,684,834 | $83,562,067 | |
| Jun-89 | $45,088,420 | $46,809,770 | Jun-89 | $79,951,721 | $87,466,790 | |
| Jul-89 | $69,382,320 | $53,968,641 |
Get a plagiarism-free answer to this questionSend us your instructions and we’ll match you with the best writer in your subject.
Your pal for every paper is one click awayJoin 12,000+ students getting original, on-time papers with free Turnitin reports. All Rights Reserved Terms and Conditions |