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

  Write a mathematical model representing the total ad cost

Write a mathematical model representing the total ad cost, C, in terms of x. Complete the table using the given values of x and the equation y = -2x + 7.

  The set of all permutations over the group formsunder

The set of all permutations over the group formsunder

  Gve one example to show how you can use expected value

bullprovide one example to show how you can use the expected value computation to assess the fairness of a situation

  Polynomial long division-multiplication

Polynomial long division and multiplication-Use polynomial long division to divide

  Solve the linear model

Select five values for x to plug into the linear function, P(x)=10x-7 and prepare a table of values

  Solution of an absolute value equation

Solution of an absolute value equation

  Find the following conditional probabilities

Find the following conditional probabilities.

  Make the fractions below in terms of the lcm

Make the fractions below in terms of the LCM of the denominators.

  Using truth table for checking the equivalence

Using truth table for checking the equivalence.

  Simplify the expression

Simplify 3(x-2)to the second -2(x+1)

  Determine the value of x

Determine the value of x using the properties of logarithms.

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