Question: The data in the table below are for retail sales in book stores by quarter. ( c3p13 ) U.S. Retail Book Sales (in Millions of

The data in the table below are for retail sales in book stores by quarter. (c3p13)

U.S. Retail Book Sales (in Millions of Dollars, NSA)

Date	Sales
Mar-02	1,866
Jun-02	1,666
Sep-02	2,351
Dec-02	2,455
Mar-03	2,169
Jun-03	1,815
Sep-03	2,498
Dec-03	2,637
Mar-04	2,326
Jun-04	2,020
Sep-04	2,858
Dec-04	2,915
Mar-05	2,725
Jun-05	2,283
Sep-05	3,134
Dec-05	3,066
Mar-06	2,876
Jun-06	2,445
Sep-06	3,190
Dec-06	3,407
Mar-07	3,197
Jun-07	2,575
Sep-07	3,290
Dec-07	3,693
Mar-08	3,273
Jun-08	2,713
Sep-08	3,514
Dec-08	3,794
Mar-09	3,480
Jun-09	2,943
Sep-09	3,654
Dec-09	4,108
Mar-10	3,628
Jun-10	3,203
Sep-10	4,051
Dec-10	4,010
Mar-11	3,719
Jun-11	3,084
Sep-11	4,234
Dec-11	4,073
Mar-12	3,983
Jun-12	3,132
Sep-12	4,328
Dec-12	4,007
Mar-13	3,969
Jun-13	3,257
Sep-13	4,824
Dec-13	4,129
Mar-14	4,298
Jun-14	3,312
Sep-14	4,811
Dec-14	4,336
Mar-15	4,261
Jun-15	3,278
Sep-15	4,991
Dec-15	4,447

a. Plot these data and examine the plot. Does this view of the data suggest a particular smoothing model? Do the data appear to be seasonal? Explain.

b. Use an exponential smoothing method to forecast the next four quarters. Plot the actual and forecast values.

How do i do this in excel?The data in the table below are for retail sales in book stores by quarter. (c3p13)

U.S. Retail Book Sales (in Millions of Dollars, NSA)

Date	Sales
Mar-02	1,866
Jun-02	1,666
Sep-02	2,351
Dec-02	2,455
Mar-03	2,169
Jun-03	1,815
Sep-03	2,498
Dec-03	2,637
Mar-04	2,326
Jun-04	2,020
Sep-04	2,858
Dec-04	2,915
Mar-05	2,725
Jun-05	2,283
Sep-05	3,134
Dec-05	3,066
Mar-06	2,876
Jun-06	2,445
Sep-06	3,190
Dec-06	3,407
Mar-07	3,197
Jun-07	2,575
Sep-07	3,290
Dec-07	3,693
Mar-08	3,273
Jun-08	2,713
Sep-08	3,514
Dec-08	3,794
Mar-09	3,480
Jun-09	2,943
Sep-09	3,654
Dec-09	4,108
Mar-10	3,628
Jun-10	3,203
Sep-10	4,051
Dec-10	4,010
Mar-11	3,719
Jun-11	3,084
Sep-11	4,234
Dec-11	4,073
Mar-12	3,983
Jun-12	3,132
Sep-12	4,328
Dec-12	4,007
Mar-13	3,969
Jun-13	3,257
Sep-13	4,824
Dec-13	4,129
Mar-14	4,298
Jun-14	3,312
Sep-14	4,811
Dec-14	4,336
Mar-15	4,261
Jun-15	3,278
Sep-15	4,991
Dec-15	4,447

a. Plot these data and examine the plot. Does this view of the data suggest a particular smoothing model? Do the data appear to be seasonal? Explain.

b. Use an exponential smoothing method to forecast the next four quarters. Plot the actual and forecast values.

How do i do this in excel?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!

The data in the table below are for retail sales in book stores by quarter. ( c3p13 ) U.S. Retail Book Sales (in Millions of Dollars, NSA) Date Sales Mar-02 1,866 Jun-02 1,666 Sep-02 2,351 Dec-02...

The data in the table below are for retail sales in book stores by quarter. (c3p13) U.S. Retail Book Sales (in Millions of Dollars, NSA) Date Sales Mar-02 1,866 Jun-02 1,666 Sep-02 2,351 Dec-02 2,455...

The data in the table below are for retail sales in book stores by quarter. U.S. Retail Book Sales (in Millions of Dollars, NSA) Date Sales Date Sales Date Sales Mar-02 1,866 Mar-07 3,197 Mar-12...

The data below show retail sales at hardware stores in the United States monthly between January 1992 and December 2005. The data are in millions of dollars and are not seasonally adjusted. Date...

develop a five forces model analysis develop a swot analysis based off the information provided Cracker Barrel Old Country Store Inc.-2018 www.crackerbarrel.com (CBRL) Hended a Luce Tesse. Cracker...

The data below show retail sales at hardware stores in the United States monthly between January 1992 and December 2005. The data are in millions of dollars and are not seasonally adjusted. Date...

I need this for a marketing presentation can you make it as detailed as possible and cite your sources thank you AND I NEED IT SOON THANK YOU. Question? "Does Flexiti's financial marketing plan...

Read the following Krispy Kreme Doughnuts, Inc. Case Study and Determine if Krispy Kreme is financially healthy. Review the data from the financial statements and ratios provided in the case. And...

Read this article and answer the following questions please. On a recent CD post, I summarized some empirical evidence on the costs of US trade protectionism based on case studies in a 1986 book...

Here is a bivariate data set. X y 59 42 80 116 59 73 52 56 84 97 52 10 61 48 60 72 62 39 Find the correlation coefficient and report it accurate to four decimal places. r = Hint: HelpThe following...

The 2008 financial statements of the Internal Revenue Service are available at: www.gao.gov/new.items/d09119.pdf. Use these to answer the following questions: a. Statement of Net Costs 1. What are...

You are willing to set aside half your salary for the next 10 years and put it in a trust that will earn a rate of 5% annual interest. After those 10 years you will not deposit anything else, but you...

You are a member of the engagement team auditing the financial statements of Alpha Corporation ( the Company ) as of and for the year ended December 3 1 , 2 0 2 4 , the initial year of the Company s...

5. Describe the principle of limited liability in a limited liability partnership

6. Give three examples that nothing (doing nothing) can function as a cause.

2. To store it and

3. Give three examples from your own everyday life where a piece of communi-cation is structured into a linear sequence, i.e. B is the cause of A.