Сравниваем доходность акций с Google Sheets from Coursera

В этом курсе-проекте продолжительностью 1 час вы получите следующие навыки: сравнивать эффективность различных ценных бумаг, используя финансовую статистику (нормальные распределения) и инструментарий Google Таблиц, чтобы решить, инвестиция в какую ценную бумагу является исторически наиболее эффективной с точки зрения отношения риска к прибыли ( отношение риска к вознаграждению). Это научит вас базовому управлению рисками с использованием количественного анализа с помощью вычисления средней доходности акций, дисперсии, стандартного отклонения, коэффициента Шарпа и коэффициента Сортино. Примечание. Этот курс изначально создан для учащихся из Северной Америки. На данный момент мы адаптируем его и для других регионов. Содержание этого курса не является инвестиционной рекомендацией и не представляет собой предложение о проведении каких-либо операций на регулируемом или нерегулируемом финансовом рынке.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Useful for individuals looking to strengthen existing foundations in quantitative analysis and risk management applied to the finance industry

Applicable to professionals seeking to make data-driven investment decisions involving financial assets

Relevant to students pursuing advanced degrees in finance, economics, or business administration

Instructors are experts in the finance industry, providing credibility to the course content

This course assumes prior knowledge of statistics, probability, and financial concepts

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Сравниваем доходность акций с Google Sheets with these activities:

Review previous coursework or study materials on basic statistics

Show steps

Refresh knowledge on basic statistics and probability to build a solid foundation.

Browse courses on Statistics

Show steps

Review notes or textbooks from previous statistics courses.
Complete practice problems or quizzes to test understanding.

Join a study group and collaborate on practice problems

Show steps

Engage withpeers to discuss concepts, solve problems, and enhance understanding.

Show steps

Join or form a study group with other course participants.
Schedule regular meetings to work on practice problems together.

Solve practice problems on Google Sheets

Show steps

Utilize Google Sheets to solve practice problems and gain familiarity with financial calculations.

Browse courses on Google Sheets

Show steps

Set up a Google Sheet and input the necessary data.
Use Google Sheets formulas to calculate mean, variance, standard deviation, and other financial metrics.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Review required textbook

Show steps

Review the required text to reinforce prior knowledge of basic statistics and mathematical formulas.

Show steps

Read chapters 1-3 to review descriptive statistics and probability distributions.
Complete practice problems at the end of each chapter to test understanding of concepts.

Follow online tutorials on Google Sheets functions

Show steps

Access online tutorials to enhance understanding of Google Sheets functions and their application in financial calculations.

Browse courses on Google Sheets

Show steps

Identify relevant Google Sheets functions for financial calculations.
Use online tutorials to learn the syntax and usage of these functions.

Create a financial data visualization dashboard in Google Sheets

Show steps

Develop a dashboard to visualize and analyze financial data, demonstrating proficiency in Google Sheets and data visualization.

Browse courses on Data Visualization

Show steps

Gather relevant financial data from multiple sources.
Create charts, graphs, and other visuals to represent the data.

Contribute to open-source projects related to financial data analysis

Show steps

Contribute to real-world projects to enhance technical skills and gain exposure to practical applications.

Browse courses on Data Analysis

Show steps

Identify open-source projects related to financial data analysis.
Review the project documentation and codebase.

Career center

Learners who complete Сравниваем доходность акций с Google Sheets will develop knowledge and skills that may be useful to these careers:

Equity Analyst

An Equity Analyst is a financial professional who provides equity research and advice to institutional clients. This course can help you develop the skills needed to be an Equity Analyst by teaching you how to compare the performance of different stocks using financial statistics and Google Sheets. This will help you make more informed decisions about which stocks to recommend to your clients.

See salaries and explore the career path for Equity Analyst

Portfolio Manager

A Portfolio Manager is a financial professional who manages investment portfolios for individuals and businesses. This course can help you develop the skills needed to be a Portfolio Manager by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about how to allocate your clients' assets.

See salaries and explore the career path for Portfolio Manager

Investment Analyst

An Investment Analyst is a financial professional who provides investment advice to individuals and businesses. This course can help you develop the skills needed to be an Investment Analyst by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which investments to recommend to your clients.

See salaries and explore the career path for Investment Analyst

Risk Manager

A Risk Manager is a financial professional who identifies and manages financial risks. This course can help you develop the skills needed to be a Risk Manager by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about how to manage your clients' risk.

See salaries and explore the career path for Risk Manager

Quantitative Analyst

A Quantitative Analyst is a financial professional who uses mathematical and statistical models to analyze financial data. This course can help you develop the skills needed to be a Quantitative Analyst by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about how to invest your clients' money.

See salaries and explore the career path for Quantitative Analyst

Financial Analyst

A Financial Analyst is a financial professional who provides financial advice to individuals and businesses. This course can help you develop the skills needed to be a Financial Analyst by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which investments to recommend to your clients.

See salaries and explore the career path for Financial Analyst

Hedge Fund Manager

A Hedge Fund Manager is a financial professional who manages a hedge fund. This course can help you develop the skills needed to be a Hedge Fund Manager by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about how to invest your clients' money.

See salaries and explore the career path for Hedge Fund Manager

Private Equity Investor

A Private Equity Investor is a financial professional who invests in private equity funds. This course can help you develop the skills needed to be a Private Equity Investor by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which funds to invest in.

See salaries and explore the career path for Private Equity Investor

Venture Capitalist

A Venture Capitalist is a financial professional who invests in early-stage companies. This course can help you develop the skills needed to be a Venture Capitalist by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which companies to invest in.

See salaries and explore the career path for Venture Capitalist

Investment Banker

An Investment Banker is a financial professional who helps companies raise capital. This course can help you develop the skills needed to be an Investment Banker by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which companies to recommend to your clients.

See salaries and explore the career path for Investment Banker

Financial Planner

A Financial Planner is a financial professional who helps individuals and families plan for their financial future. This course can help you develop the skills needed to be a Financial Planner by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about how to help your clients achieve their financial goals.

See salaries and explore the career path for Financial Planner

Data Scientist

A Data Scientist is a professional who uses data to solve business problems. This course can help you develop the skills needed to be a Data Scientist by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about how to use data to improve your business.

See salaries and explore the career path for Data Scientist

Financial Advisor

A Financial Advisor is a financial professional who provides financial advice to individuals and businesses. This course can help you develop the skills needed to be a Financial Advisor by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which investments to recommend to your clients.

See salaries and explore the career path for Financial Advisor

Insurance Agent

An Insurance Agent is a financial professional who sells insurance policies to individuals and businesses. This course can help you develop the skills needed to be an Insurance Agent by teaching you how to compare the performance of different investments using financial statistics and Google Sheets. This will help you make more informed decisions about which policies to recommend to your clients.

See salaries and explore the career path for Insurance Agent

Teacher

A Teacher is a professional who teaches students about a particular subject. This course may be useful for Teachers who want to learn more about financial markets and how to invest. The course can help you develop the skills needed to teach your students about financial literacy and how to make sound financial decisions.

See salaries and explore the career path for Teacher