{"id":26708,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/trending-analysis"},"modified":"2017-08-12T07:02:02","modified_gmt":"2017-08-12T07:02:02","slug":"trending-analysis","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/trending-analysis\/","title":{"rendered":"Trending Analysis"},"content":{"rendered":"<p><b>Resources:<\/b><\/p>\n<ul>\n<li><b>Locate <\/b>and <b>download<\/b> &#8220;Annual U.S. CPI (includes CPI-U and CPI-W)&#8221; data from: <a href=\"http:\/\/www.seattle.gov\/financedepartment\/cpi\/documents\/US_CPI_History_--_Annual.xls\" rel=\"nofollow noopener\" target=\"_blank\">http:\/\/www.seattle.gov\/financedepartment\/cpi\/documents\/US_CPI_History_&#8211;_Annual.xls<\/a><\/li>\n<li><b>Locate<\/b> and <b>download<\/b> &#8220;Median and Average Sale Price of Houses Sold&#8221; data from: <a href=\"https:\/\/www.census.gov\/construction\/nrs\/xls\/usprice_cust.xls\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/www.census.gov\/construction\/nrs\/xls\/usprice_cust.xls<\/a><\/li>\n<\/ul>\n<p><b>Create <\/b>an Excel\u00ae&nbsp;document in which you include the following:<\/p>\n<ul>\n<li>Paste from &#8220;Median and Average Sale Price of Houses Sold&#8221;, Price Ann sheet, the Period and Median Price columns (column A and B respectively), starting from year 1963.<\/li>\n<li>On a third column, calculate Index, taking into assumption that for year 1984 it is 100. Format it to 1 decimal place. Name it &#8220;House Price Index.&#8221;<\/li>\n<li>For example, for year 1983, the index will be calculated based on median price of 1983 vs. 1984 (e.g. 94.2).<\/li>\n<li>As a second example, for year 1985, the index will be calculated based on median price of 1985 vs. 1986 (e.g. 105.5).<\/li>\n<li>On a fourth column, paste from &#8220;Annual U.S. CPI (includes CPI-U and CPI-W)&#8221;, the Index column (column B) starting from 1963.&nbsp; Name it &#8220;Consumer Price Index.&#8221;<\/li>\n<li>Create a line chart, plotting &#8220;House Price Index&#8221; and &#8220;Consumer Price Index&#8221; for each year, starting from 1963. Year will be the X Axis. Price Index will be the Y Axis.<\/li>\n<li>Save the Excel\u00ae&nbsp;document for submission.<\/li>\n<\/ul>\n<p>&nbsp;<b>Compose <\/b>a minimum 1,050-word report in which you address the following:<\/p>\n<ul>\n<li>Analyze the correlation between &#8220;House Price Index&#8221; and &#8220;Consumer Price Index.&#8221;<\/li>\n<li>Evaluate conditions of abrupt median price change and correlate to a historical event (e.g. 2006).<\/li>\n<li>Predict the trend for &#8220;House Price Index&#8221; for the next few years.<\/li>\n<li>Synthesize your predictions in regards to the current market conditions based on the &#8220;House Price Index&#8221; vs. &#8220;Consumer Price Index.&#8221;<\/li>\n<li>Analyze the median income increase in the last 10 to 20 years. Correlate with the graph you have created and assess your findings.<\/li>\n<\/ul>\n<p><b>Format <\/b>your&nbsp;assignment consistent with APA guidelines.<\/p>\n<p><b>Click <\/b>the Assignment Files tab to submit your assignment.<\/p>\n<p>Grading<\/p>\n<p><b>Individual Assignment: <\/b>Trending Analysis<\/p>\n<p><b>Purpose of Assignment<\/b><\/p>\n<p>In order to know if a process, an enhancement or a change has made any impact, it needs to be measured. It can also be compared with other metrics in order to understand if the impact has a correlation. This assignment will help students determine if a series of data points have a correlation, and if those can allow the audience to understand the impact of those correlations and the trending analysis that those convey.<\/p>\n<p><b>Resources Required<\/b><\/p>\n<p><a href=\"http:\/\/www.seattle.gov\/financedepartment\/cpi\/documents\/US_CPI_History_--_Annual.xls\" rel=\"nofollow noopener\" target=\"_blank\">Annual U.S. CPI (includes CPI-U and CPI-W)<\/a><\/p>\n<p><a href=\"https:\/\/www.census.gov\/construction\/nrs\/xls\/usprice_cust.xls\" rel=\"nofollow noopener\" target=\"_blank\">Median and Average Sale Price of Houses Sold<\/a><\/p>\n<p><b>Grading Guide<\/b><\/p>\n<p><b>Content<\/b><\/p>\n<p>Met<\/p>\n<p>Partially Met<\/p>\n<p>Not Met<\/p>\n<p>Comments:<\/p>\n<p><b>Excel Document<\/b><\/p>\n<p>5<\/p>\n<ul>\n<li>Paste from &#8220;Median and Average Sale Price of Houses Sold&#8221;,&nbsp;Price Ann&nbsp;sheet, the Period and Median Price columns (column A and B respectively), starting from year 1963.<\/li>\n<li>On a third column, calculate Index, taking into assumption that for year 1984 it is 100. Format it to 1 decimal place. Name it &#8220;House Price Index.&#8221;<\/li>\n<li>For example, for year 1983, the index will be calculated based on median price of 1983 vs. 1984 (e.g. 94.2).<\/li>\n<li>As a second example, for year 1985, the index will be calculated based on median price of 1985 vs. 1986 (e.g. 105.5).<\/li>\n<li>On a fourth column, paste from &#8220;Annual U.S. CPI (includes CPI-U and CPI-W)&#8221;, the Index column (column B) starting from 1963.&nbsp; Name it &#8220;Consumer Price Index.&#8221;<\/li>\n<li>Create a line chart, plotting &#8220;House Price Index&#8221; and &#8220;Consumer Price Index&#8221; for each year, starting from 1963. Year will be the X Axis. Price Index will be the Y Axis.<\/li>\n<\/ul>\n<p>&nbsp;<b>Report<\/b><\/p>\n<p>5<\/p>\n<ul>\n<li>Analyze the correlation between &#8220;House Price Index&#8221; and &#8220;Consumer Price Index.&#8221;<\/li>\n<li>Evaluate conditions of abrupt median price change and correlate to a historical event (e.g. 2006).<\/li>\n<li>Predict the trend for &#8220;House Price Index&#8221; for the next few years.<\/li>\n<li>Synthesize your predictions in regards to the current market conditions based on the &#8220;House Price Index&#8221; vs. &#8220;Consumer Price Index.&#8221;<\/li>\n<li>Analyze the median income increase in the last 10 to 20 years. Correlate with the graph you have created and assess your findings.<\/li>\n<\/ul>\n<p>The paper is a minimum of 1,050 words in length.<\/p>\n<p><b>Total Available<\/b><\/p>\n<p><b>Total Earned<\/b><\/p>\n<p>10<\/p>\n<p>#\/10<\/p>\n<p><b>Writing Guidelines<\/b><\/p>\n<p>Met<\/p>\n<p>Partially Met<\/p>\n<p>Not Met<\/p>\n<p>Comments:<\/p>\n<p>The paper \u2014 including tables and graphs, headings, a title page, and a reference page \u2014 is consistent with APA formatting guidelines and meets course-level requirements.<\/p>\n<p>.4<\/p>\n<p>The paper includes properly cited intellectual property using APA style in-text citations and a reference page.<\/p>\n<p>.4<\/p>\n<p>The paper includes paragraph and sentence transitions that are logical and maintain flow throughout the paper.<\/p>\n<p>.4<\/p>\n<p>The paper includes sentences that are complete, clear, and concise.<\/p>\n<p>.4<\/p>\n<p>The paper follows proper rules of grammar and usage including spelling and punctuation.<\/p>\n<p>.4<\/p>\n<p><b>Total Available<\/b><\/p>\n<p><b>Total Earned<\/b><\/p>\n<p>2<\/p>\n<p>#\/10<\/p>\n<p><b>Assignment Total<\/b><\/p>\n<p><b>#<\/b><\/p>\n<p>12<\/p>\n<p>#\/12<\/p>\n<p>Additional comments:<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Resources: Locate and download &#8220;Annual U.S. CPI (includes CPI-U and CPI-W)&#8221; data from: http:\/\/www.seattle.gov\/financedepartment\/cpi\/documents\/US_CPI_History_&#8211;_Annual.xls Locate and download &#8220;Median and Average Sale Price of Houses Sold&#8221; data from: https:\/\/www.census.gov\/construction\/nrs\/xls\/usprice_cust.xls Create an Excel\u00ae&nbsp;document in which you include the following: Paste from &#8220;Median <a href=\"https:\/\/www.benedictsol.com\/blogs\/trending-analysis\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-26708","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/26708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=26708"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/26708\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=26708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=26708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=26708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}