Data Assignment #1 Instructions: Read the scenario below. Copy and paste the data into excel. For each question, you will use excel to conduct your analysis. Please copy/paste your results from Excel into your write-up summary. Your write-up should be presented in a professional manner. Suppose you are the manager of a company that produces 4 goods: A, B, C, and D. You plan to explore what factors influence the cost of producing each good. You begin by examining what is the unit cost for producing each of your goods at different levels of production, and what is the relationship between the unit costs and output of your goods. You can copy/paste the data below into excel and answer the following questions. Unit of Output 0 25 Unit Cost A ($) 2.14 2.47 2.99 3.67 4.36 4.58 5.38 6.28 7.03 7.32 50 100 150 200 250 Unit Cost B ($) 7.91 7.81 6.72 7.57 5.81 5.21 4.8 5.25 3.78 3.23 3.7 2.48 Unit Cost C ($) 5.59 6.1 4.84 6.44 4.78 5.04 5.87 6.07 6.17 4.83 5.73 5.56 Unit Cost D ($) 4.41 4.29 4.56 4.5 4.79 5.07 5.18 6.21 300 350 400 6.73 6.79 450 7.41 8.53 7.49 9.14 500 1. What type of data is presented? 2. What is the mean, median, range, and standard deviation of each unit cost variable? You can copy/paste your summary statistics and highlight these measures if that is easiest for you. Briefly explain your findings. 3. How are unit costs affected by quantity produced? Produce 4 scatter diagrams showing the relationship between output and each of the unit costs. Discuss the relationship between unit cost and output for each product. 4. Suppose you are a manager with some leftover materials that can be used to manufacture any of the 4 goods. If your goal is simply to minimize costs, and you only plan to produce a maximum quantity of 200, which good would you manufacture? Why