• Respond to the exam items below.
• Data analysis is required.
- Use the attached Excel files to complete the analysis.
• Answer all questions in two pages or less, in a Word document.
• When graphs are required, make them in Excel and then paste them into the Word document.
Each item is worth 25 pts:
1) Question:
a. In a paragraph, explain what Business Analytics is, give real-world examples.
b. In a paragraph, explain what Lifetime Value of a Customer is (LTV) and how it is used in CRM.
2) Open the MakeupSales file:
a. Clean the file. It is the policy of management to remove any observation that contains an error or is missing data, even one datum. How many observations remain in the cleaned file?
b. Who is the leading sales rep in sales revenue? Who is the weakest?
c. What product line generates the most sales revenue? What line is the weakest?
d. Which is the strongest sales region (east, midwest, south, west)?
e. Use professional quality graphs with discussion for b, c, and, d.
3) Question:
In two paragraphs, explain Relational Databases and Non-Databases (this would include definitions of both as well as discussion on database design, types of data, how they are different).
4) Open the Cereal Cluster file:
a. Assume the file has been cleaned.
b. Run a cluster analysis in Excel using k-means, presume 3 clusters.
c. Choose 3 variables to use in discerning cluster membership.
d. When you find your 3 clusters, investigate them quantitatively and compare the clusters on the variables you chose.
e. Use a professional quality graph and table for d and include discussion.
