UCSD MSBA 面经整理 [2020.05.08]

谁能想到 UCSD 如今还在发 offer 呢？

Timeline:

11 月下旬交齐材料（赶的是 12.01 R1 的 ddl）
02.15 做完 kira
5 月收到录取……（3 月到 4 月期间发了若干类似 love letter 的东西，都被打太极已不痛不痒的方式回复了，真的已经绝望）

谁能想到？ lz 其实已经做好去大森林的准备了，但是森林一直没有给应对疫情的举措，超级害怕一直网课，所以如今 SD 捞了我不如就从了他……真香。

不敢说我的面经是全站最全的，但一定是为数不多带答案的，造福后人。当时被估计题弄的脑壳痛，最后面试的时候遇到的是估计“大海中有多少条鱼”，用抽样估计的思路去回答的，这一套路也可以用来估计“树林中有多少只猴子” “草原上有多少匹马” 笑死对这个项目感兴趣的小可爱看这里，搬运了一下资料：

BG:本科 TOP 10 985 会计，GPA 4.0/5.0(10%) T（102）GRE(325)

Video（其他 45s 准备 90s 回答，估计题 2min 准备 + 2min 回答）

职业规划 & 未来期待长期 & 短期

What does the year look like after you graduate from your Master's program here at the Rady School of Management in terms of your career?
What companies, functions, jobs, or industries interest you the most?
User data analyst upon graduation

估计题

提出 assumption, 但没说需要 3 个 information,what pieces of information would you need to know to come up with a more accurate answer.
please share with us your assumptions. Also, please share the three pieces of information you would need to know to get a much more accurate answer.

Estimate the number of 10 years old in your country.
Total population:1.4 billion
One quarter: 0.3 billion 0-15 years
Even distribution：The fertility rate is steady 11-15 1/3；6-10 1/3(平均分布 1/5 0.02 billion = 20 million)；0-5 1/3
How you would determine how many loaves of bread are consumed in a single day around the world? How did you come to this number and what assumptions are you making? What pieces of information would you need to know to come up with a more accurate answer?
7.6 billion，1/2 有吃面包的习惯
2 loaves of bread could feed a family for breakfast
People only eat bread for breakfast
7.6/4(four people in a family)* 1/2 * 2 = 1.9 billion loaves of bread
假设从地球走路走到月球是可行的，需要几年时间？
月球到地球的平均距离为 363,300 kilometers
假设人的步行速度为 1.5 米每秒(5.4km/h)
平均一天休息（包括睡觉进食和中途休息）大约能达到 10 个小时
也就是每天步行 14 小时，那么一天可以前进 75.6 公里
行完全程大约要 4806 天，一年 365 天，大约 13 年
中国人买鞋花多少钱？拖鞋呢？
How much money is spent in total on shoes by everyone living in your country? How much of that is spent on sandals?
The rich: 20% 0.28bl 10 pairs each year, ￥1000 2.8 billion
The poor: 80% 1.12bl 3 pairs each year, ￥500 1.68 billion
￥4.48 billion
人一辈子要睡多长时间的觉
75 years
0-6: 15h 365x15x6
7-18:11h 365x111x2
19-50: 9h 365x9x31
51-75:8h 365x8x25
255,865 hours, which is around 30 years
中国最大的城市有多少辆出租车？How many taxi cabs are there in the largest city in your home country? How many are currently being driven and how many are not?
With the largest population: Chongqing
The resident population：30 million
The resident population(travelling)：25 million
90% private cars, bus, subway and bicycle
10% taxi 2.5 million twice a day
2,500,000x2=5,000,000
500 万流动人口=Xx30(每天接的趟数)x2.5（每次接的乘客数）
Around 67,000 taxes
With the largest area: Hulunbeier
262,062 square kilometers
你的 hometown 每天扔多少饮料瓶，有多少塑料瓶？多少玻璃瓶？哪三个信息能让你更准确的估计？
Total population:4,700,000人 3 people/family 1,600,000 个家庭
牛奶、果汁、矿泉水、汽水……
How many bottles are generated for each family?
90% plastic bottles
10% glass bottles
你的 hometown 有多少 gas station?又有多少 electronic charging station?
4,700,000 人 3 1,600,000 个家庭
50% own cars 800,000
Trip rate: 60% 480,000
One gas station: 2000 cars
Around 240 gas station
此时此刻全世界有多少飞机在天上飞？
On average, there are 100,000 classes of flights around the world every day 1day=24h=24x3600s
There are 1.15 flights in the sky per second
数到 1 Million 要用的时间？
位数个数每个数字用时用时
1-9 9 0.03 0.27
10-99 90 0.05 4.5
100-999 900 0.1 90
1000-9999 9000 0.15 1350
10000-99999 90000 0.2 18000
100000-1000000 900001 0.25 225000.25
2444445s=4074min=68h
25kg 的大米有多少米粒？
100 粒：2g
1 粒：0.02g
25000g/（0.02 g /粒）=1.25million 粒
全世界海洋里有多少条鱼？
目前全球已命名的鱼种应在 26000 种以上。
一支圆珠笔能写多远？
书写长度一般在 300~600 米的样子，少数可以达到 1000 米
ball point pen refill
capacity
How many people worldwide are in automobiles at any given time? 2011：1billion；2005：0.8billion；2020:1.4billion
奔跑数量 40%=0.56 billion
5 people/car
2.8billion people
Tell me how you would determine the number of times you could say the English alphabet in 24 hours.
Read New York Times
Prepare for English interviews
Movies/English music
How many pieces of popcorn does it need to be filled in the cinema? 有多少没爆开的？
32oz, 46oz, 85oz
60L 1.5ml 约为 40,000 粒
40,000x2=80,000 Litre
损毁率：1/10 4,000 没爆开
If you played your favorite song continuously for a year, how many times would it play? How did you come to this number and what assumptions are you making?
5min
40min=8times
365x8=2920 times
How many keys do you think are owned by people in your country? How many of these keys are used on a daily basis? As you come up with the answer to this question?
1.4billion 4people/family
0.35billion families
4 大门 4 屋门 1（车库/地下室） 2车锁 1 牛奶箱/报箱 2 other(备用/其他用途)
2.8 billion keys
5/8 of them
你的 hometown 有多少 light bulb?早上十一点时大概有多少是开着的？
Please tell me how you would determine the number of light bulbs used in your hometown. How would you come to this number, and how many of them are on any given day at 11:00am? How did you come up with this number?
淄博
4,700,000 人 1,600,000 个家庭
城镇化率：70%
农村家中灯泡数量：30% 480,000户x3盏灯/户=1,440,000盏灯
路灯数量：100,000盏
总数：1,540,000 bulb
全世界一天喝掉多少杯咖啡，其中有几杯是加糖的？
人口：7.6billion，1/3 有喝咖啡的习惯
2.3billion cups of coffe
2/3 1.53 cups of coffe

编程技术类

applications you prefer, and how you expect to use that in your future.

Share with me the most complex programming that you've done to solve a situation. What program was used? How did you use it, and why did you choose that? Is that the programming language that you prefer? Please share any details with us about your abilities in programming so that we understand your abilities and what you will bring into this class.
Data source: cube&sell-in
Excel vlookup &sumif&vba tools

理论知识类

Share with us the courses relating to statistics, probability and regression. How did you use it on daily life or projects?
Business Statistics: variable chemical industry 100 companies annual reports R square p value
Categorical variable & Qualitative variable

Writing

项目经历 It’s important to be able to describe complex ideas in simple terms. Think about a complex problem you worked on recently. Please write an email describing this problem to an acquaintance who doesn’t have a technical or quantitative background. Be sure to describe the original issue and goal, your approach, the tools used, the solution and/or outcome, and what you learned.
Dear XXX
It is my pleasure to describe this problem which occurred yesterday and its solutions to you.
In this case, I was required to analyze reasons for severe sales decline of Mini channel in west China based on the sales data so as to assist the fund allocation strategy. I extracted data of Mizone beverage from database and accessed it through pivot tables in Tableau. By disassembling the sub-channels, I found it was the clients who originally belonged to Mini in 2018 but converted to CVS in 2019 that resulted in shrink of Mini channel. Therefore, it was still necessary to invest money on mini channel rather than give it up. This precious case allows me to see through surface of data and get essence of business, during which I had a deeper understanding of the combination of data and business.
学校的 faculty 会时常与学生讨论分享一些学生所关心的问题，写封邮件给一位 professor,约他一起讨论问题。
Rady 的学生都要跟老师多 make connections.请写一封邮件给你一个 professor,请求见一面讨论一个 course related problem. Dear Professor XX
I am Sunny in your class this semester. I met some trouble when doing the project based on the data you provided. I have tried all kinds of methods but still failed to draw the correct graph on the dashboard. I feel really disappointed and eager to your help.
I would like to know whether we could have a discussion recently so that you could give me some useful suggestions about my problem? Please let me know if you are available this week!
Best wishes
Sunny
Rady School 的一位 alumni 很愿意用开咖啡茶话会的方式跟学生探讨将来找工作的事，并为在校生提供工作机会等等。请你写一封邮件，跟这位 alumni 约一次 after lunch coffee meeting 大致是这个意思。
Dear friend,
How is it going? I’m Sunny, who is going to join in MSBA program in Rady business school this autumn. Hearing that you are willing to share valuable information about job searching, I am eager to have a discussion with you! According to the information on homepage, this program is career-oriented and lasts for only 12 months, so it seems to be quite demanding for international students to find an ideal job with hardcore knowledge and limited time. Therefore, I do hope to make early preparations for internship or full-time positions such as job opportunities and career path for Business Analytics students. I know you are really warm-hearted and may have an enlightening view about the problems bothering me, so I sincerely hope to invite you to in the café next to your office this weekend. Please let me know if you are available!
Best wishes
XXX
假设你是 rady 的一名校友，写信给一个 Admission Committee 推荐你的一个同事或朋友。The decision to join the Rady MFin program is one that will forever become a part of your identity as a future alumnus of the School. Our graduates are great recruiters because they have been through the MFin program and know what it takes to be successful. Imagine that you are a Rady alumnus, and write an email to the Admissions team recommending a colleague or friend to the MFin program.
Dear officer in admission committee,
How is it going? This is Sunny, the graduate from Rady business school three years ago. Thanks to this program, which provided me with the best platform to strengthen my professional competence and rich alumni resources, I finally realized my long-cherished career goal as a business analyst. Today, I sincerely recommend an applicant who matches well with the student profile of MSBA program.
I met her in the company where I work in and she is the intern in our team. Overall, she is highly intelligent and has good analytic skills. She is proficient in applying SQL to acquiring and processing data in complex business scenarios. Furthermore, she is a well-disciplined, industrious girl with a pleasant personality. She goes well beyond the requirements in the quantity and quality of our projects, showing great perseverance and initiative. If her performance in my team is a good indication of how she would perform as a graduate student, she would be an extremely positive to MSBA program!
Please do not hesitate to contact me for further information. I do hope this program could scale new heights and admit more excellent students! Best wishes,
XXX
Rady 会邀请很多 speaker 来演讲，会有很多 student 和 alumni 来听，请写邮件邀请一位你在 speaking event 里面遇到的人（应该是指学生和校友，到时候再仔细看看吧）参加社交活动。
Dear XXX
Warm greetings from Sunny! How is it going recently? It’s my pleasure to meet you in the speaking event last weekend and I was impressed by your humorous words. I heard that a social club activity is going to be held this weekend in the lion building, which aims at promoting communication among students in business school. I consider it to be a great chance to make new friends and know more alumni who are willing to share career opportunities with us. Do you want to go with me together?
Please let me know if you have time!
Sincerely,
XXX

--------------------------------------

原文引自：
https://forum.chasedream.com/thread-1368571-1-1.html

参与讨论及查看更多的相关文章请访问【商学院Master申请区】
https://forum.chasedream.com/forum-14-1.html