Purchase Solution

Sales Forecasting Questions

Not what you're looking for?

Ask Custom Question

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?

Attachments
Purchase this Solution

Solution Summary

The solution discusses the sales forecasting questions and answers.

Solution provided by:
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.