Question
2. The following data represents sales for 2005 to 2015: Year Sales 2005 10.000 2006 11.000 2007 12.000 2008 12.500 2009 16.000 2010 18.000 2011
2. The following data represents sales for 2005 to 2015:
Year Sales
2005 10.000
2006 11.000
2007 12.000
2008 12.500
2009 16.000
2010 18.000
2011 25.000
2012 40.000
2013 41.000
2014 43.000
2015 50.000
Based on the data,
(a) Plot the data on a graph.
(b) Draw the secular trend line of best fit using semi-average method.
(c) Predict sales for 2019.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Microsoft Excel For Accounting The First Course
Authors: L Murphy Smith, Katherine Smith
1st Edition
0130085529, 978-0130085528
