Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

GRAPHING ASSIGMENT II 4 - check blackboard for the due date. THIS IS COPYRIGHTED MATERIAL. You are given the following data about the utility for

image text in transcribed
GRAPHING ASSIGMENT II 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, 5'd edition, by Herman Franks, Pantheon Press Publishers, Toronto, Ontario, 2019. THIS IS COPYRIGHTED MATERIAL. Total Utility (TU) 0 10 17 25 31 35 35 26 18 Quantity of coffee 0 1 2 3 4 5 6 7 8 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 It 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 abc, 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Economics questions

Question

What is an Internet pure play, and what are some examples?

Answered: 1 week ago