Question
In: Statistics and Probability
. Draw a plot of the following set of data and determine the linear regression equation. What is...
. Draw a plot of the following set of data and determine the linear regression equation. What is the
value of the slope and intercept? What is r and R2? Are there any outlier values? (15 points)
Age (X): 20 25 36 29 41 35 56 43 66 50 59 67 51 75 75 81 54 66 52 48
Total Body Water (Y): 61 57 52 59 53 58 48 51 37 44 42 41 48 38 41 39 47 42 51 50
Solutions
orchestra answered 1 year agoRelated Solutions
1.) Sketch a scatter plot from the following data, and determine the equation of the regression...
1.) Sketch a scatter plot from the following data, and determine
the equation of the regression line. x 125 119 103 91 50 29 24
y
2.)Investment analysts generally believe the interest rate on
bonds is inversely related to the prime interest rate for loans;
that is, bonds perform well when lending rates are down and perform
poorly when interest rates are up. Can the bond rate be predicted
by the prime interest rate? Use the following data to construct...
Curve Fitting and Linear Regression a) Determine the linear regression equation for the measured values in...
Curve Fitting and Linear Regression
a) Determine the linear regression equation
for the measured values in the table above.
??
1
2
3
4
Value 1 (????)
0
3
7
10
Value 2 (????)
2
4
9
11
b) Plot the points and the linear
regression curve.
c) Determine the Linear Correlation
Coefficient (i.e., Pearson’s r) for the dataset in the
table above.
Determine the regression equation (write the regression equation) of the following data, where Y is the...
Determine the regression equation (write the regression
equation) of the following data, where Y is the dependant variable
and X is the predictor:
X
Y
5
85
4
103
6
70
5
82
5
89
5
98
6
66
6
95
2
169
7
70
7
48
b) Interpret the regression coefficients.
c) Graph the regression line.
d) Use the regression equation to predict Y for
X=3.
e) Compute the coefficient of
determination.
f) Interpret the coefficient of
determination.
g)...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...
Run a linear regression using Excel’s Data Analysis regression
tool. Construct the linear regression equation and determine the
predicted total sales value if the number of promotions is 6. Is
there a significant relationship? Clearly explain your reasoning
using the regression results.
Number of Promotions
Total Sales
3
2554
2
1746
11
2755
14
1935
15
2461
4
2727
5
2231
14
2791
12
2557
4
1897
2
2022
7
2673
11
2947
11
1573
14
2980
For the attached data set, create a simple linear regression equation defining the relationship between height...
For the attached data set, create a simple linear regression
equation defining the relationship between height and weight.
Use the regression equation to predict the weight for a given
height of 5.75 inches
PLEASE PROVIDE EXCEL STEP CALCULATIONS
Height (in feet) X
Weight (in pounds) Y
4.8228348
115.1032102
4.92126
117.1094144
4.9868768
120.1076976
5.085302
123.1059808
5.1509188
126.104264
5.249344
129.1245934
5.3477692
132.1228766
5.413386
135.1211598
5.5118112
139.1335682
5.577428
142.1318514
5.6758532
146.1222136
5.74147
150.134622
5.8398952
154.1470304
5.905512
159.1515178
6.0039372
164.1560052
Linear regression equation
Linear regression equation also find accuracy Obtain regression equation of Y on X and estimate Y when X=55 from the following
Create a scatter plot. What does it indicate? What is the regression equation? Is the equation...
Create a scatter plot. What does it indicate?
What is the
regression equation?
Is the
equation significant? How do you know?
What is the
estimate for Period 13?
What is the
r2 and what does it signify?
Period
Sales
1
12
2
13
3
12
4
14
5
13
6
15
7
16
8
14
9
17
10
15
11
17
12
18
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data.
Then construct a scatter plot of the data and draw the regression
line. (The pair of variables have a significant correlation.) Then
use the regression equation to predict the value of y for each of
the given x-values, if meaningful. The table below shows the
heights (in feet) and the number of stories of six notable
buildings in a city.
Height : 772, 628, 518, 508, 496, 483,
y:...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data.
Then construct a scatter plot of the data and draw the regression
line. (The pair of variables have a significant correlation.)
Then use the regression equation to predict the value of y for each
of the given x-values, if meaningful. The table below shows the
heights (in feet) and the number of stories of six notable
buildings in a city. Height comma x 762 621 515 508 491 480...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data.
Then construct a scatter plot of the data and draw the regression
line. (The pair of variables have a significant correlation.)
Then use the regression equation to predict the value of y for each
of the given x-values, if meaningful. The table below shows the
heights (in feet) and the number of stories of six notable
buildings in a city.
Height comma xHeight, x
766766
620620
520520
508508
494494...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A random sample of 1600 workers in a particular city found 688 workers who had full...
- Total assets = $500,000, total asset turnover = 1.40, total debt ratio = 0.30, return on...
- How would you feel if people in your adoptive country treated you with disrespect because you...
- How do you think companies decide which type of private debt they will use? Do they...
- On November 1, 2013 John Adams, a customer service representative of Americo Drilling Supplies (ADS), was...
- Which of the following is an element of management's role in empowerment?
- You have just completed two (2) projects in your assessments, Assessment 2 used the PMBOK method,...
ADVERTISEMENT