Shar ple Linear Correlation & regression 11:59 PM EDT Following is a portion of
ID: 3063039 • Letter: S
Question
Shar ple Linear Correlation & regression 11:59 PM EDT Following is a portion of the regression output for an application relating maintenance expense (dollars per month) to usage (hours per week) for a particul computer terminal. Excel File: data14-41.xs NOVA Regression Residual Total 1575.76 49.14 1924.90 Coofficienls Standard ErrerStat Intercept Usage 6 1092 0.8951 9361 149 If your answer is zero, enter" a. Write the estimated regression equation (to 4 decimals) y -6.1092+0.8951x b. Use a t test to determine whiether morthly mainterance expense is relatéd to usage at the :05 level of significance (to 2 decimais, if necessary) 6.0073 value= 0.0003 17 MacBook AirExplanation / Answer
a.
y = 6.1092 + 0.8951x
b. Here
t = 6.1092/0.9361 = 6.5262
p - value will be calculaed with help of dF which is n- 2 = 8 and significance level = 0.05
p- value = TDIST (t > 6.5262 ; 8) = 0.0002
The regression is significant here.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.