Question
Asked Nov 27, 2019
4 views
Based on the data shown below, calculate the regression line (each value to two decimal places)
у-
х+
х
у
3
27.55
24.24
4
25.13
6
23.12
22.61
21.9
19.09
16.08
10
11
18.37
12
15.56
13
15.85
11.94
14
15
10.73
11.22
16
9.01
17
18
8.7
LO
help_outline

Image Transcriptionclose

Based on the data shown below, calculate the regression line (each value to two decimal places) у- х+ х у 3 27.55 24.24 4 25.13 6 23.12 22.61 21.9 19.09 16.08 10 11 18.37 12 15.56 13 15.85 11.94 14 15 10.73 11.22 16 9.01 17 18 8.7 LO

fullscreen
check_circle

Expert Answer

Step 1

Regression:

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...
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.984505589
R Square
Adjusted R Square
0.969251255
0.967054916
Standard Error
1.108159671
Observations
16
ANOVA
Significance F
df
SS
F
MS
Regression
541.928125
541.928125 441.3031308
5.51879E-12
Residual
17.19225 1.228017857
14
Total
15
559.120375
Lower 95.0 %
Coefficients Standard Error
P-value
Lower 95%
Upper 95%
Upper 95.0%
tStat
Intercept
30.825
0.68916904 44.72777827 1.64462E-16
29.34687942 32.30312058 29.34687942 32.30312058
X
-1.2625
0.060098396 -21.00721616 5.51879E-12
1.39139824 -1.13360176 -1.39139824
-1.13360176
help_outline

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R 0.984505589 R Square Adjusted R Square 0.969251255 0.967054916 Standard Error 1.108159671 Observations 16 ANOVA Significance F df SS F MS Regression 541.928125 541.928125 441.3031308 5.51879E-12 Residual 17.19225 1.228017857 14 Total 15 559.120375 Lower 95.0 % Coefficients Standard Error P-value Lower 95% Upper 95% Upper 95.0% tStat Intercept 30.825 0.68916904 44.72777827 1.64462E-16 29.34687942 32.30312058 29.34687942 32.30312058 X -1.2625 0.060098396 -21.00721616 5.51879E-12 1.39139824 -1.13360176 -1.39139824 -1.13360176

fullscreen

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

Math

Statistics

Other

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: The amount of syrup that people put on their pancakes is normally distributed with mean 61 mL and st...

A: Let X is the amount of people put the amount of syrup on their pancakes and it follows normal distri...

question_answer

Q: In a survey of women in a certain country (ages 20-29), the mean height was 65.6 inches with a stand...

A: (b)The first quartile is euql to 25th percentail.The height represents the first quartile is 63.66, ...

question_answer

Q: Mon 6.42 PM Safari File Edit View History Bookmarks Window Help www-awn.connectmath.com KY Find the ...

A: The provided probability for a z-score is 0.6988. It is clear from the provided graph that the provi...

question_answer

Q: LTE ll 94% cricket 11:07 AM Chapter 7: Central Limit The ... X Each sweat shop worker at a computer ...

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If y...

question_answer

Q: If as between = 30, ss within = 40, df between= 3, and df within=20, then f=

A: Given data SSbetween = 30, SSwithin = 40, dfbetween= 3, and dfwithin=20The “MS” or mean of squares i...

question_answer

Q: If a random variable X has the normal distribution with mean μ = 80.0 and standard deviation σ = 4.8...

A: Given, random variable ‘X’ has normally distributed with mean 80.0 and standard deviation 4.8.(i)The...

question_answer

Q: A study using two random samples found that the mean amount of time spent per week on leisure activi...

A: Given information:Significance level = 0.05

question_answer

Q: Use the general equation for the least square regression line to show that this line always passes t...

A: The linear regression equation always passes through (x, y)y =a + bxLet there be two variables: x &a...

question_answer

Q: Ages Number of students 15-18 9 19-22 8 23-26 10 27-30 10 31-34 6 35-38 9 Based on th...

A: Given data and calculation of Relative Frequency