CoastCo Insurance, Inc., is interested in developing a forecast of larceny thefts in the United States....

CoastCo Insurance, Inc., is interested in developing a forecast of larceny thefts in the United States. It has found the following data:

(c1p11)	Year	Larceny Thefts*	Year	Larceny Thefts*
	1	4,151	10	7,194
	2	4,348	11	7,143
	3	5,263	12	6,713
	4	5,978	13	6,592
	5	6,271	14	6,926
	6	5,906	15	7,257
	7	5,983	16	7,500
	8	6,578	17	7,706
	9	7,137	18	7,872

Plot this series in a time-series plot and make a naive forecast for years 2 through 19. Calculate the MAPE for years 2 through 18. On the basis of these measures and what you see in the plot, what do you think of your forecast? Explain. (Please show work)

Expert Solution

The time series plot is:

The MAPE calculation is as below:

The formulas are:

The output is:

Year	Larceny Thefts*	Forecast	Error	Absolute Error	% Error
1	4,151
2	4,348	4,151	197	197	4.53
3	5,263	4,348	915	915	17.39
4	5,978	5,263	715	715	11.96
5	6,271	5,978	293	293	4.67
6	5,906	6,271	-365	365	6.18
7	5,983	5,906	77	77	1.29
8	6,578	5,983	595	595	9.05
9	7,137	6,578	559	559	7.83
10	7,194	7,137	57	57	0.79
11	7,143	7,194	-51	51	0.71
12	6,713	7,143	-430	430	6.41
13	6,592	6,713	-121	121	1.84
14	6,926	6,592	334	334	4.82
15	7,257	6,926	331	331	4.56
16	7,500	7,257	243	243	3.24
17	7,706	7,500	206	206	2.67
18	7,872	7,706	166	166	2.11
19		7,872		MAPE	5.30

The time series plot is:

From the above plot and also from the calculations, it is clear that the forecast figures are most of the times less than the actual figure. Therefore, the method has a considerable amount of bias associated with it. The value of MAPE is low and hence the accuracy is good.

orchestra answered 2 years ago

1. CoastCo Insurance is interested in developing a forecast of larceny thefts in the United States....

1. CoastCo Insurance is interested in developing a forecast of larceny thefts in the United States. Year Larcency Thefts* 1 8,151 2 8,348 3 9,263 4 9,978 5 10,271 6 9,906 7 9,983 8 10,578 9 11,137 10 11,194 11 11,143 12 10,713 13 10,592 14 10,926 15 11,257 16 11,500 17 11,706 18 11,872 Plot this series in a time series plot and make a naive forecast for years 2 through 19. Plot actual and forecast values of the...

1, A police officer randomly selected 585 police records of larceny thefts. The accompanying data represent...

1, A police officer randomly selected 585 police records of larceny thefts. The accompanying data represent the number of offenses for various types of larceny thefts. (a) Construct a probability model for type of larceny theft. (b) Are coin-operated machine larcenies unusual? (c) Are bicycle larcenies unusual? (a) Complete the table below. Type of Larceny Theft Number of Offenses Pocket picking 9 Purse snatching 10 Shoplifting 124 From motor vehicles 222 Motor vehicle accessories 64 Bicycles 37 From buildings 108...

In developing countries some of the working conditions are poor in comparison to the United States....

In developing countries some of the working conditions are poor in comparison to the United States. Companies such as Nike go overseas to find affordable labor and supply costs. What would you do as a CEO of a company, such as Nike, to aid in improving the welfare of these countries?

Provide a brief description of the history of health insurance in the United States.

Why is health insurance linked to employment (e.g. group insurance) in the United States? Explain.

Many countries (including the United States and European countries) are forecast to have a severe drop...

Many countries (including the United States and European countries) are forecast to have a severe drop in production this year. a. In this context, do you think that in the coming months there will be an increase or decrease in adverse selection problems in commercial loans? Explain what are adverse selection problems and justify your answer. b. How can an economic crisis affect a bank balance sheet? Will your bank capital increase or decrease? Explain your answers. c. Could a...

Why is it difficult to forecast health care delivery in the United States? Atleast 800 words

The Federal Deposit Insurance Corporation is a United States government corporation providing deposit insurance to depositors...

The Federal Deposit Insurance Corporation is a United States government corporation providing deposit insurance to depositors in U.S. commercial banks and savings institutions. The FDIC was created by the 1933 Banking Act, enacted during the Great Depression to restore trust in the American banking system. The FDIC recently conducted a survey and found that 45% of all financial consumers were very satisfied with their primary financial institution. If this figure still holds true today, suppose 28 financial consumers are sampled...

In the United States, employee benefits in the form of health insurance are not taxed. How...

In the United States, employee benefits in the form of health insurance are not taxed. How does this affect the price of health insurance compared to goods that are purchased after income is taxed? How does the amount of health insurance consumed compare to the amount that would be consumed if the benefit was taxed

An increase in the number of people in the United States with health insurance would likely...

An increase in the number of people in the United States with health insurance would likely cause: A. the cost of health care services to increase as the incentive for health care providers to minimize costs becomes less important. B. the cost of health care services to decrease as the incentive for health care providers to minimize costs becomes less important. C. the cost of health care services to decrease as the incentive for health care providers to minimize costs...

Question