--%>

Relationships Between Data Introduction to Linear Regression

Relationships Between Data - Introduction to Linear Regression Simple Regression Notes

If you need guidance in terms of using Excel to run regressions, check pages 1 - 10 of the Excel - Linear Regression Tutorial posted to this folder of BlackBoard.

Do the following problems. Hand in a hard copy of your solutions at the next class session.

1)  Car dealers across North America use the "Red Book" to help them determine the value of used cars that their customers trade in when purchasing new cars. The book, which is published monthly, lists average trade-in values for all basic models of North American, Japanese and European cars. These averages are determined on the basis of the amounts paid at recent used-car auctions. The book indicates alternative values of each car model according to its condition and optional features, but it does not inform dealers how the odometer reading affects the trade in value.

In an experiment to determine whether the odometer reading should be included in the Red Book, an interested buyer of used cars randomly selects ten 3-year-old cars of the same make, condition, and optional features. The trade-in value and mileage for each car are shown in the accompanying table.


 

Odometer Reading

Trade-in Value

Car

(1,000 miles)

($100s)

1

59

37

2

92

31

3

61

43

4

72

39

5

52

41

6

67

39

7

88

37

8

62

40

9

95

29

10

83

33

 

Run the appropriate regression model using Excel with Trade-in Value as the dependent variable (Y) and Odometer Reading as the independent variable (X).  (Note you can copy and paste this table of data into Excel.)

Answer the following questions:

a. According to the regression equation, what's the incremental change in automobile trade-in value for an increase of 1000 miles on the odometer?

b. Can we conclude that the coefficient is significant - that is, different than zero?

c. Predict with 95% confidence the trade-in value of such a car that has been driven 60,000 miles.

d. What percentage of the variation in trade-in value is "explained" by the odometer reading?

2) Consider the Beta Technologies data from last week's assignment. Run a regression using Excel with Annual Salary as the dependent (Y) variable and Beta Experience as the independent (X) variable.  Now run a second regression model with Annual Salary as the dependent (Y) variable and Prior Experience as the independent (X) variable. 

Which model do you think is better for predicting Annual Salary? Provide as much support for your response as possible. How good is the better model?

   Related Questions in Mathematics

  • Q : Properties of a group How can we say

    How can we say that the pair (G, o) is a group. Explain the properties which proof it.

  • Q : The mean of the sampling distribution

    1. Caterer determines that 87% of people who sampled the food thought it was delicious. A random sample of 144 out of population of 5000 taken. The 144 are asked to sample the food. If P-hat is the proportion saying that the food is delicious, what is the mean of the sampling distribution p-hat?<

  • Q : Bolzano-Weierstrass property The

    The Bolzano-Weierstrass property does not hold in C[0, ¶] for the infinite set A ={sinnx:n<N} : A is infinite; Show that has no “ limit points”.

  • Q : Mathematical Method for Engineers The

     The function is clearly undefined at , but despite all of this the function does have a limit as approaches 0. a) Use MATLAB and ezplot to sketch for , and use the zoom on facility to guess the . You need to include you M-file, outp

  • Q : Mathematical and Theoretical Biology

    Mathematical and theoretical biology is an interdisciplinary scientific research field with a range of applications in the fields of biology, biotechnology, and medicine. The field may be referred to as mathematical biology or biomathematics to stress the mathematical

  • Q : Breakfast program if the average is

    if the average is 0.27 and we have $500 how much break fastest will we serve by 2 weeks

  • Q : Pig Game Using the PairOfDice class

    Using the PairOfDice class design and implement a class to play a game called Pig. In this game the user competes against the computer. On each turn the player rolls a pair of dice and adds up his or her points. Whoever reaches 100 points first, wins. If a player rolls a 1, he or she loses all point

  • Q : Problem on mass balance law Using the

    Using the mass balance law approach, write down a set of word equations to model the transport of lead concentration. A) Draw a compartmental model to represent  the diffusion of lead through the lungs and the bloodstream.

  • Q : Problem on Linear equations Anny, Betti

    Anny, Betti and Karol went to their local produce store to bpought some fruit. Anny bought 1 pound of apples and 2 pounds of bananas and paid $2.11.  Betti bought 2 pounds of apples and 1 pound of grapes and paid $4.06.  Karol bought 1 pound of bananas and 2

  • Q : Budgeted cash disbursements The ABC

    The ABC Company, a merchandising firm, has budgeted its action for December according to the following information: • Sales at $560,000, all for cash. • The invoice cost for goods purc