scatter plots

posted by .

in 1994, the profit is $250,000
in 1995, the profit is $280,000
in 1996, the profit is $240,000
in 1997, the profit is $320,000
in 1998, the profit is $310,000

this information is in a chart but charts don't work here so anyways
[it looks something like this:

Year: 1994 1995
Profit: $250,000 $280,000

etc]

so I have to make a scatter plot of the data, which is pretty easy and answer a few questions.. here are the questions that I didn't get:

1. Write a linear model for the amount of profit.
2. Write a linear model to estimate the profit in 2002.

please show/explain how to do these. thnk u

  • scatter plots -

    OK, so you've plotted your points.

    The linear model assumption is that a straight line will go through them. It won't, of course, because they're not perfectly in a line, but the idea is to create a line that comes as close as possible to them, usually with the idea of predicting future numbers from it.

    Having plotted your points, you can see that a straight line directly between the first point and the last is not a fit, but it is something like a fit. 1996 messes it up, but the other years aren't too far off. That, then, is one possible linear model. There are others, but this one is simple, so let's follow it for a minute.

    We are essentially creating a standard straight line y = mx + c (or Profit = m * Year + c in this case) from the points (1994, 250000) and (1998, 310000). Or, what might make a little more sense, depending, subtract 1994 from the year before starting, so that you're plotting (0, 250000) through (4, 310000). Any of these would be a linear model. Wikipedia has more than you'll ever want to know about this on its Linear_regression page.

    Anyway, as one possible approach, let's model (0, 250000) through (4, 310000).

    We want y=mx+c

    y = (60000/4)x + 250000

    Translating it into your graph, we get:

    P = 15000(Y-1994) + 250000

    which gves us, as we expect, 250000 in 1994 and 310000 in 1998. You can calculate the predicted P for the points inbetween to see that it is sane for the other years, and you should see that those numbers are where the straight line would pass through on your graph.

    This is not the best fit line for this graph, and in general, joining up the start and end points probably won't be the best fit, but it's a first estimate, and I figure if your course required one of the specific methods for linear regression, they'd have said so.

    Now, for number 2, I think the question must intend: "Use your linear model to
    estimate the profit in 2002."

    So we have, in Y = 2002,

    P = 15000(Y-1994) + 250000

    P = 15000(2002-1994) + 250000

    P = 120000 + 250000 = 370000.

    I'm conscious, writing this, that it's a very simplistic answer. If you need more depth - and boy, there's a lot of material on linear regression! - do ask again.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Microeconomics

    I am trying to calculate profit. If I am given the total revenue of $21,000,000. There are not fixed or variable costs. There is a constant marginal cost of $1,000.00. Would my profit still be the total revnue of $21,000,000?
  2. fin. am I correct?

    13. Healthy Foods, Inc. sells 50-pound bags of grapes to the military for $10 a bag. The fixed costs of this operation are $80,000, while the variable costs of the Grapes are $.10 per pound. a. What is the break-even point in bags?
  3. are these correct

    b. Calculate the profit or loss on 12,000 bags and on 25,000 bags. 12,000 x $10 = 120,000 80,000 + .10 x 50lbs x 12,000 = 80,000 + 60,000 = 140,000 120,000 – 140,000 = -20,000 loss 25,000 x $10 = 250,000 80,000 + .10 x 50lb x 25000 …
  4. i needhelp with e and i want to know if i am right

    13. Healthy Foods, Inc. sells 50-pound bags of grapes to the military for $10 a bag. The fixed costs of this operation are $80,000, while the variable costs of the Grapes are $.10 per pound. a. What is the break-even point in bags?
  5. maths

    in 1994, the profit is $250,000 in 1995, the profit is $280,000 in 1996, the profit is $240,000 in 1997, the profit is $320,000 in 1998, the profit is $310,000 this information is in a chart but charts don't work here so anyways [it …
  6. Statistics

    Car P(Sale) % Sold Per Sale/ Profit Per Sale VW Golf 10% 15% $1,000 Saab 10% 15% $2,000 BWM Z4 10% 20% $12,000 Skoda Octavia10% 10% $1,200 Lada Niva10% 40% $400 Sum 100% 2.1 What is the expected profit for a VW Golf?
  7. Finance

    A company is considering a plan that has different profit results under different conditions. Assuming there is a 20% chance of a boom and 10% chance of a recession, compute the expected value of their plan. Condition Result Boom $2,000,000 …
  8. finite!!!

    A manufacturing company wants to maximize profits on products A,B, and C. The profit margin is $3 for A, $6 for B, and $15 C. The production requirements and departmental capacities are as follows: DEPARTMENT Prod. Requirements Dept. …
  9. Finance

    Item Total assets $10,000,000 Total equity (all common) 9,000,000 Total debt 1,000,000 Annual interest 100,000 Total sales $25,000,000 EBIT 6,250,000 Earnings available for common stockholders 3,690,000 I am trying to find the values …
  10. Finance

    Item Total assets $10,000,000 Total equity (all common) 9,000,000 Total debt 1,000,000 Annual interest 100,000 Total sales $25,000,000 EBIT 6,250,000 Earnings available for common stockholders 3,690,000 I am trying to find the values …

More Similar Questions