Agec 352 Hmwrk 1 - 3. Given the Excel spreadsheet below,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework 1: AGEC 352 Due at beginning of Lab next Tuesday (January 19) 1. Which answer below best describes your comfort level with MS Excel? a. Expert User b. Very comfortable c. Somewhat comfortable d. Novice user e. Never used 2. Why is the XY (Scatter) the most appropriate tool for graphing economic functions? To  get some insight into this you might try graphing a function with irregular X intervals and  comparing the line graph (using the X values as labels) to the XY (Scatter). The XY (scatter) is more appropriate because it treats the x-axis values in a numerical way  unlike other ways that treat x-axis values as categories that are spaced evenly.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. Given the Excel spreadsheet below, write the sumproduct formula that calculates Total Variable Cost. Excel formula: =SUMPRODUCT(B3:D3,B4:D4) Total variable cost = 10085 4. Write an Excel formula for Unit Cost of each of the products given the levels indicated in the spreadsheet in Question 3. Unit cost is defined as the Total cost (fixed plus total variable costs) for a product divided by the number of units produced. Product A Product B Product C = ((B3*B4) +B2)/ (B4) =((C3*C4)+C2)/(C4)=((D3*D4)+D2)/(D4) Unit Cost=$11.20 Unit Cost=$5.32 Unit Cost=$8.22...
View Full Document

This note was uploaded on 03/01/2010 for the course AGEC 352 taught by Professor Staff during the Spring '08 term at Purdue University-West Lafayette.

Page1 / 2

Agec 352 Hmwrk 1 - 3. Given the Excel spreadsheet below,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online