Make Pie Graphs and Frequency Distributions in Excel: Categorical Data

  Рет қаралды 68,501

BurkeyAcademy

BurkeyAcademy

Күн бұрын

Пікірлер: 14
@jackforbes3011
@jackforbes3011 Жыл бұрын
I wish I had found this video last week when I was teaching myself the countif fxn. I had a large volume of data across multiple rows and columns. I was able to figure out how to use countif, but couldn't figure out how to isolate the range to keep the dataset consistent. I eventually just copied the formula and pasted it into each cell that I needed, then went back and changed the nuanced reference cell for each formula (probably close to 300 individual cells). This video would have probably saved at least 2 hours worth of work. Also, thanks for the tip on the pivot table. Couldn't quite figure out how to arrange the data on my own and didn't know the value of the tool, nor wanted to dedicate the time to understanding it unless it was relevant to my needs. Definitely going to steal some of this information for my job and my stats class. THANKS!!
@constanceflowers8407
@constanceflowers8407 3 жыл бұрын
I just wanna say thank you, this just helped me complete my statistics homework that has been stressing me for days 😭♥️
@H90M
@H90M 2 жыл бұрын
thanks man, u r the best
@JOHANABOTTIA
@JOHANABOTTIA 5 жыл бұрын
Thank you so much!!! I love your videos and show them to my little cousin! :D
@sajnak909
@sajnak909 4 жыл бұрын
Good ,Thank u so much (For finding the factors in column ,use Pivote table,Other wise very difficult to type if it more than 10 factors ,Thankyou)
@lev_7605
@lev_7605 5 жыл бұрын
спасибо мужик из интернета
@BurkeyAcademy
@BurkeyAcademy 5 жыл бұрын
Добро пожаловать You're welcome!
@nandonongthombam1914
@nandonongthombam1914 3 жыл бұрын
Sir, I find it very interesting and very valuable. kindly make the original data file in excel used in the video "Make Pie Graphs and Frequency Distributions in Excel: Categorical Data" available so that we can do understand it better. thank you
@BurkeyAcademy
@BurkeyAcademy 3 жыл бұрын
Good idea- I added a link in the video description.
@nandonongthombam1914
@nandonongthombam1914 3 жыл бұрын
@@BurkeyAcademy thank you sir very much I have got I will do practice.
@FRESHENDEAVOUR
@FRESHENDEAVOUR 4 жыл бұрын
I love your videos... so easy to follow! Is there any way to compare price (numerical) to categorical variable in Excel?
@BurkeyAcademy
@BurkeyAcademy 4 жыл бұрын
kzbin.info/www/bejne/hYnYgqGopJWIpKc
@FRESHENDEAVOUR
@FRESHENDEAVOUR 4 жыл бұрын
@@BurkeyAcademy thank you! How do I create graphs (such as simple clustered column / bar chart) in Excel? I've attempted this for the past few hours but can't seem to get the price point to appear on the y axis (it keeps remaining as the legend). Thanks!
@billysuoth1702
@billysuoth1702 5 жыл бұрын
THank you
Quantitative Data in Excel: Frequency Distribution and Histogram
20:33
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 49 МЛН
Twin Telepathy Challenge!
00:23
Stokes Twins
Рет қаралды 152 МЛН
黑天使被操控了#short #angel #clown
00:40
Super Beauty team
Рет қаралды 52 МЛН
Bar Chart, Pie Chart, Frequency Tables | Statistics Tutorial | MarinStatsLectures
7:36
MarinStatsLectures-R Programming & Statistics
Рет қаралды 104 М.
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
How to Make a Pie Chart in Excel
13:31
Kevin Stratvert
Рет қаралды 408 М.
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Leila Gharani
Рет қаралды 486 М.
Excel's dirty little secrets - 5 things it does you don't expect!
11:25
Excel Off The Grid
Рет қаралды 40 М.
Qualitative Frequency Distribution (with COUNTIF)
9:25
Paul Miller
Рет қаралды 51 М.
Using Pivot Tables For Categorical Data in Excel
8:56
Learn Something
Рет қаралды 22 М.
I never understood why you can't go faster than light - until now!
16:40
FloatHeadPhysics
Рет қаралды 4,5 МЛН
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 49 МЛН