Assignment 2 - February 25th

1. Clean the data - even if it says it is clean, you should review the data and see if further cleaning is needed. assignment, need to clean up the list, remove incomplete records, and remove variables you do not need (you can make further adjustments later). Your independent variables should be on the left, and your dependent should be on the right. (Hint: I recommend using the same Excel Workbook, adding a new worksheet for the current assignment, and labeling your tabs for all of your assignments. The first should be your original data set, then your cleaned data. This is helpful if you need to add variables back in, you accidentally delete something, etc.)

2. Perform a frequency distribution and histogram of each variable in your cleaned data set (be sure you have completed the data cleaning step from the previous Check-in).

3. Using the information in the weekly reading and video 1 (link in ulearn), determine if your sample has a normal distribution.

4. Calculate each variable's mean, variance, and standard deviation. (Provide your Excel file to show your work.)

Deliverables: Upload two documents - the Excel document containing your variables and a Word document providing the rationale of why you did what you did

Please be aware that I tried to clean the Excel data and frequency distribution. I still need help separating the cities and states into four regions - North East, South, West, and Midwest. And then, do the histograms and identify which ones have a normal distribution.

Here is the link for the data file

https://docs.google.com/file/d/1_7gRoisc0lRHgCPgfL1I0w49XCVVB-de/edit?filetype=msexcel