Question

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

Answer #1

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

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 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

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 16 minutes ago

asked 17 minutes ago

asked 27 minutes ago

asked 28 minutes ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago