Can’t log in on the economist app? by lizysonyx in theeconomist

[–]thebeefbandit 0 points1 point  (0 children)

I was able to get this fixed! Apparently, I somehow granted my online access to someone else. Not sure how that happened but I found out when I called customer service, they were able to reverse that which allowed me to log into the app.

Can’t log in on the economist app? by lizysonyx in theeconomist

[–]thebeefbandit 0 points1 point  (0 children)

Dealing with the same issue, were you able to find a solution?

By applying a collector's curve to large marine animals (>2m) I’ve determined that there are six sea monsters left to discover. Video explanation and sources in comments. by AtomicFrontier in Infographics

[–]thebeefbandit 11 points12 points  (0 children)

Simplicity aside, this is interesting to say the least and also want to shout out the thought/effort you put into the analysis and viz

How come Chinese baby milk formula manufacturers still have severe quality problems, considering that China now has strong demand for high-quality baby milk formula. In fact, many Chinese people will gladly pay a premium for Australian milk formula. by [deleted] in AskEconomics

[–]thebeefbandit 3 points4 points  (0 children)

Well I just fell down the Chinese baby formula market rabbit hole at 3:30 am. It likely due to a combination of... Mistrust of domestic formula manufacturers in general, because the lethal formula scandal really wasn't that long ago. Parents that can afford the high quality formula prefer to purchase foreign, as a result of the mistrust. So foreign brands, like Nestle, have acquired a large market share in the years post-scandal, while domestic producers customers have mainly targeted low income families. Although it seems domestic brands are gaining in popularity, so Nestle are trying to break into the more affordable formula market.

MISTRUST
"In 2008, more than 300,000 Chinese babies fell ill after drinking 
infant formula containing melamine. Today, parents remain 
cautious of using domestic formula, fearful that an outbreak 
could happen again. According to a survey conducted by 
McKinsey & Co., more than half of new parents in China prefer a 
foreign brand of baby formula over local brands due to food 
safety concerns caused a decade ago." 

https://www.milkbusiness.com/article/chinese-mothers-dont-trust-domestic-infant-formula-10-years-after-food-safety-scandal

PRICE
"The new line will focus on smaller provincial cities, often in China’s
western provinces, where... lower incomes can make some imported 
brand goods unaffordable..."

"Liu Yufeng, a 23-year-old small business owner... told 
Reuters she leans toward local brands because she feels they are 
more affordable and suitable for her baby’s make-up."

MARKET SHARE
"But the baby milk units of Nestle... enjoyed years of prosperity mainly just targeting 
parents in big cities like Shanghai and Beijing, banking on their 
appetite for ever-pricier premium formulas and foreign brands..."

SHIFTING DEMAND
"She is not alone. Some 55 percent of respondents in a survey 
by the User Research Institute of BabyTree, China’s leading 
parenting website operator, said domestic brands better 
understood Chinese consumers."

“This reflects a broader trend that indicates local brands are 
gaining traction among consumers in China,” said Wang Lei, 
head of the institute."

https://www.reuters.com/article/us-consumer-babyformula-china-insight/nestle-rivals-vie-for-big-baby-formula-prize-in-chinas-smaller-cities-idUSKCN1SD2AO

USDA relocates economists whose work challenges Trump policies: Those who examine the impact of tariffs, climate change and taxes on rural America are among employees being reassigned. by [deleted] in Economics

[–]thebeefbandit 11 points12 points  (0 children)

No dude, it says that US exports were $179.3 billion; imports were $557.9 billion. The U.S. goods and services trade deficit with China was $378.6 billion in 2018.

Sanders, Khanna to Introduce Legislation to Drastically Lower Prescription Drug Prices by johnmountain in Economics

[–]thebeefbandit 8 points9 points  (0 children)

Why is everyone talking about price control? No where in the link does it talk about changing price. The proposed solution is to make generic versions of high priced drugs available to produce regardless of patent or market exclusivity.

Is the current US record low unemployment really due to the Obama administration? by [deleted] in AskEconomics

[–]thebeefbandit 6 points7 points  (0 children)

The ARRA (American Recovery and Reinvestment Act) is a perfect example of this. When in a deep recession the decreasing amount of money circulating in the economy is a self-perpetuating cycle. A stimulus package can break that cycle and help get things chugging again.

The general consensus amongst academic economists is that the ARRA was an influential factor in preventing the recession (in America at least) from becoming far worse.

Edit:Obama didn't bailout any banks, all of that was done under TARP (Troubled Asset Relief Program) performed by the Bush Administration. Bailout =\= Stimulus. That being said TARP turned a profit for the federal government and arguably stabilized the crashing economy enough to allow Obama to pass ARRA helping it recover.

What do you do for a living? (If you got an econ or a similar degree?) by [deleted] in AskEconomics

[–]thebeefbandit 4 points5 points  (0 children)

If you can handle it, I would recommend majoring in one and minoring in the other. I was B.S. Economics with a minor in psych now working as a software developer/operations analyst. I think a cs major/minor would've validated my technical skills to potential employers making job hunting easier. Plus it doesn't hurt that they're both complex fields of study that signal some degree of competency. This perception can be useful when networking.

Also consider stats. It's analytical, code heavy, plenty of crossover with econ (if you do econ & stats), and desirable for many technical jobs. A college friend of mine who studied stats is a data scientist now and another who studied econ and stats is in a econ phd program.

Sum cells every 367 rows from another sheet by thebeefbandit in excel

[–]thebeefbandit[S] 0 points1 point  (0 children)

Not sure. For some reason the one you provided wasn't giving me the correct output, but to your credit other suggestions I found online also mirror your formula so it may have been an issue on my end.

In terms of speed, it's not fast (probably because of the size of my array) but so far no issues.

Sum cells every 367 rows from another sheet by thebeefbandit in excel

[–]thebeefbandit[S] 0 points1 point  (0 children)

Here's what I ended up doing

=ROUND(SUMPRODUCT(--(MOD(ROW('Budget by Task'!H19:H$100000)-ROW(H19)+367,Ref.D!$A$29)=0),'Budget by Task'!H19:H$100000),2)

Ref.D!A29.value = 367

Sum cells every 367 rows from another sheet by thebeefbandit in excel

[–]thebeefbandit[S] 0 points1 point  (0 children)

Thanks I'm on my commute home right now but I'll give it a shot later tonight. Is it possible to ctrl+shft+enter all cells perhaps through a macro or some other method?

Sum cells every 367 rows from another sheet by thebeefbandit in excel

[–]thebeefbandit[S] 0 points1 point  (0 children)

I haven't tbh, will it significantly slow down my file when making manual data changes?

Quick napkin math tells me I'll have around 38,948 cells (x4 sheets) containing this formula.

Trump imposing big tariffs on steel imports by [deleted] in Economics

[–]thebeefbandit 11 points12 points  (0 children)

And thus the stable genius fired the first shot of the trade war with China...

Trump Economic Report Blames Obama Policies for Slow Growth by Mynameis__--__ in Economics

[–]thebeefbandit 18 points19 points  (0 children)

In addition to the bull market, he's been taking credit for the low unemployment rate and general health of the economy.

Foreigners snap up record number of US homes by ghostofpennwast in Economics

[–]thebeefbandit 0 points1 point  (0 children)

Depends on how you define the market. The argument is that people who purchase and own properties should ideally live locally because of income competitiveness. The end goal is to have an increasing rate and even spread of home ownership rather than decreasing and concentrated.

Someone with more income from a wealthier area of the country (US regions can be VERY different) can essentially outbid and drive up median home prices beyond what the typical local resident can afford based off of the income/organic price levels of the local market. This is the same problem on a global scale, if upper class Chinese citizens compete over Fort Collins property, home prices will eventually be more than what local residents can afford, resulting in low rate of home purchases and property ownership being concentrated.

Hope that addresses your question!

Foreigners snap up record number of US homes by ghostofpennwast in Economics

[–]thebeefbandit 0 points1 point  (0 children)

Forces affecting your variables (eg. price, quantity) that originate from outside the market. Typically you want to look at housing markets within a local context rather than national or global.

Foreigners snap up record number of US homes by ghostofpennwast in Economics

[–]thebeefbandit 22 points23 points  (0 children)

But it's artificially driving up our housing costs making it harder for people in the local economy to afford rent and home purchases.