| Year | Month | Make | Quantity | Pct | Date |
|---|---|---|---|---|---|
| 2007 | 1 | Toyota | 2884 | 22.7 | 2007-01-01 |
| 2007 | 1 | Volkswagen | 2521 | 19.9 | 2007-01-01 |
| 2007 | 1 | Peugeot | 1029 | 8.1 | 2007-01-01 |
| 2007 | 1 | Ford | 870 | 6.9 | 2007-01-01 |
| 2007 | 1 | Volvo | 693 | 5.5 | 2007-01-01 |
| 2007 | 1 | Skoda | 665 | 5.2 | 2007-01-01 |
Which Car Brand Should You Buy? A Data-Driven Analysis
Exploring Sales Performance and Public Sentiment to Determine the Best Car Brand
Introduction
Area of Interest
The automotive industry plays a crucial role in shaping consumer lifestyles, economic growth, and environmental sustainability. Choosing the right car brand often involves analyzing various factors such as sales trends, market performance, and public perception. This project seeks to answer the question: Which car brand is the best choice for potential buyers in Norway?
By analyzing car sales data and public sentiment from news sources, this study aims to identify brands that combine strong market performance with positive public perception.
Why is this Important?`
The Norwegian automotive market presents a compelling case study due to its unique characteristics, including its early adoption of sustainable transportation and the high penetration of electric vehicles (EVs). By analyzing car sales data and public sentiment in Norway, we gain valuable insights into how consumer preferences align with broader market trends, such as environmental consciousness, technological innovation, and brand loyalty. This study bridges the gap between quantitative metrics—like market share and sales trends—and qualitative insights from public sentiment to uncover which car brands stand out as leaders in performance and perception. Understanding this dynamic within the Norwegian context can help shed light on brand strategies that resonate with environmentally-conscious and innovation-driven markets globally.
Research Questions
Market Performance: Which car brands consistently dominate sales in Norway?
Sales Trends: How do monthly and cumulative sales vary among the top brands over time?
Public Perception: What is the overall sentiment toward these brands, and how does it correlate with their market performance?
Insights: Which brand emerges as the best option for purchase, balancing sales performance and consumer sentiment?
Hypothesis
Car brands with higher sales volumes and positive public sentiment are likely to be viewed as more reliable and desirable, making them better choices for consumers.
Dataset Selection
This analysis utilizes a structured dataset containing monthly car sales data from Norway, supplemented by public sentiment data collected from news articles via the Google News RSS API.
Primary Dataset:
norway_new_car_sales_by_make.csv- Provides sales data for various car brands in Norway, including monthly sales volume and market share.
Supplementary Dataset: News articles related to car brands, collected using the Google News RSS API for sentiment analysis.
This combination of datasets offers a robust framework for analyzing both quantitative and qualitative dimensions of car brand performance. The sales dataset provides a precise measure of market dynamics through metrics such as monthly sales volumes, cumulative sales trends, and market share percentages. These figures offer valuable insights into each brand’s commercial success and competitiveness over time.
Complementing this, the sentiment data extracted from news articles captures public opinion, which serves as a proxy for consumer perception and brand reputation. By evaluating the sentiment—both positive and negative—associated with top car brands, we gain a deeper understanding of how external narratives and consumer attitudes align with actual sales performance.
Together, these datasets enable a holistic analysis, merging the rigor of numerical sales data with the nuance of public sentiment. This dual approach not only identifies high-performing brands but also highlights those that resonate positively with consumers, creating a comprehensive and actionable profile of the car brands under consideration.
Data Dictionary
The dataset contains the following variables:
| Column | Description |
|---|---|
| Year | Year of the car sales record |
| Month | Month of the car sales record |
| Make | Car manufacturer or brand name |
| Quantity | Number of cars sold in the given month |
| Pct | Percentage of market share in the given month |
| Date | Date derived from the year and month columns |
Example Data
Summary Statistics
| Make | Total_Sales | Avg_Pct |
|---|---|---|
| Volkswagen | 206669 | 15.276860 |
| Toyota | 168177 | 12.621488 |
| Volvo | 99937 | 7.380165 |
| Ford | 99713 | 7.558678 |
| BMW | 73315 | 5.323141 |
| Audi | 70475 | 5.274380 |
Descriptive Analysis
Cumulative Sales Trends
Key Observations:
Volkswagen Dominates: Volkswagen consistently leads in cumulative sales across the analyzed period, reflecting its strong market presence and brand appeal.
Toyota’s Consistent Growth: Toyota demonstrates steady cumulative growth, indicating a reliable and stable market share.
Ford and Volvo’s Modest Growth: Both Ford and Volvo show slower growth trends, suggesting a more niche or stable customer base compared to leaders like Volkswagen.
BMW’s Fluctuations: BMW’s cumulative sales exhibit significant variability, possibly due to seasonal trends, economic factors, or specific model releases.
Real-World Translation:
Volkswagen: Its dominance in cumulative sales suggests that it appeals to a broad customer base, likely due to competitive pricing, reliability, or a diverse product lineup.
Toyota: Steady growth may indicate customer loyalty and consistent performance, making it an attractive choice for buyers seeking reliability.
Ford and Volvo: These brands may target specific market segments or niche buyers. For example, Volvo’s focus on safety might appeal to families, while Ford might attract utility vehicle enthusiasts.
BMW: Sales fluctuations could signal reliance on high-end models or market sensitivity to economic conditions, which might resonate more with luxury buyers.
Insights for Decision-Making:
This trend suggests that Volkswagen and Toyota could be the best options for buyers looking for widespread support and reliability, while brands like BMW, Ford, and Volvo might appeal to niche markets or specific preferences.
Monthly Sales Distribution
Key Observations:
Volkswagen’s High Sales Variability: Volkswagen exhibits the highest median and range of monthly sales among the top brands. This indicates its strong dominance in the market but also suggests variability in demand or seasonal influences.
Toyota’s Stability: Toyota displays a higher median monthly sales volume with relatively moderate variability, reflecting consistent demand and stable market performance.
BMW’s Narrow Distribution: BMW has a smaller range of sales compared to others, suggesting a niche market appeal or less frequent fluctuations in sales.
Ford and Volvo’s Modest Performance: Both brands show lower median monthly sales, with Volvo exhibiting slightly narrower sales distribution, which could signify a smaller but steady customer base.
Real-World Translation:
Volkswagen: Its high variability and large median sales suggest that Volkswagen likely targets a broad market with diverse offerings. Seasonal promotions or model-specific launches might contribute to the spikes in sales.
Toyota: The consistent monthly sales make Toyota an attractive option for buyers looking for reliability and a trusted reputation.
BMW: The tighter distribution reflects its luxury positioning, appealing to a more stable and specific demographic.
Ford and Volvo: Their narrower ranges indicate steady sales, possibly due to a focus on specific niches like safety (Volvo) or utility vehicles (Ford).
Insights for Decision-Making:
For buyers seeking reliability and wide market acceptance, Volkswagen and Toyota stand out as strong options. BMW appeals to luxury-focused buyers, while Ford and Volvo are better choices for those prioritizing niche features such as safety or utility.
Market Share Pie Chart
Key Observations:
Volkswagen Leads: With 21.4% of the total market share, Volkswagen dominates the market, indicating its broad consumer appeal and significant presence.
Toyota’s Strong Position: At 17.4%, Toyota secures the second-highest market share, reflecting its reliability and consistent demand.
Diverse Competition: Brands like Volvo (10.3%) and Mercedes-Benz (10.3%) have comparable market shares, showing strong competition among premium and niche segments.
Smaller Shares: Audi, BMW, and Ford each have market shares between 6.7% and 7.6%, suggesting they cater to more specific customer bases or offer less overall volume.
Real-World Translation:
Volkswagen: As the clear leader, its market strategy likely includes a mix of affordability, availability, and broad product offerings, making it a default choice for many consumers.
Toyota: Its high share underscores its reputation for reliability and value, appealing to a wide range of buyers, especially in markets prioritizing longevity and practicality.
Luxury and Niche Brands: Volvo, Mercedes-Benz, and BMW’s significant shares indicate strong loyalty within premium segments, where factors like safety, innovation, and brand prestige play a key role.
Insights for Decision-Making:
Buyers seeking widely trusted and well-established brands should consider Volkswagen and Toyota due to their dominant market positions. For premium or niche preferences, Volvo and Mercedes-Benz stand out as strong contenders. The remaining brands, while smaller in market share, may still excel in specific features or targeted customer demographics.
Sales Growth Rates
Key Observations:
Volvo’s Significant Peaks: Volvo shows substantial growth in certain years, peaking around 2010 and 2015. These peaks might correlate with successful model launches or favorable market conditions.
BMW’s Consistent Positive Growth: BMW exhibits steady growth in several years, including strong performance in 2013 and 2015, signaling stable demand in its target demographic.
Volkswagen’s Volatility: While Volkswagen has strong years of growth (e.g., 2010), it also experiences significant declines in others, highlighting potential fluctuations in market demand or external factors like competition or recalls.
Ford’s Erratic Trends: Ford shows highly volatile growth patterns, including some steep declines, suggesting challenges in maintaining consistent market performance.
Toyota’s Moderate Growth: Toyota maintains relatively balanced growth rates without extreme fluctuations, indicating a stable and reliable performance.
Real-World Translation:
Volvo and BMW: These brands experience strong bursts of growth, likely driven by innovation, model popularity, or marketing success. Buyers looking for brands that innovate or make periodic impactful launches may gravitate toward these.
Volkswagen: Its significant swings suggest susceptibility to external market forces or competitive pressures, despite being a leader in total sales.
Toyota: Stable growth underscores its consistent appeal and reliability, making it a safe choice for long-term buyers.
Ford: Its erratic patterns may signal challenges in adapting to market demands, which could impact customer loyalty.
Insights for Decision-Making:
Toyota emerges as the most consistent performer, appealing to buyers who value reliability. In contrast, BMW and Volvo offer strong performance during specific periods, appealing to customers drawn to high-impact models or innovations. Volkswagen remains competitive but may require a closer look at specific market periods for a clearer picture of its performance.
Monthly Sales Distribution
Key Observations:
Volkswagen’s Leading Performance: Volkswagen consistently outperforms other brands in monthly sales across the entire year, maintaining a clear lead regardless of the season.
Toyota’s Strong Presence: Toyota exhibits the second-highest average monthly sales, with consistent performance throughout the year.
Relatively Uniform Performance: BMW, Ford, and Volvo show relatively similar and lower monthly averages compared to Volkswagen and Toyota, highlighting their smaller market shares.
No Strong Seasonal Fluctuations: None of the brands display significant dips or peaks in specific months, suggesting stable demand patterns.
Real-World Translation:
Volkswagen: Its leadership in average monthly sales signifies a dominant market position, with consistent consumer demand and likely strong distribution channels.
Toyota: As a close competitor, Toyota’s steady sales further reinforce its reputation as a reliable and widely preferred brand.
BMW, Ford, and Volvo: These brands likely cater to more niche markets, which could include luxury segments (BMW), safety-conscious buyers (Volvo), or specific vehicle types (Ford).
Insights for Decision-Making:
For consumers prioritizing consistent availability and market dominance, Volkswagen and Toyota stand out as top choices. Buyers with specific preferences, such as luxury or unique features, may find value in exploring BMW, Ford, or Volvo. The lack of pronounced seasonal fluctuations makes these brands reliable year-round options.
Sentiment Analysis
Simple Positivity (Valence) Scoring for Top 5 Brands
# A tibble: 10 × 3
Brand sentiment total
<chr> <chr> <int>
1 Ford positive 54
2 Volvo positive 49
3 Toyota positive 41
4 Ford negative 28
5 Volkswagen positive 27
6 BMW positive 26
7 Volkswagen negative 22
8 Toyota negative 20
9 BMW negative 19
10 Volvo negative 11
Key Observations:
Volvo Dominates Positivity: The word “autonomous” associated with Volvo has the highest positive count, reflecting the brand’s reputation for safety and technological innovation.
Toyota’s Quality Perception: Positive words like “top” and “compact” for Toyota highlight consumer appreciation for its reliability and practical offerings.
Ford’s Polarization: While Ford is associated with positive words such as “free” and “awards,” negative terms like “difficult” and “threat” suggest potential concerns or controversies.
BMW and Volkswagen’s Mixed Sentiment: BMW’s association with “luxury” is positive, but negative words like “stolen” and “crash” may indicate issues like high theft rates or safety concerns. Volkswagen’s “strike” highlights labor or operational disruptions.
Real-World Translation:
Volvo: Strong positive sentiment around safety and technology makes it an attractive choice for tech-savvy or safety-conscious buyers.
Toyota: Positive associations with practicality and reliability align with its reputation for offering dependable, value-driven vehicles.
Ford: Mixed sentiment suggests it may face challenges in maintaining a uniformly positive brand image, possibly requiring better communication or addressing underlying concerns.
BMW and Volkswagen: These brands may need to focus on mitigating negative perceptions around safety or operational issues to reinforce consumer trust.
Insights for Decision-Making:
Volvo and Toyota emerge as strong choices for consumers prioritizing reliability and innovation. Ford, BMW, and Volkswagen might appeal to specific buyer segments but may need to address specific challenges reflected in the sentiment analysis.
Key Observations:
Volvo Leads in Positive Sentiment: Volvo has the highest positive sentiment count, indicating strong public perception and consumer trust.
Toyota and Volkswagen Show Balanced Sentiments: Both brands display relatively high positive sentiment, with manageable levels of negative sentiment, reflecting consistent market appeal.
Ford and BMW’s Split Sentiments: These brands show a noticeable balance between positive and negative sentiments, potentially highlighting mixed public opinions or recent controversies.
Real-World Translation:
Volvo: Its overwhelming positive sentiment suggests a strong brand reputation, possibly driven by innovative features like safety and reliability.
Toyota and Volkswagen: Balanced sentiments align with their roles as reliable, market-leading brands with broad consumer appeal.
Ford and BMW: Mixed sentiments may require further exploration, as they could stem from product-specific issues or varying consumer experiences.
Insights for Decision-Making:
For buyers prioritizing public perception, Volvo, Toyota, and Volkswagen are the most positively viewed brands. Ford and BMW may still appeal to niche markets but could benefit from addressing sources of negative sentiment to strengthen their reputation.
Dominant Emotions
Key Observations:
Positive Emotions Lead: Across all brands, positive sentiment dominates, indicating a general trend of favorable public perception.
Trust and Anticipation: Emotions such as “trust” and “anticipation” are highly prominent, reflecting customer loyalty and excitement toward certain brands.
Negative Emotions Are Less Frequent: While negative emotions like “anger” and “fear” exist, they are far less prevalent compared to positive emotions, suggesting fewer critical public concerns about these brands.
Real-World Translation:
Positive Trends: The prevalence of trust and anticipation suggests that most brands are perceived as reliable and generate excitement, possibly due to new releases or positive consumer experiences.
Areas of Concern: While minimal, negative emotions highlight areas where specific brands might face challenges, such as addressing consumer concerns or unfavorable news coverage.
Insights for Decision-Making:
Brands with strong trust and anticipation metrics (e.g., Toyota, Volvo, Volkswagen) should focus on sustaining these emotions through innovation and customer engagement. Addressing occasional spikes in negative emotions will further enhance brand reputation. This balance of trust and positive sentiment makes these brands reliable choices for consumers.
Top 10 Most Commonly Used Words
Key Observations:
“Electric” Leads Significantly: The word “electric” dominates the chart, reflecting the growing consumer and industry focus on electric vehicles (EVs) and sustainability.
Positive Associations: Words like “top,” “good,” and “deal” highlight consumer and media positivity around quality, affordability, or high performance.
Production and Authority: Words like “production” and “authority” may reflect discussions about manufacturing efficiency, government policies, or leadership in the market.
Negative Mentions: Words like “crash” could indicate discussions on recalls, safety, or accidents but are not dominant compared to positive terms.
Real-World Translation:
Electric Vehicles: The prominence of “electric” indicates a market shift toward EVs, making this a crucial factor for buyers and manufacturers.
Positive Sentiment: The frequent mention of “top” and “good” aligns with consumer satisfaction or competitive advantage for specific brands.
Opportunities for Improvement: Words like “crash” suggest areas of concern, likely related to safety or reliability, that brands can address to enhance trust.
Insights for Decision-Making:
Consumers interested in cutting-edge technology or sustainability might prioritize brands heavily associated with “electric.” Positive terms indicate strong consumer and media reception, reinforcing trust in specific brands, while mentions of challenges like “crash” provide opportunities for brands to improve public perception.
Conclusion
Summary of Findings:
The comprehensive analysis of sales performance and public sentiment has unveiled critical insights into the strengths and challenges faced by the leading car brands in the Norwegian market. By combining quantitative sales metrics with qualitative sentiment analysis, we have developed a multidimensional view of the automotive industry.
Findings Generalized to Global Automotive Trends
The findings from this analysis extend beyond Norway to offer valuable insights into global automotive trends. As consumer preferences increasingly emphasize sustainability, reliability, and innovation, the brands that perform well in the Norwegian market—such as Toyota, Volkswagen, and Volvo—may serve as benchmarks for success in other regions. By identifying the strategies and features driving these brands’ success, manufacturers and stakeholders worldwide can better align their offerings to meet the evolving demands of modern consumers in competitive and environmentally-conscious markets.
Key Insights:
Top Performers in Sales:
Volkswagen: Dominates cumulative sales, market share, and monthly sales trends, demonstrating widespread consumer trust and a strong market presence.
Toyota: Shows consistent sales growth and high reliability, supported by stable monthly performance and positive public sentiment.
Sentiment Analysis Highlights:
Volvo: Stands out with the highest positive sentiment scores, reflecting its emphasis on safety and innovation, resonating with tech-savvy and family-oriented buyers.
Ford: While it demonstrates a balanced sales trend, the mixed sentiment highlights areas of improvement in public perception.
BMW: Despite being a premium brand, mentions of “luxury” are countered by negative terms such as “stolen,” indicating challenges in trust or reliability.
Emerging Market Trends:
The prominence of “electric” in sentiment analysis underscores the growing shift toward sustainability and electric vehicle (EV) adoption. Brands that prioritize EV offerings are likely to sustain future growth.
Consistent trust and anticipation sentiment across brands reflect consumer excitement around new launches and innovations.
Sales Variability and Growth:
Sales growth trends highlight brands like Volvo and BMW leveraging innovation, while Volkswagen capitalizes on its established reputation.
Year-over-year fluctuations suggest external influences such as market competition, economic conditions, or regulatory changes impacting growth.
Real-World Implications:
For Consumers:
Buyers seeking reliability and widespread availability should prioritize Volkswagen and Toyota.
For safety and cutting-edge technology, Volvo offers a compelling choice.
Those exploring premium or niche segments may consider BMW or Ford, with an understanding of their unique strengths and challenges.
For Manufacturers:
Addressing specific concerns reflected in sentiment analysis (e.g., negative terms like “crash” or “stolen”) can enhance brand perception.
Investing in electric vehicles and sustainability initiatives is critical to maintaining competitiveness in the evolving automotive market.
Leveraging positive public sentiment and trust for brands like Volvo can further solidify their standing.
Final Recommendation:
Based on the data, Volkswagen, Toyota, and Volvo emerge as the strongest overall performers, balancing high sales with favorable public sentiment. These brands should be top considerations for consumers and strategic investments for stakeholders. Ford and BMW maintain competitive niches but should focus on addressing areas of improvement to better align with consumer expectations.
This data-driven approach ensures that recommendations are backed by evidence, providing a holistic understanding of the market dynamics and brand performance in Norway.