n TAB 2 of the Google Sheet, you will generate a simple random sample of 300 data Essay

n TAB 2 of the Google Sheet, you will generate a simple random sample of 300 data values from the data set to be used for the remainder of this assignment. 

Open your copy of Property Prices – Part 1 Data Template.
Copy the original data set provided for you (TAB 1) and paste that entire data set into TAB 2. To do this, 
Select inside the blank box in the top left corner of screen. This will select all the cells. 
Then, right-select to copy the data. 
Paste the data by selecting “Paste” in cell A1 in TAB 2.
Once the random sample of 300 rows is generated, sort the data in TAB 2 by TYPE, since for some parts of this assignment you will be working with only homes or only townhomes or only units. To do this, 
Select Column B
Then select “Data” from the menu followed by “Sort Range”
>It is imperative that you sort the sheet by the range as opposed to sorting the column by just the range, as you need to make sure that the entire row is sorted, not just the column. 
Then select “Data” as a header row checkbox to protect your header row from being sorted. Note that, if done correctly, you will notice the first number of rows correspond to data on HOME prices (h), the next number of rows correspond to data on TOWNHOME prices (t), and the last number of rows corresponds to data on UNIT prices (u). 
Now that the rows of data in TAB 2 are sorted by TYPE, copy the rows corresponding only to HOME prices in TAB 2 and paste the rows in TAB 3. 
Copy the rows in TAB 2 corresponding only to TOWNHOME prices and paste the rows in TAB 4. 
Copy the rows in TAB 2 corresponding only to UNIT prices and paste the rows in TAB 5.
Then post a link to your Google Sheet or upload an excel version for grading.
Resources
Property Prices – Part 1 Data Template (opens in a new window)

Assignment Helps
Making A Copy Of A Google Sheet [DOWNLOAD]
Add Apps And Extensions (opens in a new window)

Share Files From Google Drive (opens in a new window)

Generating A Random Sample And Sorting Tutorial [DOWNLOAD]
Histogram Charts (opens in a new window)
Add