Determining linear and nonlinear models

Assignment Help Accounting Basics
Reference no: EM13115740

A toy company has been marketing souvenir toys in conjunction with various professional sports teams in a number of cities. Over the past few years, this experience has provided some data on the effect of advertising on sales revenues because the advertising expenditures have tended to be different in each case. Although the lengths of advertising campaigns vary, the vast majority of the sales occur within the first three months, which is the time period covered in the data. A summary is shown in the table.
__________________

Advertising 18 12 5 4 24 26 15 12 16 10 15 12
($M)

Revenues 105 72 40 44 135 122 88 77 105 67 98 54
__________________

a. Explore the possibility of a linear relation between advertising expenditures and three-month sales revenue. Does there seem to be a strong linear relationship, based on a scatter plot and the correlation?

b. Build a linear model to represent the relation between advertising and revenue. What revenues would the model predict for expenditures of $2 million and $30 million?

c. As an alternative to the linear model in (b), build a nonlinear model using the power function y+ABx. What revenues would the model predict for expenditures of $2 million and $30 million? What are the advantages and disadvantages of a nonlinear model for this relationship?

Please show all work, use excel and identify the value and units measured.

Reference no: EM13115740

Questions Cloud

Illustrate what is the acceleration of the center of mass : Treat the ball as a uniform, solid sphere, ignoring the finger holes. Illustrate what is the acceleration of the center of mass of the ball?
Estimate how long it will take a muscle cell to translate : The mediam molecular weight of eukaryotic proteins is about 40,000 daltons. A few proteins are much larger, such as a muscle cell protein called titin, which has a molecular weight of 3,000,000 daltons.
Budegeting and comparison shopping : You are looking into purchasing computer equipment for your at-home business, personal recruiting. Since you are just starting out, you have set an initial budget of 1500.00
Conduct the test using the level of significance : Suppose that a claim is made that the average billionaire is 60 years old or younger.The following is a random sample of billionaires. Conduct the test using the 0.05 level of significance.
Determining linear and nonlinear models : A toy company has been marketing souvenir toys in conjunction with various professional sports teams in a number of cities. Over the past few years, this experience has provided some data on the effect of advertising on sales revenues because the ..
Do you expect cl- to flow into the cell : A neuron with an intracellular Cl- concentration of 50 mM is placed in a solution that contains 100 mM Cl- at 25 degree celcius. The membrane potential of the neuron is -60 mV.
Data analysis and trends : This is the data table about my city that I live in 1990 and 2000 and difference 1990 2000 Difference-What information from this table do you find to be most interesting? Give 2 to 4 sentences of explanation.
Find probablity mean height for sample is greater : The mean height of women in a country (age 20-29) is 64.3 inches. A random sample of 75 women in this age group is selected. what is the probablity that the mean height for the sample is greater than 65 inches?
Illustrate what is the maximum compression of the spring : then collides with a spring whose spring constant is 250 N/m. angle is 30 degrees. Illustrate what is the maximum compression of the spring?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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