Question

Consider the data set: x y 1 -2.8948 2 5.806411 3 11.0518 4 5.486057 5 8.625354...

Consider the data set:

x y
1 -2.8948
2 5.806411
3 11.0518
4 5.486057
5 8.625354
6 12.95243
7 18.10561
8 21.45488
9 33.39081
10 36.66942
11 38.03181
12 43.02581
13 44.28387
14 50.17743

1.Using Excel or another tool calculate linear regression analysis of the set. What is the slope>

2.Using the result from previous question, report R2 . Use two decimals.

3.Predict the value of y when x = 28. Use one decimal.

Homework Answers

Answer #1

​​​​​​​

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given are five observations for two variables, x and y. X: 1 2 3 4 5...
Given are five observations for two variables, x and y. X: 1 2 3 4 5 Y: 4 5 5 11 13 a. Try to approximate the relationship between x and y by drawing a straight line through the data. b. Develop the estimated regression equation by computing the values of b0 and b1 (to 1 decimals). y= _____ + ______x c. Use the estimated regression equation to predict the value of y when x=4 (to 1 decimals). y=_____
Data Set: x y 0 4 2 2 2 0 5 -2 6 1 1. Find...
Data Set: x y 0 4 2 2 2 0 5 -2 6 1 1. Find intercept b0 2. Find slope B1 3. Find the best fitted linear regression equation 4.Graph observations 5.Graph the linear equation on the same plot 6. Find the coefficient of Determination r² 7. Find the linear correlation coefficient r 8.Interpret r (the correlation between x & y)
Given are five observations for two variables, x and y. xi 1 2 3 4 5...
Given are five observations for two variables, x and y. xi 1 2 3 4 5 yi 2 8 6 11 13 a) Develop the estimated regression equation by computing the values of b0 and b1 using b1 = Σ(xi − x)(yi − y) Σ(xi − x)2 and b0 = y − b1x. ŷ =? b) Use the estimated regression equation to predict the value of y when x = 2.
Given are five observations for two variables, x and y. xi 1 2 3 4 5...
Given are five observations for two variables, x and y. xi 1 2 3 4 5 yi 4 6 6 11 15 Which of the following scatter diagrams accurately represents the data? 1. 2. 3. What does the scatter diagram indicate about the relationship between the two variables? Develop the estimated regression equation by computing the the slope and the y intercept of the estimated regression line (to 1 decimal). ŷ = + x Use the estimated regression equation to...
Consider the following set of ordered pairs, x   y 2   6 7   11 1   4 4  ...
Consider the following set of ordered pairs, x   y 2   6 7   11 1   4 4   9 3   7 Assuming that the regression equation is y=3.519 + 1.142x and that the SSE= 1.5755, test to determine if the slope is not equal to zero using a=0.05. Test statistic= identify the critical values= and last state the conclusion
Given are five observations for two variables, x and y. xi 1 2 3 4 5...
Given are five observations for two variables, x and y. xi 1 2 3 4 5 yi 4 7 6 11 14 The estimated regression equation is  = 1.2 + 2.4 x. Compute the mean square error using the following equation (to 3 decimals). Compute the standard error of the estimate using the following equation (to 3 decimals). Compute the estimated standard deviation b 1 using the following equation (to 3 decimals). Use the t test to test the following hypotheses...
Use the data set to find the following: X Y 4 1 7 16 3 4...
Use the data set to find the following: X Y 4 1 7 16 3 4 5 7 6 7 a) Compute SSRegression b) Compute MSRegression c) Compute the F ratio for the regression analysis d) Compute the t ratio for the slope e) Compute the t ratio for the intercept
Consider the following time series. t 1 2 3 4 5 yt 5 11 9 14...
Consider the following time series. t 1 2 3 4 5 yt 5 11 9 14 14 Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 =   Slope, b1 =   MSE =   (c) What is the forecast for t = 6? If required, round your answer to one decimal place.
Use the graphing feature and the linear regression tool from the Data Analysis ToolPak in Excel...
Use the graphing feature and the linear regression tool from the Data Analysis ToolPak in Excel to analyze the data found in Alligator mass/length data. After graphing the data, add a trendline and be sure to include R2 and the equation of the line. Length (ft) Weight (lbs) 8.2 280 11.5 314 10.1 296 9.6 408 9.1 267 12.3 467 14.3 580 10.4 318 8.7 351 13.7 560 16.1 582 14.3 572 8.3 235 7.6 208 9.4 347 13.6 543...
Consider the following set of ordered pairs. x 4 1 2 5 y 5 1 3...
Consider the following set of ordered pairs. x 4 1 2 5 y 5 1 3 6 ​ a) Calculate the slope and​ y-intercept for these data. ​ b) Calculate the total sum of squares​ (SST). ​c) Partition the sum of squares into the SSR and SSE.