Asked Dec 14, 2019

Find the regression equation for the following data set

x 143 167 143 189 175 174 134 155
y  20  80  72  69  44  59  51  63

Expert Answer

Step 1


In order to obtain the least square regression line, first perform regression analysis on the data.

The regression analysis is conducted here by using EXCEL. The software procedure is given below:

  • Enter the data.
  • Select Data > Data Analysis > Regression> OK.
  • Enter Input Y Range as ...

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R 0.330138078 R Square 0.10899115 Adjusted R Square -0.039510325 Standard Error 19.31220998 Observations ANOVA df Significance F MS Regression 273.7312741 273.7312741 0.733939851 0.424498115 Residual 2237.768726 372.9614543 Total 2511.5 Coefficients Standard Error t Stat Lower 95% Upper 95% Lower 95.0% Upper 95.0% P-value 5.234555985 61.09856427 0.085673961 0.934512979 -144.268245 154.737357 -144.268245 154.737357 Intercept 0.325096525 0.379474059 0.856702895 0.424498115 -0.603443047 1.253636097 -0.603443047 1.253636097


Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in




Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: In a certain​ lottery, you must correctly select 6 numbers​ (in any​ order) out of 26 to win. You pu...

A: It is given that there are 26 numbers and of them 6 numbers is selected in any order.The total numbe...


Q: Rocky Mountain National Park is a popular park for outdoor recreation activities in Colorado. Accord...

A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for yo...


Q: Childhood participation in sports, cultural groups, and youth groups appears to be related to improv...

A: Solution:a.From the given information, sample size is 100, population mean is 50, population standar...


Q: For a poisson random variable (x) with a mean of 3.3; p(x>11) =?

A: The value of P (X >11) is obtained below:It is given that in the value of mean is 3.3 that is λ=3...


Q: given matched pairs of "ranked" differences, then sum positive ranks = 75sum negative ranks = 285, n...

A: According to the provided information,


Q: Please answer number 17.

A: The appropriate null and alternative hypotheses are shown below: H0: p1 = p2.Ha: p1 ≠ p2.


Q: 10) A discrete random variable x can assume five possible values: 2, 3, 5, 8, 10. Its probability di...

A: Before calculating the probability corresponding to x=5, the conditions of probability are stated be...


Q: Suppose  N = 20  and  r = 4.  What is the probability of  x = 3  for  n = 15?

A: The probability of X = 3 for n = 15 is obtained below:The probability distribution of the hyper geom...


Q: A population has a mean μ=83 and a standard deviation σ=2424. Find the mean and standard deviation o...

A: Given dataMean μ=83Standard Deviation σ=24Points on sampling distribution of the sample mean:If the ...