Re: Various attempts at vegan analytics
Posted: Mon Nov 18, 2019 6:55 am
-
@brimstoneSalad Managed to extract the channel ID's from a website with a list of 1000 fashion brand channels, so we'll be able to get stats from them. Hard part will just be finding them all in a stock list.
I think any results we get will be slightly quizical, for comparing the rate people tune into social movements and the rate at which people get sucked into consumer advertising, but we're trying all sorts for fun like 'vs. hunting channels', 'vs. ex-vegan trend', etc.
Also:
Does anyone know how to interpolate data in a horizontal range that's non-linear in google sheets?
We've sorted linear regression, but I've been told what I'm hoping to do is called 'polynomial regression' or 'spline interpolation'.
We've imported monthly YouTube channel viewership figures from google API. We've laid out the dates and views in a horizontal range. On the right I want to be able to pick a date and show a rough viewership figure that's close to the actual viewership figure, so interpolating as if it were on a curved line of best fit with multiple peaks and troughs.
The reason is to create a YouTube channel directory with monthly actual viewership figure and % monthly trend difference figure (calculated as if it were on a curved line of best fit since the channels beginning).
Here's the google spreadsheet example anyone can edit, using linear regression:
https://docs.google.com/spreadsheets/d/ ... 87IXsKJt3Q
And I need it to work with blank/unknown cells. So using a formula that doesn't treat empty cells as an error, or fills them in based on the average of known figures to both sides in a series.
-
@brimstoneSalad Managed to extract the channel ID's from a website with a list of 1000 fashion brand channels, so we'll be able to get stats from them. Hard part will just be finding them all in a stock list.
I think any results we get will be slightly quizical, for comparing the rate people tune into social movements and the rate at which people get sucked into consumer advertising, but we're trying all sorts for fun like 'vs. hunting channels', 'vs. ex-vegan trend', etc.
Also:
Does anyone know how to interpolate data in a horizontal range that's non-linear in google sheets?
We've sorted linear regression, but I've been told what I'm hoping to do is called 'polynomial regression' or 'spline interpolation'.
We've imported monthly YouTube channel viewership figures from google API. We've laid out the dates and views in a horizontal range. On the right I want to be able to pick a date and show a rough viewership figure that's close to the actual viewership figure, so interpolating as if it were on a curved line of best fit with multiple peaks and troughs.
The reason is to create a YouTube channel directory with monthly actual viewership figure and % monthly trend difference figure (calculated as if it were on a curved line of best fit since the channels beginning).
Here's the google spreadsheet example anyone can edit, using linear regression:
https://docs.google.com/spreadsheets/d/ ... 87IXsKJt3Q
And I need it to work with blank/unknown cells. So using a formula that doesn't treat empty cells as an error, or fills them in based on the average of known figures to both sides in a series.
-
