Question

In: Statistics and Probability

For the data below: Year Automobile Sales Year Automobile Sales 1990 116 1997 119 1991 105...

For the data below:

Year	Automobile Sales	Year	Automobile Sales
1990	116	1997	119
1991	105	1998	34
1992	29	1999	34
1993	59	2000	48
1994	108	2001	53
1995	94	2002	65
1996	27	2003	111

(a) Determine the least squares regression line using Excel.

(b) Determine the predicted value for 2004.

(c) Determine the 3 year moving average.

(d) Determine the MSE for the trend line (in a) and the 3 year moving average (in c.) Which forecasting method is better? Explain.

Expert Solution

a) By using excel we have

b)

YEAR= 2004

AUTOMOBILES SALES

c) 3 YEARS MOVING AVERAGE

d)

MSE FOR REGRESSION=1308.608

MSE FOR MOVING AVERAGE= 1403.96

SINCE MSE IS SMALLER FOR REGRESSION METHOD.SO IT IS BETTER METHOD FOR FORECASTING

orchestra answered 1 year ago

Suppose we have the following annual sales data for an automobile dealership: Year Sales &nb

Suppose we have the following annual sales data for an automobile dealership: Year Sales Trend 2009 121 1 2010 187 2 2011 165 3 2012 134 4 2013 155 5 2014 167 6 2015 200 7 2016 206 8 2017 221 9 2018 231 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to...

Suppose we have the following annual sales data for an automobile dealership: Year Sales &n

Suppose we have the following annual sales data for an automobile dealership: Year Sales Trend 2009 121 1 2010 187 2 2011 165 3 2012 134 4 2013 155 5 2014 167 6 2015 200 7 2016 206 8 2017 221 9 2018 231 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to...

Suppose we have the following annual sales data for an automobile dealership: Year Sales Trend 2009...

Suppose we have the following annual sales data for an automobile dealership: Year Sales Trend 2009 121 1 2010 187 2 2011 165 3 2012 134 4 2013 155 5 2014 167 6 2015 200 7 2016 206 8 2017 221 9 2018 231 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to determine the best model using the RMSE measure...

Full Boat Manufacturing has projected sales of $119 million next year. Costs are expected to be...

Full Boat Manufacturing has projected sales of $119 million next year. Costs are expected to be $70 million and net investment is expected to be $13.4 million. Each of these values is expected to grow at 10 percent the following year, with the growth rate declining by 1 percent per year until the growth rate reaches 6 percent, where it is expected to remain indefinitely. There are 5.5 million shares of stock outstanding and investors require a return of 12...

The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α =...

The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α = 0.2 and β = 0.15 (Hint: Use XLMiner) Year Units sold in thousands 1981 888 1982 900 1983 1000 1984 1200 1985 1100 1986 1300 1987 1250 1988 1150 1989 1100 1990 1200 Using the double exponential smoothing, find the value of the root mean square error for the given data.

last year electric out of hair sales of 105 million in assets at the start of...

last year electric out of hair sales of 105 million in assets at the start of the year of 160 million if his return on star of your assets was 10% what was its operating profit margin?

The data below is the data of Promotion and Sales of PT.Duta Pratama. Sales (Y) Promotion...

The data below is the data of Promotion and Sales of PT.Duta Pratama. Sales (Y) Promotion (X) 64 20 61 16 84 34 70 23 88 27 92 32 72 18 77 22 Requested: a. How is the Cost of Promotion and Sales? b. Create the Regression Equation. c. How much is the sale if the promotion is 20? d. How much is the sale if the promotion is 16? e. How much is the Promotion if sales are 90?...

With the data below, calculate NPV for the following Project Project life is 5 year Sales...

With the data below, calculate NPV for the following Project Project life is 5 year Sales forecasting for yr1 is $485,000 follow by sales Growth rate of 15.650%, 13.85%, 12.50% & 10.90% COGS as % of annual sales is 63.15 cap invest $275,000 to be depreciated over 6year Salvage value $81,000 Beg NWC $8900 NWC as % of Sales 1.05% WACC 10.23% Tax rate 35.40% The Firm could rent out the property for $1950/yr if they decide to not go...

Below is a data set containing information on applicants applying for automobile insurance with an insurance...

Below is a data set containing information on applicants applying for automobile insurance with an insurance company. Here is a description of each variable: Conduct a test to see if the population average annual Claims Paid is higher for people who are Not Married thant it is for people who are Married. Use alpha = 0.05. State hypotheses. Explain your results. Assume that the population standard deviations are not equal. App. No. Marital Status Education Annual Salary Credit Score Age...

Situation: The town of Waterville has the following past population data projected beyond 1990. Year ...

Situation: The town of Waterville has the following past population data projected beyond 1990. Year 1900 1910 1920 1930 1940 1950 1960 1970 1980 1990 Population 10,240 12,150 18,430 26210 22,480 32.410 45,050 57,200 64,030 77,320 The average water consumption (including every possible sector) is 160 gal/cap-day in 2005. The town has a wastewater treatment plant (WWTP) with a treatment capacity of 20 MGD. Due to the rapid growth of the population, the town is planning to build a...