Our orders are delivered strictly on time without delay 
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.
