COLLECTION AND USE OF DATA IN ECONOMICS

ECON 301 (DATA ANALYSIS) MINI PROJECT 1 (PERFORMING DATA ANALYSIS IN EXCEL)

File saved as: G:\PD - 2019-05-28\I-Docs\Academic\SDSU\Economics\Econ 301 (Data Analysis)\Mini Projects\Econ 301 - Mini Project 1 - Summary Statistics (Excel).doc

1

Assignment Objective: Perform Statistical Data Analysis Using Microsoft Excel. Data Source(s): Econ 301 – Mini Project 1 – Summary Statistics Individual/Group: This is an individual project. Students are expected to do their own work. Assignment Deadline: Tuesday, February 18, 2020 Assignment Suggestions:

1. We will be going over the mechanics of this assignment in class. If you are a little rusty with Excel, it would be a good idea to attend and take good notes.

2. I do NOT need nor want the raw data in the assignment!! Please do NOT print out those pages!!

3. You may need to size the tables and graphs you create to the paper you use. 4. You might also want to consider copy and pasting the tables and graphs you create into a

Word document. Method of Submission/Deliverables: Please submit the following for this assignment:

1. Hard copies of tables and graphs. 2. E-mail Excel workbook used in the assignment.

Work submitted that does not conform to the directions will be marked down. Other Information:

ECON 301 (DATA ANALYSIS) MINI PROJECT 1 (PERFORMING DATA ANALYSIS IN EXCEL)

File saved as: G:\PD - 2019-05-28\I-Docs\Academic\SDSU\Economics\Econ 301 (Data Analysis)\Mini Projects\Econ 301 - Mini Project 1 - Summary Statistics (Excel).doc

2

Assignment Specifics:

Task Dataset Excel Function/ Feature

Generate Frequency Table for Data Labels RATINGS COUNTIF Function Generate Pie Chart or Bar Graph Using RATINGS Graph Data Labels

Create Variables STATE LEVEL DATA Population/Electoral Votes Function Bar/Speed Fill PerCapita GSP Function Bar/Speed Fill

Generate Histogram of Population STATE LEVEL DATA Data Analysis Generate Descriptive Statistics STATE LEVEL DATA Data Analysis

Calculate the Coefficient of Variation for STATE LEVEL DATA Function Bar Population and Electoral Votes

Calculate the covariance between STATE LEVEL DATA COVAR Function Population/Electoral Vote and Per Capita GSP

Calculate the Average of Fuel and the Weighted FUEL PURCHASES Function Bar/Speed Fill Average for Fuel Purchases

Calculate the Geometric Mean for the S&P 500 STOCK INDEXES-DATA Function Bar/Speed Fill Index GEOMEAN Function