Estimate model using regression analysis

Assignment Help Basic Statistics
Reference no: EM131406692

1. You have been provided with data for Sales and Advertising. Assume there are no outliers in the data.

Estimate this model using regression analysis...

Sales = β0 + β1*advertising + β2*advertising 2

a. State the hypothesis that tests if a non-linear relationship exists betweenSales and Advertising.

b. Based on your regression analysis what is your conclusion? Give reason.

c. What is the marginal impact of advertising on sales if advertising is increasedfrom $1500 to $1600?

d. What is the marginal impact on sales if advertising isincreased from $2400 to $2500? Please comment on any differences

e. Is there a lead/lag relationship between Advertising and Sales? That is, estimatethis model ...

Salest = β0+ β1*advertising t+ β2*advertising t23 *advertisingt-1

f. What is your conclusion? Give reason.

Attachment:- Data.rar

Verified Expert

The given word file contains the basic worked out solutions for a problem on non-linear regression equation and lag relation. Here, I have also worked out the various questions related to hypothesis testing.

Reference no: EM131406692

Questions Cloud

Describe the function of the mechatronic system : Describe the function of the mechatronic system and its significance to society. How does the mechatronic system improve upon the previous state of the art
Implications of using a smartphone for work : Consider the implications of using a smartphone for work. What are some of the advantages and disadvantages? Is it ethical for employees to be contacted outside of work hours? Defend your answers.
Urgent need for risk management plan assignment : You are an information technology (IT) intern working for Health Network, Inc. (Health Network), a fictitious health services organization headquartered in Minneapolis, Minnesota. Health Network has over 600 employees throughout the organization a..
Explain some of the companys response strategies : Identify multiple business pressures on Xerox. Describe some of the company's response strategies. Identify the role of IT as a contributor to the business technology pressures (for example, obsolescence).
Estimate model using regression analysis : Estimate model using regression analysis and State the hypothesis that tests if a non-linear relationship exists betweenSales and Advertising
Suppose you were a system librarian : 1. Suppose you were a system librarian. Using entity relationship diagramming notation, describe the database you would need to keep track of the information necessary in your job. Consider operational, managerial, and planning aspects of the job.
Case analysis - Hana financial analyst or pineapple grower : ECON802: The Economics of Global Business Challenges Assessment Authentic tasks - Case study analysis report. CASE STUDY ANALYSIS - Hana: Financial Analyst or Pineapple Grower? You have to write a Business Report where you address the following issue..
Benefits of using enterprise systems : What are some collaboration tools that are available for people to work together? How can businesses collaborate with their customers and/or with other businesses? What are some of the benefits of using enterprise systems (ERP systems)?
Explain the role of an operations director : Explain the role of an operations director and how this role impacts a company. Identify the key facts in this scenario. Based on the facts, describe your assumptions about the situation.

Reviews

inf1406692

3/8/2017 3:55:07 AM

I have one additional question to get insight too and two questions I have answered that I would like you to review for accuracy. Thank you for the response. I am working all night my time here as well. I did not know what to list under price as I am not sure the the going rates etc. the problems are meant to be done via excel using regressions etc. Appreciate the effort! Looking forward to next steps, quote, etc. I need the calculation in the excel spreadhsheet please. 21374398_12 2Question 2 Data.xlsx Oh thank you very much.

len1406692

2/27/2017 5:09:15 AM

I need direction as to how to begin the problem as I have missed a day of class and know how do to this with the regression in excel but am at at loss to what the solution is, how far I should go.

Write a Review

Basic Statistics Questions & Answers

  Determining proportion of sample means

What proportion of sample means would be between 1.31 and 1.33 inches?

  What is their speed after the collision

A 0.250 kg ball of Plasticine moving 5.0 m/s overtakes and collides with a 0.3000 kg ball of Plasticine, traveling in the same directiion at 2.0 m/s. The 2 balls of Plasticine stick together pm collison. What is their speed after the collision.

  How many packages be sampled to be confident population

How many packages should be sampled in order to be 90% confident of being within 0.9% of the actual population percentage of packages delivered damaged.

  Construct a sample space using a tree diagram

Construct a sample space using a tree diagram - Which of the following three sets of probabilities are inappropriate because they violate a basic rule of probability

  What is the t-test statistic

What is the t-test statistic? Top Shelf Sales Volume 23 35 50 68 32 Bottom Shelf Sales Volume 55 70 72 51 63

  Calculate the correlation between the two variables

problem one the manager of a catering company is using the number of people in the party to predict the cost of the

  Mean and standard deviation of distribution

It is very difficult for small businesses to be successful. The Small business administration estimates that 20 percent will dissolve or go bankrupt within two years. A sample of 50 new businesses is selected. (show work) (a) What is the mean and ..

  Toss a fair die twice and record the numbers find the

toss a fair die twice and record the numbers. find the probability that the first number is 3 given that the sum of two

  Impact of campaign film on attitude toward political person

The impact of campaign film on attitudes toward a political candidate was investigated. Prior to showing the film, the attitudes of 15 people toward the candidate were assessed using a political likability scale.

  Find probability that selected thermostat reads greater

A standard deviation of 1.00 degrees C. Find the probability that a randomly selected thermostat reads greater than -0.74 and draw a sketch of the region.

  Suppose two customers are chosen at random from the list of

the utility company in a large metropolitan area finds that 70 of its customers pay a given monthly bill in full.a.

  A recent study focused on the number of times men

At the .01 significance level, is there a difference in the mean number of times men and women order take-out dinners in a month? What is the p-value?

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