For each of the data sets, create a scatter plot with the regression line and answer these questions. What is r, r2, Critical Value (CV)? In general, what does r2 mean? What does r2 mean specifically for the data set? What is the regression equation? Is there any positive or negative correlation? Interpret b1. Interpret b0. Forecast the next year.
|
Year |
Cost (Thousands of dollars) |
|
1 |
100 |
|
2 |
99 |
|
3 |
102 |
|
4 |
80 |
|
5 |
90 |
|
6 |
82 |
|
7 |
80 |
|
8 |
76 |
|
9 |
85 |
|
10 |
70 |

| X(year) | Y(cost) | (x-x̅)² | (y-ȳ)² | (x-x̅)(y-ȳ) |
| 1 | 100 | 20.25 | 184.96 | -61.2 |
| 2 | 99 | 12.25 | 158.76 | -44.1 |
| 3 | 102 | 6.25 | 243.36 | -39 |
| 4 | 80 | 2.25 | 40.96 | 9.6 |
| 5 | 90 | 0.25 | 12.96 | -1.8 |
| 6 | 82 | 0.25 | 19.36 | -2.2 |
| 7 | 80 | 2.25 | 40.96 | -9.6 |
| 8 | 76 | 6.25 | 108.16 | -26 |
| 9 | 85 | 12.25 | 1.96 | -4.9 |
| 10 | 70 | 20.25 | 268.96 | -73.8 |
| ΣX | ΣY | Σ(x-x̅)² | Σ(y-ȳ)² | Σ(x-x̅)(y-ȳ) | |
| total sum | 55 | 864 | 82.5 | 1080.4 | -253 |
| mean | 5.5 | 86.4 | SSxx | SSyy | SSxy |
sample size , n = 10
here, x̅ = 5.5 ȳ
= 86.4
SSxx = Σ(x-x̅)² = 82.5
SSxy= Σ(x-x̅)(y-ȳ) = -253
slope , ß1 = SSxy/SSxx =
-3.066666667
intercept, ß0 = y̅-ß1* x̄ =
103.2666667
so, regression line is Ŷ =
103.2667 + -3.0667 *x
SSE= (Sx*Sy - S²xy)/Sx =
304.53
std error ,Se = √(SSE/(n-2)) =
6.1698
correlation coefficient , r = Sxy/√(Sx.Sy)
= -0.8474
R² = (Sxy)²/(Sx.Sy) = 0.7181
---------------------------
r = correlation = -0.8474
R² = coefficient of determination = 0.7181
in general, R² represents how much percentage of variation in observation of y is explained by variable X
--------------------------------
What does r2 mean specifically for the data set here,
Here,71.81 % variation in observations of cost is explained by variable year
-----------------------------
What is the regression equation?
from above calculations
regression eqn is
Ŷ = 103.2667 -3.0667 *x
-------------------------------------
Is there any positive or negative correlation
since, the value of r is negative,so correlation is negative
--------------------------
Interpret b1. Interpret b0.
b1--> for 1 unit increase in Year,the cost will get decrease by 3.0667(thousand of dollars)
bo--> when year=0,then cost will be 103.2667(thousand of dollars)
-----------------------
Forecast the next year
Ŷ = 103.2667 -3.0667 *x
for x=11
Ŷ = 103.2667 -3.0667 *11 = 69.533 (thousand of dollars)
For each of the data sets, create a scatter plot with the regression line and answer...
For each of the data sets, create a scatter plot with the regression line and answer these questions. What is r, r2, Critical Value (CV)? In general, what does r2 mean? What does r2 mean specifically for the data set? What is the regression equation? Is there any positive or negative correlation? Interpret b1. Interpret b0. Forecast the next year. Year Revenue ($) 1 1002 2 1108 3 967 4 1054 5 1206 6 1400
For each of the data sets, create a scatter plot with the regression line and answer these questions What is r, r^2, Critical Value (CV)? In general, what does r^2 mean? What does r^2 mean specifically for the data set? What is the regression equation? Is there any positive or negative correlation? Interpret b1. Interpret b0. Forecast the next year. Model your answers off the Excel file of the solutions found under Content, 3B
13. You are given the following regression equation for a scatter plot which The displays data for x = Weight of Car (in pounds) and y = Miles per Gallon in City: y = −0.006x + 42.825 r2 = 0.7496 (Note: The scatter plot graph is attached to the Canvas assignment as a separate document.) (a) Find the value of r based on the information given. (b) Based on your value of r, what conclusion can you make about the...
You are given the following regression equation for a scatter plot which The displays data for X= weight of car (in pounds) and y= Miles per gallon in City: Equation: y=-0.006x + 42.825 and r2= 0.7496. a. find the value of r2 based on the information given. b. Based on your value of r, what conclusion can you make about the correlation of this data? c. What does the value of r2 tell you about the regression? d. Use the...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (Each pair of variables has a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The caloric content and the sodium content (in milligrams) for 6 beef hot dogs are shown in the table below. (a)x=180 (b)x=90 (c)x=120 (d)x=50 Calories, x Sodium, y 150 ...
You generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the r2 value. The regression equation is reported as y 63.79x 13.96 and the r2 = 0.4356. What is the correlation coefficient for this data set?
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 vaiables 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 number of hours 6 students spent for a test and their scores on that test are shown below (a) x 2 hours (c)x-15 hours (b) x =...
Below are four bivariate data sets and the scatter plot for each. (Note that each scatter plot is displayed on the same scale.) Each data set is made up of sample values drawn from a population. y 1.0 7.4 2.0 9.0 3.0 7.0 11 10- 11 102 9 8+ 7+ 8+ 71 61 5 5 41 4.0 5.4 5.0 7.5 6.05.2 7.0 4.5 8.0 7.1 9.0 5.5 10.0 3.9 V 1.0 8.0 2.0 6.9 3.07.3 4.0 6.1 5.0 7.4 6.0...
You are given the following regression equation for a scatter plot which The displays data Weight of Car (in pounds) and y = Miles per Gallon in City: for x = y = -0.006.0 + 42.825 p2 = 0.7496 (Note: The scatter plot graph is attached to the Canvas assignment as a separate document.) (a) Find the value of r based on the information given. (b) Based on your value of r, what conclusion can you make about the correlation...
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 significa 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, x 758 621 518 510 492 483 (a)...