Question

In: Statistics and Probability

x y 14 50 10 55 12 54 11 56 10 58 9 59 6 61...

x y
14 50
10 55
12 54
11 56
10 58
9 59
6 61
4 62

1.What is the slope?

2. What is the intercept?

3. Using the prediction of x=11 what are the residuals?

4. The sum of squared residuals is 12.038 calculate the standar deviation of the regression

5. What is the test statistic?

Solutions

Expert Solution

Solution-:

By using R-software:

> x=c(14,10,12,11,10,9,6,4);x
[1] 14 10 12 11 10 9 6 4
> y=c(50,55,54,56,58,59,61,62);y
[1] 50 55 54 56 58 59 61 62
> #(1)and (2)
> fit=lm(y~x);fit

Call:
lm(formula = y ~ x)

Coefficients:
(Intercept) x
67.89 -1.16

> cr=coef(fit);cr
(Intercept) x
67.892361 -1.159722
> mcr=matrix(cr);mcr
[,1]
[1,] 67.892361
[2,] -1.159722
> a=mcr[1,1];a #Intercept
[1] 67.89236
> round(a,2)
[1] 67.89
> b=mcr[2,1];b #slope
[1] -1.159722
> round(b,2)
[1] -1.16
> esty=fitted(fit);esty
1 2 3 4 5 6 7 8
51.65625 56.29514 53.97569 55.13542 56.29514 57.45486 60.93403 63.25347
> #Or
> esty=67.89-1.16*x;esty # Regression equation
[1] 51.65 56.29 53.97 55.13 56.29 57.45 60.93 63.25
> d=y-esty
> d1=d^2
> SSE=sum(d1);SSE #Residual Sum of Square
[1] 12.0384
> round(SSE,3)
[1] 12.038
> #(3) When x=11
> #Residual=Actual Value-Predicted value
> Res=11-55.1357;Res
[1] -44.1357
> #(4) For Standard deviation of regression
> n=8 # (Total observation in data)
> SDreg=sqrt(SSE/(n-2));SDreg
[1] 1.416474
> round(SDreg,2)
[1] 1.42

R-Code:

x=c(14,10,12,11,10,9,6,4);x
y=c(50,55,54,56,58,59,61,62);y
#(1)and (2)
fit=lm(y~x);fit
cr=coef(fit);cr
mcr=matrix(cr);mcr
a=mcr[1,1];a #Intercept
round(a,2)
b=mcr[2,1];b #slope
round(b,2)
esty=fitted(fit);esty
#Or
esty=67.89-1.16*x;esty # Regression equation
d=y-esty
d1=d^2
SSE=sum(d1);SSE #Residual Sum of Square
round(SSE,3)
#(3) When x=11
#Residual=Actual Value-Predicted value
Res=11-55.1357;Res
#(4) For Standard deviation of regression
n=8 # (Total observation in data)
SDreg=sqrt(SSE/(n-2));SDreg
round(SDreg,2)


Related Solutions

48 51 52 52 53 54 54 54 55 56 58 58 59 61 63 65...
48 51 52 52 53 54 54 54 55 56 58 58 59 61 63 65 65 67 69 70 73 75 75 76 77 77 79 80 81 82 82          Find the 76th percentile Find the 43rd percentile Find the 20th percentile Find the 76th percentile
0, 3, 11, 24, 36, 47, 42, 53, 56, 59, 52, 58, 50, 64, 63, 61,...
0, 3, 11, 24, 36, 47, 42, 53, 56, 59, 52, 58, 50, 64, 63, 61, 65, 78, 89, 91 A. Calculate the mean, median, and mode. B. Which measure, mean or median, best describes the central tendency of this data? Why?
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 58 (7) 64 (8) 61 (9) 71 (10) 66 (11) 69 (12) 77
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 58 (7) 64 (8) 61 (9) 71 (10) 66 (11) 69 (12) 77
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 58 (9) 67 (10) 66 (11) 70 (12) 76
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. Data The actual values for 12 periods (shown in order) are: (1) 45  (2) 52 (3) 48 (4) 59  (5) 55  (6) 54  (7)...
Given the following data: x 2 8 5 12 9 y 6 11 7 14 10...
Given the following data: x 2 8 5 12 9 y 6 11 7 14 10 a) draw/graph a scatter plot. b) by hand, find the correlation coefficient r. c) by hand, find b0 and b1. d) write the regression equation.
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 59 (9) 72 (10) 66 (11) 67 (12) 78
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 69 (12) 74
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
Given the following grouped frequency distribution Data Frequency 50 - 54 12 55 - 59 23...
Given the following grouped frequency distribution Data Frequency 50 - 54 12 55 - 59 23 60 - 64 11 65 - 69 8 70 - 74 5 75 - 79 7 80 - 84 3 85 - 89 1 90 - 94 1 Find the mean (give you answer to one decimal) = Find the standard deviation (give your answer to two decimals) = What is the shape of this distribution? Your answer will be hand graded.
1.The actual values for 12 periods (shown in order) are:(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 69 (12) 74
  Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT