Question

In: Statistics and Probability

A scientific study on bird migration distances gives the following data table. Migration distance Average number...

A scientific study on bird migration distances gives the following data table.

Migration distance Average number of birds per flock
54 103
60 133
63 136
71 169
72 174

The least squares regression line was found. Using technology, the following information was determined:

  • total sum of squares (SST) was 3386
  • sum of squares of regression (SSR) was 3344.

Calculate R2 and explain its meaning.

Round your answer to four decimal places.

Solutions

Expert Solution

The least squares regression line: y = 3.8130x - 101.0348

R-squared: 0.9876

Run regression analysis in excel followed by below procedures:

1. Go to data tab --> data analysis --> choose Regression

Results:


Related Solutions

A scientific study on speed limits gives the following data table. Average speed limit Average annual...
A scientific study on speed limits gives the following data table. Average speed limit Average annual fatalities 25 16 27 29 29 38 32 71 35 93 Using technology, it was determined that the total sum of squares (SST) was 4029.2, the sum of squares regression (SSR) was 3968.4, and the sum of squares due to error (SSE) was 60.835. Calculate R2 and determine its meaning. Round your answer to four decimal places. Select the correct answer below: R2=0.0153 Therefore,...
The table to the right gives size and distance data for the planets at a certain...
The table to the right gives size and distance data for the planets at a certain point in time. Calculate the scaled size and distance for each planet using a 1 to 10 billion scale model solar system. Planet Diameter Distance from Sun Mercury 4880 km 50.4 million km Venus 12,100 km 108.9 million km Earth 12,760 km 148.4 million km Mars 6790 km 220.2 million km Jupiter 143,000 km 748.6 million km Saturn 120,000 km 1501 million km Uranus...
The table gives the average number of voters in a certain city in each of three...
The table gives the average number of voters in a certain city in each of three political parties during the last 12 years, along with the average number that voted in presidential elections during this period. Political Party Republican Democratic Independent Registered     voters 4500 6100 2200 Voted 2925 2379 1100 (a) For each political party, use these data to find the probability that a person selected at random from the registered voters in the party will vote in the next...
Consider the following data on distances traveled by 100 people to visit the local park. distance...
Consider the following data on distances traveled by 100 people to visit the local park. distance frequency 1-8 30 9-16 25 17-24 25 25-32 10 33-40 10 Expand and construct the table adding columns for relative frequency and cumulative relative frequency. Then plot Histogram, Frequency Polygon and Ogive Curve.
The following table gives the mean velocity of planets in their orbits versus their mean distance...
The following table gives the mean velocity of planets in their orbits versus their mean distance from the sun. Note that 1 AU (astronomical unit) is the mean distance from Earth to the sun, about 93 million miles. Planet d = distance (AU) v = velocity (km/sec) Mercury 0.39 47.4 Venus 0.72 35.0 Earth 1 29.8 Mars 1.52 24.1 Jupiter 5.20 13.1 Saturn 9.58 9.7 Uranus 19.20 6.8 Neptune 30.05 5.4 Astronomers tell us that it is reasonable to model...
The following table shows data on the average number of customers processed by several bank service...
The following table shows data on the average number of customers processed by several bank service units each day. The hourly wage rate is $15, the overhead rate is 1.2 times labor cost, and material cost is $4 per customer. Unit Employees Customers Processed / Day A 5 38 B 6 46 C 7 61 D 3 33 a. Compute the labor productivity and the multifactor productivity for each unit. Use an eight-hour day for multifactor productivity.(Round your "Labor Productivity"...
Table 2.5 (page 109) gives data on the true calories in 10 foods and the average...
Table 2.5 (page 109) gives data on the true calories in 10 foods and the average guesses made by a large group of people. Exercise 2.26 explored the influence of two outlying observations on the correlation. (a) Make a scatterplot suitable for predicting guessed calories from true calories. Circle the points for spaghetti and snack cake on your plot. These points lie outside the linear pattern of the other 8 points. (b) Find the least-squares regression line of guessed calories...
Use the following population data for the next question(s). At a bird watching center, the number...
Use the following population data for the next question(s). At a bird watching center, the number of yellow throated warblers observed over Memorial Day Weekend was: three on Saturday, 10 on Sunday, and eight on Monday. Assume sample sizes of two are randomly selected with replacement from this population. 10) List the nine different possible samples of yellow throated warblers and find the mean of each of them. 11) Identify the probability of each sample of yellow throated warblers and...
The table below gives data from a study that shows that social exclusion causes "real pain."...
The table below gives data from a study that shows that social exclusion causes "real pain." That is, activity in the area of the brain that responds to physical pain goes up as distress from social exclusion goes up. The scatterplot for this data shows a moderately strong linear relationship. The data are given below.      Social      Brain      Social      Brain Subject      distress      activity Subject      distress      activity 1 1.22 −0.055   8 2.18 0.027 2...
The table below gives data from a study that shows that social exclusion causes "real pain."...
The table below gives data from a study that shows that social exclusion causes "real pain." That is, activity in the area of the brain that responds to physical pain goes up as distress from social exclusion goes up. The scatterplot for this data shows a moderately strong linear relationship. The data are given below.      Social      Brain      Social      Brain Subject      distress      activity Subject      distress      activity 1 1.22 −0.055 8 2.20 0.028 2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT