34:["$","title",null,{"children":"Analyzing a dataset: Is an expensive college worth it | Erik | Observable"}] 3c:T11da,3d:T477,const loadData = () => { const url = "https://raw.githubusercontent.com/rfordatascience/tidytuesday/main/data/2020/2020-03-10/tuition_cost.csv"; // Download the data. Then, after it's downloaded, process it as // described in the function inside "then". return d3.csv(url, d3.autoType).then((data) => data.map(d => ({ ...d, room_and_board: d['room_and_board'] === 'NA' ? NaN : d['room_and_board'], state: Object.keys(nonStates).includes(d['state_code']) ? nonStates[d['state_code']] : d['state'] })) ) } const tuitionData = await loadData(); const incomeData = (await d3.csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/main/data/2020/2020-03-10/salary_potential.csv', d3.autoType)) .map(d => ({ name: d.name, state: d.state_name, early_career_pay: d.early_career_pay, mid_career_pay: d.mid_career_pay, make_world_better_percent: d.make_world_better_percent })); // From inside out: use map to get a list of states, then put them in a Set to get unique names, // then turn it back into an array. const states = Array.from(new Set(tuitionData.map(d => d.state)));3e:[] 38:{"id":"03dbb746299e1fbb","slug":"analyzing-a-dataset-is-an-expensive-college-worth-it","title":"Analyzing a dataset: Is an expensive college worth it","thumbnail":"6e316c5a885308283bc42422b5eacef62a795758a4f5adc28c34cfd2a6708f45","access_level":"public","create_time":"$D2026-10-12T22:06:21.769Z","update_time":"$D2026-10-28T20:27:34.999Z","view_time":null,"first_public_time":"$D2026-10-28T20:35:40.276Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"334ebec93890ef30","login":"elo","name":"Erik","avatar_url":null,"tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":910,"publish_version":910,"role":null,"authored":false,"authors":[{"type":"individual","id":"572ee5f8859f340d","login":"elo","name":"Erik","avatar_url":null,"tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"334ebec93890ef30","login":"elo","name":"Erik","avatar_url":null,"tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Analyzing a dataset: Is an expensive college worth it","cells":[{"id":1,"value":"# Analyzing a dataset: Is an expensive college worth it","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"Today's lesson is all about using array functions (some familiar, some new) to do a realistic data analysis. We're going to take a data-driven perspective to answer the question: **_Is an expensive college worth it?_**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"First, let's try to state how we're going to answer this question. What would make that expensive college \"worth it\"? For that matter, what counts as \"expensive\"? What data would you need to answer these questions?\n\nWrite your answer (briefly) in the cell below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"Tuition\nCredibility\nContains major\nFinancial aid offers\nOut of college job rate\nAverage salary\nStudent happiness\nFacilities\nLocation\nNetworking/Researching opportunities\n","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"$${vspace(150)}\n## Getting started\n\nWe'll start with [a dataset](https://rfordatascience.github.io/tidytuesday/data/2020/2020-03-10/readme.html) of college tuition amounts and survey responses from graduates, collected and cleaned from various sources as part of the [_Tidy Tuesday_](https://rfordatascience.github.io/tidytuesday/about.html) project.\n\nThe data is from the 2018–2019 academic year.\n\nHere's what it looks like in tabular form.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"Inputs.table(tuitionData, { rows: 5, sort: 'degree_length', reverse: true })","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"As before, it's an array of objects.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"tuitionData","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"tuitionData[0]","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"tuitionData[1]","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"## Warm up\n\nLet's start by getting to know the data little better.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"_Can you find the record for Cal Poly?_ You can use the [`find`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/find) function here.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"tuitionData.find(c => c.name === \"California Polytechnic State University\")\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"tuitionData.filter(c => c.name === \"California Polytechnic State University\")","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"tuitionData.find(c => c.name.startsWith('California Polytechnic'))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"tuitionData.filter(c => c.name.startsWith('California Polytechnic'))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"tuitionData.filter(c => c.name.includes('California') && c.name.includes('Polytechnic'))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"_Does this table include only 4-year institutions?_ I.e., `degree_length === \"4 Year\"` true for _all_ schools? You can use the [`every`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/every) function here.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"// Your code here.\ntuitionData.filter(c => c.degree_length === \"4 Year\")","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"tuitionData.filter(c => c.degree_length.includes(\"4 Year\"))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"tuitionData.filter((school) => school['degree_length'] !== \"4 Year\").length === 0","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"tuitionData.some((school) => school[\"degree_length\"] === \"4 Year\")","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"tuitionData.map((school) => school['degree_length'] === \"4 Years\").reduce((acc, curr) => acc && curr)","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"tuitionData.map(c => c.name)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"_How many **unique** schools are in this table?_ There are **${tuitionData.length}** records in our table. Are any schools repeated?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"\nconst uniqueNames = new Set(tuitionData.map(school => school.name))\ndisplay(uniqueNames)\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"const uniqueStates = new Set(tuitionData.map(school => school.state))\ndisplay(uniqueStates)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"new Set(tuitionData.map(school => school.in_state_tuition))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"python:\n\nseen = set()\ncount = 0\n\nfor school in tuitionData:\n if school['name'] not in seen:\n seen.add(school['name'])\n count += 1\n\nreturn count","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"$${vspace(150)}\n## What does college cost, typically?\n\nWhat's the average cost of college?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"const avg_cost_college = (tuitionData) => {\n const totalin = tuitionData.map((school) => school[\"in_state_tuition\"])\n const totalout = tuitionData.map((school) => school[\"out_of_state_tuition\"])\n\n const totalboth = [...totalin, ...totalout]\n const total = totalboth.reduce((acc, curr) => acc + curr, 0)\n\n return total / totalboth.length\n}\n\ndisplay(avg_cost_college(tuitionData))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"// const avgInState = d3.mean(tuitionData.map((school) => school.in_state_tuition))\nconst avgInState = d3.mean(tuitionData.filter(school => !isNaN(school.room_and_board)), school => school.in_state_total)\ndisplay(avgInState)\n\nconst avgOutOfState = d3.mean(tuitionData.filter(school => !isNaN(school.room_and_board)), school => school.out_of_state_total)\ndisplay(avgOutOfState)\n\ndisplay(`In state average: ${Math.round(avgInState)}, out of state average: ${Math.round(avgOutOfState)}`)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"Is that number, alone, representative of what college costs? What other factors should we consider to paint a fuller picture?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"No, because it only takes into account tuition and boarding, but theres food, cost for events, transportation, average financial aid, school supplies, and other misc. stuff.\nin state tuition in particular state\n\nfiler all objects with california\nthen just do d3.mean","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"const in_state_california = d3.mean(tuitionData.filter(s => s.state === state), s => s.in_state_tuition)\ndisplay(in_state_california)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"const state = view(Inputs.select(states.toSorted()))\n // toSorted sorts the array","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"const pubPriv = view(\n Inputs.checkbox(\n ['Public', 'Private'],\n { value: ['Public'], label: \"Public or Private\"}\n )\n)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"state","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"const stateSchools = tuitionData\n .filter(s => s.state === state)\n .filter(s => pubPriv.includes(s.type))\nconst avgInState = d3.mean(stateSchools, s => s.in_state_tuition);\ndisplay(avgInState)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"$${vspace(300)}\n## Should you go in-state, or out-of-state?\n\nIs it more expensive to go in-state or out-of-state? For this question, we want to calculate an \"average record\" for each state.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"We'll start by doing this for a single state.\n\nWrite a function called `stateAverage`.\n- It should take one parameter: a `string` representing the name of a state (e.g., `\"California\"`).\n- It should return an `object` representing the state's tuition averages. For example, here's what we want for California:\n\n```txt\n{\n state: \"California\",\n in_state: 14721.625984251968, // average in-state tuition\n out_of_state: 20166.937007874014, // average out-of-state tuition\n out_of_state_premium: 5445.3110236220455 // difference between the two averages\n}\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"const stateAverage = (state: str) => {\n const allState = tuitionData.filter(s => s.state === state)\n\n const avgInState = Math.round(d3.mean(allState.filter(school => !isNaN(school.room_and_board)), school => school.in_state_total));\n const avgOutState = Math.round(d3.mean(allState.filter(school => !isNaN(school.room_and_board)), school => school.out_of_state_total));\n\n const diff = avgOutState - avgInState;\n\n const result = {\n state: state,\n in_state: avgInState,\n out_of_state: avgOutState,\n out_of_state_premium: diff\n }\n return result\n}\n//if (avgOutState > avgInState) {\n // return (`The difference between the out and in-state tuitions is ${Math.round(avgOutState - avgInState)}`)\n // }\n // if (avgOutState < avgInState) {\n// return (`The difference between the out and in-state tuitions is ${Math.round(avgInState - avgOutState)}`)\n // }\ndisplay(stateAverage(\"Alabama\"))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"tuitionData.filter(s => s.out_of_state_total > s.in_state_total)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":161,"value":"tuitionData","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"$${vspace(200)}\nLet's use our function from above to produce a _new table_ (i.e. array of objects) that contains state averages. That is, we want to call our `stateAverage` function _for each state_. We can then use that new table in further analyses.\n\nHint: you can use the `states` array that I've prepared for this.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"// Complete this line to produce the table\nstates","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"//states.map(state => stateAverage(state))\nconst average = states.map(stateAverage)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"With that done, which state has the biggest out of state premium?\n\nWe'll use a new function for this: [`d3.maxIndex`](https://d3js.org/d3-array/summarize#maxIndex). It gives back an index, which we can then use to find the whole object with the highest premium.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"//average.reduce((acc, curr) =>\n// acc['out_of_state_premium'] > curr['out_of_state_premium'] ? acc: curr\n//)\naverage.at(d3.maxIndex(average, s => s['out_of_state_premium']))\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"$${vspace(400)}\n## Salary potential\nWhat's the \"return on investment\"? In an ideal world, a college education is inexpensive and available to everyone who wants it, and your choice of whether or for what to attend college should be based solely on your academic interests.\n\nHowever, in our current world it can be very expensive. It's worth asking how much that investment in yourself tends to \"pay off\".\n\nFor that analysis, we'll bring in another dataset. (Shown in tabular form and array form below).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"Inputs.table(incomeData, { rows: 6 })","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"incomeData","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"And here's the first tuition data set again.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"tuitionData","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"callout(\"What do you notice about the income data? What's different between it and the tuition data?\", { type: \"ponder\" })","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"$${vspace(200)}\n### Joining the datasets","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"$3c","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"vspace(75)","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"// For each record in the incomeData (using map)...\nconst joined = incomeData.map((incomeRow) => {\n // Find the matching record in the tuitionData (where the school names match)\n const matchingRow = tuitionData.find((tuitionRow) => tuitionRow.name === incomeRow.name);\n return matchingRow !== undefined // If a match is found...\n ? { ...matchingRow, ...incomeRow } // return a joined record combining the two records\n : undefined; // otherwise return undefined\n })\n .filter((row) => row !== undefined); // Then filter out all undefined values","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"With our combined dataset in hand, we can ask some questions that draw on information from _both_ sources.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"_What's the average early and mid-career pay for public vs. private schools?_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"// Im thinking use a map filter to map only early and mid inside a function, and store those in a variable, and then use a reduce function.\n\nconst avgEarly = (object) => {\n const totalEarly = joined.map((school) => school[\"early_career_pay\"])\n\n const total = totalEarly.reduce((acc, curr) => acc + curr, 0)\n\n return Math.round(total / totalEarly.length)\n}\n\ndisplay(avgEarly(joined))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"const avgMid = (object) => {\n const totalMid = joined.map((school) => school[\"mid_career_pay\"])\n\n const total = totalMid.reduce((acc, curr) => acc + curr, 0)\n\n return Math.round(total / totalMid.length)\n}","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"\n\ndisplay(avgMid(joined))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"_What's the mean early career pay for graduates from expensive vs. less expensive schools?_ To answer this, we need to decide what \"expensive\" means! Below, update the value of `costThreshold` to some meaningful value of your choosing. After all, this is your analysis.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"joined","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"const costThreshold = 20000;","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"In the following cells, find the mean `early_career_pay` for schools whose `in_state_tuition` is under that threshold, and for schools whose `in_state_tuition` is greater than or equal to that threshold.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"const meanWorth = (object) => {\n // currently have an object of all the schools where the in_state is smaller than cost, so its worth\n const inState = object.filter((school) => school['in_state_tuition'] < costThreshold).map((school) => school['early_career_pay'])\n\n const total = inState.reduce((acc, curr) => acc + curr, 0)\n\n return Math.round(total / inState.length)\n}\n\ndisplay(meanWorth(joined))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"const meanNotWorth = (object) => {\n const inState = object.filter((school) => school['in_state_tuition'] >= costThreshold).map((school) => school['early_career_pay'])\n const total = inState.reduce((acc, curr) => acc + curr, 0)\n return Math.round(total / inState.length)\n}\ndisplay(meanNotWorth(joined))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"_Which schools have the worst return-on-cost?_\n\nIn this part, we're going to compute a `return_on_cost` measure for each school, computed as follows:\n\n`early_career_pay / in_state_tuition`\n\nProduce a new table that includes that information for each school.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"const withCostIndex = (object) => {\n const returnOnCost = object.map((school) => ({\n name: school['name'],\n return_on_cost: school['early_career_pay'] / school['in_state_tuition']\n }))\n\n return returnOnCost\n}\n\ndisplay(withCostIndex(joined))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"With that information, which schools have the worst return on cost? Sort the table by `return_on_cost` and inspect the top 10 rows.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"const worst10 = (object) => {\n const worstTen = withCostIndex(object)\n\n return worstTen.sort((a, b) => a['return_on_cost'] - b['return_on_cost']).slice(0, 10)\n}\ndisplay(worst10(joined))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"$3d","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"const nonStates = {\n DC: \"Washington, DC\",\n PR: \"Puerto Rico\",\n GU: \"Guam\",\n VI: \"U.S. Virgin Islands\",\n AS: \"American Samoa\",\n MP: \"Northern Mariana Islands\",\n FM: \"Federated States of Micronesia\",\n MH: \"Marshall Islands\",\n PW: \"Palau\"\n}","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"import { utils, stylesheet, vspace, callout } from 'observable:@ayaankazerouni/utils'","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3e","stdlib":"2"}} 33:null