Ch 2 Excel HW 9.6.17.xlsx - a Using Excel Draw the Production Possibility Curve(PPC for Drugs v A B C D E F G H I J K Prescription Natural Drugs Gas 50

Ch 2 Excel HW 9.6.17.xlsx - a Using Excel Draw the...

This preview shows page 1 - 6 out of 6 pages.

a.) Using Excel Draw the Production Possibility Curve (PPC) Prescription Natural Drugs Gas A 50 0 B 45 10 C 40 20 D 35 30 Natural E 30 40 Gas F 25 50 G 20 60 H 15 70 I 10 80 J 5 90 K 0 100 Prescription Drugs How to draw the Graph using Excel 1. Using the curser highlight the numerical data. 2. Click on INSERT 3. From the chart menu select the scatter plot with a line and click on it 4. The graph will appear. Move it to the desired location. b.) An enhanced fracking solution increases gas production by Prescription Natural Drugs Gas A 50 0 B 45 12.5 C 40 25 Natural Gas D 35 37.5 E 30 50 F 25 62.5 0 10 20 30 40 50 0 20 40 60 80 100 120 Chart Title 80 100 120 140 Chart Title
Image of page 1

Subscribe to view the full document.

G 20 75 H 15 87.5 I 10 100 J 5 112.5 K 0 125 Prescription Drugs c.) A R&D break trough increases drug production by 50% us Prescription Natural Drugs Gas A 75 0 B 67.5 10 C 60 20 D 52.5 30 E 45 40 Natural F 37.5 50 Gas G 30 60 H 22.5 70 I 15 80 J 7.5 90 K 0 100 Prescription Drugs d.) An increased supply of lower priced labor could result in Use Excel to draw the new PPC. What is the effect of the new Prescription Natural Both Natural Gas and Prescription Drugs are increasing Drugs
Image of page 2
Image of page 3

Subscribe to view the full document.

Image of page 4
Image of page 5

Subscribe to view the full document.

Image of page 6
  • Spring '14
  • GeraldAbdesaken
  • Harshad number, Use Excel, solution increases gas production

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes