BU1007 Business Data Analysis and Interpretation

Imagine that you, as nationwide sales manager in IV, are asked by the CEO to report back on the indicators of sales force including the recent promotional program. As a result you need to prepare a statistical report (as guided by your lecturer on LearnJCU), and use the method of descriptive statistics you learned so far to summarise the data, and comment on your findings. In preparation of this report, you must use excel to generate results.
At minimum your report should address the following questions:
1-What are the variables in this database (name them), what scale of measurement is used for each variable, and what are the types of these variables?
2-Is the data collected in this sample cross-section or time series? Explain your answer.
3-Provide a table in which you summarise complete descriptive statistics on “net sales” (including but NOT limited to: measures of central location, measures of variability, etc.), then use the information in the summary table you prepared to calculate the coefficient of variation for “net Sales”. What insights you could potentially gain from these results?
4-Develop complete frequency table/s to make inferences on the “gender” and the “marital status” of costumers in the sample data. Carefully interpret your table/s.
5-Calculate the correlation coefficient between “age” and “net sales”. Interpret the result. 
6-Create a bar chart to show comparisons between types of credit cards used in the sample data (where the vertical axis is the frequency and horizontal axis represents card types).
Create another bar chart to show comparisons between types of customers in the sample data, using your findings for this question; do you think the promotional program has been effective and/or successful? Explain.