Construct a scatter graph

Assignment Help Microeconomics
Reference no: EM13109911

Kramer Smith Case

Kramer Smith owns a dry-cleaning service and is thinking about changing his advertising expenditures for the year. He hires you as a consultant to determine the relationship between sales, consumer incomes, and advertising by means of multiple regression analysis.

Smith has gathered the sales, income, and advertising data for the last year, as shown in Table 1.

The Sales and Advertising Data (2009)

 Table 1

Month

Advertising ($)

Sales

($)

Consumer Income ($)

January

10,000

43,000

41,000

February

9,000

40,500

43,000

March

11,000

41,000

45,000

April

12,000

45,900

47,000

May

11,000

47,000

49,000

June

12,000

51,000

51,000

July

13,000

54,000

53,000

August

13,000

57,000

55,000

September

14,000

56,000

57,000

October

15,000

60,000

58,000

November

15,800

61,000

59,000

December

16,700

63,000

61,000

Create a report answering the following questions:

  • Construct a scatter graph showing the advertising and sales relationship over the last twelve months.
  • Using multiple regression, conduct an analysis of the firm's sales revenue, consumer incomes, and advertising.
  • Describe how you would explain your results to Smith and what recommendations you would suggest.
  • Summarize your recommendations or advice to Smith concerning the relationship between sales, income, and advertising.

Create your report in a 2- to 3-page Microsoft Word document. ***Please use APA citation of work with references***

Reference no: EM13109911

Questions Cloud

What are the final concentrations of dopa, citrate buffer : 1ml of potato extract, 2ml of 5mM dopa (3,4-dihydroxyphenyalanine), 0.5ml of 20mM citrate buffer, 0.5ml of 1% hydroquinone and 2ml distilled water.
Find sufficient evidence average calorie content : 1- ounce chocolate chip cookies resulted in following calorie amounts. At α=0.01 level, is there sufficient evidence that average calorie content is greater than 110 calories.
Suggest a suitable buffer range for each of the following : Suggest a suitable buffer range for each of the following substances.
Hypothesis test-independent samples : Provide an example and state the Null and the Alternative hypothesis for the example in symbolic form.
Construct a scatter graph : Construct a scatter graph showing the advertising and sales relationship over the last twelve months and using multiple regression, conduct an analysis of the firm's sales revenue, consumer incomes, and advertising.
Hypothesis test-paired samples : Provide an example and state the Null and the Alternative hypothesis for the examples in symbolic form.
Determine the [h+] in this solution : A patient's blood pH was measured upon arrival in the emergency room to be 7.55 at which point they were treated for alkalosis.
Difference between population portions : Two teams of workers assemble automobile engines at a manufacturing plant. Quality control personnel inspect a random sample of the teams assemblies and judge each assembly to be acceptable or unacceptable.
Describe some of the physiological changes that happen : Describe some of the physiological changes that happen to the cell membranes of a rainbow trout as it acclimatizes to cold, water at 4 degrees Celsius, after living at 16 degrees Celsius for a long time?

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

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