Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. a researcher would like to predict the dependent v

A researcher would like to predict the dependent variable Y from the two independent variables X1...

Free

90.2K

Verified Solution

Question

Statistics

A researcher would like to predict the dependent variable Y fromthe two independent variables X1 and X2 for a sample of N=12subjects. Use multiple linear regression to calculate thecoefficient of multiple determination and test statistics to assessthe significance of the regression model and partial slopes. Use asignificance level α=0.05.

  X1         X2         Y

34.426.459.4
53.738.390.4
72.843.271.3
25.421.264.5
75.946.571.1
60.427.972.6
2856.429.9
40.143.653.7
27.264.561.5
48.26043.8
78.653.653.5
6943.985.5

R2=
F=
P-value for overall model =

t1=
for b1, P-value =
t2=
for b2, P-value =

What is your conclusion for the overall regression model (alsocalled the omnibus test)?

  • The overall regression model is statistically significant atα=0.05
  • The overall regression model is not statistically significantat α=0.05


Which of the regression coefficients are statistically differentfrom zero?

  • neither regression coefficient is statisticallysignificant
  • the slope for the first variable b1 is the only statisticallysignificant coefficient
  • the slope for the second variable b2 is the only statisticallysignificant coefficient
  • both regression coefficients are statistically significant

Answer & Explanation Solved by verified expert
4.0 Ratings (635 Votes)

using excel data analysis tool for regression,steps are:

write data>menu>data>data analysis>regression>enter required labels>ok> and following o/p is obtained

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.645566
R Square 0.416756
Adjusted R Square 0.287146
Standard Error 14.26945
Observations 12
ANOVA
df SS MS F Significance F
Regression 2 1309.446 654.7232 3.215463 0.088375
Residual 9 1832.554 203.6171
Total 11 3142
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 67.90951 17.56506 3.866171 0.003811 28.17459 107.6444 28.17459 107.6444
X1 0.402109 0.214897 1.871172 0.094123 -0.08402 0.888239 -0.08402 0.888239
X2 -0.57943 0.315883 -1.83431 0.099811 -1.294 0.13515 -1.294 0.13515

R2=0.4168
F=3.2155
P-value for overall model =0.0884

t1=1.8712
for b1, P-value =0.0941
t2= -1.8343
for b2, P-value =0.0998

  • The overall regression model is not statistically significant at α=0.05

-------------------------

neither regression coefficient is statistically significant
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Programming
1.2K views

Write a program in Java Design and implement simple matrix manipulation techniques program in java. Project Details: Your program...

Mechanical Engineering
1.2K views

The paper rolls, shown in the figure below, are 0.9 m OD x 0.22 m ID...

Physics
1.2K views

This section O P In an a c circuit the voltage applied is E Eosinot...

Statistics
1.2K views

A research center claims that 28 of adults in a Cain country would travel into...

Statistics
1.2K views

Seth plays in a hockey league His team is called the Broncos Each team in...

Calculus
1.2K views

Please Simplify as instructed.1 + sec(t)/1 + cos(t)Times top and button by 1 - cos(t)Simplify...

Algebra
1.2K views

Suppose that the lengths of human pregnancies are normally distributed with a mean of 266...

Accounting
1.2K views

Using the following information, what is the amount of gross profit?...

Accounting
1.2K views

a. Determine the number of units transferred to the next department. units b. Determine the...

Accounting
1.2K views

The BlueGum Hotel predicted $12,000 in variable labour costs and room revenue of $220,000 from...

Accounting
1.2K views

Indigo Corporation sells a snowboard, EZslide, that is popular with snowboard enthusiasts. Below is information...

Finance
1.2K views

Which of the following best describes the categories of variation that form the basis of...