In Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16 12,466,617 March/16 14,195,923 April/16 13,097,298 May/16 17,183,162 June/16 14,482,648 July/16 16,823,849 August/16 17,574,149 September/16 19,145,992 October/16 19,266,922 November/16 18,425,864 December/16 17,694,953 January/17 18,164,787 February/17 17,723,858 March/17 17,550,692 April/17 22,867,587 May/17 18,563,939 June/17 19,662,464 July/17 20,437,751 August/17 23,775,043 September/17 23,235,507 October/17 23,098,408 November/17 21,076,993 December/17 21,211,445 January/18 21,681,438 February/18 21,134,864 March/18 20,871,820 April/18 22,947,141 May/18 22,367,707 June/18 21,928,692 July/18 22,963,778 August/18 23,044,818 September/18 23,770,397 October/18 22,589,679 1. Estimate the linear trend model. Note: Negative values for regression coefficients should be indicated by a minus sign. Round final answers to 2 decimal places. 2. Use the estimated model to forecast the number of inquiries for November and December of 2018. Note: Round coefficient estimates to at least 4 decimal places

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

In Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018.

Date	Revenue
February/14	3,519,756
March/14	4,092,575
April/14	4,980,992
May/14	5,273,355
June/14	5,715,707
July/14	6,522,085
August/14	7,407,450
September/14	7,741,167
October/14	7,232,870
November/14	7,642,800
December/14	7,465,568
January/15	8,558,141
February/15	8,802,295
March/15	9,099,395
April/15	9,979,643
May/15	10,617,311
June/15	11,326,452
July/15	10,856,584
August/15	12,811,437
September/15	13,181,758
October/15	11,656,736
November/15	11,290,012
December/15	12,231,410
January/16	13,247,434
February/16	12,466,617
March/16	14,195,923
April/16	13,097,298
May/16	17,183,162
June/16	14,482,648
July/16	16,823,849
August/16	17,574,149
September/16	19,145,992
October/16	19,266,922
November/16	18,425,864
December/16	17,694,953
January/17	18,164,787
February/17	17,723,858
March/17	17,550,692
April/17	22,867,587
May/17	18,563,939
June/17	19,662,464
July/17	20,437,751
August/17	23,775,043
September/17	23,235,507
October/17	23,098,408
November/17	21,076,993
December/17	21,211,445
January/18	21,681,438
February/18	21,134,864
March/18	20,871,820
April/18	22,947,141
May/18	22,367,707
June/18	21,928,692
July/18	22,963,778
August/18	23,044,818
September/18	23,770,397
October/18	22,589,679