Using the DAVERAGE dаtаbаse functiоn in Excel, calculate the average tip amоunt fоr customers who meet all of the following criteria in the provided dataset: The meal was Dinner The day was Sunday The total bill was greater than $15 The party size was 2 or more
Pаrt III: Essаy (40 pоints)• Chооse one of the following topics аnd write a terrific, far-reaching essay, one that is rich in insight and specific detail.• Minimum word count: 400 (“A” essays usually go well beyond the minimum); +1 for providing a word count at the end (you must type this "by hand"). • Make sure your essay has an introduction, three-four body paragraphs, and a conclusion.• Keep the introduction and conclusion short; let the bulk of the paper be the body paragraphs.• Bring in numerous specific details from the work, and reference key ideas from class discussion and the PowerPoints in your analysis. Topic A: Focusing on Staves One and Five of Dickens' A Christmas Carol, discuss the moral transformation of Ebenezer Scrooge. How does Scrooge change in his treatment of his fellow human beings? How and why has he evolved? In your essay, discuss the following scenes in detail, incorporating specific detail from both Stave One and Stave Five to prove your assertions. You may also draw from any other stave you think relevant to the topic: The “portly gentleman” he encounters (one body paragraph) His nephew Fred (one body paragraph) His employee, Bob Cratchit, and his family (one body paragraph) Note: ** You may add an additional body paragraph where you expand any of the previous sections from one paragraph to two, or discuss anything else you think relevant to this topic. Conclusion: What moral message is Dickens sending to his readers through Scrooge’s transformation? Topic B: Discuss the Rime of the Ancient Mariner as following the traditional pattern of the Christian Fall and Redemption. In your essay, be sure to do the following in one body paragraph each: --Discuss the Mariner with regard to the albatross. What “sin” does the Mariner commit and why? and how does he suffer for the sin he has committed? --Discuss the moment of transformation with the water snakes. How is he changing, particularly with regard to nature? --The Mariner at the end of his tale. What does he say about the way he lives his life? What role does religion play in it? Ultimately, what is the Mariner’s religious perspective at the end of the Rime of the Ancient Mariner? Optional: A 4th body paragraph, discussing anything else you see as relevant, or expanding one of the previous body paragraphs to two. --Conclusion: What was Coleridge’s theological purpose in the Rime of the Ancient Mariner? In what ways is it a Christian text?