2f:T435,For this assignment, you will explore impacts of calcium addition on sugar maple seedlings in two watersheds at Hubbard Brook Experimental Forest using data from Juice and Fahey (2019). Sugar maple (_Acer saccharum_) growth can be inhibited by soil acidification from acid rain, which leaches calcium (a nutrient important for plant growth) from soils. Learn more: [Decades of acid rain is causing loss of valuable Northeast sugar maples, Cornell researchers warn](https://news.cornell.edu/stories/2006/05/acid-rain-causing-decline-sugar-maples-say-researchers). Stephanie Juice, Tim Fahey and colleagues at Hubbard Brook Long Term Ecological Research (LTER) site (Vermont, USA) measured “general sugar maple germinant health by height, leaf area, biomass, and chlorophyll content” (Juice and Fahey 2019) for seedlings in untreated and calcium-treated watersheds to investigate the impact of soil calcium addition on sugar maple seedling growth. In this assignment, you will explore the sugar maple data to gain insights about the impact of watershed calcium addition.30:[{"id":"0ac178f48e32de753388e4c8df81398c47fd886162740691c6f06853dc5f4ede5010b424637298bbb4e28e750a5b87e2dd2a43d34826855b5a5d1749ea214a88","href":"https://static.observableusercontent.com/files/0ac178f48e32de753388e4c8df81398c47fd886162740691c6f06853dc5f4ede5010b424637298bbb4e28e750a5b87e2dd2a43d34826855b5a5d1749ea214a88","name":"w1_acsa_seed_physical.csv","type":"text/csv","lastModified":1690690282315.124,"size":33070}] 2d:{"title":"Assignment (Data science workflows in JavaScript Workshop Series)","cells":[{"id":0,"value":"# Assignment (Data science workflows in JavaScript Workshop Series)","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"## Logistics\n\n- **Fork this notebook** to make your own copy. Complete tasks below in your fork.\n- When you are ready to submit, ensure that your fork visibility is **Public unlisted** so that we can see your work. To update the setting, go to the Share button, the under Access choose “Can view (unlisted)” for Public visibility. Make sure to Save changes.\n- Submit assignment by sharing the URL in [this Google Form](https://forms.gle/cYLwZBsyvikVwgH59) by end of day **Friday, August 4th 2023**\n- Ask questions in the Observable Community Slack #learn-javascript channel.\n- Things in yellow are where you’re prompted to add content for the assignment.","pinned":false,"hidden":false,"mode":"md"},{"id":27,"value":"## About the data","pinned":false,"hidden":false,"mode":"md"},{"id":29,"value":"$2f","pinned":false,"hidden":false,"mode":"md"},{"id":33,"value":"**Data source:** Juice, S. and T. Fahey. 2019. Health and mycorrhizal colonization response of sugar maple (Acer saccharum) seedlings to calcium addition in Watershed 1 at the Hubbard Brook Experimental Forest ver 3. Environmental Data Initiative. https://doi.org/10.6073/pasta/0ade53ede9a916a36962799b2407097e","pinned":false,"hidden":false,"mode":"md"},{"id":43,"value":"## Task 1: Access the data","pinned":false,"hidden":false,"mode":"md"},{"id":45,"value":"Access the data from the [this data package on the Environmental Data Initiative](https://portal.edirepository.org/nis/mapbrowse?packageid=knb-lter-hbr.157.3). You will only need one file: **w1_acsa_seed_physical** (found in the Resources section on that page). You can either read in the remote file directly using the URL, or download the file and attach it in your notebook. Note that while this is a text file (.txt), values are comma-separated, so you can still use the CSV methods we used in the workshop.","pinned":false,"hidden":false,"mode":"md"},{"id":58,"value":"Below this cell, add a new JavaScript cell below, then add code to load data from the file above as `maples`.","pinned":false,"hidden":false,"mode":"md"},{"id":453,"value":"seed_data = await FileAttachment(\"w1_acsa_seed_physical.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":66,"value":"---\n## Task 2: Take a look at the data in a Data table cell","pinned":false,"hidden":false,"mode":"md"},{"id":74,"value":"Below, visualize the `maples` data in a Data table cell. Familiarize yourself with the variables. Here are variable summaries (for the variables you’ll use in this assignment) from the [data package metadata](https://portal.edirepository.org/nis/metadataviewer?packageid=knb-lter-hbr.157.3): \n\n- **Year**: year measured\n- **Watershed**: study watershed (Reference = untreated; W1 = Calcium treated)\n- **Elevation**: categorical description of watershed elevation\n- **Transect**: study transect\n- **Sample**: sugar maple seedling sample number\n- **StemLength**: seedling stem length (millimeters)\n- **Leaf1Area**: area of first leaf sampled from seedling (cm²)\n- **Leaf2Area**: area of second leaf sampled from seedling (cm²)\n- **LeafDryMass**: dry mass of both leaves (grams)\n- **StemDryMass**: dry mass of seedling stem (grams)\n- **CorrectedLeafArea**: total leaf area for both sampled leaves (Leaf1Area + Leaf2Area), corrected for the area removed for chlorophyll analysis (cm²)","pinned":false,"hidden":false,"mode":"md"},{"id":93,"value":"Below this cell, add a new Data table cell below, selecting maples as the data source:","pinned":false,"hidden":false,"mode":"md"},{"id":456,"value":"maples = seed_data","pinned":true,"hidden":false,"mode":"ojs"},{"id":97,"value":"---\n## Task 3: Data wrangling","pinned":false,"hidden":false,"mode":"md"},{"id":99,"value":"Make a simplified version of the `maples` data that only includes observations from 2003. Using the method(s) of your choice (e.g. Array methods, Arquero, SQL, Data table cell, any other tools you prefer, or a combination!), create a simplified version of the `maples` data updated as follows:\n\n- Only keep (and rename) variables:\n - Year (rename to **year**)\n - Watershed (rename to **watershed**)\n - StemLength (rename to **stemLength**)\n - LeafDryMass (rename to **leafMass**)\n - StemDryMass (rename to **stemMass**)\n - CorrectedLeafArea (rename to **leafArea**)\n- Only keep observations from 2003","pinned":false,"hidden":false,"mode":"md"},{"id":105,"value":"Below this cell, add a JavaScript, SQL, or Data Table cell to wrangle the data as described above, naming your new subset `maples2003`.","pinned":false,"hidden":false,"mode":"md"},{"id":459,"value":"simple_maples = maples\n .filter((d) => d.Year == data_year)\n .map((d) => ({\n watershed: d.Watershed == \"Reference\" ? \"untreated\" : \"calcium treated\",\n year: d.Year,\n stemLength: d.StemLength,\n leafMass: d.LeafDryMass,\n stemMass: d.StemDryMass,\n leafArea: d.CorrectedLeafArea\n }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":468,"value":"simple_maples","pinned":false,"hidden":false,"mode":"ojs"},{"id":127,"value":"---\n## Task 4: Exploratory data visualization","pinned":false,"hidden":false,"mode":"md"},{"id":129,"value":"In the area below, create three exploratory data visualizations for the 2003 maple seedlings. Where prompted, add a Markdown cell with a 1-sentences summary of a takeaway or insight gleaned from the visualization.\n\n**Note:** Throughout the rest of the assignment, you will use the 2003 subset `maples2003` you created above.","pinned":false,"hidden":false,"mode":"md"},{"id":131,"value":"Below this cell, use the **Chart cell** to create histogram of leafArea for seedlings recorded in 2003. Facet (vertically) by watershed to compare the distributions in the untreated (Reference) and calcium treated (W1) watersheds. ","pinned":false,"hidden":false,"mode":"md"},{"id":479,"value":"Plot.plot({\n marginRight: 100,\n color: {\n legend: true\n },\n marks: [\n Plot.auto(simple_maples, {x: \"leafArea\", fy: \"watershed\", color: \"watershed\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":210,"value":"Below this cell, add a new Markdown cell, then describe and compare the distributions for leaf areas in untreated and calcium treated watersheds based on the histograms.","pinned":false,"hidden":false,"mode":"md"},{"id":489,"value":"This histogram clearly shows that the calcium treated watersheds skewed towards larger leaf areas than the untreated reference watersheds","pinned":false,"hidden":false,"mode":"md"},{"id":181,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":183,"value":"Below this cell, insert a **Plot snippet from the Add cell menu to create a Scatterplot** of **stemLength** and **stemMass**, with fill color mapped to **watershed**. Then, visualize the linear trends by adding a `linearRegressionY` mark atop the scatterplot mark, with stroke color mapped to **watershed**.","pinned":false,"hidden":false,"mode":"md"},{"id":514,"value":"Plot.plot({\n marks: [\n Plot.dot(simple_maples, {\n x: \"stemLength\",\n y: \"stemMass\",\n fill: \"watershed\",\n tip: true,\n opacity: 0.5,\n r: 8\n }),\n Plot.linearRegressionY(simple_maples, {\n x: \"stemLength\",\n y: \"stemMass\",\n stroke: \"watershed\",\n strokeWidth: 10\n }),\n // Plot.linearRegressionY(\n // simple_maples.filter((d) => d.watershed == \"untreated\"),\n // { x: \"stemLength\", y: \"stemMass\", stroke: \"watershed\", strokeWidth: 5 }\n // ),\n // Plot.linearRegressionY(\n // simple_maples.filter((d) => d.watershed == \"calcium treated\"),\n // { x: \"stemLength\", y: \"stemMass\", stroke: \"watershed\", strokeWidth: 5 }\n // ),\n Plot.frame()\n ],\n color: { legend: true }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":219,"value":"Below this cell, add a new Markdown cell, then describe and compare the relationship between stem length and mass in untreated and calcium treated watersheds.","pinned":false,"hidden":false,"mode":"md"},{"id":540,"value":"The above scatterplot shows that there is a positive linear correlation between stem length and stem mass for both the treated and untreated watersheds. The correlation is slightly higher in the treated watersheds than in the untreated ones.","pinned":false,"hidden":false,"mode":"md"},{"id":198,"value":"---\nBelow this cell, add a JavaScript cell to import PlotMatrix from [Fil’s Autoplot matrix notebook](https://observablehq.com/@observablehq/autoplot-matrix). Then in a second JavaScript cell, use PlotMatrix to create an interactive matrix of charts to visualize the different variable relationships and distributions.","pinned":false,"hidden":false,"mode":"md"},{"id":543,"value":"import { PlotMatrix } with { simple_maples as data } from \"@observablehq/autoplot-matrix\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":548,"value":"PlotMatrix(simple_maples, { color: \"watershed\" })","pinned":true,"hidden":false,"mode":"ojs"},{"id":204,"value":"---\n## Task 5: Analysis / modeling","pinned":false,"hidden":false,"mode":"md"},{"id":228,"value":"**Choose one** of the following to explore differences and patterns in sugar maple morphology in untreated and calcium-treated watersheds: \n\n- **Option 1:** Perform simple linear regression on stem dimensions (stemLength versus stemMass) for the untreated and calcium-amended watershed. For the purposes of this assignment, you can do these separately (e.g. create separate subsets for Reference and W1 watersheds, then use simple linear regression to estimate parameters for each). \n\n- **Option 2:** Perform k-means clustering with two clusters to see if, based on the four quantitative variables in `maples2003`, the seedlings are largely within separate clusters based on watershed. Add a visualization or table to describe the outcomes of cluster analysis.\n \n- **Option 3:** Perform principal component analysis using the four quantitative variables in `maples2003`, and create a biplot showing both observation scores (points) on PC1 and PC2, overlayed by the variable vectors (arrows).\n","pinned":false,"hidden":false,"mode":"md"},{"id":237,"value":"Below this cell, add any cells necessary to perform the analysis you chose from the options above.","pinned":false,"hidden":false,"mode":"md"},{"id":563,"value":"ML = require(\"https://www.lactame.com/lib/ml/6.0.0/ml.min.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":570,"value":"Untreated_Length_Mass_Linear_Regression = new ML.SimpleLinearRegression(\n simple_maples\n .filter((d) => d.watershed == \"untreated\")\n .map((d) => d.stemLength),\n simple_maples.filter((d) => d.watershed == \"untreated\").map((d) => d.stemMass)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":573,"value":"Calcium_Treated_Length_Mass_Linear_Regression = new ML.SimpleLinearRegression(\n simple_maples\n .filter((d) => d.watershed == \"calcium treated\")\n .map((d) => d.stemLength),\n simple_maples\n .filter((d) => d.watershed == \"calcium treated\")\n .map((d) => d.stemMass)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":553,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.dot(simple_maples, {\n x: \"stemLength\",\n y: \"stemMass\",\n grid: true,\n fill: \"watershed\",\n tip: true,\n opacity: 0.5,\n r: 8\n }),\n\n Plot.linearRegressionY(\n simple_maples.filter((d) => d.watershed == \"untreated\"),\n {\n x: \"stemLength\",\n y: \"stemMass\",\n stroke: \"watershed\",\n strokeWidth: 5,\n tip: true,\n marker: \"circle\"\n }\n ),\n\n Plot.linearRegressionY(\n simple_maples.filter((d) => d.watershed == \"calcium treated\"),\n { x: \"stemLength\", y: \"stemMass\", stroke: \"watershed\", strokeWidth: 5 }\n ),\n Plot.frame()\n ],\n color: { legend: true }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":589,"value":"StemLRSlopeRatio = Calcium_Treated_Length_Mass_Linear_Regression.slope /\n Untreated_Length_Mass_Linear_Regression.slope","pinned":true,"hidden":false,"mode":"ojs"},{"id":592,"value":"StemRadiusRatio = Math.sqrt(StemLRSlopeRatio)","pinned":false,"hidden":false,"mode":"ojs"},{"id":242,"value":"--- \n","pinned":false,"hidden":false,"mode":"md"},{"id":244,"value":"Below this cell, add a new Markdown cell and in 1-2 sentences summarize the findings from your analysis for Task 5. Then, in 1-2 sentences based on **all** of the exploration you have done in this assignment, share your preliminary thoughts on if and how calcium addition impacts sugar maple seedlings. ","pinned":false,"hidden":false,"mode":"md"},{"id":596,"value":"It is no surprise that the stem mass should be linearly correlated with stem length. The slope of the correlation is a measure of mass per unit length. In the treated watersheds the mass/length was 1.55 times higher than that of the untreated watersheds. Since mass per unit length is equal to volume times density we can assume that the treated stems had some combination of thicker or more dense stems than those of the untreated watersheds.*","pinned":false,"hidden":false,"mode":"md"},{"id":600,"value":"My preliminary thoughts based on all my analysis are that overall treating a watershed seems to have a significant positive influence on the seedlings. This assumes that there is no selection bias in determining which watersheds were part of the treatment and which were part of the control.","pinned":false,"hidden":false,"mode":"md"},{"id":640,"value":"**Extra Credit** I couldn't resist adding a radio button to select the data for the whole notebook by year. Observable make this easy (and fun). I did find a cool hack using d3 Set to avoid having to hard code which years have data. Thank you so much for the course. I enjoyed it and learned a lot. Observable rocks. In computer science it's all about the glue. Gluing tools, hardware, data, networks, ideas, insights, and people together. Observable is super-glue.","pinned":false,"hidden":false,"mode":"md"},{"id":620,"value":"viewof data_year = Inputs.radio([...new Set(maples.map((item) => item.Year))], {\n label: \"data year\",\n value: [...new Set(maples.map((item) => item.Year))][0]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":246,"value":"---\n## Congratulations! Submit your assignment.\n\nOnce you’re done with the assignment, make sure to: \n\n- Update your notebook settings (click the Share button) so that Public access is “View (unlisted)”\n- Submit the URL to your notebook in [this Google form](https://forms.gle/cYLwZBsyvikVwgH59) by midnight on August 4, 2023\n- Await your course certificate, which we’ll send out in mid-August! \n","pinned":false,"hidden":false,"mode":"md"},{"id":262,"value":"_**Thank you** for joining us for the Data Science Workflows in JavaScript workshop series! We look forward to seeing you in our upcoming courses and workshops, and in our Community Slack!_ ","pinned":false,"hidden":false,"mode":"md"}],"files":"$W30","stdlib":"1","titling":"auto"}