GRAPHING ASSIGMENT # 4 - check blackboard for the due date. THIS IS COPYRIGHTED MATERIAL. You are given the following data about the utility for coffee. Total Utility (TU) is measured in 100 's of utils and the quantity of coffee (Q) is measured in number of cups of coffee consumed. You will be making a presentation about utility to your Microeconomics class. The data is listed below. The source for your knowledge about utility is from a book Coffee Utility and The Individual, 5rd edition, by Herman Franks, Pantheon Press Publishers, Toronto, Ontario, 2019. THIS IS COPYRIGHTED MATERIAL. 1 THIS IS COPYRIGHTED MATERIAL 1. a. In one clearly and accurately labeled graph, created using Excel, graph your Total Utility (TU) curve of your coffee consumption. This will be graph # 2 in your presentation. (15 pts) THIS IS COPYRIGHTED MATERIAL b. In one clearly and accurately labeled graph, created using Excel, graph your Marginal Utility (MU) curve of your coffee consumption. MU is measured in 100's utils. This will be graph # 3 in your presentation. (15 pts) THIS IS COPYRIGHTED MATERIAL. Be certain to calculate MU, which you will need for part c). c. In one clearly and accurately labeled table, created using Excel, list your data for MU, being certain to show all your work for calculating MU. This will be Table # 1 in your presentation. (15 pts) THIS IS COPYRIGHTED MATERIAL d. Based solely on your graphs in parts a and b, and specifically referencing both graphs, explain, THIS IS COPYRIGHTED MATERIAL a. where TU and MU have hit their peak and why, b. explain where and why diminishing marginal utility is located on both graphs, and c. explain where negative marginal utility is located on both curves and why. (5 pts each for a-b-c, for 15 pts total) THIS IS COPYRIGHTED MATERIAL Graphs and tables for this assignment must be properly constructed and created using Excel. Prepare your assignment as a Word document with embedded Excel charts. Number each step of the assignment. The assignment may be submitted to Turnitin as a Word or .pdf document. Be sure to include your name at the top of the assignment before submitting. This graphing assignment is worth 60 points. THIS IS COPYRIGHTED MATERIAL. GRAPHING ASSIGMENT # 4 - check blackboard for the due date. THIS IS COPYRIGHTED MATERIAL. You are given the following data about the utility for coffee. Total Utility (TU) is measured in 100 's of utils and the quantity of coffee (Q) is measured in number of cups of coffee consumed. You will be making a presentation about utility to your Microeconomics class. The data is listed below. The source for your knowledge about utility is from a book Coffee Utility and The Individual, 5rd edition, by Herman Franks, Pantheon Press Publishers, Toronto, Ontario, 2019. THIS IS COPYRIGHTED MATERIAL. 1 THIS IS COPYRIGHTED MATERIAL 1. a. In one clearly and accurately labeled graph, created using Excel, graph your Total Utility (TU) curve of your coffee consumption. This will be graph # 2 in your presentation. (15 pts) THIS IS COPYRIGHTED MATERIAL b. In one clearly and accurately labeled graph, created using Excel, graph your Marginal Utility (MU) curve of your coffee consumption. MU is measured in 100's utils. This will be graph # 3 in your presentation. (15 pts) THIS IS COPYRIGHTED MATERIAL. Be certain to calculate MU, which you will need for part c). c. In one clearly and accurately labeled table, created using Excel, list your data for MU, being certain to show all your work for calculating MU. This will be Table # 1 in your presentation. (15 pts) THIS IS COPYRIGHTED MATERIAL d. Based solely on your graphs in parts a and b, and specifically referencing both graphs, explain, THIS IS COPYRIGHTED MATERIAL a. where TU and MU have hit their peak and why, b. explain where and why diminishing marginal utility is located on both graphs, and c. explain where negative marginal utility is located on both curves and why. (5 pts each for a-b-c, for 15 pts total) THIS IS COPYRIGHTED MATERIAL Graphs and tables for this assignment must be properly constructed and created using Excel. Prepare your assignment as a Word document with embedded Excel charts. Number each step of the assignment. The assignment may be submitted to Turnitin as a Word or .pdf document. Be sure to include your name at the top of the assignment before submitting. This graphing assignment is worth 60 points. THIS IS COPYRIGHTED MATERIAL
