Sales Forecasting Questions
Not what you're looking for?
Will you please help with the following 2 questions? I have attached an example of excel sheet problems but you do not have to use this.
PROBLEM 1)
Please use the following data in MS Excel to answer the below questions
Month Unemployment Rate (%)
1 5.1
2 5.6
3 5.3
4 5.5
5 5.3
6 5.2
7 6.3
a) What is the average unemployment rate? ________
b) What is the median unemployment rate? ________
c) Find the regression line? (y = a + bx) ________¬¬¬¬¬______
PROBLEM 2)
Please use the following data to answer the below questions. Please use MS Excel to help solve these problems
Share of Drugs in X market Efficacy of Drugs
18.3 4
6.7 1
28.3 4
21.7 4
15.0 3
23.3 4
11.7 2
20.0 4
31.7 5
21.7 3
28.3 3
3.3 1
25.0 4
26.7 4
16.7 3
30.0 5
25.0 3
a) What is the median share?
b) Compute the mode for the efficacy.
c) Find the standard deviation (for the population) for the share.
d) What is the correlation of share and efficacy?
Purchase this Solution
Solution Summary
The solution discusses the sales forecasting questions and answers.
Education
- MBA, Indian Institute of Finance
- Bsc, Madras University
Recent Feedback
- "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
- "thank you!"
- "Thank you again Jayant. You are super fast. "
- "Thank you Jayant. You are appreciated. "
- "Again, thank you Jayant. You are wonderful. "
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Introduction to Finance
This quiz test introductory finance topics.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.