Question

Regression and Correlation X Y fresh marine 147 444 139 446 160 438 99 437 120...

Regression and Correlation

X Y
fresh marine
147 444
139 446
160 438
99 437
120 405
151 435
115 394
121 406
109 440
119 414
130 444
110 465
127 457
100 498
115 452
117 418
112 502
116 478
98 500
98 589
83 480
85 424
88 455
98 439
74 423
58 411
114 484
88 447
77 448
86 450
86 493
65 495
127 470
91 454
76 430
44 448
42 512
50 417
57 466
42 496

How can I get "a" and "b". How do I do this question by hand using excel.

The equation for line is y=-.2364+478.35. "a" is 478.35 and "b" is -.2364.

I am confused on how to get these answers by just using simple excel commands such as multiplication divison etc etc.

Thanks

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The given data is entered in the Column A and Column B in Excel sheet

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the seasonal influenza vaccine in preventing acute respiratory infection (ARI). A total of 507 subjects from Texas who showed symptoms of ARI were recruited for this study. The data provided show the result of each subject's test for influenza. Click to download the data in your preferred format.    CrunchIt!    CSV    Excel    JMP    Mac-Text    Minitab    PC-Text    R   ...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are interested in purchasing bolts from different suppliers and have obtained and tested samples of 200 bolts from three suppliers: Allnutt, Boltzman, Coachers.You have tested these in your new bolt testing machine, purchased after you had discovered your old bolt testing machine was performing erratically. (For the purposes of this question, you are safe to assume that the new machine works perfectly and that its...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT