n\u00a0TAB 2\u00a0of the Google Sheet, you will\u00a0generate a simple random sample of 300 data values from the data set to be used for the remainder of this assignment.\u00a0 <\/p>\n
Open your copy of\u00a0Property Prices \u2013 Part 1 Data Template.
Copy the original data set provided for you (TAB 1) and paste that entire data set into\u00a0TAB 2. To do this,\u00a0
Select inside the blank box in the top left corner of screen. This will select all the cells.\u00a0
Then, right-select to copy the data.\u00a0
Paste the data by selecting \u201cPaste\u201d in cell A1 in\u00a0TAB 2.
Once the random sample of 300 rows is generated, sort the data in\u00a0TAB 2\u00a0by TYPE, since for some parts of this assignment you will be working with only homes or only townhomes or only units. To do this,\u00a0
Select Column B
Then select \u201cData\u201d from the menu followed by \u201cSort Range\u201d
>It is imperative that you sort the\u00a0sheet\u00a0by 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.\u00a0
Then select \u201cData\u201d 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).\u00a0
Now that the rows of data in\u00a0TAB 2\u00a0are sorted by TYPE, copy the rows corresponding only to HOME prices in\u00a0TAB 2\u00a0and paste the rows in\u00a0TAB 3.\u00a0
Copy the rows in\u00a0TAB 2\u00a0corresponding only to TOWNHOME prices and paste the rows in\u00a0TAB 4.\u00a0
Copy the rows in\u00a0TAB 2\u00a0corresponding only to UNIT prices and paste the rows in\u00a0TAB 5.
Then post a link to your Google Sheet or upload an excel version for grading.
Resources
Property Prices – Part 1 Data Template\u00a0(opens in a new window) <\/p>\n
Assignment Helps
Making A Copy Of A Google Sheet\u00a0[DOWNLOAD]
Add Apps And Extensions\u00a0(opens in a new window) <\/p>\n
Share Files From Google Drive\u00a0(opens in a new window) <\/p>\n
Generating A Random Sample And Sorting Tutorial\u00a0[DOWNLOAD]
Histogram Charts\u00a0(opens in a new window)
Add<\/p>\n","protected":false},"excerpt":{"rendered":"
n\u00a0TAB 2\u00a0of the Google Sheet, you will\u00a0generate a simple random sample of 300 data values from the data set to be used for the remainder of this assignment.\u00a0 Open your copy of\u00a0Property Prices \u2013 Part 1 Data Template. Copy the original data set provided for you (TAB 1) and paste that entire data set into\u00a0TAB […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-13400","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/13400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=13400"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/13400\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=13400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=13400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=13400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}