Semester Project Part one (regression line or best-fit linear function) The following table shows (for the years 1965 to 2000 and for people 18 and over) the total percentage of cigarette smokers, the percentage of males who are smokers, and the percentage of females who are smokers. Percentage of Smokers _________________________________________________________________________________________________ Year Total Population All Males All Females _________________________________________________________________________________________________ 1965 42.4 51.9 33.9 1974 37.1 43.1 32.1 1979 33.5 37.5 29.9 1983 32.1 35.1 29.5 1985 30.1 32.6 27.9 1987 28.8 31.2 26.5 1990 25.5 28.4 22.8 1992 26.5 28.6 24.6 1993 25.0 27.7 22.5 1995 24.7 27.0 22.6 2000 23.3 25.7 21.0 1)Using Excel, draw a Scatter Plot and generate a regression line for the percentages of total population who are smokers versus time. 2) The Regression Line for the Percentage of total population who are smokers is (just copy the equation from your Excel spread sheet, and attach an excel print out): ______________________________________________ 3) According to the model, the percentage of total population who are smokers in the year 2002 is: __________________________________________________ Part two (quadratic function passing three points) Use excel to find the quadratic function whose graph is a parabola containing the points (-2,1137), (2,1017), (3,1062). The quadratic function is (attach an excel print out): __________________________________________________ Part three (best-fit quadratic function) The table below gives the US population, in millions, for selected years. 1) Create a scatter plot of the data points, with x equal to the number of years after 1960. 2) Create a best-fit quadratic function that models the data, using the number of years after 1960 as the input x. The best-fit quadratic function is (attach an excel print out): __________________________________________ 3) Use the model to estimate the population of US in 2000. Is the estimate close to the actual population? According to the model, the estimate of US population in 2000 is: _______________________ 4) Use the model to predict the US population in 2005. According to the model, the US population in 2005 is: _______________________________ Turn in your project with the excel print out and with coversheet. How to Make a Scatter Plot and Regression Line (for users of Excel 2003 and before): i) ii) iii) iv) v) vi) vii) viii) ix) x) xi) xii) xiii) xiv) Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default Highlight the data and select Chart Wizard from Insert Menu or the icon Select XY (Scatter) from Chart Type. Select the FIRST Diagram from the First Column (Scatter. Compares pairs of values) in the Chart sub-type Click on Press and Hold to view sample of what you have made Click on next to continue Under Data Range; check Columns for Series in and click next Under Titles, a) Type in a title for your Bar Graph b) Label both axes Do not change anything under the Axes tab Select the Gridlines tab and uncheck every box Select the Legend tab and uncheck show legend Select the Data Labels tab and ensure that no box has been checked and then click on next For Place Chart; Select As object in to show both Data and Diagram To include a Regression Line; Right click on any of the plotted data: 1) Select Add Trend line 2) Under the Type tab select the appropriate type of graph your data fit 3) Under Options check Display equation on chart. How to make a Scatter Plot and Regression Line (for users of Excel 2007): i) ii) iii) iv) Type your data into two columns side-by-side. Note The first column is always going to be on your X-axis by default Highlight the data and then \"Insert \"a Scatter Plot. \"Layout\" to add title to your chart and turn off the legend and gridlines To include a Regression Line, Right click on any of the plotted data point: 1. Select Add Trend line 2. Under the Type tab select the appropriate type of graph your data fit 3. Under Options check Display equation on chart