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. R² =

Perform Data > Data Analysis > Regression

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

Expert Solution

3 & 5. The scatterplot is:

4. a. Intercept =39030

b. Slope =3342.6

c. R² = 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

milcah answered 6 months ago

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)

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.

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

Let x be the age in years of a licensed automobile driver. Let y be the...

Let x be the age in years of a licensed automobile driver. Let y be the percentage of all fatal accidents (for a given age) due to speeding. For example, the first data pair indicates that 37% of all fatal accidents of 17-year-olds are due to speeding. x 17,27,37,47,57,67,77 y 37,25,18,12,10,7,5 Complete parts (a) through (e), given Σx = 329, Σy = 114, Σx2 = 18,263, Σy2 = 2636, Σxy = 3958, and r ≈ −0.948. (a) Draw a scatter...

Question