World Wide Training and Assistance for Electrical, Computer Science and Electronics Engineering

Good analysis follows a repeatable path. This data analysis workflow works whether you use Excel, Google Sheets or MATLAB. Need help with data analysis workflow? Message Senthil Kumar on WhatsApp: +91-9952749533 1. Define the question State what decision the analysis will support. 'Why did downtime increase last quarter?' is a better starting point than 'analyse the maintenance data'. 2. Gather and clean Collect all relevant data, merge files and fix errors, duplicates and gaps. Keep a copy of the original. 3. Explore Look at summaries, ranges, trends and distributions. Plot the data. Exploration often reveals problems and ideas you did not expect. 4. Analyse Apply suitable methods such as averages, comparisons, correlations, regression or time-series analysis. Match the method to the question and the data. 5. Visualise Choose charts that make the answer obvious. Keep them simple, labelled and consistent. 6. Report and recommend State the main find...

Good analysis follows a repeatable path. This data analysis workflow works whether you use Excel, Google Sheets or MATLAB. Need help with data analysis workflow? Message Senthil Kumar on WhatsApp: +91-9952749533 1. Define the question State what decision the analysis will support. 'Why did downtime increase last quarter?' is a better starting point than 'analyse the maintenance data'. 2. Gather and clean Collect all relevant data, merge files and fix errors, duplicates and gaps. Keep a copy of the original. 3. Explore Look at summaries, ranges, trends and distributions. Plot the data. Exploration often reveals problems and ideas you did not expect. 4. Analyse Apply suitable methods such as averages, comparisons, correlations, regression or time-series analysis. Match the method to the question and the data. 5. Visualise Choose charts that make the answer obvious. Keep them simple, labelled and consistent. 6. Report and recommend State the main find...