Module 3: Time Series Analysis

• Time Series Analysis
  • Watch this Video Lecture (start at 1:20)
  • Scatter plots
  • Line plots
  • Trend lines
    • Linear
    • Polynomial
  • Forecasting
  • Oil Prices
  • Yield Curve

Module 2: Data Visualization

• Watch this Module Introduction Video first!
• Please note: I’ve changed this module
  • You’ll be working with Colorado’s Economic Regions instead of Congressional Districts.
  • This should make life easier for you because the Congressional Districts are tricky.
  • I haven’t changed the video so I still refer to Congressional Districts.
  • Whenever you hear Congressional Districts think Economic Regions instead.
  • If you have questions about this ask on the discussion board in Bb!

• Step 1
  • DataCamp: Introduction to Pivot Tables for Google Sheets
• Step 2
  • Video 2.1: Data Assembly
    • Compile a Colorado County Data Set
    • Download population data for all US counties
    • Download County GDP from the Bureau of Economic Analysis
    • Look up Economic Regions and assign each Colorado County to one of 14 regions
• Step 3
  • Video 2.2: Pivot Tables
    • If you haven’t already, complete Pivot Tables in Spreadsheets
    • Chapter 1 ONLY
    • Use a Pivot Table to aggregate GDP and Population by Economic Region
  • Video 2.3: Visualizing frequency distributions
    • Make two histograms
  • Video 2.4: Visualizing bivariate relationships
    • Make one scatterplot
• Step 4
  • Download US County Dataset
  • Create a Pivot Table
    • 49 rows and 4 columns
    • Each row corresponds to 48 States and Washington DC (Alaska and Hawaii are excluded)
    • Each column corresponds to four variables: Population, GDP, Median HH Income, Poverty %
    • Calculate the “Sum” for Population and GDP by State
    • Calculate the “Average” for Median HH Income and Poverty % by State
• Step 5
  • Create graphs (use Insert > Chart)
    • Use the resulting State aggregation (from the Pivot table)
    • Make four (4) histograms
      • (1) Population
      • (2) GDP
      • (3) Median HH Income
      • (4) Poverty %
    • Make four (4) scatter plots:
      • (1) Population (x) vs GDP (y)
      • (2) GDP (x) vs Poverty % (y)
      • (3) GDP (x) vs Median HH Income (y)
      • (4) Median HH Income (x) vs Poverty % (y)
    • All graphs must have axis labels
    • All scatter plots must include a “Trendline” along with labels for the “Equation” and “R^2 value”
• Step 6
  • Submit your assignment in Bb.
    • Click the “Share” (green button, upper right)
    • Under “Get Link”, click “Change” to be sure “Anyone” with the link can view, comment or edit.
    • Click “Copy Link” and paste the link into Bb.

Module 1: Intro to Data Analysis with Spreadsheets

In week 1 you will begin learning to analyze data in spreadsheets.

Assignment 1:

• Watch this Module 1 Video

• Join DataCamp
  • Check your email and look for an invitation to join my classroom on DataCamp
  • Complete these two courses
    • Introduction to Spreadsheets
    • Data Analysis in Spreadsheets
• Videos – where I walk through the DataCamp exercises (optional)
  • DataCamp Intro to Sheets Chapter 01
  • DataCamp Intro to Sheets Chapter 02
  • DataCamp Data Analysis in Sheets Chapter 01
  • DataCamp Data Analysis in Sheets Chapter 02
• Troubleshooting
  • DataCamp is a bit temperamental. Here are a few tips.
  • Email account
    • The invitation link above (and here) is setup for the csupueblo.edu domain.
    • If you sign up using gmail or other personal email you won’t be connected to my classroom automatically.
    • The main benefit of having a classroom for you to connect to is free access to all premium content. Here are your options (unless you want to pay):
      • Use your pack.csupueblo.edu email when you create a new account. Use the email with your NAME not the one with your C123… number.
      • If you want to sign up with a different email, send me your preferred email address and I will create a separate invitation. 
  • Browser Refresh – duct tape for the internet
    • If you signed up successfully with your pack.csupueblo.edu email but you are still being prompted to pay for premium content try these steps.
      1. Kill your browser and restart.
      2. Use the invitation link to my classroom.
      3. Logout and log back in.
    • These steps typically resolve 90% of issues. If it doesn’t resolve your problem try the steps one more time and then email me.
    • During the courses DataCamp occasionally gets confused. Just refresh your browser and retry.
    • These issues can be annoying but when you’re thinking about complaining just remember that DataCamp makes all their premium content available to us at no cost. Also, I haven’t found anything better for teaching data analysis skills.

Introduction to Advanced Statistics Online

This course will consist of eight one-week modules, each module beginning Monday and ending the following Sunday. Each week you are responsible for contributing to Discussion forums in Bb and for completing an Assignment. I will provide descriptions and resources here each week and I will make an Announcement on Bb each time a new module post appears. Typically, I will also post one or more video lectures each week.

All assignments are due by 11:59pm on Sunday each week!

Here’s an introductory video.

Here’s a link to the course syllabus and below I’m providing some general guidelines for the asynchronous online format.

No Textbook! Don’t buy one. I use my own material.

Discussions:

• Each week you will earn up to 20 points by contributing to the discussion forums on Bb.
• Ask a question or share something you learned that saved you time or helped you understand the material. The idea is to be curious and promote understanding.
• Don’t regurgitate or summarize the material unless it’s part of a question or helpful insight.
• Submit comments or questions during the week, no later than Friday. If you wait until Sat or Sun your input won’t help you or anyone else. (That said, better late than never for scoring).
• Don’t login only once a week, make a few comments and logout 10 min later. I’ll notice if you’re doing the bare minimum.
• Don’t skip Discussion all together. If I see nothing, you’ll get 0/20.

Assignments:

• Each week you will earn up to 80 points by completing an assignment.
• I will provide instructions. Please follow the instructions.
  • If I ask you to submit something via Bb or via Google Forms don’t email it instead. Grading is time consuming and handling special cases wastes my time.
  • Pay attention to format. If I ask you to submit an .xlsx file, don’t send a .pdf or other format.
• Make it easy for me to identify where you are answering a question. If I can’t find it you may not get credit.
• If you’re not sure what to do to complete an assignment, post a question on the discussion board! That’s the whole idea! Or you can send me an email if you prefer not to broadcast. Of course, this requires that you think about the assignment before 10p on Sunday.