Reference no: EM132846809

Use descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign by finding the following;

a) Frequency distribution of the Net Sales using the intervals 50-99,100-149, 150-199,...

b) Frequency distribution of the Customer Age using the interval 20-29,30-39,40-49,...

c) Compute the modal customer age.

d) Compute the median Net Sales value.

e) Compute the mean of the Net Sales.

f) Calculate the standard deviation of the Net Sales.

g) Develop a Simple Regression model to show the relationship between Customer Age (x)

and Net Sales (y). Interpret your results.

h) Find the correlation coefficient between Customer Age (x) and Net Sales (y). Interpret

your results.

i) Compute the coefficient of determination by using the above correlation coefficient and Interpret your results.