登录查看更多内容

R Explained for Excel Users: What is a Vector?

George Mount

Analytics & AI for Modern Excel ?? LinkedIn Learning Instructor ?? Microsoft MVP ?? O'Reilly Author ??

发布日期: 2017年5月25日

An essential step toward understanding any information system is defining its building block, or lowest common denominator.

What is the most granular level of information that cannot be drilled down into any further? How do these building blocks interact to form higher levels of information?

The cell is the basic unit of information in an Excel workbook. R’s building block is the vector. While similar in theory, vectors are used a bit differently in R than cells are used in Excel.

Continue Reading...

(Apologies for the outbound link. The GIFs used in this post were not loading correctly in LinkedIn.)

Jon Fedor

Product Leader - Expert in Product Lifecycle Management, SAFe agile, and Cross-functional Collaboration

7 年

This was great! I read the piece on your website - the GIFs were really instructive to illustrate the relationships between cells and vectors in R. Thanks!

1 次回应

查看更多评论

要查看或添加评论，请登录

George Mount的更多文章

Free white paper: Five things Excel users should know about Python

2021年8月2日

Free white paper: Five things Excel users should know about Python

If you’ve visited my blog before you’ll know that I see Excel as a valuable slice of the data analytics stack. In fact,…
Five Reasons I Wrote Advancing into Analytics

2021年3月6日

Five Reasons I Wrote Advancing into Analytics

The thing that struck me about writing a book is just how much it is like starting a business: you can do your research…
The future of analytics may be “low/no-code” … at first

2021年1月17日

The future of analytics may be “low/no-code” … at first

You can’t get through much datascrolling these days without hearing about the rise to dominance of so-called “low- and…

1 条评论
Five myths about learning data analytics

2020年9月19日

Five myths about learning data analytics

I grew to loathe math in school, which culminated in me getting a “D” in one semester of algebra. So it seems nuts that…

3 条评论
Why Excel is the best way to learn data analytics

2020年8月3日

Why Excel is the best way to learn data analytics

The more I advance into analytics, the more I come back to Excel as a teaching and prototyping cool. Yes, of course…
Demo guide: The central limit theorem in Excel

2020年6月7日

Demo guide: The central limit theorem in Excel

Excel is not just a powerful tool for doing data, but for learning it: spreadsheets provide an unparalleled opportunity…

2 条评论
What makes a good analytics course?

2020年5月2日

What makes a good analytics course?

I recently had the pleasure of speaking with John David Ariansen of the How to Get an Analytics Job podcast. I…
Demo guide: Coin tosses in Excel

2020年4月20日

Demo guide: Coin tosses in Excel

I love teaching data using examples from everyday life. And what’s more quotidian than coins? Plus, the third week of…
The law of large numbers, visually demonstrated in?Excel

2020年4月13日

The law of large numbers, visually demonstrated in?Excel

I know very little about gambling. But these very literal “games of probability” make great examples for teaching…
Building your data academy: Presentation and slides

2020年4月7日

Building your data academy: Presentation and slides

In September 2019, McKinsey called for the rise of the in-house “analytics academy” to up-skill employees’ data…

See all articles

R Explained for Excel Users: What is a Vector?

George Mount

Analytics & AI for Modern Excel ?? LinkedIn Learning Instructor ?? Microsoft MVP ?? O'Reilly Author ??

George Mount的更多文章

社区洞察

其他会员也浏览了

Paste Special Operations in Excel (Add and Subtract)

"What we know about spreadsheet errors"

Binomial Option Pricing Model with Excel VBA (for European Options)

Excel : How to do running Count of Duplicates Entries

Quick Excel Tip: Alphabetizing Tabs Made Easy

(MS Excel)Tip of The Day- Line Breaks and Wrapping Text

Excel Guideline #15: Keep Formulas Short

Excel guideline #13: Keep Formulas Close to their Input

Inflow Outflow (Flow) Parallel Plots - Track Your Budget Flow with JMP Graph Builder

R Explained for Excel Users: What is a Directory?

George Mount的更多文章

Free white paper: Five things Excel users should know about Python

Five Reasons I Wrote Advancing into Analytics

The future of analytics may be “low/no-code” … at first

Five myths about learning data analytics

Why Excel is the best way to learn data analytics

Demo guide: The central limit theorem in Excel

What makes a good analytics course?

Demo guide: Coin tosses in Excel

The law of large numbers, visually demonstrated in?Excel

Building your data academy: Presentation and slides

社区洞察

其他会员也浏览了

Paste Special Operations in Excel (Add and Subtract)

"What we know about spreadsheet errors"

Binomial Option Pricing Model with Excel VBA (for European Options)

Excel : How to do running Count of Duplicates Entries

Quick Excel Tip: Alphabetizing Tabs Made Easy

(MS Excel)Tip of The Day- Line Breaks and Wrapping Text

Excel Guideline #15: Keep Formulas Short

Excel guideline #13: Keep Formulas Close to their Input

Inflow Outflow (Flow) Parallel Plots - Track Your Budget Flow with JMP Graph Builder

R Explained for Excel Users: What is a Directory?