solve all

$```\{$r setup, include$=$FALSE$\}$

knitr::opts$\_$chunk$set$($echo $=$ TRUE$)$

$```$

### Instructions

$1.$ This is an R Markdown format used for publishing markdown documents to GitHub. When you click the $**$Knit$**$ button, all R code chunks are run and a markdown file $(.$md$)$ suitable for publishing to GitHub is generated.

$2.$ Fill in the code chunks for following question and submit this R markdown file to the assignment on Canvas. Make sure when you save that you have run all cells, so the outputs displace between the cells.

$3.$ Solo work, open book & open notes $-$ This part of the exam is open book, open notes. You may use the textbook, your own notes, and any pre$-$existing resources. You must not use communicate with others $-$ in person, using online forums, social media, Slack, WeChat, GroupMe, etc. If you have concerns, contact me directly so I can advise you.

$4.$ Partial credit $-$ If you can't get your code to work $100\%$ correctly, you can often earn partial credit. To get partial credit you need to show that you know there is a problem and describe it$.$ The better you can describe the problem, the more partial credit you can earn, because it helps demonstrate your knowledge and skill. Please provide your description outside of the code chunk.

$5.$ Make sure you can have a successful knit of the document, and have a screenshot of your knitted file.

### Q$1.(5$pts$)$ Create a vector containing all the positive odd numbers smaller than $100.$

$```\{$r$\}$

$```$

### Q$2.(3$pts$)$ Create a matrix of $4$ rows and $3$ columns with random numbers. $(2$pts$)$ Get the $1$st and $4$th row from the matrix.

$```\{$r$\}$

$```$

### Q$3.(5$pts$)$ Create a function sum$\_$n that for any given value, say n$,$ computes the sum of the integers from $1$ to n $($inclusive$).$ Use the function to determine the sum of integers from $1$ to $500.$

$```\{$r$\}$

$```$

### Q$4.(5$pts$)$ Create a dataframe with two columns: 'Name' $($chr$),$ 'Score' $($numeric$),$ containing $5$ rows of data.

$```\{$r$\}$

$```$

### Q$5.(5$pts$)$ Write a function compute$\_$s$\_$n that for any given n computes the sum S$($n$)=1^2+2^2+...+$n$^2.$

$```\{$r$\}$

$```$

### Q$6.(5$pts$)$ Download the 'HousePrice$-$exam.csv$\text{'}.$ Read the file and import the data to a data frame 'house$\_$df$\text{'}.$

$```\{$r$\}$

$```$

### Q$7.(5$pts$)$ Add a new column 'price$\_$per$\_$sqft$\text{'}$ to house$\_$df$,$ it is computed as Price$/$Sqft$\_$Area.

$```\{$r$\}$

$```$

### Q$8.(5$pts$)$ What is the median price $($Price$)$ of hourses in zipcode area $98118($Check the column Postal$)?$

$```\{$r$\}$

$```$

### Q$9.(5$pts$)$ Get a subset of houses that were built after $2000($check the column Built$\_$Year$).$

$```\{$r$\}$

$```$

### Q$10.(5$pts$)$ What is the price of the most expensive house in the dataset? $(5$pts$)$ What is the Property$\_$Address of the most expensive house?

$```\{$r$\}$

$```$

### Q$11.(5$pts$)$ Design a question with the house$\_$df data: the question will use both "mutate" and "filter" from the tidyverse package. $(5$pts$)$ Write code to answer your question.

#### Write your question here:

$```\{$r$\}$

$```$

### Q$12.(5$pts$)$ Design a question with the house$\_$df data: the question will use both "group$\_$by$"$ and "summarize" from the tidyverse package. $(5$pts$)$ Write code to answer your question.

#### Write your question here:

$```\{$r$\}$

$```$

### Q$13.(5$pts$)$ Design a question with the house$\_$df data: the question will use both "arrange" from the tidyverse package. $(5$pts$)$ Write code to answer your question.

#### Write your question here:

$```\{$r$\}$

$```$

### Q$14.(15$pts$)$ How many houses have Zestimate price higher than sold price. $($Hint: You need to convert Zestimate to a numeric value first, e$.$g$.,278$K $->278000,$ then you can compare Price with Zestimate$)$

$```\{$r$\}$

$```$