Find the equation of the regression line for the given data

Assignment Help Algebra
Reference no: EM131019051

Section 1.1: Correlation

1. Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.

The data for x and y is shown below.

x

-5

-3

4

1

-1

-2

0

2

3

-4

y

11

6

-6

-1

3

4

1

-4

-5

8

a: Scatter plot

b: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation)

c: Complete the table and find the correlation coefficient r rounded to 4 decimals.

x

y

xy

x2

y2

-5

11

 

 

 

-3

6

 

 

 

4

-6

 

 

 

1

-1

 

 

 

-1

3

 

 

 

-2

4

 

 

 

0

1

 

 

 

2

-4

 

 

 

3

-5

 

 

 

-4

8

 

 

 

Use the last row of the table to show the column totals.

n = 10

r = {n∑xy - (∑x)( ∑y)} / {√{n∑x2 - (∑x)2 } {√{n∑y2 - (∑x)2}}

2. Construct a scatter plot and include the regression line on the graph using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r. (References: example 1 - 4 pages 498 - 500; end of section exercises 15 - 22 pages 508 - 509)  

A manager wishes to determine the relationship between the numbers of miles (in hundreds of miles) the manager's sales representative's travel per month and the amount of sales (in thousands of dollars) per month.

Miles traveled, x

2

3

10

7

8

15

3

1

11

Sales, y

31

33

78

62

65

61

48

55

90

a: Scatter plot with regression line

b: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation).

c: Complete the table and find the correlation coefficient r rounded to 4 decimals.

x

y

xy

x2

y2

2

31

 

 

 

3

33

 

 

 

10

78

 

 

 

7

62

 

 

 

8

65

 

 

 

15

61

 

 

 

3

48

 

 

 

1

55

 

 

 

11

90

 

 

 

Use the last row of the table to show the column totals.

n = 9

r = {n∑xy - (∑x)( ∑y)} / [√{n∑x2 - (∑x)2 } {√{n∑y2 - (∑x)2}]

3. Using the r calculated in problem 2c test the significance of the correlation coefficient using a = 0.01 and the claim rho = 0. Use the 7-steps hypothesis test shown at the end of this project. (References: example 7 page 505; end of section exercises 23 - 28 pages 510 - 511).

1. H0 :  

Ha:

2. a =

3. t = r / √{(1-r2) / (n - 2)} =

4. The critical value(s) t0

5. Rejection region:

6. Decision:

7. Interpretation:

Section 1.2:  Linear Regression

4. A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager's sales representative's travel per month and the amount of sales (in thousands of dollars) per month.

Miles traveled, x

2

3

10

7

8

15

3

1

11

Sales, y

31

33

78

62

65

61

48

55

90

Use the table developed in #2.

a. Find the equation of the regression line for the given data. Round the line values to the nearest two decimal places.  Show your work.

b. Using the equation found in part a, predict the sales when the mileage is 400 (remember the mileage is given in hundreds so convert 400 to hundreds). Round to the nearest thousand.

Unit Projects should be uploaded to the Dropbox for the appropriate Unit.

Projects will be submitted as a Microsoft Word document with a doc file.  All Projects are due by Tuesday at 11:59 PM ET of the assigned Unit.

NOTE: Project problems should not be posted to the Discussion threads. Questions on the project problems should be addressed to the instructor by sending an email or by attending office hours.

Instruction to copy a graph from Excel to a Word document

1. Create the graph in Excel.

2. Put your mouse in the graph area and left click. You will see little black boxes top, bottom, sides and the corners. (If desired, you can resize your graph by dragging these boxes with your mouse.)

3. With the boxes showing, choose EDIT COPY from the top menu.

4. Go to the Word document, place your mouse pointer when you want the graph and choose EDIT PASTE form the top menu.

5. Save your document.

Guidelines -- Hypothesis Testing Steps:

  1. State H0 and Ha.
  2. Specify the level of significance alpha a.

Find the test statistic t = r / √{(1-r2) / (n - 2)}

  1. using the given data.
  2. Find the critical value(s) t0.  Use the method specified in the problem statement.
  3. Define the rejection region using critical value(s)
  4. Make a decision to reject or fail to reject the null hypothesis.
  5. Interpret the decision in the context of the original claim.

Reference no: EM131019051

Questions Cloud

Find the values of r1 and r2 : Suppose we need to design a voltage-divider circuit to provide an output voltage vo = 5V from a 15-V source as shown in Figure. The current taken from the 15-V source is to be 200mA. Find the values of R1 and R2.
They decided to refinance the remaining loan balance : A couple took out a 20-year mortgage for $219,236 at 8.4% compounded monthly. After they have made 10 years of payments (120 payments), they decided to refinance the remaining loan balance for 15 years at 4.8% interest, compounded monthly.
Find the maximum value of rg : The metallic case is connected through the ground wire of a three-terminal power outlet to power-system ground. The resistance of the ground wire is Rg. The resistance of the worker s body is Rw = 500 Ω. Due to faulty insulation in the drill, a cur..
How is the prince an example of humanism : What major religious difference between Latin (Catholic and Protestant) Christianity and Eastern Orthodoxy resulted from their very different political contexts after the 400s?
Find the equation of the regression line for the given data : Find the equation of the regression line for the given data. Round the line values to the nearest two decimal places. Show your work.
Draw a suitable circuit consisting of them voltage source : We have a load resistance of 50Ω that we wish to supply with 5V. A 12.6-V voltage source and resistors of any value needed are available. Draw a suitable circuit consisting of them voltage source, the load, and one additional resistor. Specify the..
Effectiveness of a corrective action measured : What are corrective actions, how does the project manager know that corrective action is needed, how the root causes of corrective actions determined, how is the effectiveness of a corrective action measured
The return on investment at reed was exactly : The return on investment at Reed was exactly the same in Year 1 and Year 2. Average operating assets in Year 1 were:
An integrated paid time-off policy : Discuss the pros and cons of choosing an integrated paid time-off policy instead of multiple specific paid time-off policies-for example, sick leave, vacation, and so forth.  What does your company offer?

Reviews

Write a Review

 

Algebra Questions & Answers

  Solve equation and provide a explanation for your answer

Solve equation and provide a explanation for your answer.

  Why is the quadratic formula useful

There are many other sites that explain the quadratic formula. Find one of your own and share it with the class. Explain its contents.

  Link between exponents and logarithms

What is the relationship between exponents and logarithms? How would one distinguish between the two, using both a graph and a sequence?

  Computing compount interest

The formula A=P(1+r)^2 gives the amount A in dollars that P dollars will grow to in 2 years at interest rate r (where r is given as a decimal), using compound interest. What interest rate will cause $2000 to grow to $2247.20 in 2 years?

  Verify each trigonometric equation by substituting

verify each trigonometric equation by substituting identities to match the right hand side of the equation to the left

  Find the x- and y-intercepts of each given graph

Find the x- and y-intercepts of each graph(write your answers as points). Write the equation of the line through (3, -2) and (-1, 5) (slope-intercept form). Write the equation of the line parallel to 3x - 2y = 4 through (-2, 5).

  Creating quadratic equation

How do you know if a quadratic equation will have one, two, or no solution? What is the role played by the discriminant? How do you find a quadratic equation

  Find the column vectors

Find the column vectors.

  Elimination method for solving the system of equations

Elimination method for solving the system of equations.

  Find the feasible region

Finding the feasible region.

  Apply the echelon method to solve the equation

Apply the echelon method to solve the equation

  A perfect positive linear correlation b large but not

make up a scatter diagram with 10 dots for each of the following situations a perfect positive linear correlation b

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