Chapter Project 271 Figure 63 the side and you will see the cubic function of best fit displayed on the scatter diagram. Do you think the function accurately describes the relation between latitude and length of day? 6. Which of the three models seems to fit the data best? Explain your reasoning. 7. Use your model to predict the hours of daylight on the day you selected for Chicago (41.85 degrees north latitude). Go to the Old Farmer’s Almanac or another website to determine the hours of daylight in Chicago for the day you selected. How do the two compare? Chapter Project Length of Day Go to http://en.wikipedia.org/wiki/Latitude and read about latitude through the subhead “Preliminaries.” Now go to http://www.orchidculture.com/COD/daylength.html. 1. For a particular day of the year, record in a table the length of day for the equator … ( ) ° ° ° ° 0 N , 5 N, 10 N, , 60 N. Enter the data into an Excel spreadsheet, TI-graphing calculator, or some other spreadsheet capable of finding linear, quadratic, and cubic functions of best fit. 2. Draw a scatter diagram of the data with latitude as the independent variable and length of day as the dependent variable using Excel, a TI-graphing calculator, or some other spreadsheet. The Chapter 3 project describes how to draw a scatter diagram in Excel. 3. Determine the linear function of best fit. Graph the linear function of best fit on the scatter diagram. To do this in Excel, right click on any data point in the scatter diagram. Now click the Add Trendline . . . menu. Under Trendline Options, select the Linear radio button and select Display Equation on Chart. See Figure 63. Move the Trendline Options window off to the side and you will see the linear function of best fit displayed on the scatter diagram. Do you think the function accurately describes the relation between latitude and length of day? 4. Determine the quadratic function of best fit. Graph the quadratic function of best fit on the scatter diagram.To do this in Excel, right-click on any data point in the scatter diagram. Now click the Add Trendline . . . menu. Under Trendline Options, select the Polynomial radio button with Order set to 2. Select Display Equation on chart. Move the Trendline Options window off to the side and you will see the quadratic function of best fit displayed on the scatter diagram. Do you think the function accurately describes the relation between latitude and length of day? 5. Determine the cubic function of best fit. Graph the cubic function of best fit on the scatter diagram. To do this in Excel right-click on any data point in the scatter diagram. Now click the Add Trendline . . . menu. Under Trendline Options, select the Polynomial radio button with Order set to 3. Select Display Equation on chart. Move the Trendline Options window off to Citation: Excel © 2020 Microsoft Corporation. Used with permission from Microsoft. Internet-based Project Credit: kesipun/Shutterstock
RkJQdWJsaXNoZXIy NjM5ODQ=