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
Asked Oct 2, 2019
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

Expert Answer

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

help_outline

Image Transcriptionclose

SUMMARY OUTPUT Regression Statistics Multiple R 0.952577158 R Square 0.907403242 Adjusted R Square 0.902258978 Standard Error 4.942656583 Observations 20 ANOVA Significance F df SS MS F Regression Residual 4309.212626 4309.212626 176.3912551 9.69495E-11 18 439.7373737 24.4298541 Total 19 4748.95 Coefficients Standard Error P-value Lower 95% tStat Upper 95% 147.2424242 Intercept 7.743654649 19.01459077 2.30003E-13 130.9736095 163.511239 -2.682277319 0.201959902 -13.28123696 9.69495E-11 3.106579329 -2.257975309

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Math

Statistics

Advanced Topics in Statistics

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: A manufacturer of industrial solvent guarantees its customers that each drum of solvent they ship ou...

A: We are given,Population mean = μ = 101.8 and population standard deviation =  3.57Also, A manufactur...

question_answer

Q: Which of the following results in a null hypothesis μ≤7 and alternative hypothesis μ>7? A study w...

A: We are given null and alternative hypothesis.Null hypothesis:Ho: μ ≤ 7And alternative hypothesis:Ha:...

question_answer

Q: The heights of women has a bell-shaped distribution with a mean of164 cm and a standard deviation of...

A: Let x be a height of woman that follows normal distribution with mean of 164 cm and standard deviati...

question_answer

Q: If the price of a piece of tuperware having capacity X is given by 60X-545, what is the expected pri...

A: Click to see the answer

question_answer

Q: Pro basketball player Shaquille O’Neal is a poor free-throw shooter. Consider situations in which he...

A: Let A be the event that shows the he makes the first throw success.Similarly , B be the event that s...

question_answer

Q: Please provide the numerator and the denominator for the following probability examples: a. The prob...

A: Probability of an event:The probability of an event is the number of favourable outcomes divided by ...

question_answer

Q: Consider the following data:Monthly Profit of an Auto Repair Shop Month Jan-14 Feb-14 Mar-14 Apr-...

A: The exponential smoothing forecast for the next time period (Oct-14) is 19,193.2 and it is calculate...

question_answer

Q: 16. Which score indicates the highest relative position? a. A score of 3.2 on a test with X = 4.6 an...

A: Hello. Since you have posted multiple questions and not specified which question needs to be solved,...

question_answer

Q: The mean of the commute time to work for a resident of a certain city is 27.3 minutes. Assume that t...

A: According to the provided details, the mean of the commute time to work for a resident of a certain ...