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 |

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

Tagged in

Find answers to questions asked by student like you

Show more Q&A

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

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

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

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

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

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

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

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

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