{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Agec 352 Hmwrk 1

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

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

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.

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

View Full Document
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

{[ snackBarMessage ]}

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
Ask a homework question - tutors are online