This blog will help you in knowledge hunt of Data science. The below given list will help you to find the blogs that talk about Data science easily. I hope you will find this useful.
This Infographic will assist us to understand better about the skills and responsibilities of Data Engineer and Data Scientist. Also, it helps us to compare salaries, popular software and tools used by each. Hope this helps!
Most of us know that we can do few statistical analysis using ‘Analysis Tool pack’ addin in Microsoft Excel. We can also do more than that using KADD STAT.
KADD STAT is an add-in which comes for free of cost and easy to use. Mostly all the versions after Excel 2003 would support. So, students and other people who want to use some basic statistical stuff can utilize this awesome one.
Download KADD here https://kelley.iu.edu/mabert/e730/KADD.xla
How to Install the New Version of KADD
Also see video here
If KADD is currently not stored on your computer, then use the following steps:
- Download KADD into a folder on your hard drive
- Open up Excel
- Go to the Tools option and click on Add-Ins
- Click on the Browse button (on the right side of the dialog box) and go to the folder with KADD
- Double-Click on KADD
- KADDSTAT 3.02 will now show up as an Add-In option. Check it and press OK
- KADD will then show up as a menu option across the top. You may have to close Excel and then open it up again before you see KADD in Excel across the top
IF you have already installed the older version of KADD, then use the following steps to upgrade it to the new version:
- Download KADD to your hard drive
- Open up Excel
- Go to the Tools option and click on Add-Ins. KADD (the older version) will be an option in Add-In menu. Remove it by clicking off the check mark and shut down Excel
- Now open up Excel again and follow Steps 3 through 7 from Option A
Ready to rock?
A Glance at the available list of analysis in the add-in
You can calculate probability values
- Find confidence Intervals in different scenarios
2. Plot a Normal curve
3. Plot ‘Box plots’ for your data
4. Find out minimal sample size for different scenarios
5. Perform Hypothesis testing
6. Draw different quality control charts and find out process capability for normal data
7. Find out correlation and regression
8. Become a forecasting pro ! 🙂
9. Some financial calculations
10. Find out Expected value and variability
11. Perform Decision Trees
12. Linear Programming
Doing this is simple if you have data and know what to do. Give it a try and enjoy ! Happy learning…
“If you want to become one, first get inspired by one”
There is always few interesting ways to learn things and get inspire. Would you like to know few TV shows which are based on Data science and Artificial intelligence? We always like to do the things in the way we love. Here you go & happy watching (learning)
Thanks to AV for this.
This is especially for the excel lovers! In this blog, we will see few of the new and exciting data visualization features of Excel 2016.
Here is the list of new features
- Hierarchy Chart/Tree Map
- Water fall or Stock Chart
- Transform Cold data into a cool picture
- Instant Histogram
- Pareto Chart
- 3D map
- One click forecast
These are the most wanted charts by the Dashboard creators. These are very simple and attractive. This set of features makes excel more competitive with other expensive visualization tools.
- Hierarchy Chart/Tree Map:
Select the data that you want to use for creation of the chart then Go to ‘Insert’ tab > Charts > Insert Hierarchy Chart
Isn’t it cool? OK, we go to the next one.
2. Sunburst/Donut Chart:
It is another representation of a Pie chart. An alternate to boring the Pie chart. Go to ‘Insert’ > Charts > Insert Hierarchy Chart
3. Water fall or Stock Chart
It is recommended to sort the data by any order to have the better insights.
4. Transform Cold data into a cool picture
This one is based on the Add-ins.
Select your data to visualize
Select ‘Settings’ to change the design of the charts
5. Instant Histogram:
Create histograms quickly instead of going to “Analysis Tool Pack” in add-ins. Go to Insert > Charts > Histogram
6. Pareto Chart:
Earlier, we had to customize the data structure to create ‘Pareto chart’ but now it is just a click away to explain the 80/20 principle.
7. 3D map:
Power Map, the popular 3-D geospatial visualization add-in for Excel 2013, is now fully integrated into Excel. We’ve also this feature a more descriptive name, “3D Maps”. You’ll find this functionality alongside other visualization features on the Insert tab.
It will open another sheet like below
then we can change the theme and other options like ‘2D Map’. “Play Tour” option will show an awesome chart with lively visual.
8. One click Forecast
It has become more easy for the Data analysts who do forecast.
Select the data that you want to forecast and Go to ‘Data’ tab > Click on “Forecast Sheet”
Adjust the “Seasonality” appropriately
and your forecast is ready.
Hope you like these features and much more to come from Microsoft. Try these things and enjoy !
Data visualization has become a vital slice of data science arena. Hence, our key tool should have strong capabilities on both the fronts – data analysis as well as data visualization. With this revolution in the landscape, or has extended immense popularity because of its splendid data visualization capabilities. With a few lines of code, you can produce beautiful charts and data stories. R contains superb libraries to create basic and more evolved visualizations like Bar Chart, Histogram, Scatter Plot, Map visualization, Mosaic Plot and various others. Below is the cheat sheet of widespread visualization for representing data. Thanks to my colleague for sharing this.
A very good analysis using R in the field of cricket. Must see ! 🙂
Yet all experience is an arch wherethro’
Gleams that untravell’d world whose margin fades
For ever and forever when I move.
How dull it is to pause, to make an end,
To rust unburnish’d, not to shine in use!
Ulysses by Alfred Tennyson
This is an initial post in which I introduce a cricketing package ‘cricketr’ which I have created. This package was a natural culmination to my earlier posts on cricket and my completing 9 modules of Data Science Specialization, from John Hopkins University at Coursera. The thought of creating this package struck me some time back, and I have finally been able to bring this to fruition.
So here it is. My R package ‘cricketr!!!’
This package uses the statistics info available in ESPN Cricinfo Statsguru. The current version of this package only uses data from test cricket. I plan to develop functionality for One-day and…
View original post 2,667 more words