Specify which formula to use for each column please! Introduction The Primary goal of this spreadsheet assignment

Specify which formula to use for each column please!

  

Transcribed Image Text:

Introduction The Primary goal of this spreadsheet assignment is for students to gain comfort in using excel to conduct a demand analysis of a particular firm. Completing it will also depend on the excel spreadsheet that is posted to the canvas site. Assignment questions 1. Demand analysis Px = 8- *6* Q This equation completes the specification for the demand equation for your spreadsheet assignment. Once you have the demand equation, please open up the excel spreadsheet... The first task is to fill in the spreadsheet. So in particular, you will find that the first column headed "Q" is filled in with values. Please use the demand equation above in order to compute price. The lectures on elasticity of demand and marginal analysis will direct you through how to compute elasticity using the point- slope formula. Finally, once we complete this table, we want to graph the relationship between demand, elasticity. total revenues, and marginal revenues using this table. It is okay if you screenshot this graph or handwrite it into the word document, please make sure to include all explanations and also to label all graphs following your demand equation. 2. Discussion Using your web browser and your own judgement and the power points, please interpret and discuss the strength of the relationship between demand, elasticity, total revenues, and marginal revenues for the business operation of the company you chose for the term project. Introduction The Primary goal of this spreadsheet assignment is for students to gain comfort in using excel to conduct a demand analysis of a particular firm. Completing it will also depend on the excel spreadsheet that is posted to the canvas site. Assignment questions 1. Demand analysis Px = 8- *6* Q This equation completes the specification for the demand equation for your spreadsheet assignment. Once you have the demand equation, please open up the excel spreadsheet... The first task is to fill in the spreadsheet. So in particular, you will find that the first column headed "Q" is filled in with values. Please use the demand equation above in order to compute price. The lectures on elasticity of demand and marginal analysis will direct you through how to compute elasticity using the point- slope formula. Finally, once we complete this table, we want to graph the relationship between demand, elasticity. total revenues, and marginal revenues using this table. It is okay if you screenshot this graph or handwrite it into the word document, please make sure to include all explanations and also to label all graphs following your demand equation. 2. Discussion Using your web browser and your own judgement and the power points, please interpret and discuss the strength of the relationship between demand, elasticity, total revenues, and marginal revenues for the business operation of the company you chose for the term project.