Describe the trend and discuss possible causes

Reference no: EM131538286

Choose a company that interests you, and for which you can find data on its annual revenue for the last 10 years.

A) Use Excel and Megastat to make an attractive, well-labeled time series line chart of the last 10 years of revenue for the company. Post this first graphic in your discussion. Adjust the Y-axis scale if necessary to show more detail. Label it Figure 1.

B) Describe the trend and discuss possible causes.

C) Fit both a linear and an exponential trend to the data. Use Excel’s option to display the equation and R2 statistic. Attach this as Figure 2.

D) Which model is better? Why?

E) Make annual forecasts for 2014-2015 using a trend model of your choice. Explain to us the model that you used, and why you chose it. Attach this as Figure 3 in your discussion thread.

Reference no: EM131538286

Questions Cloud

How have medical care costs affected government spending : How have medical care costs affected government spending? What are entitlements and how are they created?

Should the attack be considered a crime or espionage : Based off of the facts we know, should the attack be considered a crime, espionage or act of war? What should the US response be?

Total amount of dividends paid to common stockholders : How much in dividends is paif for each share of preferred stock? What is the total amount of dividends paid to common stockholders?

Evaluate the project npv : A project has annual cash flows of $3,000 for the next 10 years and then $8,500 each year for the following 10 years. The IRR of this 20-year project is 13.12%.

Describe the trend and discuss possible causes : Describe the trend and discuss possible causes.

Define federalism and then select a piec of legislation : Define federalism and then select a specific piec of legislation that will directly impact it...... I chose Every Student Succeeds Act (1970).

What percentage of the offer price does the load represent : What percentage of the offer price does the load represent?

Shares of common stock has the corporation issued : How many shares of common stock has the corporation issued?

The analysis of a new project should exclude : The analysis of a new project should exclude:

User Account

All Pages