You can use Excel to find the best-fitting line for a data set. Enter the data into a spreadsheet. Make a scatter plot of the data. Click on the scatter plot. From the chart menu, choose "Add Trendline." Click on the "Options" tab. Check the box labeled "Display equation on chart." Click "OK." This will add the best-fitting line and its equation to your scatter plot.

The data set relates the number of chirps per second for striped ground crickets and the temperature in degrees Fahrenheit.

1. Enter the data into a spreadsheet and make a scatter plot of the data.
2. Graph the best-fitting line on your scatter plot and find its equation.
3. Estimate the temperature when there are 19 chirps per second.
4. Estimate the temperature when there are 22 chirps per second.

You can use Excel to find the best-fitting line for a data set. Enter the data into a spreadsheet. Make a scatter plot of the data. Click on the scatter plot. From the chart menu, choose "Add Trendline." Click on the "Options" tab. Check the box labeled "Display equation on chart." Click "OK." This will add the best-fitting line and its equation to your scatter plot.

Data were collected from a sample of 414 infants, grouped by month of birth. The data set relates the average monthly temperature (in degrees Fahrenheit) six months after the infants were born and the average age (in weeks) at which the infants learned to crawl.

(Source: Janette Benson, Infant Behavior and Development, 1993)

1. Enter the data into a spreadsheet and make a scatter plot of the data.
2. Graph the best-fitting line on your scatter plot and find its equation.
3. Estimate the average crawling age for infants when the average temperature 6 months after they are born is 55°F.
4. Estimate the average crawling age for infants when the average temperature 6 months after they are born is 475°F. Is this temperature reasonable? Is your estimate reasonable? Explain your reasoning.