{"id":19530,"date":"2024-04-05T02:22:02","date_gmt":"2024-04-05T02:22:02","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/you-will-analyze-data-collected-on-cancer-statistics-in-canada-in-2023-and-draw-some-conclusions-based-on-this-data\/"},"modified":"2024-04-05T02:22:02","modified_gmt":"2024-04-05T02:22:02","slug":"you-will-analyze-data-collected-on-cancer-statistics-in-canada-in-2023-and-draw-some-conclusions-based-on-this-data","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/you-will-analyze-data-collected-on-cancer-statistics-in-canada-in-2023-and-draw-some-conclusions-based-on-this-data\/","title":{"rendered":"you will analyze data collected on cancer statistics in Canada in 2023 and draw some conclusions based on this data."},"content":{"rendered":"<p>Overview:<br \/>\nIn this project, you will take on the role of secondary health science researchers to demonstrate your<br \/>\nunderstanding of the statistical techniques studied in class. As secondary researchers, you will analyze<br \/>\ndata collected on cancer statistics in Canada in 2023 and draw some conclusions based on this data.<\/p>\n<div>Submission Format:<br \/>\n\u2022 Your project must be completed using Microsoft Excel.<br \/>\n\u2022 Each question should be on its own worksheet, labelled by part and question number<br \/>\n(e.g. Part 1-2, Part 2-3, etc.)<br \/>\n\u2022 All graphs should be properly titled and fully labelled<br \/>\n\u2022 All statistical values\/probabilities should be clearly labelled and calculated using Excel formulas<br \/>\no Statistical values\/probabilities that are manually typed in will not receive any mark<\/div>\n<div>&nbsp;Your assignment should be laid<br \/>\nout clearly and neatly, with appropriate headings, titles, and labels, and your conclusions<br \/>\nshould be presented in a way that is easy to understand.<\/div>\n<div>Downloading the Data:<br \/>\nGo to the website www.cancer.ca\/statistics and download the Excel data file underneath the heading<br \/>\n\u201c2023 Resources\u201d called \u201cSource Data File\u201d.<br \/>\nOpen a new workbook, and call it \u201cMATH 20025 Data Project \u2013 GROUPNUM\u201d where \u201cGROUPNUM\u201d is<br \/>\nreplaced by your group number<\/div>\n<div>PART 3: Estimating and Interpreting Data (15 marks)&nbsp;<\/div>\n<div>Estimating and interpreting probabilities and confidence intervals using Microsoft Excel&nbsp;<\/div>\n<div>1)&nbsp;<span style=\"background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit; font-family: Poppins, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;;\">(6 marks) Using the mean and standard deviation you calculated in questions 1 &amp; 2 of PART 2,<br \/>\nuse the normal distribution to calculate the probability of a randomly-selected individual with that<br \/>\ntype of cancer being:<br \/>\no Under 40 years old<br \/>\no Between 50 \u2013 74 years old<br \/>\no 65 years old and over&nbsp;<\/span><\/div>\n<div><span style=\"background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit; font-family: Poppins, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;;\">2) (3 marks) Using the mean and standard deviation you calculated in questions 1 &amp; 2 of PART 2,<br \/>\nconstruct a confidence interval for the true mean age of those diagnosed with the type of cancer<br \/>\nyou chose, at ONE of the following significance levels:<br \/>\no 90%<br \/>\no 95%<br \/>\no 99%&nbsp;<\/span><\/div>\n<div><span style=\"background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit; font-family: Poppins, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;;\">3) (3 marks) Compare the values from question 1 of Part 3 to those you calculated in question 3 of<br \/>\nPart 2-B and discuss what conclusions you can draw about the distribution of the data based on<br \/>\nthese results. Be sure to support your claims by referencing at least one other idea we learned in<br \/>\nclass when discussing the shape and distribution of data.&nbsp;<\/span><\/div>\n<div><span style=\"background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit; font-family: Poppins, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;;\">4) (3 marks) From the \u201cSource Data File\u201d workbook, copy Table 1.6 into your workbook, which shows<br \/>\nthe average annual percent change (AAPC) in age-standardized incidence rates (ASIR) for<br \/>\nselected cancers, and provides a 95% confidence interval for the true AAPC based on the data.<br \/>\nFind a specific cancer type (do not use \u201call cancers\u201d) that satisfies each of the following:<br \/>\no Statistically significant increase in AAPC between 1984-2019 for males<br \/>\no Statistically significant decrease in AAPC between 1984-2019 for females<br \/>\no No statistically significant change in AAPC between 1984-2019 for both sexes<br \/>\nBe sure to justify your answers for each selection.<\/span><\/div>\n<div>PART 4: Modelling Data using Correlation and Regression (15 marks)&nbsp;<\/div>\n<div>Creating scatter plots and running regression analysis using Microsoft Excel&nbsp;<\/div>\n<div>1) (5 marks) From the \u201cSource Data File\u201d workbook, copy Figure 1.3 into your workbook. Construct a<br \/>\nscatter diagram between age and ASIR for males. Add a linear trendline to the data, and display<br \/>\nthe equation and R^2 value for the data, and calculate the correlation coefficient for the data.<br \/>\nHint: you will need to use the midpoint of the age class in order to do a regression analysis.&nbsp;<\/div>\n<div>2) (5 marks) Repeat question 1 for females.&nbsp;<\/div>\n<div>3) (5 marks) Interpret the values that you found in questions 1 and 2 in the context of the problem<br \/>\nand use them to estimate the ASIR for a person in your group (indicate the appropriate sex* and<br \/>\nage for the person you have selected to perform your estimate for). *Please note these studies<br \/>\nrefer to biological sex as opposed to gender identity. However, the selected student is welcome to<br \/>\nuse their preferred gender identity in lieu of their biological sex, if they are not the same.<span style=\"background-color: var(--color-6); color: var(--color-1); font-variant-ligatures: inherit; font-variant-caps: inherit; font-family: Poppins, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;;\"><br \/><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Overview: In this project, you will take on the role of secondary health science researchers to demonstrate your understanding of the statistical techniques studied in class. As secondary researchers, you will analyze data collected on cancer statistics in Canada in 2023 and draw some conclusions based on this data. Submission Format: \u2022 Your project must [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[8],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/19530"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=19530"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/19530\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=19530"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=19530"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=19530"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=19530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}