Creating Visuals From Data

profileBookworm05
BusinessScenario-datasets.xlsx

Topic 5 - Business

Business Scenario
Topic 5 Predicting Tires Purchased
Scenario 5 Review the yearly data involving tires purchased at a tire shop with declining business. Predict how many tires will need to be in stock to have available for the customers in 2018.
Year Tires Purchased Wheels Purchased Lugnuts Purchased
1996 20,478 20,018 28,592
1997 15,478 18,274 9,967
1998 11,148 13,086 11,148
1999 17,916 14,659 14,659
2000 13,390 9,697 8,080
2001 16,146 25,698 18,425
2002 18,456 32,237 15,132
2003 12,570 21,404 9,173
2004 16,243 14,993 7,184
2005 15,628 18,346 9,852
2006 18,063 14,193 6,999
2007 7,122 3,052 3,713
2008 6,649 3,740 3,586
2009 9,217 4,748 3,994
2010 6,235 3,662 2,733
2011 16,542 12,426 8,145
2012 12,459 8,743 11,405
2013 9,322 5,243 6,033
2014 8,704 4,687 4,491
2015 9,904 4,661 5,028