Part 1 Statistics and Rival Causes
Read "Immigrant Facts Versus Myths"
1. Give an example of a statistic from the article.
2. Give another example of a statistic.
3. Do you think this author made good use of statistics to support his conclusion that illegal immigrants are contributing to society, not hurting it? Why or Why not? Refer to the guidelines from Chapter 11 in Asking the Right Questions in your answer.
4. This article makes use of information provided by the Public Policy Institute of California. Here's how the Institute describes themselves:
Public Policy Institute of California (PPIC) is a nonprofit, nonpartisan think tank. We are dedicated to informing and improving public policy in California through independent, objective, nonpartisan research.PPIC is independent, with no government, university, or charitable affiliations.PPIC is objective. We approach our research without any specific results in mind. And we publish our results even when they may be unpopular or controversial.PPIC is nonpartisan. We do not propose legislation or take positions on legislation, candidates, or ballot measures.We are guided by a set of core values, beliefs, and principles that inform our organization’s choices and staff actions.
Go to the Public Policy Institute of California site at http://www.ppic.org/main/home.asp and use the links to find an article that gives additional statistics about immigrants. Provide the following:
a. The title of the article
b. The URL
c. Give an example of a statistic used in the article.
d. Give another example of a statistic used in the article.
Type your answers in the answer box in Etudes or upload a Word document.
The cost of college textbooks has been rising and students are looking for alternatives to the campus bookstore. You will research the cost of a textbook. You can choose the Asking the Right Questions textbook or any textbook you are interested in. Shop for the textbook online and create a database of your findings using Excel. Excel can be used as a simple database program as long as you have a limited number of records (rows) and do not need to print complicated reports.
1. Start Excel. Enter the textbook title in cell A1
2. Put your name in cell A2
3. Enter the column labels below across row 3. Make the column wider or wrap the text (press Alt+Enter while typing) so all text shows.
| Seller | Price | Shipping | URL | Edition | Condition |
4. Use online textbook sellers to find 8 different copies of the textbook for sale (new, used or rental). Enter the data into the worksheet.
5. Sort the rows of book information (records) in descending order by price.
6. Use a function to calculate the Average for the Price and Shipping
7. (2 points) Use a function to calculate the Median for the Price
8. (4 points) Format the worksheet to look attractive.
Merge and center the title
Use appropriate number formats.
Add at least one border.
9. A filter is used to display only those rows (records) that meet criteria you specify. Select the Price values. Click the Filter button in the Data tab of the Ribbon. Click the drop-down arrow that appears next to the first value. Click the Number Filters option in the menu. Click Below Average.
Save the workbook as May21 (with the filter still applied). Upload the workbook to Assignments.