Reference no: EM13930039
PART I: Projects
1. For a school project, you are studying the history of immigration in the urban areas of the U.S. You used census data to learn that in the years 1980 through 1990, immigration in urban U.S. areas grew. The following tables list urban areas in the United States that grew the most and the origin of immigrants. Use this data to illustrate immigration distribution in each of these urban areas. Open a new workbook and save it as Immigration.xlsx
Los Angeles area
|
Mexico
|
866,088
|
|
El Salvador
|
169,077
|
|
Philippines
|
114,123
|
|
Vietnam
|
91,442
|
|
Korea
|
91,385
|
San Francisco area
|
Mexico
|
113,919
|
|
Philippines
|
81,575
|
|
China
|
56,837
|
|
Vietnam
|
56,803
|
|
El Salvador
|
26,093
|
New York City area
|
Dominican Republic
|
145,153
|
|
China
|
74,959
|
|
Jamaica
|
74,168
|
|
Colombia
|
66,685
|
|
Korea
|
58,456
|
· Enter the data shown in the tables above.
· Create two charts for each urban area that show the immigration distribution.
· Change the color of a data series in at least one of the charts.
· Resize and move the charts for an attractive presentation.
· Preview your work so you will know what the printed charts will look like.
· Enter your name in a cell and save your work.
2. As the head of the multicultural task force for your school, you are leading a campaign to keep the school community informed of the cultures represented at your school. To illustrate the school's population, you have decided to create charts of the demographic background of the student body. Utilize the demographic data that appears below.
Ethnicity
|
Native American
|
15725
|
|
Afro-American
|
12457
|
|
White
|
22998
|
|
Asian
|
16255
|
Age
|
Under 15
|
15
|
|
16-20
|
7921
|
|
21-30
|
17325
|
|
31-40
|
12555
|
|
41-50
|
10235
|
Course Popularity
|
English
|
14525
|
|
Computers
|
28955
|
|
Fine Arts
|
9695
|
|
Science
|
12544
|
Open a new workbook and save it as School Statistics.xlsx in the drive and folder where your Data Files are stored.
· Enter demographic data that appears above.
· Create charts that show the following: ethnic origin of students, age distribution of students, and most popular courses (by attendance figures, if possible).
· Preview your work so you will know what the printed charts will look like.
· Enter your name in a cell and save your work.
PART II: Essay
Directions: Write an essay that summarizes be at least 2 pages in length, utilize APA style, and include a cover page and a bibliography.
Your summary must include all of the following topics:
· Plan a chart
· Create a chart
· Move and resize a chart
· Change the chart design
· Change the chart layout
|
Prepare a dopamine drip for the cat
: You also want the cat to receive the drip for at least 48 hours so you need to prepare 250 ml of the dopamine drip. How much dopamine do you need to add from a stock concentration of dopamine (200mg/5ml) to a final volume of 250 ml of saline?
|
|
Telecommunication''s impact on business
: The objective of this project is to allow you to select an area of telecommunications and evaluate its impact on a particular business. The purpose is to evaluate how a company uses telecommunications to improve its strategic or competitive advantage..
|
|
What is the firms gain or loss at sales
: Break-Even Analysis- The Weaver Watch Company sells watches for $25, fixed costs are $140,000 and variables costs are $15 per watch. a) What is the firm`s gain or loss at sales of 8,000 watches? At 18,000 watches? b) What is the break-even point? Ill..
|
|
Account balance after depositing the check
: Your bank account was overdrawn by $14. You then were charged a $35 overdraft fee. The bank applies a $5 fee for each day your account is overdrawn. Your account is overdrawn for 3 days when you deposit a check for $256. What is your account balance ..
|
|
Create two charts for each urban area
: Enter the data shown in the tables above. Create two charts for each urban area that show the immigration distribution. Change the color of a data series in at least one of the charts
|
|
Compare and contrast current models of abnormal behavior
: Compare and contrast current models of abnormal behavior: the biological model, the psychoanalytic model, the cognitive-behavioral model, the diathesis-stress model, and systems theory.
|
|
Explains relationships between theory and experience
: Support in systems administration, software Installation and desktop operating system and communicate and co-ordinate with suppliers and service providers for example Dell.
|
|
As an accountant working on the federal budget
: As an accountant working on the federal budget, what would you recommend we do to balance the budget, how do you think we can turn the budget into a balanced budget.
|
|
Calculate the expected return and standard deviation
: The stock of Bruin, Inc., has an expected return of 17 percent and a standard deviation of 32 percent. The stock of Wildcat Co. has an expected return of 12 percent and a standard deviation of 47 percent. The correlation between the two stocks is .34..
|