Our search for keyword “Marketing Data Analysis” on India’s leading job portal resulted into 47,000 job offers, of these jobs 40,000 are directly offered by Companies. Is this not a right career to choose? Why wait and think. Join this course and learn how to perform marketing data analysis from scratch to hypothesis testing using MS-Excel.
From this course earn how to create data tables, data entry form, listed data entry form and enter data in MS Excel. Also learn how to create frequency distribution tables and cross tabulations, draw pivot charts, how to run descriptive statistics, and inferential statistics of Marketing data in Excel.
How to create marketing data Tables and Forms in Excel
Learn how to create data table in excel and enter market research data. Know about data validation tool and how to use it for error proof entry of demographic data.
Learn how to create data entry form in Excel. Also know how to enter marketing research data in Excel data table using Excel data entry form.
Learn how to create drop down list to enter market research data in Excel data table. Know the application of data validation - List option to create and use drop down list.
With marketing data entry form or data validation you may have entered variable options in numeric values in Excel. From this lecture learn how to convert numeric data in text option names.
Marketing Data Pivot Tables and Pivot Charts
Learn how to draw frequency distribution table using Excel Pivot table option. Also know how to copy, paste, and edit pivot table in Excel as well as in Word document.
Learn how to create cross tabulation or cross tabs in Excel using Pivot Table option. In marketing research data analysis cross tabs are very helpful and gives preliminary insights about customers.
Learn how to draw pie chart of a marketing research data using Excel Pivot Chart option. Also know how to edit chart and copy to Word document.
Learn how to draw column chart of a marketing research data using excel pivot table chart option. Also learn how to edit, give axis names and copy pie chart to word document.
Categorical Data and Rank Data Analysis
Learn how to run chi square test from raw marketing research data using pivot table and Excel functions.
Learn how to run chi square test in Excel. Know how to convert data collected from customers in to contingency table and then calculate chi square test.
Learn how to run Spearman's rank correlation on real time marketing research data using Excel.
