Answer:
To develop a customer profile and evaluate the promotional campaign, we can use tabular and graphical methods of descriptive statistics on the "customer data set" Excel file. Descriptive statistics is a methodology to describe data, and it summarizes, organizes, and represents data from a vast raw database in a clear and concise manner.
Descriptive statistics consists of three basic categories of measures: measures of central tendency, measures of variability (or spread), and frequency distribution.
To develop a customer profile, we can use measures of central tendency such as mean, median, and mode to determine the average age, income, and subscription length of the customers. We can also use measures of variability such as standard deviation and variance to determine the spread of the data and identify any outliers. We can use frequency distribution to determine the distribution of customers across different age groups, income levels, and subscription plans.
To evaluate the promotional campaign, we can use graphical methods such as histograms, scatter plots, and box plots to visualize the data and identify any patterns or trends. We can use a histogram to show the distribution of subscription lengths and identify any peaks or clusters. We can use a scatter plot to show the relationship between age and income and identify any correlations. We can use a box plot to show the distribution of income across different subscription plans and identify any outliers or differences between plans.