 |
Assignment 1 |
|
|
|
Assignment 1 |
|
1. Open the file USTobacco_2004.xls which contains data on the total amount of tobacco produced in the US.
a. Make an XY scatter plot of the data. Add a linear trendline to your plot, including the equation and the R-squared value. Include it in your document.
b. Use the equation method and extended trendline method to predict the amount of tobacco produced in 2008. Show both results in your Word document.
c. How much confidence do you have in your prediction? Why? (Write a short paragraph using the language we learned in class.)
2. Open the file Smoking_2004.xls which contains data on the percent of the US adult population that smokes cigarettes.
a. Make X,Y scatter graph of the years and the total percentages (not male and female) and add a trendline. Include the equation and R-squared value for the trendline. Paste the resulting chart into your Word document.
b. Using your model (equation method) and the extended trendline method, predict the percentage of the total population that smokes in 2008. Show both results in your Word document.
c. How much faith do you have in your prediction? (Write a short paragraph using the language we learned in class.)
d. Use your model to estimate what percentage of the total population smoked in 1953. Do you have faith in this prediction? Explain.
e. Use your model to estimate when 100% of the US population smoked. How much faith do you have in this prediction? Explain.
3. The January 13, 2002 issue of the New York Times reported that there were 547,867 foreign students enrolled at US colleges and universities in 2000-01 — representing a 6.4% increase from the previous year. The greatest number (59,939) of foreign students came from China. What percent of the foreign students studying in the US were from China in 2000-01?
4. In the 2004 presidential election, 18.3 million 25-34 year-olds reported that they voted. If this represents 46.9% of the entire 25-34 year-old population, how many 25-34 year-olds were there in 2004?
5. The bill at a restaurant was $52.45. You want to leave an 18% tip. What is the dollar amount of the tip that you will leave?
6. Answer the following questions using the tables below:
| US population in 2002 | |
| White Non-Hispanic | 196,822,344 |
| Hispanic or Latino | 35,525,695 |
| Black or African American | 36,666,602 |
| American Indian and Alaska Native | 2,748,962 |
| Asian/Pacific Islander | 11,512,403 |
| Native Hawaiian and Other Pacific Islanders | 485,184 |
| Two or more races | 4,180,030 |
| People living with AIDS in 2002 | |
| White, not Hispanic | 139,089 |
| Black, not Hispanic | 160,022 |
| Hispanic | 75,782 |
| Asian/Pacific Islander | 3,414 |
| American Indian/Alaska Native | 1,380 |
a. What percent of the US population is white non-Hispanic?
b. What percent of the people living with AIDS were White non-Hispanic?
