# For the data set below(a) Determine the least-squares regression line(b) Graph the least-squares regression line on the scatter diagram3468461116(a) Determine the least-squares regression line) (Round to four decimal places as needed)y =xEnter your answer in the ed it fields and then click Check Answerpart1 remainingeType here to searchX

Question
49 views
check_circle

Step 1

a.

Step-by-step procedure to obtain the least square regression line using Excel Mega stat as follows:

• Choose MegaStat > Correlation/Regression > Regression Analysis.
• Select Input ranges, enter the values of X, Independent variable and enter the values of Y, Dependent variable.
• Check the appropriate options in Options.
• Click OK
Step 2

Output obtained using Excel Mega stat is represented as follows:

Step 3

From the above output, the least square r...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in