An organization collects information on the life expectancy (in years) of a person in certain countries and the fertility rate per woman in those countries. The data for 21 randomly selected countries for the year 2011 is given below. Use Excel to find the best fit linear regression equation, where fertility rate is the explanatory variable. Round the slope and intercept to two decimal places.   Fertility Rate Life Expectancy2.1    71.12.7    67.83.2    70.62.6    66.16.1    67.65.4    55.31.5    82.77.5    57.51.4    75.91.8    80.66.5    57.41.1    82.64.7    62.23.5    70.02.3    78.24.2    61.06.8    54.33.9    64.85.2    55.92.6    77.05.8    57.8   Answer: y=___x+___

Question

An organization collects information on the life expectancy (in years) of a person in certain countries and the fertility rate per woman in those countries. The data for 21 randomly selected countries for the year 2011 is given below. Use Excel to find the best fit linear regression equation, where fertility rate is the explanatory variable. Round the slope and intercept to two decimal places.

 

Fertility Rate Life Expectancy
2.1    71.1
2.7    67.8
3.2    70.6
2.6    66.1
6.1    67.6
5.4    55.3
1.5    82.7
7.5    57.5
1.4    75.9
1.8    80.6
6.5    57.4
1.1    82.6
4.7    62.2
3.5    70.0
2.3    78.2
4.2    61.0
6.8    54.3
3.9    64.8
5.2    55.9
2.6    77.0
5.8    57.8

 

Answer:

y=___x+___

Expert Answer

Want to see the step-by-step answer?

See Answer

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Answer
*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.
Tagged in

Related Statistics Q&A

Find answers to questions asked by student like you

Q: Describe the main difference between a dependent and an independent t test. (Note: I am not asking y...

A: Dependent t-test: The dependent t-test, also known as the “paired t-test”, is a statistical procedur...

Q: Jobs and productivity! How do retail stores rate? One way to answer this question is to examine annu...

A: (a)Using the provided data, the sample mean can be calculated using Excel function “AVERAGE()”.Enter...

Q: Are there ever any circumstances when a correlation such as Pearson's r can be interpreted as eviden...

A: Correlation between any two variables tell us the linear association meaning that one variable rise ...

Q: Find the critical value and rejection region for the type of​ t-test with level of significance α an...

A: Note:Hey! Thank you for posting the question. Since you have not mentioned the purpose for which the...

Q: What determines whether a post hoc test is used in a one-way ANOVA calculation? Be specific.

A: ANOVA is generally used to analyze the  significant differences among group means. Here we apply F-t...

Q: a. Which of the six correlations above are statistically significant (i) if you test each correlatio...

A: We have been given alpha  = 0.05 which implies that the probability of inferring that there is a cor...

Q: In a union-management negotiation, the following are the percentages of annual wage increase gained ...

A: Let’s make a table to see this data M1M2M3U1133U2422U3314U4332U5312

Q: The Orchard Cafe has found that about 10% of the diners who make reservations don't show up. If 86 r...

A: The aim is to find the mean, µ, and standard deviation, σ of the binomial distribution.

Q: Given that z is a standard normal random variable, find z for each situation (to 2 decimals) a. The ...

A: a.The area to the left of z is 0.209 can be written as P(Z < z)=0.209.In the z-table for negative...