Question

In: Math

Age (X) Time (Y) 34            123,556.00 17              92,425.00 42            250

Age (X) Time (Y)
34            123,556.00
17              92,425.00
42            250,908.00
35            204,540.00
19              77,897.00
43            197,012.00
51            195,126.00
50            177,100.00
22              83,230.00
58            140,012.00
48            265,296.00
35            189,420.00
39            235,872.00
39            230,724.00
59            238,655.00
40            138,560.00
60            259,680.00
22              93,208.00
33              91,212.00
36            153,216.00
28              77,308.00
22              56,496.00
28            106,652.00
44            242,748.00
54            195,858.00
30            178,560.00
28            190,876.00
16              98,528.00
52            169,572.00
22              79,420.00
28            167,928.00
35            215,705.00
50            146,350.00

3. The strength of the correlation motivates further examination.

a. Insert Scatter (X,Y) plot linked to the data on this s heet with Age on the horizontal (X) axis.

b. Add to your chart: the chart name, vertical axis label, and horizontal axis label

c. Complete the chart by adding Trendline and checking boxes: Display Equation on chart & Display R-squared value on chart

4. Read directly from the chart:

a. Intercept =

b. Slope =

c. R2 =

Perform Data > Data Analysis > Regression

5. Highlight the Y-Intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orange.

Solutions

Expert Solution

3 & 5. The scatterplot is:

4. a. Intercept =39030

b. Slope =3342.6

c. R2 = 0.4703

The regression result is:

Regression Statistics
Multiple R 0.685795
R Square 0.470314
Adjusted R Square 0.453228
Standard Error 46057.65
Observations 33
ANOVA
df SS MS F Significance F
Regression 1 5.84E+10 5.84E+10 27.52528 1.06E-05
Residual 31 6.58E+10 2.12E+09
Total 32 1.24E+11
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 39029.92 24863.07 1.569795 0.126615 -11678.6 89738.49 -11678.6 89738.49
Age (X) 3342.627 637.1213 5.246454 1.06E-05 2043.21 4642.045 2043.21 4642.045

Related Solutions

Regression Analysis. Calculate when y hat = 9,500 – 250(x) when age = 10, 15, 20,...
Regression Analysis. Calculate when y hat = 9,500 – 250(x) when age = 10, 15, 20, and 22 with an asking price of $8,000 6,000, 5,000 and 4,200 respectively. 1. Sum of Squared Errors (SSE) 2. Total Sum of Squares (TSS) 3. Sum of Squares of Regression (SSR) 4. The calculated value that represents the explained variation. 5. What is the calculated value that represents the unexplained variation 6. What is the value of the coefficient of determination.
Let x and y be integers such that 17 | (3x +5y). Prove that 17 |...
Let x and y be integers such that 17 | (3x +5y). Prove that 17 | (8x + 19y).
Find x and y so that the ordered data set has a mean of 42 and...
Find x and y so that the ordered data set has a mean of 42 and a median of 35, hence compute the harmonic mean and geometric mean of the data sample.        17, 22, 26, 29, 34, x, 42, 67, 70, y                                                          The lengths, in centimeters, of 18 snakes are given below. Draw an ordered stem-and-leaf diagram for the data.                                                                                                                                     24, 62, 20, 65, 27, 67, 69, 32, 40, 53, 55, 47, 33,...
Consider the following data for two variables, x and y. x 10 34 20 11 24...
Consider the following data for two variables, x and y. x 10 34 20 11 24 y 11 30 22 19 21 a. Develop an estimated regression equation for the data of the form y=b0+b1x. Comment on the adequacy of this equation for predicting . Enter negative value as negative number. The regression equation is Y=___________+___________ (to 2 decimals) s=__________ (to 3 decimals) r2=_________% (to 1 decimal) r2 adj=_______ % (to 1 decimal) Analysis of Variance SOURCE DF SS (to...
y ' ' ' − y ' ' − 17 y ' − 15 y =...
y ' ' ' − y ' ' − 17 y ' − 15 y = 0 y ( 0 ) = − 2 , y ' ( 0 ) = − 14 , y ' ' ( 0 ) = − 82 y(t)= ?
Find dy/dx by implicit differentiation. 11. ycosx=x^2+y^2 13. sqrt(x+y)=x^4+y^4 15. tan(x/y)=x+y 17. sqrt(xy)=1+(x^2)*(y) 19. sin(xy) =...
Find dy/dx by implicit differentiation. 11. ycosx=x^2+y^2 13. sqrt(x+y)=x^4+y^4 15. tan(x/y)=x+y 17. sqrt(xy)=1+(x^2)*(y) 19. sin(xy) = cos(x+y)
AND( OR(OR(X,Y), AND(OR(X,Y), OR(NOT(X), NOT(Y)))), OR(OR(X,Y), AND(OR(X,Y), NAND(X,Y))) ) is equivalent to: A. OR(X,Y) B. AND(X,Y)...
AND( OR(OR(X,Y), AND(OR(X,Y), OR(NOT(X), NOT(Y)))), OR(OR(X,Y), AND(OR(X,Y), NAND(X,Y))) ) is equivalent to: A. OR(X,Y) B. AND(X,Y) C. NOR(X,Y) D. XOR(X,Y) E. NAND(X,Y) F. XNOR(X,Y) How do I simplify this with the Idempotence, De morgan, absorbtion law, etc and waht are the steps to break it down?
Solve the given initial value problem. y'''+2y''-13y'+10y=0 y(0)=4    y'(0)=42 y''(0)= -134 y(x)=
Solve the given initial value problem. y'''+2y''-13y'+10y=0 y(0)=4    y'(0)=42 y''(0)= -134 y(x)=
Using Euclidean algorithm, Find integers x and y with 65537x + 3511y = 17.
Using Euclidean algorithm, Find integers x and y with 65537x + 3511y = 17.
Let X,Y and Z be the following matrices X=[1 10 42 6;5 8 78 23;56 45...
Let X,Y and Z be the following matrices X=[1 10 42 6;5 8 78 23;56 45 9 13;23 22 8 9] Y=[1 2 3;4 10 12;7 21 27] Z=[10 22 5 13] 1. Using single index notation, find the index numbers of the elements in each matrix that contain values of greater than 10. Use MATLAB format
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT