Analyze the summary of your data

Assignment Help Management Information Sys

Reference no: EM131993214

ITS836 Assignment 1: Data Analysis in R

1) Read the income dataset, "zipIncomeAssignment.csv", into R. (You can find the csv file in iLearn under the Content -> Week 2 folder.)

2) Change the column names of your data frame so that zcta becomes zipCode and meanhouseholdincome becomes income.

3) Analyze the summary of your data. What are the mean and median average incomes?

4) Plot a scatter plot of the data. Although this graph is not too informative, do you see any outlier values? If so, what are they?

5) In order to omit outliers, create a subset of the data so that:

$7,000 < income < $200,000 (or in Rsyntax , income > 7000 & income < 200000)

6) What's your new mean?

7) Create a simple box plot of your data. Be sure to add a title and label the axes.

In the box plot you created, notice that all of the income data is pushed towards the bottom of the graph because most average incomes tend to be low. Create a new box plot where the y-axis uses a log scale. Be sure to add a title and label the axes. For the next 2 questions, use the ggplot library in R, which enables you to create graphs with several different types of plots layered over each other.

8) Make a ggplot that consists of just a scatter plot using the function geom_point() with position = "jitter" so that the data points are grouped by zip code. Be sure to use ggplot's function for taking the log10 of the y-axis data. (Hint: for geom_point, have alpha=0.2).

9) Create a new ggplot by adding a box plot layer to your previous graph. To do this, add theggplotfunction geom_boxplot(). Also, add color to the scatter plot so that data points between different zip codes are different colors. Be sure to label the axes and add a title to the graph. (Hint: for geom_boxplot, have alpha=0.1 and outlier.size=0).

10) What can you conclude from this data analysis/visualization?

Attachment:- Income Assignment.rar

Reference no: EM131993214

Questions Cloud

Define tools of the customer interface : This assignment provides you with an opportunity to define tools of the customer interface and to distinguish the different stages.

Allocating common fixed expenses to business segments : Allocating common fixed expenses to business segments:

Stereotypes about aging and the older population : When viewing commercials, ads in magazines/papers, and electronic media, how do they contribute to stereotypes about aging and the older population?

What is the meaning of beta : What is the meaning of "beta"? How is it used to calculate "k", the rate of return required by the investor ?.

Analyze the summary of your data : Change the column names of your data frame so that zcta becomes zipCode and meanhouseholdincome becomes income.

Which people would you collaborate with : Explain who would need to be involved if you wanted to conduct research in your school. Which people would you collaborate with?

True of company that uses absorption costing : Which of the following is true of a company that uses absorption costing?

Write an essay on the key challenges in workforce : Task Description - You will write an essay on the key challenges in attracting and retaining a workforce in your selected sector

Explain the overview of network security fundamentals : After transitioning out of the military, you were contracted by a medium-sized start-up company that processes credit card transactions on a daily basis.

User Account

All Pages