Assignment
1. Show that EWMA smoothing is equivalent to an ARIMA{O, 1,1) model with no constant, as described in Chapter 8, "Advanced Analytica l Theory and Methods: Time Series Analysis."
2. Develop and test a user-defined aggregate to calculate n factorial {n!), where n is an integer.
3. From a SQL table or query, randomly select 10% of the rows. Hint: Most SQL implementations have a random() function that provides a uniform random number between 0 and 1.
4. Discuss possible reasons to randomly sample records from a SQL table.
5. Describe four common deliverables for an analytics project.
6. What is the focus of a presentation for a project sponsor?
7. Give examples of appropriate charts to create in a presentation for other data analysts and data scientists as part of a final presentation. Explain why the charts are appropriate to show each audience.
8. Explain what types of graphs would be appropriate to show data changing over time and why.
9. As part of operationalizing an analytics project, which deliverable would you expect to provide to a Business Intelligence analyst?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.