# The table below contains the geographic latitudes, x, and average January temperatures, y, of 20 cities. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.xy46233260394033593857403342333064345641393649395447202676452531623942433137554131

Question
56 views

The table below contains the geographic latitudes, x, and average January temperatures, y, of 20 cities. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.

 x y 46 23 32 60 39 40 33 59 38 57 40 33 42 33 30 64 34 56 41 39 36 49 39 54 47 20 26 76 45 25 31 62 39 42 43 31 37 55 41 31
check_circle

Step 1

Software procedure for regression in Excel.

• Enter the given data in EXCEL sheet as x in column A and y in column B.
• Go to Data > Data Analysis > Regression.
• Select x and y ranges with labels.
• Click OK.
Step 2

The output obtained from Ex...

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