Jared Colston's Avatar

Jared Colston

@jaredcolston.bsky.social

Lead Data Scientist @SSTARLab. Ph.D. candidate @UW-Madison in Higher Ed Policy, studying geography of ed. opportunity and impact of colleges on their local economies/communities. Opinions my own.

317 Followers  |  1,111 Following  |  19 Posts  |  Joined: 01.12.2023  |  2.0912

Latest posts by jaredcolston.bsky.social on Bluesky

speed gauge chart in excel. it is actually two superimposed charts, a donut chart and a pie chart. they have an empty 100 filler series, the value series and a remainder series. the arrow is a 1% slice with black outline (rest of the pie is invisible)

speed gauge chart in excel. it is actually two superimposed charts, a donut chart and a pie chart. they have an empty 100 filler series, the value series and a remainder series. the arrow is a 1% slice with black outline (rest of the pie is invisible)

I made a reusable speed gauge NPS chart in Excel
and now you have to see this abomination too ๐Ÿ“Š

12.03.2025 18:40 โ€” ๐Ÿ‘ 13    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 1
Video thumbnail

THEYโ€™RE CLIMBING THE POLES IN TOKYO GO BIRDS๐Ÿฆ…๐Ÿฆ…๐Ÿฆ…

10.02.2025 03:27 โ€” ๐Ÿ‘ 11462    ๐Ÿ” 2201    ๐Ÿ’ฌ 108    ๐Ÿ“Œ 198
Post image Post image Post image Post image

๐Ÿš€ Launching a new #Stata package #geoflow that allows users to generate spatial arcs.

This package is a culmination of over a year of work for building stable core dependencies. It also brings us one step closer to flexibly plot network data.

12.01.2025 21:10 โ€” ๐Ÿ‘ 48    ๐Ÿ” 13    ๐Ÿ’ฌ 3    ๐Ÿ“Œ 0
Preview
Thinking like an Economist The story of how economic reasoning came to dominate Washington between the 1960s and 1980sโ€”and why it continues to constrain progressive ambitions today

Good opportunity to plug one of my favorite books I've read in a while by @epopppp.bsky.social
press.princeton.edu/books/hardco...

10.01.2025 23:52 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Huge spillover effects on the broader relish industry

21.11.2024 15:16 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Please check it out and let me know if anything breaks with it! This is version 1.0 and I wrote it in about two hours so I'm sure there will be problems that arise! I'll also likely add more functionality as time goes on.

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

And since this command is just a simple wrapper for the -twoway line- command, all other -twoway- options are available:
trendline gdp_percap if inlist(regnum,1,2), time(year) category(regnum) lpattern(dash)

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Average GDP per Capita for East Asia and Europe, 1990-2022.

Average GDP per Capita for East Asia and Europe, 1990-2022.

-if- statements are also allowed with the command:
trendline gdp_percap if inlist(regnum,1,2), time(year) category(regnum)

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Median GDP per Capita by world region, 1990-2022.

Median GDP per Capita by world region, 1990-2022.

You can also change the statistic (any statistic available in the -collapse- command):
trendline gdp_percap, time(year) category(regnum) statistic(median)

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Average GDP per capita by region of the world, 1990-2022.

Average GDP per capita by region of the world, 1990-2022.

And you can plot by group:
trendline gdp_percap, time(year) category(regnum)

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Trend line of average GDP per Capita for all the countries in the World Bank database, 1990-2022.

Trend line of average GDP per Capita for all the countries in the World Bank database, 1990-2022.

The simplest form of the command plots mean values over time for your entire dataset:
trendline gdp_percap, time(year)

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

You can download it using this command:
net install trendline, from("https://raw.githubusercontent.com/jdcols01/trendline/main/installation/") replace

And then just type -help trendline- for the documentation.

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

I used to use -lgraph- but since it doesn't appear to have been updated in nearly a decade, the new -twoway- functions in Stata don't seem to work with it very well. This new package is a MUCH slimmer version purely for plotting aggregates over time. It is particularly useful for multi-level data.

20.11.2024 14:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Preview
GitHub - jdcols01/trendline: Stata package for aggregate trendlines while preserving data structure Stata package for aggregate trendlines while preserving data structure - jdcols01/trendline

Hey folks! Wanted to share a ๐Ÿงต on a super slim Stata package I put together for making aggregate line graphs by group while preserving your data structure. It's called -trendline- and you can find it on my GitHub here: github.com/jdcols01/tre...

20.11.2024 14:32 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 2    ๐Ÿ“Œ 0

Louisville beating Clemson and then losing to Stanford. This is absurd. Why would UK do this to us

17.11.2024 00:16 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Stata graph tips for academic articles Learn tips and tricks for optimizing Stata graphs for journal articles.

Reposting this #Stata guide I wrote a couple of years ago that discusses how to finetune #graphs for academic/journal articles.

The guide covers topics such as colors, legends, fonts, markers, focusing on certain elements etc.

medium.com/the-stata-gu...

16.11.2024 13:19 โ€” ๐Ÿ‘ 53    ๐Ÿ” 15    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 1

Economics of funny

13.11.2024 12:36 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Regression is a tool for making comparisons

If you don't know / can't easily explain what comparisons you're trying to make, then you don't understand the regression you're running

13.11.2024 07:02 โ€” ๐Ÿ‘ 282    ๐Ÿ” 46    ๐Ÿ’ฌ 10    ๐Ÿ“Œ 1
Preview
Eleven people hospitalized after explosion at Louisville plant A factory explosion in Louisvilleโ€™s Clifton neighborhood Tuesday afternoon injured multiple people and damaged homes and businesses.

Eleven people hospitalized after explosion at Louisville plant www.lpm.org/news/2024-11...

12.11.2024 23:22 โ€” ๐Ÿ‘ 12    ๐Ÿ” 9    ๐Ÿ’ฌ 3    ๐Ÿ“Œ 0
Preview
GitHub - asjadnaqvi/stata-schemepack: Here you will find various ready-to-use Stata schemes. Here you will find various ready-to-use Stata schemes. - asjadnaqvi/stata-schemepack

A ๐Ÿงต to keep track of my #Stata #dataviz packages. Regularly updated! Check GitHub links for more info.

Listed in the order they were released ๐Ÿ‘‡

1) ๐˜€๐—ฐ๐—ต๐—ฒ๐—บ๐—ฒ๐—ฝ๐—ฎ๐—ฐ๐—ธ: A large collection of ready-to-use #Stata #schemes.

ssc install schemepack, replace

github.com/asjadnaqvi/s...

12.11.2024 21:07 โ€” ๐Ÿ‘ 24    ๐Ÿ” 4    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 1
Preview
GitHub - asjadnaqvi/stata-waffle: A Stata package for Waffle charts A Stata package for Waffle charts. Contribute to asjadnaqvi/stata-waffle development by creating an account on GitHub.

19) waffle: A Stata package for Waffle plots
(together with @jaredcolston.bsky.social!)

ssc install waffle, replace

github.com/asjadnaqvi/s...

12.11.2024 21:07 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Preview
GitHub - asjadnaqvi/stata-spider: spider: A Stata package for spider plots. spider: A Stata package for spider plots. Contribute to asjadnaqvi/stata-spider development by creating an account on GitHub.

#Stata #spider ๐Ÿ•ท๏ธis bumped to v1.4:

๐Ÿ•ธ๏ธ Weights ๐Ÿ‹ are now allowed and users can also specify how they want to collapse the data.
๐Ÿ•ธ๏ธ Users can now specify variable lists (wide form) making it easier to use.
๐Ÿ•ธ๏ธ More options added.

More info and examples:
github.com/asjadnaqvi/s...

Up soon on SSC!

04.10.2024 15:19 โ€” ๐Ÿ‘ 6    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Too late to explore the world, too soon to explore the universe...

17.09.2024 02:50 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Why am I spending my Saturday wondering why Hoxby & Turner (2013) postcard intervention did not replicate when Gurantz and the College Board crew expanded it and what that means for information interventions in this post-sffa world?

07.09.2024 20:47 โ€” ๐Ÿ‘ 7    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

"We conclude that racial and ethnic minorities are inadequately served by our large household surveys [from census] and that researchers should cautiously interpret survey-based estimates of racial and ethnic differences in [safety net] program receipt and post-benefit income."

26.08.2024 17:49 โ€” ๐Ÿ‘ 15    ๐Ÿ” 9    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Colston: You gotta go full onebag mode. Whatever doesn't fit in a backpack throw away

16.08.2024 17:30 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 1

I tried making a starter pack for the U.S. higher ed folks on here (after looking for one and not finding it myself). Includes researchers, journos, and just people who talk about higher ed stuff. Let me know who I missed!
go.bsky.app/71aQ6gS

16.08.2024 16:37 โ€” ๐Ÿ‘ 7    ๐Ÿ” 4    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

I haven't been a reviewer much, but the last review I did I was just sent another Word doc with a message that basically said "the authors have addressed your concerns". With no mention of how. I basically did a side-by-side word search after going back to my original comments!!

27.06.2024 02:27 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Excited to announce that I'm joining the SSTAR Lab at UW-Madison as Lead Data Scientist! Can't thank PNPI enough for the opportunity to be their Associate Director of Research. Looking forward to this next prof. chapter!

24.04.2024 20:53 โ€” ๐Ÿ‘ 4    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Excited to announce the new and greatly improved -waffle- package available currently on GitHub (and SSC soon)! From my first-ever Stata package using Asjad's waffle plot guide to collaborating on this massively improved version! Just in time for waffle day on the #30DayChartChallenge

04.04.2024 14:27 โ€” ๐Ÿ‘ 7    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

@jaredcolston is following 19 prominent accounts