Signature Presentation
Bookworm05
VisualsData-KSpells.docx
Signature Assignment: Creating Visuals From Data
VISUALS FROM DATA
1.
|
Year |
Tires Purchased |
|
1996 |
20,478 |
|
1997 |
15,478 |
|
1998 |
11,148 |
|
1999 |
17,916 |
|
2000 |
13,390 |
|
2001 |
16,146 |
|
2002 |
18,456 |
|
2003 |
12,570 |
|
2004 |
16,243 |
|
2005 |
15,628 |
|
2006 |
18,063 |
|
2007 |
7,122 |
|
2008 |
6,649 |
|
2009 |
9,217 |
|
2010 |
6,235 |
|
2011 |
16,542 |
|
2012 |
12,459 |
|
2013 |
9,322 |
|
2014 |
8,704 |
|
2015 |
9,904 |
SCATTERPLOT WITH TREND LINE
The y axis show the number of tires purchased while the x axis shows the year of purchase.
The graph shows the numbers of tire purchased in a given year. The trend line shows the linear model that relates the year and the number of tires purchased. The equation of the trend line is:
y=-442.2x+899919. X is the year and y is the tires purchased. For example, in the year 1995, x=1995
The value of R2 shows the proportion of the variability in tires purchased that can be explained by the year of the purchase. In this case, R2= 0.3593.
Prediction for the number of tires purchased in 2018 based on the model above:
y=-442.2(2018) +899919
= 7559.4 tires or 7559 tires. Since the value of R2= 0.3593, I am a little confident that this will be the actual data because of the low value of R2.
2. PIE CHART
The pie chart above shows the figures of tires purchases and their associated percentages. It helps to visualize the data. It is generated from Excel.
3. COLUMN CHART
The y axis shows the tires purchased while the x axis shows the year starting from 1.
The visual above shows the relationship between tires purchased from year 1(or 1996) to year 20(or 2015). It clearly shows that there were more tires purchased in the first years compared to the last years.
4. We use the AVERAGE function in Excel to calculate the mean of the data.
From Excel, the mean of the tires purchased was 13084.
The mean of the wheels purchased was 12678
The mean of the lugnuts purchased was 9417.
Tires Purchased 20478 15478 11148 17916 13390 16146 18456 12570 16243 15628 18063 7122 6649 9217 6235 16542 12459 9322 8704 9904
Tires Purchased
1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 20478 15478 11148 17916 13390 16146 18 456 12570 16243 15628 18063 7122 6649 9217 6235 16542 12459 9322 8704 9904
Pie chart of tires purchased
20478 15478 11148 17916 13390 16146 18456 12570 16243 15628 18063 7122 6649 9217 6235 16542 12459 9322 8704 9904
