Question

In: Statistics and Probability

REGRESSION - USING CALCULATOR 1- You are given data for Xi (independent variable) and Yi (dependent...

REGRESSION - USING CALCULATOR

1- You are given data for Xi (independent variable) and Yi (dependent variable).

2- Calculate the correlation coefficient, r:

3- Calculate the coefficient of determination:

4- Calculate the regression coefficient b1 (the slope):

5- Calculate the regression coefficient b0 (the Y-intercept, or constant):

6- The regression equation (a straight line) is:

Problem 2:

A researcher is interested in determining whether there is a relationship between shelf space and number of books sold for her bookstore.

Shelf Space in feet(X)

Books Sold(Y)

7.0

280

3.5

140

4.0

170

4.2

200

4.8

215

3.9

190

4.9

240

7.5

295

3.0

125

5.9

265

5.0

200

Solutions

Expert Solution

Shelf X Books Y   X * Y
7 280 1960 49 78400
3.5 140 490 12.25 19600
4 170 680 16 28900
4.2 200 840 17.64 40000
4.8 215 1032 23.04 46225
3.9 190 741 15.21 36100
4.9 240 1176 24.01 57600
7.5 295 2212.5 56.25 87025
3 125 375 9 15625
5.9 265 1563.5 34.81 70225
5 200 1000 25 40000
Total 53.7 2320 12070 282.21 519700



r = 0.953

Coefficient of Determination

Explained variation = 0.909* 100 = 90.9%
Unexplained variation = 1 - 0.909* 100 = 9.1%

Equation of regression line is

b = ( 11 * 12070 - 53.7 * 2320 ) / ( 11 * 282.21 - ( 53.7 )^{2})

Slope b = 37.105


a =( 2320 - ( 37.1045 * 53.7 ) ) / 11
Intercept a = 29.772

Equation of regression line becomes

To Test :-

H0 :-

H1 :-

  Test Statistic :-


t = 9.4587


Test Criteria :-
Reject null hypothesis if


Result :- Reject null hypothesis


Decision based on P value
P - value = P ( t > 9.4587 ) = 0
Reject null hypothesis if P value < level of significance
P - value = 0 < 0.05 ,hence we reject null hypothesis
Conclusion :- We reject H0

There is statistically linear relationship between variables.


Related Solutions

1. Using any data sets, run two multiple regression equations. state the dependent and independent variable...
1. Using any data sets, run two multiple regression equations. state the dependent and independent variable ( you need to start with at least three and end with at least two) and how you believe they will be related. Run the regression equation until you get to the final model. Then test for the assumptions and interpret the necessary statistics. (use excel Megastat). Please select from any of the data sets. Real Estate Data Price Bedrooms Size Pool Distance Twnship...
Consider the following data to be used in a regression. xi yi 1 0 2 10...
Consider the following data to be used in a regression. xi yi 1 0 2 10 3 25 4 30 5 35 (a) Find the values of b0 and b1. (b) Find the Coefficient of Determination. (c) Find the estimated standard deviation of b1 and the corresponding t-statistic. At the 1% level of significance, can you reject the null hypothesis? Make sure you state the null and alternative hypotheses. (d) Find the F-statistic. Is the equation significant at the 1%...
The following 12 data pairs relate variable xi, the amount of fertilizer, to variable Yi, the...
The following 12 data pairs relate variable xi, the amount of fertilizer, to variable Yi, the amount of wheat harvested: x: 30 30 30 50 50 50 70 70 70 90 90 90 Y: 9 11 14 12 14 23 19 22 31 29 33 35 such that : ∑x = 720 ∑y = 252 , ∑ xy =17240, ∑x2 =49200, ∑y2 = 6228 a) Find equation of linear regression line: Y = A + BX. b) 95% 2 sided...
Given here are the data from a dependent variable and two independent variables. The second independent...
Given here are the data from a dependent variable and two independent variables. The second independent variable is an indicator variable with several categories. Hence, this variable is represented by x2, x3, and x4. How many categories are there for this independent variable? Use a computer to perform a multiple regression analysis on this data to predict y from the x values. Discuss the output and pay particular attention to the dummy variables. y x1 x2 x3 x4 11 1.9...
create a multiple regression using your dependent variable and as many independent variables you can think...
create a multiple regression using your dependent variable and as many independent variables you can think of. discuss the statistical significance of each of your independent variables
Given the research questions below, state the independent and dependent variables (or Variable 1 and Variable...
Given the research questions below, state the independent and dependent variables (or Variable 1 and Variable 2) and level of measurement. Write null and research/alternative hypotheses. Then conduct the appropriate statistical analysis. State tests used, report and interpret key statistics, and explain your findings, including the likelihood you might be committing Type I or II errors given your decision regarding the null hypothesis. Research question is, How and how well age of patients predict how long they take to cure...
Suppose Xi and Yi are all independent (i=1,2,3), where the three Xi are iid and follow...
Suppose Xi and Yi are all independent (i=1,2,3), where the three Xi are iid and follow an Exponential distribution with rate r, while the three Yi are also iid but follow a Normal(μ, σ2) distribution. (a) Write down the joint pdf for the random vector (X1,X2,X3,Y1,Y2,Y3). (b) Find the expected value of the product X1 Y1, i.e., E(X1 Y1), and find Cov(X2, X3).
Suppose Xi and Yi are all independent (i=1,2,3), where the three Xi are iid and follow...
Suppose Xi and Yi are all independent (i=1,2,3), where the three Xi are iid and follow an Exponential distribution with rate r, while the three Yi are also iid but follow a Normal(µ, σ2) distribution. (a) Write down the joint pdf for the random vector (X1,X2,X3,Y1,Y2,Y3). (b) Find the expected value of the product X1 Y1, i.e., E(X1 Y1), and find Cov(X2, X3).
Supplementary Problem 14.27 (Essay) Given here are the data for a dependent variable, y, and independent...
Supplementary Problem 14.27 (Essay) Given here are the data for a dependent variable, y, and independent variables. Use these data to develop a regression model to predict y. Discuss the output. Which variable is an indicator variable? Was it a significant predictor of y? (Set the alpha level of significance at 0.10.) x1 x2 x3 y 0 51 16.4 14 0 48 17.1 17 1 29 18.2 29 0 36 17.9 32 0 40 16.5 54 1 27 17.1 86...
a. If they are going to run a linear regression, identify which variable should be the independent variable and which should be the dependent variable in a regression equation.
In seeking to determine how influential advertising is, the management of a recently established retail chain collected data on sales revenue and advertising expenditure from its' stores over the last ten (10) weeks. The table below shows the data collected: Advertising Expenditure ($ 000) Sales ($ 000) 3 5 76 50 250 700 450 3.5 75 4 150 4.5 7 200 750 7.5 800 8.5 1,100 a. If they are going to run a linear regression, identify which variable should...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT