eco2115_2023 assignment 2 v1 (1)

pdf

School

University of Ottawa *

*We aren’t endorsed by this school

Course

2115

Subject

Economics

Date

Jan 9, 2024

Type

pdf

Pages

Uploaded by DukeGuineaPigMaster921

1 M ONEY AND B ANKING ECO 2115 F ALL 2023 A SSIGNMENT 2 DEADLINE: November 20, 11 : 30PM All electronic files (PDF and Excel) to be returned on Brightspace in the assignment 2 space Please start this assignment early in case you have questions. If you wait until the last minute, we might not have time to get to your questions by the deadline. Please ask your questions in the forum. Professor: Marc Prud’Homme Instructions: Please respect to avoid serious penalties This is an individual assignment. You can however consult each other to work on the assignment but you must return your own individual copy. Under no circumstances can you submit your assignment by email; you must submit it on Brightspace. Tardiness will be penalized at the rate of a 10% deduction per day (starting @ midnight + 1 minute after the deadline) up to a maximum of 2 days after which time no assignments will be accepted. Include with your working document a typed cover page that is produced with a word processing software such as MS Word or Pages; do not submit a handwritten cover page. Your last name (family name) should be in caps (capital letters) so that we can best identify you (do not capitalize your given name.) A sample title (cover) page can be found in this document on pages 18 - 19: https://socialsciences.uottawa.ca/public-international- affairs/sites/socialsciences.uottawa.ca.public-international-affairs/files/guidelines- 20110217/WritingandStyleGuide2010-2011_001.pdf I would also like to point out that a subset of the exercises will be corrected and not the entire assignment due to lack of resources. However, you must attempt all the exercises, otherwise points will be deducted for incomplete work. A full set of solutions will be made available soon which you can consult in preparation for the exam.

2 Note for some targeted exercises (to be identified in the question if any exist), the graphs and tables that you produce in MS Excel will need to be included in your working document (this is your Word processing document in MS Word or other similar software). There are several ways to go about transferring charts and tables from an Excel file to the working document. Here's an example (the same basic approach is used if you are using other similar word processing software such as Pages by Apple): https://support.microsoft.com/en-us/office/insert-a-chart-from-an-excel-spreadsheet-into-word- 0b4d40a5-3544-4dcd-b28f-ba82a9b9f1e1 This is not the only source of information on how to transfer graphs. If you need more help start with Google. You can also resize your graphs and tables so that they can fit on the page of your document. Always include labels on your charts labels to identify axes, the name of the series and a title. Tables should always include a title. One of the goals of these exercises is to assess your ability to find data, so please don't ask me where the data is, as that defeats the purpose of the exercise. If it proves impossible to find the requested data (unlikely), then simply skip the question. With every assignment you will be asked to submit in Brightspace the following: 1. A copy of your working document, which is typically produced in MS Word (or Pages) and then saved as a PDF file. You MUST submit the PDF file, otherwise we might not be able to read your file and grade it. 2. Your MS Excel file. 3. This is a total of 2 files maximum. Additional guidelines for submitting the assignment: Please observe the following advice/instructions to avoid point deductions (note there is some repetition from above for emphasis): 1) Work submitted by email will not be graded. 2) Do not return your documents in a ZIP file (they can sometimes contain a virus). 3) When you are asked to do calculations in the Excel file, you must use the formulas in MS Excel to perform them. You should never just write a result in a cell which requires a calculation. You need to calculate the result using the Excel formula. 4) When you apply an Excel formula, you must use the cell addresses in the formula and not use the numbers taken directly from a cell in the table. 5) You have a grace period of two days after the deadline to return the assignment but with penalty. Delays will be penalized at the rate of 10% per day (maximum tolerated of 2 days). After this date, the window for returning the work will be closed and it will be impossible to submit the TP regardless of the motivation.

3 6) Back up your files to one of the many services that exist in the cloud since there are no exceptions to deadlines in case you have technical problems that prevent you from submitting the work on time. The best practice is to start early and submit early in case of issues with the Brightspace server or the StatCan server for example) 7) If you have any questions, please ask them in the forum for a timelier response. Do not communicate by email any questions about the assignment. Note that your question was perhaps already asked in the forum and has been answered. Therefore, please peruse the forum before posting a question; this will save you time and frustration. 8) Also be clear in the subject heading of the Forum posting when submitting a question, e.g., Problem 2 B: How to calculate such and such a result. Just writing “I have a question” does not work. 9) It is advised to start the assignment earlier than later. That way, if you have any questions, they have a better chance of being addressed in the forum before the deadline. 10) If asked in a problem to include the graph you constructed in Excel to your working document, you simply copy the chart from Excel to MS Word or Pages as a PGN image or PDF image. These formats allow for easy resizing within the working document. 11) All charts constructed in Excel should be saved within Excel using this method: https://www.youtube.com/watch?v=mD28breAR2g ( this is explained about 1 minute into the video). Name that chart sheet in Excel using a title corresponding to the problem number (e.g. Chart Q1 ) and position this sheet within Excel next to sheet in which you have worked the problem. 12) In the MS Excel template, do not move or change the parameters (the way the page is set up) that appear in this file. Simply fill in the blanks without moving or changing the set up or layouts of these various sheets. Include your answers in the cells that have been reserved for this purpose (look for the yellow highlighted cells). 13) If and when searching for the Statistics Canada V number codes (you will know what I mean when you see them in the problem statements below) you start by going to the Data link on the Statistics Canada home page ( https://www150.statcan.gc.ca ) … once there, look in the right hand corner and you will see a box that reads “Search by Vector”. Once on that page you can enter the vector numbers as they appear in the exercises to find your data. However, once on that page, you will need to click on the number that appears under the SOURCE heading in the box to have access to the full historical data needed to complete some of these exercises.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4 Once on that page you can enter the vector numbers as they appear in the exercises to find your data. However, once on that page, you will need to click on the number that appears under the SOURCE heading in the box to have access to the full historical data needed to complete some of these exercises. You will now find yourself on a page like the one in the image below. From there, you click on the ADD/REMOVE DADA button. You will be offered choices for the data series and the periods which are relevant to the requested data. Note that some series will have a “+” sign next to them. Press on it to expand your data choices.

5 You will have many choices of formats for downloading the data. Pick this one.

6 14) In your calculations, limit the number of digits for your answers after the decimal to one (e.g., 12.1 and not 12.1234) unless otherwise specified. 15) Note that you are new to MS Excel, there are several YouTube videos on how to use this tool. 16) Use the following naming conventions for all your files: Family name_student number.pdf. For example: Prudhomme_11111111.xls 17) Failure to respect these instructions will result in a penalty. To learn more about Statistics Canada data and how to download the data please look at these links: https://www.statcan.gc.ca/eng/developers/csv/user-guide https://www.statcan.gc.ca/eng/about/website-faq https://www.youtube.com/watch?v=4jdlqFu6Yak

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

7 1. Yield curve 1. From the textbook in the DATA ANALYSIS PROBLEMS section (towards the end of the chapter) in Chapter 6 of the textbook. Question 2. Retrieve the requested data for the period that appears in the Excel template file on sheet Data Prob 1 but extend the data to the last period available from Statistics Canada (not January 2021 like it reads in the textbook); you will need to add the years and months to column C past January 1983. Answer part a) by including the relevant data (see sheet Prob 1 ) in sheet Prob 1. (Note that the required data differs from what is formulated in the textbook question). Save the graph in a separate sheet in your Excel file as per the instructions above. Note that you need only a subset of the data you downloaded to answer part a). Part b) should be answered in your working document. 2. From the textbook in the APPLIED PROBLEMS section in Chapter 7 (at the end), complete the following: Question 24. Answer in your working document. 3. From the textbook in the QUESTIONS section in Chapter 12 (at the end), complete the following: A. Question 4. Answer in your working document. B. Question 6. Answer in your working document. C. Question 8. Answer in your working document. D. Question 11. Answer in your working document. E. Question 13. Answer in your working document. 4. From the textbook in the APPLIED PROBLEMS section in Chapter 12 (at the end), complete the following: A. Question 24. Answer in your working document. B. Question 25. Answer in your working document. 5. From the textbook in the DATA ANALYSIS PROBLEMS section in Chapter 12 (at the end), complete the following: A. Question 2. Answer in your working document. 6. Forthcoming 7. From the textbook in the DATA ANALYSIS PROBLEMS section in Chapter 14 (at the end),

8 complete the following: A. Question 2. Answer in your working document. 8. From the textbook in the APPLIED PROBLEMS section in Chapter 15 (at the end), complete the following: A. Question 21. Answer in your working document. B. Question 23. Answer in your working document.

Related Documents

P 8-28 in-class exercise.docx

ECO-20043 - Microeconomics and Decisions - Resource Recs.docx

ECO-20044 - Economic Cost of Decisions - Resource Recs.docx

Practice SAQs Midterm Exam 2.pdf

Screenshot 2023-12-18 at 7.20.24 AM.png

eco2115_2023 assignment 1 v2. answers.pdf

Sample questions Quiz 1.pdf

Sample questions Quiz 2-1.pdf

4.png

IMG_0389.jpeg

Catlett_ECO110_Week4Assignment (2).docx

Walton_Multiple_Inputs_Complete_ (1).xlsx

Recommended textbooks for you

Managerial Economics: Applications, Strategies an...

Economics

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:Cengage Learning

Principles of Economics 2e

Economics

ISBN:9781947172364

Author:Steven A. Greenlaw; David Shapiro

Publisher:OpenStax

Brief Principles of Macroeconomics (MindTap Cours...

Economics

ISBN:9781337091985

Author:N. Gregory Mankiw

Publisher:Cengage Learning

Economics:

Economics

ISBN:9781285859460

Author:BOYES, William

Publisher:Cengage Learning

Managerial Economics: A Problem Solving Approach

Economics

ISBN:9781337106665

Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:Cengage Learning

Microeconomics: Principles & Policy

Economics

ISBN:9781337794992

Author:William J. Baumol, Alan S. Blinder, John L. Solow

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Principles of Economics 2e
Economics
ISBN:9781947172364
Author:Steven A. Greenlaw; David Shapiro
Publisher:OpenStax
Brief Principles of Macroeconomics (MindTap Cours...
Economics
ISBN:9781337091985
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Economics:
Economics
ISBN:9781285859460
Author:BOYES, William
Publisher:Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Microeconomics: Principles & Policy
Economics
ISBN:9781337794992
Author:William J. Baumol, Alan S. Blinder, John L. Solow
Publisher:Cengage Learning