(Answered) Consider the sales pattern shown in the data set

Management Studies

Consider the sales pattern shown in the data set below:

Sales	Year	Time Index
121	2004	0
130	2005	1
145	2006	2
160	2007	3
155	2008	4
179	2009	5
215	2010	6
208	2011	7
235	2012	8
262	2013	9
?	2014	10
?	2015	11

Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015. Note, you can use 'Year' as the explanatory variable or the 'Time Index' as the explanatory variable, but not both in the same equation. In your opinion, is this a good equation for forecasting future sales? Why or why not?

View complete question

Business Management, Management Studies

Category:- Business Management
Reference No.:- M92186293
Price:- $30

Verified Expert

Priced at $60 Now at $30, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Business Management

Puneet is a member of a student project team in her

Puneet is a member of a student project team in her Organizational Behavior class. In order to assess the extent to which her team is cohesive, she should ask which of these questions?

Identify a leader that has used power and influence in a

Identify a leader that has used power and influence in a harmful way. Identify an additional leader who has used power and influence in a positive way. For both of these leaders, state your thoughts on their motives for ...

In class today we were discussing daniel goleman three

In class today we were discussing daniel goleman three motivational competencies self-awareness, self-regulation, and motivation. How could you apply them to personal and organizational issues I dont understand the conce ...

Pick three writings from the module which you consider

Pick three writings from the module which you consider particularly powerful. Ho might these stories have shaped the worldview of the people from the culture?

Stratgeic planningassessment activity cost benefit

STRATGEIC PLANNING ASSESSMENT ACTIVITY: COST BENEFIT ANALYSIS A Sales director is considering whether to implement a new computer based contact management and sales processing system. The Sales directors department has o ...

There is a psychopathic disorder checklist that an

There is a psychopathic disorder checklist that an organization is in accordance with. Explain the approach that a leader can use to change the characteristics within the organization. What kind of framework can be used ...

Why is it important to engage on sustainabilityis it

Why is it important to engage on sustainability? Is it possible for stakeholder relationship to be only one-way? Discuss What is meant by a ladder of stakeholder engagement?

Tactical operational exercises incorporate determination

Tactical operational exercises incorporate determination making in a management model of a business. What aspect are not covered by the tactical operations?

What is the difference between direct supplier and direct

What is the difference between direct supplier and direct seller, and who is Costco direct supplier and direct seller?

Ellen is an anthropologist who has been working at olduvai

Ellen is an anthropologist who has been working at Olduvai Gorge in Tanzania for the past six months. She has been conducting research on the Internet. She finds a Web site with an article that proposes a revolutionary t ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Business Management Expert