Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I did the summary output on excel.Can someone help with the questions Automatic Sort Filter Text to What-If Query) Picture Edil Links Advanced Columns Data

I did the summary output on excel.Can someone help with the questions

image text in transcribed
Automatic Sort Filter Text to What-If Query) Picture Edil Links Advanced Columns Data Analyst All Analysis Subtotal Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes P15 + X V fx A B C D E F G H K L M P a R S U SUMMARY OUTPUT Question?? Regression Statistics Select and report the inferential statistical test contextualized in the research question. 4 Multiple R 0.16925002 Provide the alpha value and use it to determine the significance of your test. 5 R Square 0.02864557 Report the results in APA format, including statistic value with degree of freedom, p value, and effect size. Adjusted R Sq 0.02527281 Report the values necessary to interpret the findings and identify the pattern of relationship (for example, slope for regression and means for ANOVA). Standard Erro 17.8122584 8 Observations 290 10 ANOVA 11 SS MS Significance F 12 Regression 1 2694.6986 2694.6986 8.49321705 0.00384435 13 Residual 288 91375.6462 317.276549 14 Total 289 94070.3448 15 16 Coefficients standard Error t Stat P.value Lower 95%% Upper 95% Lower 95.0% Upper 95.0% 17 Intercept 61.855275 2.08875804 29.6134228 2 173E-89 57 744108 65 9664421 57 744108 65.9664421 18 marhomo -2.7092726 0.92964384 -2.9143124 0.00384435 4.5390303 -0.8795149 4 5390303 0.8795149 19 20 21 22 23 24 25 26 27 28 30 31 32 33 34 35 36 37 38

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

Statistics The Exploration & Analysis Of Data

Authors: Roxy Peck, Jay L. Devore

7th Edition

0840058012, 978-0840058010

Students also viewed these Mathematics questions