Refer Excel Output and answer the following questions.1. Determine whether there is a significant relationship between dependent variable and the two independent variables at the 0.05 level of significance. 2. At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. (use critical value T stat Approach) SUMMARY OUTPUTRegression StatisticsMultiple RR SquareAdjusted R SquareStandard Error0.97X1X23.98ObservationsX3ANOVAdfMSSignificance FRegressionResidualX47248.71X8X100.00X5522.73X9TotalX6X7Upper 95%-0.51CoefficientsStandard Errort StatP-valueLower 95%Intercept-3.921.67-2.340.03-7.32Feet0.030.005X110.00X12X13Large4.220.91X140.00X15X16

The Excel output for regression analysis is given.

Answered: Refer Excel Output and answer the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Refer Excel Output and answer the following questions.
1. Determine whether there is a significant relationship between dependent variable and the two independent variables at the 0.05 level of significance.

2. At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. (use critical value T stat Approach)

SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
0.97
X1
X2
3.98
Observations
X3
ANOVA
df
MS
Significance F
Regression
Residual
X4
7248.71
X8
X10
0.00
X5
522.73
X9
Total
X6
X7
Upper 95%
-0.51
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Intercept
-3.92
1.67
-2.34
0.03
-7.32
Feet
0.03
0.005
X11
0.00
X12
X13
Large
4.22
0.91
X14
0.00
X15
X16

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions