Question

Data needs to be analyzed For this assignment I have to analyze the regression (relationship between...

Data needs to be analyzed

For this assignment I have to analyze the regression (relationship between 2 independent variables and 1 dependent variable). Below is all of my data and values. I need help answering the questions that are at the bottom. Questions regarding the strength of the relationship  

Sum of X1 = 184.6

Sum of X2 = 21307.03

Sum of Y = 2569.1

Mean X1 = 3.6196

Mean X2 = 417.7849

Mean Y = 50.3745

Sum of squares (SSX1) = 33.8204

Sum of squares (SSX2) = 14931428.3367

Sum of products (SPX1Y) = 71.8455

Sum of products (SPX2Y) = 54585.5864

Sum of products (SPX1X2) = 1642.7001

Regression Equation = ŷ = b1X1 + b2X2 + a

b1 = ((SPX1Y)*(SSX2)-(SPX1X2)*(SPX2Y)) / ((SSX1)*(SSX2)-(SPX1X2)*(SPX1X2)) = 983088040.09/502288298.2 = 1.95722

b2 = ((SPX2Y)*(SSX1)-(SPX1X2)*(SPX1Y)) / ((SSX1)*(SSX2)-(SPX1X2)*(SPX1X2)) = 1728085.34/502288298.2 = 0.00344

a = MY - b1MX1 - b2MX2 = 50.37 - (1.96*3.62) - (0*417.78) = 41.85279

ŷ = 1.95722X1 + 0.00344X2 + 41.85279

Sum of X1 = 184.6

Sum of X2 = 21307.03

Sum of Y = 2569.1

Mean X1 = 3.6196

Mean X2 = 417.7849

Mean Y = 50.3745

Sum of squares (SSX1) = 33.8204

Sum of squares (SSX2) = 14931428.3367

Sum of products (SPX1Y) = 71.8455

Sum of products (SPX2Y) = 54585.5864

Sum of products (SPX1X2) = 1642.7001

---------

Model: y = 41.8528 + 1.9572 * x1 + 0.0034 * x2

Predictor

Coefficient

Estimate

Standard Error

t-statistic

p-value

Constant

B0

41.8528

4.9857

8.3946

0

x1

B1

1.9572

1.3409

1.4596

0.1509

x2

B2

0.0034

0.002

1.7048

0.0947

R-Squared

R2 = 0.1016

Adjusted R-Squared

R2 adj = 0.0642

Residual Standard Error

7.7775 on 48 degrees of freedom

Overall F-statistic

.7147 on 2 and 48 degrees of freedom

Overall p-value

0.0764

Analysis of Variance Table

Source

df

SS

MS

F-statistic

p-value

Regression

2

328.415

164.2075

2.7147

0.0764

Residual Error

48

2903.4619

60.4888

E=Total

50

3231.8769

64.6375

1. Find the model with the most explanatory power and significant estimates. Describe what your regression output shows regarding the statistical properties of your model.

2. What does this model suggest regarding the relationships between your variables?

3. Do you think your data more or less satisfy OLS regression assumptions? Explain why? Or why not?  

4. Based on 3), do you think your analysis is reliable?

There are 3 variables (2 independent variables and 1 dependent variable). I need help analyzing my data and answering these questions regarding the regression (relationship between all variables). Thank you!

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A manager at a company analyzed the relationship between the weekly record sales and factors affecting...
A manager at a company analyzed the relationship between the weekly record sales and factors affecting its sales with a sample of 200 records. The independent variables included in the regression model are as follows: x1: Advertising budget (thousands of dollars), x2: No. of plays on radio per week, x3: Attractiveness of band, The following ANOVA summarizes the regression results. Table 1: ANOVA Source of Variation df Source of Squares Mean Square F R Squared Regression 861377.418 0.665 Residual or...
A statistical program is recommended. A highway department is studying the relationship between traffic flow and...
A statistical program is recommended. A highway department is studying the relationship between traffic flow and speed. The following model has been hypothesized: y = β0 + β1x + ε where y = traffic flow in vehicles per hour x = vehicle speed in miles per hour. The following data were collected during rush hour for six highways leading out of the city. Traffic Flow (y) Vehicle Speed (x) 1,257 35 1,328 40 1,225 30 1,333 45 1,348 50 1,122...
The ANOVA summary table to the right is for a multiple regression model with six independent...
The ANOVA summary table to the right is for a multiple regression model with six independent variables. Complete parts​ (a) through​ (e). Source: Degrees of Freedom / Sum of Squares Regression 6 90 Error 14 170 Total 20 260 a. Determine the regression mean square​ (MSR) and the mean square error​ (MSE). MSR= ​ (Round to four decimal places as​ needed.) MSE=   (Round to four decimal places as​ needed.) b. Compute the overall F STAT test statistic. (Round to two...
Consider the following data for two variables, x and y. x 22 24 26 30 35...
Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 13 22 34 34 41 35 (a) Develop an estimated regression equation for the data of the form ŷ = b0 + b1x.  (Round b0 to one decimal place and b1 to three decimal places.) ŷ = (b) Use the results from part (a) to test for a significant relationship between x and y. Use α = 0.05 Find the value of the...
A study to determine the relationship between the height of a son and the height of...
A study to determine the relationship between the height of a son and the height of his mother and father used a random sample size of n=65. The resulting multiple regression equation was = 22.97 + .30x1 + .41x2 where y is the height of the son, x1 is the height of the mother, x2 is the height of the father. All measurements are in inches. The standard error for b1 is .06786 and the standard error for b2 is...
A highway department is studying the relationship between traffic flow and speed. The following model has...
A highway department is studying the relationship between traffic flow and speed. The following model has been hypothesized: y = β0 + β1x + ε y = traffic flow in vehicles per hour x = vehicle speed in miles per hour. The following data were collected during rush hour for six highways leading out of the city. Traffic Flow (y) Vehicle Speed (x) 1,257 35 1,331 40 1,227 30 1,336 45 1,349 50 1,125 25 In working further with this...
#8 An article used an estimated regression equation to describe the relationship between y = error...
#8 An article used an estimated regression equation to describe the relationship between y = error percentage for subjects reading a four-digit liquid crystal display and the independent variables x1 = level of backlight, x2 = character subtense, x3 = viewing angle, and x4 = level of ambient light. From a table given in the article, SSRegr = 23.1, SSResid = 24, and n = 30. Calculate the test statistic. (Round your answer to two decimal places.) F = Calculate...
The following show the results of regression: Housing Sold = b0 + b1 permit +b2 price...
The following show the results of regression: Housing Sold = b0 + b1 permit +b2 price + b3 employment Dependent Variable: SOLD ,              Method: Least Squares               Date: 03/15/20   Time: 14:59                            Included observations: 108                              Variable      Coefficient Std. Error t-Statistic    Prob.                C -61520.76   167763.0            -0.366712      0.7146 PERMIT    15.98282                .280962   12.47721     0.0000 PRICE     ...
1.A real estate analyst has developed a multiple regression line, y = 60 + 0.068 x1...
1.A real estate analyst has developed a multiple regression line, y = 60 + 0.068 x1 – 2.5 x2, to predict y = the market price of a home (in $1,000s), using two independent variables, x1 = the total number of square feet of living space, and x2 = the age of the house in years. With this regression model, the predicted price of a 10-year old home with 2,500 square feet of living area is __________. $205.00 $255,000.00 $200,000.00...
Which of the following statements about the regression standard error hold TRUE? (2p) I. The regression...
Which of the following statements about the regression standard error hold TRUE? (2p) I. The regression standard error reflects the variation of the y-values about the regression line. II. The regression standard error is an estimate of the model standard deviation . III. The larger the regression standard error is, the better the model fits the data and the more precise inference about the regression model will be. A) I B) I and II C) II and III D) I,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT