Login Signup
Verified Document

Sales Of Mid-Size Sport Utility Term Paper

Related Topics:
Forecasting Honda Spss Toyota
Open Document Cite Document

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

Continue Reading...
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

Essay
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

Read More
Essay
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

Read More
Essay
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

Read More
Essay
American Automotive Industry and Porter's
Words: 3581 Length: 10 Document Type: Research Paper

4). 2.4 Effects of Environment: Concerns related to carbon emission were heightened in mid-2000s and in 2007 Al-Gore in his book 'An inconvenient Truth' condemned the big three saying "They keep trying to sell large, inefficient gas-guzzlers even though fewer and fewer people are buying them." In comparison to other developed countries in Europe and Asia, American standard for distance covered in one U.S. gallon was only 25 mpg (miles per gallon).

Read More
Essay
Revitalization of the American Car Industry
Words: 2115 Length: 7 Document Type: Term Paper

General Motors was founded in 1908 and has been the largest manufacturer, designer, building and marketer of cars and trucks throughout the world since 1921. It sells vehicles in more than 200 countries worldwide and maintains assembly, manufacturing, distribution or warehousing operations in 53 of these countries. In 2000, it sold 8.6 million cars and trucks - constituting 15.1% of the entire world vehicle market (the world's biggest share) at

Read More
Essay
Globalization and Energy Demands in
Words: 5347 Length: 20 Document Type: Term Paper

S. pp). For more than ten years, Chinese officials have stated that production from Chinese firms investing overseas is more secure than imports purchased on the international market (U.S. pp). In order to secure more reliable access, Chinese firms are being directed to invest in projects in the Caspian region, Russia, the Middle East and South America (U.S. pp). The National Intelligence Council's report also states that Europe's energy needs will

Read More

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