ECON3320_Homework1_SP2022

.docx

School

University of Houston, Downtown *

*We aren’t endorsed by this school

Course

110

Subject

Economics

Date

Apr 3, 2024

Type

docx

Pages

4

Uploaded by BaronScorpion12542 on coursehero.com

ECON3320 Homework 1: Part A due Friday January 28th, 2022 • Out of 50 points. Part A (this document) 24 points. Part B (questions to be answered on Blackboard) 16 points. • Write your name and the date. • Answer all questions inside this document and in the same order. Questions answered out of order will not be graded. All questions should appear in the homework. • Copy & Paste Excel tables/graphs below each question. Delete blank lines as necessary but be careful not to delete any questions or change the format of the number list. • Make sure to answer a question when a question is asked. Copying a table/graph without answering a question will receive partial credit only. • Upload a single pdf file to Blackboard. Other file formats might upload with errors which might make you lose some or all points. You can save the Word document as a pdf file. Select “Save as Adobe PDF”. • After uploading the file to Blackboard be sure to confirm that all graphs and content have been uploaded correctly. • Homework will not be accepted over email. • There is a penalty for up to 10 points for not following any of the instructions above. Part A: Dataset (24 points) Dataset. Download the following file from Blackboard: ECON2304_HW1_Data_Mutual Funds.csv This is a dataset for a sample of 45 mutual funds. There are three Fund Types (DE=domestic equity, IE=international equity, FI=fixed income). Net Asset Value ($) = Equity per share. Expense Ratio (%) = expenses as a percentage of assets. The remaining variables are self-explanatory. Instructions for Tables and Graphs: ○ Each must have a descriptive title. ○ Axes in graphs and rows/columns in tables must be properly labeled. ○ Answer the question associated to each Graph/ Table to get full credit. 1. How many variables are in the dataset? 2. How many observations are in the dataset? 3. Which variables are categorical, and which are quantitative? 1
4. Fund Type – Using a PivotTable: Prepare the percentage frequency distribution of Fund Type. No need to copy and paste the table to the homework. But you need it for the next step. – Prepare a Pie Chart of the Fund Type. Copy and Paste it here. – Which is the most frequent fund type in the dataset? 5. Fund Type and Expense Ratio – Using a PivotTable: Prepare a cross tabulation of Fund Type (rows) and Expense Ratio (columns). Group Settings: min= 0.25, max=1.49, by=0.50. No need to copy and paste the table to the homework. But you need it for the next step. – Prepare a 100% Stacked Bar Chart of Fund Type (horizontal axis category) and Expense Ratio (stacked categories). Copy and Paste it here. 2
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
Recommended textbooks for you
Text book image
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:9780190931919
Author:NEWNAN
Publisher:Oxford University Press
Text book image
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Text book image
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Text book image
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:9780190931919
Author:NEWNAN
Publisher:Oxford University Press
Text book image
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Text book image
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Text book image
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education
SEE MORE TEXTBOOKS