Research analyst for a large investment firm

Reference no: EM131798465

Madelyn Davis is a research analyst for a large investment firm. She has been assigned the task of forecasting sales for W al-Mart Stores, Inc., for fiscal year 2011. She collects quarterly sales for Wal-Mart Stores, Inc. (in millions $) for the 10-year period 2001 through 2010, a portion of which is shown in the accompanying table. The full data set is on the text website, labeled Wal-Mart Sales.

Wal-Mart Quarterly Sales (in millions $)

	Quarters Ended
Years	April 30	July 31	October 31	January 31
2001	42,985	46,112	45,676	56,556
2002	48,052	52,799	52,738	64,210
....	....	....	....	....
2010	93,471	100,082	98,667	112,826

In a report, use the sample information to:

1. Use a scatterplot to determine which model best depicts trend for Wal-Mart's sales.

2. Determine whether or not a seasonal component exists in the series, using the seasonal dummy variable approach.

3. Given the conclusions on trend and the seasonal component, provide forecast values for the four quarters of 2011 as well as total projected sales for fiscal year 2011.

Reference no: EM131798465

Questions Cloud

Design a web page for attracting travelers : Decide the way you would best represent the destination as an exciting and interesting place to visit - Apply layer styles and filter effects to your design

What is the remaining depreciable cost of the machine : Clausen revised several estimates related to this machine. It determined the new total life of the machine to be 8 years and the revised salvage

Compute the elasticity of demand for the new sandwich : Find the elasticity at the possible prices of $4 and $10. Classify these prices as elastic, inelastic, or unitary elastic.

What are the two assumptions of covered interest parity : What are the two assumptions of covered interest parity? How do investors use covered interest arbitrage to maximize their investment returns?

Research analyst for a large investment firm : Madelyn Davis is a research analyst for a large investment firm. She has been assigned the task of forecasting sales for W al-Mart Stores

What amount should be reported in the consolidated income : What amount should be reported in the consolidated income statement for income from noncontrolling interests

Find the function that describes the number of daily sales : Find the function that describes the number of daily sales t days after the end of the campaign.

Discuss relative merits of keynesian and new keynesian model : Discuss the relative merits of the Keynesian and New Keynesian models and offer an opinion as to which is superior.

Problem on capital investment and production : Capital investment and production. Suppose that for a particular product, the number of units x produced per month depends on the number of thousands of dollars

User Account

All Pages