Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

just to clarify, when identifying the x and y variant, is the independent variable for this R_IV2 (is this Y) and the dependent variable R_DV

just to clarify, when identifying the x and y variant, is the independent variable for this R_IV2 (is this Y) and the dependent variable R_DV (the X)?

image text in transcribed
Excel Edit View Insert Format Tools Data Window Help Q Sat Dec 10 7:47 PM AutoSave OFF AH ? CED ... Book3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments 8. Queries & Connections 24 72 Y Clear Group v Analysis Tools Properties Reapply 2B Ungroup v Get Data (Power Data from Refresh Stocks Currencies Sort Filter Text to What-If Query) Picture All Edit Links Geography ZL Advanced Data Analysis Columns Analysis Subtotal AA35 X V fx D N Q AA AB AC AD AE V2 DV ID R_IV1 R_IV2 R_DV SUMMARY OUTPUT 70 11 880 8.04545455 770 INDEPENDENT VARIABLE R_IV2 78 858 8.45454545 858 Regression Statistics DEPENDENT VARIABLE R_ 53 880 7.2727272 583 Multiple R 0.32463772 74.62 65.25 8.27272727 820.875 Square 0.10538965 83.5 858 7.54545455 918.5 Adjusted R Square 0.10006459 98 990 8.52272727 1078 Standard Error 1.07121915 26 1034 7.45454545 286 Observations 170 62 781 8.36363636 R_DV Line Fit Plot 55 957 505 ANOVA 913 8.18181818 363 SS MS Significance F 95 1001 8.36363636 1045 Regression 22.71067151 22.7106715 19.7912542 1.56671E-05 105 023 8.72727273 1155 esianal 168 192.7817598 1.14751048 374 6.09090909 610.5 Total 169 215.4924313 957 7.81818182 1056 264 4.54545455 1100 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% R_IV2 968 8.72727273 1078 ntercept .26243546 0.315542169 19.8465881 6.6093E-46 5.63949678 6.88537413 5.63949678 6.88537413 R_IV2 896.5 8.72727273 1023 R DV 0.00168194 0.000378071 4.44873625 1.5667E-05 0.000935557 0.00242832 0.00093556 0.00242832 Predicted R_IV2 1045 8.54545455 935 572 7.8636363 86.5 770 5.72727273 693 968 8.54545455 1083.5 RESIDUAL OUTPUT 1067 8.36363636 1045 200 400 600 800 1000 1200 1400 629.75 5.72727273 665.5 Observation redicted R IV. Residuals R_DV 377.25 4.72727273 467.5 7.55752897 0.487925574 792 2 7. 7.70553966 0.749005796 660 8.72727273 682 7.24300626 0.029721012 363.5 7.27272727 797.5 4 7.64309765 0.629629622 973.5 8.22727273 852.5 5 7.80729701 -0.261842461 407 6.18181818 726 6 8.07556638 0.447160895 - BBB BBB BBB BBB BBB B B BBB BBB B B B B B B B B B B B B B B B B B B B B B B B B B B BBBBBBER 1067 7.45454545 473 7 6.74347019 0.711075264 577.5 8.454 49.75 7.40951828 0.954118079 880 8.04545455 770 9 7.28000893 0.719991067 358 8.45454545 858 10 6.87297954 1.308838639 880 7.27272727 583 11 8.02006237 0.343573994 965.25 8.27272727 820.875 12 8.20507573 0.522196998 83.5 858 7.54545455 918.5 7.2892596 -1.19835051 990 8.52272727 1078 14 8.03856371 -0.220381887 034 7.45454545 286 15 8.11256905 -3.567114504 781 8.36363636 682 16 8.07556638 0.65170635 957 605 7.9830597 0.744213029 913 8.18181818 363 18 7.83504901 0.710405535 001 8.36363636 1045 19 7.58528098 0.278355388 968 8.72727273 1155 20 7.42801962 -1.700746893 880 6.09090909 610.5 21 8.08481705 0.4606375 957 7.81818182 1056 22 8.02006237 0.343573994 264 4.54545455 1100 23 7.38176628 -1.654493553 968 8.72727273 1078 24 7.04874223 -2.321469506 96.5 8.72727273 1023 7.59453164 0.041831993 1045 8.54545455 935 26 7.40951828 1.317754443 572 7.86363636 786.5 27 7.60378231 0.331055039 770 5.72727273 693 28 7.69628899 0.530983736 968 8.54545455 1083.5 29 7.48352363 -1.301705446 1067 8.36363636 1045 30 7.0579929 0.396552553 629.75 5.72727273 665.5 7.69166366 0.762881797 877.25 4.72727273 467.5 32 7.55752897 0.487925574 627 7.63636364 792 33 7.70553966 0.749005796 660 8.7272727 682 $4 7.24300626 0.029721012 LILLLCLCL S* 48 797 5 35 7 64309765 0 629629627 A B C D + Ready Accessibility: Investigate - 66%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Economics Foundations of Business Analysis and Strategy

Authors: Christopher Thomas, S. Charles Maurice

11th edition

978-0078021718

Students also viewed these Mathematics questions