Question: Using the information below, how can I tell if my variables are related or not (correlation)? SUMMARY OUTPUT Regression Statistics Multiple R 0.268609844 R Square

Using the information below, how can I tell if my variables are related or not (correlation)?

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.268609844
R Square 0.072151248
Adjusted R Square 0.041222956
Standard Error 5.465961014
Observations 32
ANOVA
df SS MS F Significance F
Regression 1 69.69810566 69.69811 2.3328559 0.137145018
Residual 30 896.3018943 29.87673
Total 31 966
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 99.0% Upper 99.0%
Intercept 76.42350177 9.755186509 7.834141 9.644E-09 56.50075306 96.34625049 49.59678127 103.2502223
X Variable 1 0.16694157 0.109300094 1.527369 0.137145 -0.056279002 0.390162143 -0.133633214 0.467516355
RESIDUAL OUTPUT
Observation Predicted Y Residuals
1 89.77882741 -10.77882741
2 92.61683411 -5.616834108
3 90.61353526 4.386464737
4 90.61353526 2.386464737
5 92.1160094 -6.116009397
6 92.1160094 3.883990603
7 92.1160094 2.883990603
8 89.11106113 8.888938871
9 86.60693757 -2.606937572
10 92.61683411 4.383165892
11 92.61683411 4.383165892
12 91.11435997 5.885640026
13 92.61683411 7.383165892
14 92.1160094 -3.116009397
15 91.11435997 2.885640026
16 92.61683411 5.383165892
17 92.1160094 5.883990603
18 88.61023642 5.389763583
19 92.1160094 -3.116009397
20 90.11271055 2.887289449
21 89.61188584 -6.61188584
22 92.61683411 -2.616834108
23 93.11765882 -5.117658819
24 91.61518469 -7.615184685
25 92.1160094 0.883990603
26 92.1160094 -6.116009397
27 91.11435997 -7.114359974
28 92.1160094 -4.116009397
29 92.1160094 -0.116009397
30 91.28130154 3.718698456
31 89.61188584 5.38811416
32 89.11106113 -6.111061129

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Lance H. and Wanda B. Dean are married and live at 431 Yucca Drive, Santa Fe, NM 87501. Lance works for the convention bureau of the local Chamber of Commerce, while Wanda is employed part-time as a...

Q:

24. A marketing researcher decides to ask a handful of experts on their expectations for annual rainfall for next year and its impact on the agricultural industry. This is an example of: a. Executive...

Q:

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.0557586537 0.0031090275 -0.0058719723 4.3428216036 225 ANOVA df Regression Residual Total SS...

Q:

Only need the excel section completed. I will do the written report stuff. Model is the format I want it complete in. Thanks Date 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010...

Q:

Suppose a portfolio consists of 50% of stock Do and 50% of stock GDT, calculate the beta of this portfolio (use stock betas estimated from 5 to compute the portfolio's beta (1 point). What is the...

Q:

I need question one answered. Attached are documents from the chapter to help add in the question. A 1 D E F Final Examination FINC 5880 3 5 6 7 8 9 10 11 C Question 6. (15 points) Your portfolio is...

Q:

Problem Solving Questions (Chapter 7: Linear Regression] A realtor wishes to investigate what type of homes would attract residents in the neighborhood. The realtor collected a sample data that...

Q:

Journal Project Part A: Please use the given information to answer the following questions. (Show your work) 1. According to the team marketing report quoted by Dallas Morning News, the average...

Q:

i need this two papers 22 MODULE V: RISK AND RETURN INTRODUCTION To better understand the relationship between return and ris, we must know how return andre med tit. RATE OF RETURN If you buy at your...

Q:

Finish all the charts completely, Answer options for #4: Only F is a reliable estimate, Only V is a reliable estimate, both F and V are reliable estimates, and Neither F and V are reliable estimates....

Q:

Solve the problem without using EXCEL WORSHEET: The detailed calculation must appear in your ANSWER SHEETS. You can use the calculator. Limit your calculation within 3 dismal points Take the printout...

Q:

Two beakers of water, A and B, initially are at the same temperature. The temperature of the water in beaker A is increased 10 Fo, and the temperature of the water in beaker B is increased 10K.After...

Q:

On January 1, 2021, Jack leased a catnip processing factory for a 4-year period ending December 31, 2024, at which time possession of the machine will revert back to Luna. Jack intends to use the...

Q:

1 4 : 3 4 Time Remaining The net present value: method of analysis cannot be applied to mutually exclusive projects. decreases as the required rate of return increases. ignores cash flows that are...

Q:

Superstar Ice Rinks Inc. (SIR) is a privately owned company owned by a group of investors headed by James T. Kirk, a retired professional hockey player. SIR owns three arenas in suburban areas near a...

Q:

The U.S. Department of Energys Fuel Economy Guide provides fuel efficiency data for cars and trucks (Fuel Economy website, February 22, 2008). A portion of the data for 311 compact, midsize, and...

Q:

Cost On January 1, 2016, Baznik Company adopted a defined benefit pension plan. At that time, Baznik awarded retroactive benefits to certain employees. These retroactive benefits resulted in a prior...

Q:

Determination of Pension Plan Amounts Various pension plan information of Kerem Company for 2013 and 2014 is as follows: Required: Fill in the blanks lettered (a) through (k). All the necessary...

Q:

For each of the following economic events, indicate the effect that not recording the necessary adjusting entry associated with the transaction described at year-end would have on the financial...

Q:

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Q:

Direct materials price and efficiency variances, direct materials yield and mix variances, food processing. (50 minutes) Tropica, AB, processes tropical fruit into fruit salad mix, which it sells to...

Q:

Variance analysis of contribution margin, multiple products; working backward. (30 minutes) Rusti-Verres, SNC, sells two brands of wine glassesChoc and Chic. Rusti-Verres provides the following...

Q:

Determine the amount of revenue required to break even or to earn a tar geted profit. LO2