TDM 10100: Project 11 — 2022

Motivation: Selecting the right tools, understanding a problem and knowing what is available to support you takes practice.
So far this semester we have learned multiple tools to use in R to help solve a problem. This project will be an opportunity for you to choose the tools and decide how to solve the problem presented.

We will also be looking at Time Series data. This is a way to study the change of one or more variables through time. Data visualizations help greatly in looking at Time Series data.

Make sure to read about, and use the template found here, and the important information about projects submissions here.

Dataset(s)

The following questions will use the following dataset(s):

"/anvil/projects/tdm/data/zillow/County_time_series.csv"

Questions

ONE

Read in the dataset "/anvil/projects/tdm/data/zillow/County_time_series.csv" into a data.frame named county

  1. Convert the Date column to month, date, year format.

  2. How many years are in the data.frame in total?

  3. Create a lineplot that shows the average value per year of MedianListingPricePerSqft_3Bedroom AND shows the average value per year of MedianListingPricePerSqft_1Bedroom.

  4. Write one to two sentences on what you notice in the graph

Items to submit
  • Code used to solve this problem.

  • Output from running the code.

TWO

  1. What is the average value per year of the median prices of top tier homes? Write a sentence or two about anything that may seem interesting about this data.

  2. What is the average value of the median of bottom tier homes in 2014?

  3. What is the average value of the median of middle tier homes in 2010?

Helpful Hint

You can use either tapply OR the aggregate function for this

Items to submit
  • Code used to solve this problem.

  • Output from running the code.

THREE

Can you create a graph that shows the average per year of each of the three columns (bottom tier, middle tier, and top tier), so that you can easily compare these variables?

Helpful Hint

You can use the library ggplot2 for this

Items to submit
  • Code used to solve this problem.

  • Output from running the code.

FOUR

Looking at the data, is there something that you find interesting? Create 3 new graphs and explain what you see and why you chose that specific type of plot.

Items to submit
  • Code used to solve this problem.

  • Output from running the code.

Please make sure to double check that your submission is complete, and contains all of your code and output before submitting. If you are on a spotty internet connection, it is recommended to download your submission after submitting it to make sure what you think you submitted, was what you actually submitted.

In addition, please review our submission guidelines before submitting your project.