graph and econ

Data Analysis Project 2 • Using the data sources provided in class, generate two separate files (One Excel & One PowerPoint) and

upload them via the submission link in Blackboard by the due date (e-mailed copies will not be accepted).

• Excel: For each of the letters on the next page, create one graph in Excel. Use a separate Excel spreadsheet

for each letter. Construct graphs from the data you input into excel only.

• PowerPoint: For each of the letters on the next page, create one graph in PowerPoint and up to three

bullet points to narrate the graph. Also place a hyperlink to your data source (cannot grade unless

hyperlink works). Use separate PowerPoint pages for each letter below. Graphs should reasonably mirror

those generated in Excel and the data must be the same. You are to construct the PowerPoint as though

you will be presenting it to your classmates and it will be graded as a presentation so consider the

following:

o Introduction slide with name(s) of presenters, class title, and project number.

o Cosmetics: check spelling, redundant info, character size (students in back of room should be able

to easily read), narrations (up to three bullet points can be added to enhance your presentation),

color, creativity, animations, etc.). This is your project so doll it up as though you are presenting to

your classmates or better yet, a panel of supervisors at work.

• For each questions you may choose the appropriate graph to use; however, make sure to include a vertical

bar chart, horizontal bar chart, pie chart, histogram, frequency table, and lined scatterplot at least once in

the overall project. Do not copy any existing graph from the sites used, even if cited. The goal is for you to

demonstrate that you can generate your own illustrations in Excel and PowerPoint.

• Letters, not numbers, are graded with equal weight.

• You may work with one partner on this project. You are responsible for selecting your partner and any

deficient performance that may emerge; choose wisely or simply work alone. If you choose to work with a

partner you must identify them on your PowerPoint introduction slide AND in the comments section of

Blackboard. Only one partner needs to upload the project. For equity, partners will have additional

questions to complete (#6).

• It is preferred that you ask questions about the project in class, rather than via e-mail, so that all students

can benefit from the answers.

• Questions are intentionally open ended and presented through the lens of a lay-person’s inquiry. This

provides you creative license to answer as you see optimal. Feel free to interpret subjectively but make

sure you substantiate whatever you present with data from the sites provided.

You are to use each of the following statistical concepts at least once in the entire project: ▪ Mean, Median, and Mode

▪ Variance and Standard Deviation

▪ Percentile ▪ Range

▪ Collectively Exhaustive ▪ Mutually Exclusive

▪ Union and Intersection of Events ▪ Skew

▪ Statistical Independence or Dependence

▪ Normal Distribution, Z-Scores ▪ Empirical rule and Chebyshev’s Theorem

1. Housing Research

a. How old and how large are homes in America?

b. Should we expect more new housing development in the near future? Compare building permits,

housing starts, and housing completions.

c. How much have housing prices increased in San Diego and Nationally since the end of the Great

Recession?

2. Health Research

a. What types of cancer have the highest mortality?

b. How does the U.S. compare internationally in terms of infant mortality?

c. What are the leading causes of death among young people?

d. How long do people in the U.S. live? Does this vary based on different demographics?

3. Education Research

a. Does student performance in Math and Reading vary across race and gender?

b. What fraction of men in the U.S. have college degree? What about women?

c. Does having a college degree change if you look at married people vs. non-married people?

d. How does educational spending vary across states?

4. If working with a Partner complete these additional questions:

a. What vehicles are the more dangerous in terms of traffic fatalities?

b. For the U.S, what are we spending our education budget on?

c. How have deaths from lung and breast cancer changed over time?

d. What areas of the country have the most, and least, expensive homes?

e. How common is abortion in America? Does abortion vary based on race, age, and/or income?