Math Project

Name: Math Manisa No. : 10740 Project 2 Regression Line 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 _________________________________________________________________________________________________ 965 42. 4 51. 9 33. 9 1974 37. 1 43. 1 32. 1 1979 33. 5 37. 5 29. 9 1983 32. 35. 1 29. 5 1985 30. 1 32. 6 27. 9 1987 28. 8 31. 2 26. 5 1990 25. 5 28. 22. 8 1992 26. 5 28. 6 24. 6 1993 25. 0 27. 7 22. 5 1995 24. 7 27. 22. 6 2000 23. 3 25. 7 21. 0 Part one 1)Using Excel, draw a Scatter Plot and generate a regression line for the percentages of males who are smokers versus time. Part two 1) The Regression Line for the Percentage of Males who are smokers is (just copy the equation from your Excel spread sheet ) Y= -0. 7766X+1575 2).By the model in 1), the percentage of Males who are smokers in the year 2002 is: 20. 85=21% 2) Using Excel, draw a Scatter Plot and generate a regression line for the percentages of females who are smokers versus time. [pic] Part Two 3). The Regression Line for the Percentage of Females who are smokers is (just copy the equation from your Excel spread sheet ) Y= -0. 4134x+847. 64 4) By the model in 3), the percentage of Females who are smokers in 2002 is: 20. 01=20% ———————– [pic]