Verified Document

Sales Of Mid-Size Sport Utility Term Paper

Related Topics:

Table 3: SPSS Correlation Coefficients

Kendall's tau_b

BodyOnFrame

Correlation Coefficient

Sig. (2-tailed)

UnibodyCrossover

Correlation Coefficient

Sig. (2-tailed)

Spearman's rho

BodyOnFrame

Correlation Coefficient

Sig. (2-tailed)

UnibodyCrossover

Correlation Coefficient

Sig. (2-tailed)

With the statistical analysis showing reasonably strong predictability, the next step is to evaluate the specific 14-month time series for greater insights into the variability and predictability of the data. What emerges from completing a Linear Regression along with every exponential smoothing techniques for curve fitting is further evidence of linear (.702 regression) in addition to quadratic (.737 regression) shows that variations in Body-on-Frame demand are explained through these statistical techniques.

Table 4: Model Summary and Parameter Estimates

Dependent Variable: BodyOnFrame

Equation

Model Summary

Square

Linear

Logarithmic

Inverse

Quadratic

Cubic

Compound

Power

Growth

Exponential

Logistic

The independent variable is UnibodyCrossover.

Forecasting Results by Type of Method

The most basic of forecasting techniques, the moving average, yields the following table for the unibody (crossover) and Body-on-Frame unit sales through the remainder of 2007 with the following table showing the results.

Table 5: Three-Month Moving Average Forecast of Body on Frame SUVs based on Unibody as the Independent Variable

Body on Frame SUVs

Unibody SUVs

Using Correlation for the Forecasting Technique

Taking the correlation analysis and creating a linear regression to the 14-month data, the following forecast is generated. SPSS Version 13 generates the following cross-correlation analysis shows a more significant gap emerging over time for Body-on-Frame vs. Unibody (crossover) vehicle comparisons. The following graphic generated in SPSS Version 13 shows the progression of the forecast graphically.

Table 6: Correlation Forecast of Body on Frame SUVs based on Unibody as the Independent Variable

Body on Frame SUVs

Unibody SUVs

Summary

Appendices a and B. provide the background data for this paper, and the extensive use of statistical analysis to first prove that gas prices are not as much of a predictor to the sales of mid-size Body-on-Frame SUVs as the rapid growth of unibody (crossover) SUVs are. Gas is a contributing factor in the forecasts of unibody SUVs (.32) yet with a quadratic correlation of.737 the impact of this vehicle class itself is even more of a powerful predictor of Body-on-Frame SUV demand. Using three-month moving averages, the results are smoothed through those fundamental forecasting techniques. Conversely, when more robust statistical analysis tools and techniques are used, the data shows a much more significant divergence of these two variables, when unibody (crossover) SUVs is used as part of the analysis. Using correlation analysis show this wider divergence of values in the sample set, including a wider confidence interval for the forecasts.

Moving averages and correlation analyses, cross-correlation, and regression analyses have been used in this paper to predict both the influence of gas prices on both unibody (crossover) and Body-on-frame SUVs. While the commonly held belief that gas prices directly influence the sales of these larger vehicles, they do have an influence. Yet the number...

The results of this paper support that finding and conclusion, and the forecasts quantify it.
References

Monthly Energy Review (2006) - Posted: August 28, 2006 from the Energy Information Administration at Website: http://www.eia.doe.gov/emeu/mer/petro.html. Here is the specific data table used for the analysis:

http://tonto.eia.doe.gov/merquery/mer_data.asp?table=T09.04

Appendix a: Comparison Analysis for 14-month Analysis

COMPARING BODY on FRAME SUV vs. CROSS-OVER (UNIBODY) SUV SALES

Body on Frame SUVs Jun-05 Jul-05 Aug-05 Sep-05 Oct-05 Nov-05 Dec-05 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 CHEVROLET - TRAIL BLAZER 21,252-19,767-18,718-16,091-12,140-11,277-15,901-12,286-11,162-12,915-10,791-13,939-13,716-14,013 CHEVROLET - TRAILBLAZER EXT 7,445-6,377-6,070-5,112-4,980-4,396-4,801-5,311-3,020-2,727-2,076-1,925-1,948-2,301 CHEVROLET - TRAILBLAZER SS 1,165 FORD - EXPLORER 28,369-29,592-19,646-14,476-13,137-11,932-16,512-16,030-17,739-17,206-14,493-18,373-17,832-15,930 GMC - ENVOY XL DENALI 561-516 358-345 526-528 824-639 572-629 455-472 557-529 KIA - SORENTO 4,057-4,626-5,020-4,530-4,374-4,282-3,444-3,274-3,241-4,252-4,607-4,991-4,785-5,676 NISSAN - PATHFINDER 6,796-7,601-6,886-5,624-5,523-5,932-6,816-6,956-7,139-8,468-6,309-5,903-5,501-5,439 TOYOTA - 4 RUNNER 8,950-8,722-9,107-7,723-8,214-8,012-9,182-9,554-9,242-10,352-9,649-9,195-8,659-9,461 TOTALS: 77,430-77,201-65,805-53,901-48,894-46,359-57,480-54,050-52,115-56,549-48,380-54,798-52,998-54,514 Unibody SUVs Jun-05 Jul-05 Aug-05 Sep-05 Oct-05 Nov-05 Dec-05 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 CHEVROLET - EQUINOX 15,310-16,743-11,534-10,064-6,997-6,699-8,399-7,601-8,190-8,609-11,749-10,416-10,702-13,280 FORD - FREESTYLE 6,730-9,263-7,248-7,663-6,856-4,729-5,113-5,139-5,798-6,529-6,866-6,266-5,854-5,384 HONDA - PILOT 11,770-13,655-14,019-10,344-10,964-11,477-17,454-11,495-11,522-12,452-12,626-12,121-11,667-18,168 HYUNDAI - SANTA FE 11,759-7,526-6,359-4,707-4,779-3,780-3,784-3,543-3,837-3,983-3,564-3,920-5,820-7,893 NISSAN - MURANO 6,661-6,786-6,131-5,556-5,113-5,266-6,840-8,323-7,621-8,788-7,107-6,699-6,754-6,559 SUBARU - B9 TRIBECA 1,312-1,259-1,687-1,546-1,715-1,709-2,210-1,872-1,564-1,813-1,528-1,382-1,542-1,531 TOYOTA - HIGHLANDER 13,432-12,835-13,997-11,012-9,664-9,609-9,806-9,970-9,911-10,878-10,854-11,060-10,451-11,775 TOTALS: 66,974-68,067-60,975-50,892-46,088-43,269-53,606-47,943-48,443-53,052-54,294-51,864-52,790-64,590 Unibody SUV as a % of total SUV Sales: 46% 47% 48% 49% 49% 48% 48% 47% 48% 48% 53% 49% 50% 54% TOTAL MIDSIZE SUV UNIT SALES 144,404-145,268-126,780-104,793-94,982-89,628-111,086-101,993-100,558-109,601-102,674-106,662-105,788-119,104 Average U.S. Gas Price $

Appendix B: COMPARING BODY on FRAME SUV vs. CROSS-OVER (UNIBODY) SUV SALES

COMPARING BODY on FRAME SUV vs. CROSS-OVER (UNIBODY) SUV SALES

Body on Frame SUVs

CHEVROLET - TRAIL BLAZER

CHEVROLET - TRAILBLAZER EXT

CHEVROLET - TRAILBLAZER SS

FORD - EXPLORER

GMC - ENVOY XL DENALI

KIA - SORENTO

NISSAN - PATHFINDER

TOYOTA - 4 RUNNER

TOTALS by YEAR

Unibody SUVs

CHEVROLET - EQUINOX

FORD - FREESTYLE

HONDA - PILOT

HYUNDAI - SANTA FE

NISSAN - MURANO

SUBARU - B9 TRIBECA

TOYOTA - HIGHLANDER

Totals by Year

Sources used in this document:
References

Monthly Energy Review (2006) - Posted: August 28, 2006 from the Energy Information Administration at Website: http://www.eia.doe.gov/emeu/mer/petro.html. Here is the specific data table used for the analysis:

http://tonto.eia.doe.gov/merquery/mer_data.asp?table=T09.04

Appendix a: Comparison Analysis for 14-month Analysis

COMPARING BODY on FRAME SUV vs. CROSS-OVER (UNIBODY) SUV SALES
Cite this Document:
Copy Bibliography Citation

Related Documents

Products, Such As Crest Toothpaste
Words: 639 Length: 2 Document Type: A-Level Outline Answer

Because the Sephora flagship store is located in New York, customers often expect to come in and out quickly, and if the product is not there, they may not patronize the store again, because of the availability of other retailers only a few stores away. This is why keeping detailed information about its inventory is essential. Inventory strategists closely monitor the numbers flow of various products throughout the store.

Automobile the American Car Industry
Words: 1561 Length: 5 Document Type: Term Paper

These force American car manufacturers to improve the quality of their products, to focus on developing more fuel-efficiency vehicles and to regain the population's loyalty to the national cars. Bibliography Jones, R., quoting Lindland, R., American auto industry seen at a crossroads, MSNBC, May 9, 2006, http://www.msnbc.msn.com/id/10642724/,last accessed on October 31, 2007 Environmental Implications of the Automobile, State of the Environment, Fact Sheet No. 93-1, published under the Authority of the Canadian

Rollover the Hidden History of
Words: 2218 Length: 5 Document Type: Research Proposal

It will be recorded as the time the auto industry ducked its responsibility and missed a unique opportunity." (2002) The ABC Primetime report entitled: "Technology to Prevent SUV Rollovers" reports that is a new device that is purported to have the capacity to prevent SUV rollovers. This report states specifically that in a rollover "there are so many ways to die. Ejections, getting runover by the vehicle when it's rolling,

International Marketing How Does Global
Words: 2030 Length: 7 Document Type: Term Paper

The role of the augmented product component has significantly added differentiation and value to products that compete in highly commoditized and less differentiated markets. These include cell phones accessories, cell phone plans, and the pervasive use of customer service to drive up lifetime customer value and loyalty. Augmented components of products are also the guarantees, accessibility to technical and service support resources, and warranties delivered with the product itself. This

Influence of 2007 Economic Crisis on American Car Market
Words: 24230 Length: 88 Document Type: Thesis

2007 Economic Crisis on American Car market Effect of the 2008 global economic crisis on automotive industries Crisis in the United States Crisis in Canada Crisis in Russia Crisis in European markets Crisis in Asian markets Effects by other related crisis events In this paper, we will review the effects of 2008 global automotive crisis. Our main focus will be on the American car manufacturers and the negative impact they suffered due to the crisis. We will

High Gas Prices on the
Words: 12212 Length: 44 Document Type: Term Paper

The former might be, 'What specific...' [while] Less structure might be exemplified by: "Please respond to the following in your own words: I....'" (Dereshiwsky, 1999) in addition: adding some open-ended items such as these to a more traditionally scaled quantifiable survey, such as one with Likert-scaled attitudinal items, and/or "check/off" questions on demographic background variables, is a good way to make the survey "multimethod" in nature. This is because you'd

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now