Start with downloading the data on your computer and getting familiar with the data set. Use Excel to answer the questions below. Use a separate worksheet in your Excel file to show your work for each question. Label worksheets using Q$\_$# format. Report your findings in a provided Word document template, and include all the relevant output from Excel. Submit both your Excel file and your written project report as a Word document.

List all the quantitative variables in the order they appear in the dataset in a separate worksheet named Q$1.$

In the worksheet named Data, create two new variables: house age at the time of sale, HouseAgeSale, and number of bathrooms, BRTotal. Show the formulas you use to create the new variables.

Copy the two columns with the new variables into a new worksheet, Q$2.$ Calculate the mean and standard deviation for HouseAgeSale and BRTotal.

Take a random sample of $250$ observations, and save it in a separate worksheet labeled Q$3\_$Sample.$>$

From this point on$,$ continue working with your random sample of $250$ observations. Construct a histogram for SalePrice. Take a natural log of SalePrice and name the new variable LogPrice. Construct a histogram for LogPrice. Label the axes clearly and give titles to your histograms. Comment on the shape of the distribution for each variable. What do you observe after the log transformation?

Create a scatterplot for GrLivArea and SalePrice. Describe the relationship between the two variables, point out any unusual features you might observe.

Choose a categorical variable with at least four categories and construct a bar chart for it$.$ Make sure your bar chart has a legend and is easy to read.