Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart

Video about: Frequency Distributions, Relative Frequency Distribution and Percent Frequency Distribution & Column Chart for Categorical Data
Learn:
1) (00:17) Introduction to Frequency Distribution and our Large Data Set
2) (01:08) PivotTable: Frequency Distribution for Categorical Data
3) (02:17) PivotTable Show Values As, % of Column Total: % Frequency Distribution for Categorical Data
4) (03:26) Why Formula for Frequency Distribution for Categorical Data?
5) (03:52) Create Unique List from a Field using Advance Filter, “Unique records only”
6) (05:06) COUNTIFS function with Sheet References for Frequency Distribution
7) (07:11) Formula for % Frequency
8) (07:35) Column or Bar Chart for Categorical Data Frequency Distributions
9) (10:15) Column Chart for Discrete Quantitative Data
10) (11:25) Conclusion

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[onpoc]

Thanks for the videos and the enthusiasm you put in your work.

How do you do the automatic formating for formulas at 5:07?

Thanks again :)

[ronleeee]

Hi just wanna ask. say I wanna rely on pivot table to create a bar chart but I can't seem to create a chart without the frequency field. How do i do that.

[BraveSupat]

Where I can find some other raw sales data sample?

[lissetdiaz]

How I can select invoices with foreign currency and converted in US dollars with out affecting de rest of the invoices en US dollars.
I love your videos