Build a regression model

Assignment Help Applied Statistics
Reference no: EM131075

ALOMEGA PHARMACEUTICALS

Alomega Pharmaceuticals is a small to mid size pharmaceutical company. The accounting department began extending its historical records by recording the sales volume for each month over the past four years, starting in January.

The company engages in various kinds of direct to consumer advertising and, until recently, has never studied the effect its advertising dollars have on sales, although some data had also been collected. Their hope was that after several months the collected data could be examined to possibly reveal any relationships that would help in future advertising expenditures.

The accounting department besides extending its historical records by recording the sales volume for each month, they also collected advertising dollars for both magazine and TV spots. They also recorded both these values lagged one and two months. This was done because some people on the executive committee thought that sales might lag advertising expenditures rather than respond in the month the ads appeared. It was also believed that sales experienced a seasonal effect and management further wondered about any trend in the sales volume. Finally, it was believed that Alomega's advertising dollars might have an effect on its major competitors' advertising budgets the following month. For each following month it was decided that competitors' advertising could be classified as: (1): little; (2): a moderate amount, or; (3): a great amount.

After a few months of data collection and analysis of past records, the accounting department completed an Excel file using the following variables:
Sales dollars
Magazine advertising dollars
TV advertising dollars
Code 1, 2, or 3 to indicate competitors' advertising efforts the following month.

The data is in the Excel file in the worksheet called data.

1. Evaluate the above model, i.e., is it a good model? If so, why, or if not, why? Consider all the appropriate tests, α = 0.05.

2. Using the model you developed in 1 (of part 2), in your worksheet forecast the next 12 months (in the future).

3. Build a model regression model with only the causal variables, paper advertising, tv advertising, and competitors' advertising (compet).

Below, evaluate the above model, i.e., is it a good model? If so, why, or if not, why? Consider all the appropriate tests, α = 0.05.

4. Compare the models, moving average, exponent smoothing, classical decomposition, regression with time series and regression with causal variables, which one is the best and explain why.

Reference no: EM131075

Questions Cloud

Knowledge and data warehousing : Knowledge and Data Warehousing
Evaluate the range of marginal revenues : Evaluate the range of marginal revenues
Describe the population of interest for the survey : Describe the population of interest for the survey
What is the time response : What is the time response
Build a regression model : Build a regression model
Theoretical analysis and discussion of economic principles : Theoretical analysis and discussion of economic principles
Design a simple econometric research project : Design a simple econometric research project
Write a litrature review : Write a litrature review about: Sustainability movement and green building
Case study on professional ethics : Case Study on professional ethics

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd