Marken_Data-Translation

install.packages(c(‘ggpubr’,‘ggforce’,‘ggalt’))

library(tidyverse) library(ggalt) library(ggpubr) library(ggforce) library(ggplot2) library(ggannotate)

dv <- readRDS(‘king_dailyvisits.Rdata’)

This graph is a little cluttered, but it is still telling. Besides for Tesla, shown in red, all manufactures show a decline of visitors on the weekends, specifically on Sunday. The two conclusions we can draw are that Tesla seems to be performing the best the most often, and ford is the polar opposite, performing the worst on the most number of days.

Because of the clutter it may be difficult to see who exactly is leading in terms of visits. Here, it is far easier to see that Tesla is the clear leader. We can also see that Toyota and Chevrolet are very close in the Seattle market at least as far as visitors go.

DailyVisits

We can see the impact of the averages over the course of a month. Toyota ends up with 51 more visitors for the month. We can also see that Ford has less than half of the monthly visitors than even Chevrolet in third place. Additionally, Tesla has such dominance, it has more visitors than both Ford and Subaru combined.

DailyVisits

Although Toyota and Tesla aren’t strictly competitors in terms of price, Toyota was the closest brand to Tesla. Here we can see that on four separate occasions, Toyota drops below the lowest daily visits of Tesla. This is surprising since Toyota has a far lower average price as a brand which means its a feasible purchase for far more people.

Ford and Chevrolet are long time rivals, so I found it interesting that ford has so much less traffic than Chevy. Ford only beat Chevy’s foot traffic on three separate days. Out of these brands, as far as daily visits go at least, Chevy and Toyota were the closest on most metrics.

DailyVisits

This graph again displays how close Chevy and Toyota were over the month. Their max daily visits, although eclipsed by Tesla, were only separated by one visitor. Additionally, Ford isn’t in last place for the first time. Subaru was obviously more consistent as it outperformed Ford in all metrics besides max visits in a single day.

Here we look at the brands I took a deep look at vs the average daily visits of all dealerships in the Seattle area, which goes to show the interest of brands I chose as even Ford which performed worst in most cases has nearly twice as many daily visits as the that of all new car dealers.

To sum up, I have some thoughts about Ford and Tesla. They each have opposite performance but are on the on the extremes either way. They both also have surprising performance given Ford’s popularity and Tesla’s price. I think their is an explanation for the odd performance in each case.

In the case of Ford, I simply think there are fewer Ford dealerships in Seattle than Chevrolet. Given that they both sell a similar number of vehicles per year, this would make sense.

In the case of Tesla, well they have an interesting dealership model. Tesla dealers are located in shopping malls and in downtown, not where you would usually expect a car dealer to be. This is due to the fact that much if not all of their inventory is sold on their website. I believe that the high foot traffic numbers we are seeing from this data is misleading, and more often than not, people are simply window shopping. Yes this is the case with all dealers, but more so with Tesla due to the locations of the show rooms.