Grade Report 1

Exam 1: Take Home (Part 1)

Part 1 – Take Home Instructions

Due date: Wed Sep 16th

Download: GDP-Fertility Data

The last digit of your PID determines which column of data you will use for the exam. If your PID ends in 3 your assigned column is “Dataset 3”. If your PID ends in 4 your assigned column is “Dataset 4”. And so on.

Your assigned column has either a 1 or a 0 in each row. You will include each Country listed with a 1 in your assigned column. Please omit the countries with a 0.

Each country is part one of 3 Regions: (1) the Americas, (2) Europe, Middle East & Africa (EMEA) and (3) Asia Pacific. Use the “Filter” or “Sort” feature to separate your countries by region.

Analysis

You will analyze the GDP Per Capita data for each of the three regions separately. So, you must complete the following steps [highlight color=”options: yellow, black”]3 times[/highlight], once for each region.

1. Create a Stemplot
2. Create two Histograms using a different “Bucket size” for each
3. Calculate Quartiles Q1, Q2 and Q3
4. Create a Box Plot
5. Calculate the Mean, Median and Standard Deviation

Region Comparison

• Create a 1-page visual summary for comparing all 3 regions.

Executive Summary

• Write a 1 page “Executive Summary” analyzing observed regional differences and similarities. What story are the data telling you?

Print Copy

In total, you will prepare 3-5 pages (no more than 5) and submit a print copy in class on Wed Sep 16th. Print copies should be well organized, neat and easy to read. You may use Google Sheets or Excel to complete the analysis. You may also complete the work by hand if you prefer. Either way, appearance, legibility and written communication all count. If your report is sloppy or difficult to read your grade will suffer.

Lesson 5: Variance

Mon Sep 7

Review:

• Central Tendency
• Week 1 slides

Presentation:

• Variance
  • Percentiles and Quartiles
    • Position in data set = i = percentile * n
    • 50th Percentile = Median
    • Q1 = 25th Percentile
    • Q2 = 50th Percentile = Median
    • Q3 = 75th Percentile
    • Interquartile Range (IQR = Q3 – Q1)
  • Box Plots: video
    • Visualize variance
  • Standard Deviation: video
    • Calculate variance
  • Example
    • Data: {213, 345, 609, 73, 167, 243, 444, 524, 199, 682}
    • Calculate Q1, Q2, Q3, IQR
    • Calculate standard deviation

Activity:

• Use Data set 1 and 2 below
  • Data set 1: {2, 4, 8, 4, 6, 2, 7, 8, 4, 3, 8, 9, 4, 3, 5}
  • Data set 2: {7, -2, 5, 9, 0, -3, -6, -7, -4, -5, 2, -8}
•  Calculate the following
  • Q1, Q2, Q3, IQR for each data set, separately
  • Draw Box Plots side by side for comparison
  • Calculate mean and standard variation, separately

Assignment:

• Using Sheets and the D60-D70 % Free-Reduced Lunch data
  • Calculate Q1, Q2, Q3 and IQR (for D60 and D70, separately)
  • Draw Box Plots side by side for comparison
  • Calculate standard variation

Lesson 4: Measures of Central Tendency

Wed Sep 2

Review:

• Stemplots and Histograms

Presentation:

• Measures of Central Tendency
  • Mean
  • Median
  • Mode
• Video: Measures of Center

Activity:

• Determine the mean, median and mode for the following data:
  • Data set 1: {2, 4, 8, 4, 6, 2, 7, 8, 4, 3, 8, 9, 4, 3, 5}
  • Data set 2: {7, -2, 5, 9, 0, -3, -6, -7, -4, -5, 2, -8}
  • Data set 3: {213, 345, 609, 73, 167, 243, 444, 524, 199, 682}

Assignment:

• Use Google Sheets for the following
  • Calculate the mean and median of the distance from campus variable in Q2_Text
  • Calculate the mean and median % Free-Reduced Lunch in D60-Elem
  • Calculate the mean and median of Sales Price in PuebloRE-2014YTD-SF-Sales
• Post results to your blog
• Read p. 98-100 Measures of the Center of Data

Tutoring Available

Statistics tutoring is available!

• For BUSAD 265 (Inferential Statistics and Problem Solving): Tue 6-8pm in HSB 111
• For BUSAD 360 (Advanced Statistics): Wed 6-8pm in HSB 113

Lesson 3: Stemplots and Histograms

Mon Aug 31

Review:

• Intro to Data Analysis
• Google Sheets and data access requests

Presentation:

• Data Distribution
• Stemplot video
• Histogram video
• Stemplot demo
• Histogram demo

Activity:

• Create stemplots by hand
  • Problem 2.1 on p. 69
  • Problem 2.2 on p. 70

Assignment:

• Create histograms using Google Sheets and the data for the problems below.

  • 2.7 The following data are the shoe sizes of 50 male students. The sizes are continuous data since shoe size is measured. Construct a histogram and calculate the width of each bar or class interval. Suppose you choose six bars. 9; 9; 9.5; 9.5; 10; 10; 10; 10; 10; 10; 10.5; 10.5; 10.5; 10.5; 10.5; 10.5; 10.5; 10.5 11; 11; 11; 11; 11; 11; 11; 11; 11; 11; 11; 11; 11; 11.5; 11.5; 11.5; 11.5; 11.5; 11.5; 11.5 12; 12; 12; 12; 12; 12; 12; 12.5; 12.5; 12.5; 12.5; 14

  • 2.9 The following data represent the number of employees at various restaurants in New York City. Using this data, create a histogram. 22; 35; 15; 26; 40; 28; 18; 20; 25; 34; 39; 42; 24; 22; 19; 27; 22; 34; 40; 20; 38; and 28 Use 10–19 as the first interval.

  • Post to your blog
• Reading p. 67-69 and 76-77

Lesson 2: Intro to Data Analysis

Wed, Aug 26

Review:

• Syllabus
• Textbook
• Blog setup
• Twitter account and tweet with blog link and #PuebloStats265
• Google Sheets

Presentation:

• Intro to Statistics Video
• Types of Data
  • Numeric
    • Discrete (counting)
    • Continuous (measuring)
  • Categorical (nominal)
  • Ordinal (ranking)
  • *Spatial
  • *Temporal
• Types of Analysis
  • Exploratory – looking for patterns
  • Descriptive – summarizing data
  • Inferential – estimating [highlight color=”options: yellow, black”]population[/highlight] parameters based on [highlight color=”options: yellow, black”]sample[/highlight] statistics
  • Experimental – testing for significance
  • Predictive – forecasting, simulation
  • Prescriptive – optimization

Assignment:

• Blog Assignment 2
  • Download or copy this Grade Data worksheet
  • Load the data in Google Sheets (your account)
  • Combine Sec 1, 2 and 3 so there are only 2 columns with all Scores and Grades
  • Sort using the Scores column from High to Low
  • Count the number of As, Bs, Cs, Ds and Fs (Bonus: use the “countif” function)
  • Post a table with counts to your blog
• Textbook Reading in Chapter 1 
  • p. 9-11 (Introduction and Definitions)
  • p. 13-14; 17 (Quantitative vs Qualitative)
  • p. 21-23 (Sampling)

Activity:

• Data Collection

Getting Started with Google Sheets

We will use Google Sheets for data analysis. If you are already familiar with Google Apps you are a step ahead of the game. If not, here are a few links to help you get started.

I told classes yesterday you might need a Gmail account. Turns out I was wrong and you can sign up without Gmail.

Some people already have good spreadsheet skills – that’s great! If you’re not one of those people, here are a few sources for learning basic spreadsheet tasks in Google Sheets.

• Google Apps Learning Center
• Video Tutorials 
• Berkeley Spreadsheet Tutorials

Did you find other useful tutorial pages? Please post them in comments below or Tweet to the group using #PuebloStats

Thanks!

Lesson 1: Syllabus

Presentation

• Syllabus: F15-BUSAD265-Holman
• Textbook: OpenStax Intro Statistics
• Activity: Math Assessment

Assignment

1. Set-up a blog where you will post “E-Homework” material for this course. You can use any platform you like; but, if you don’t have a personal preference, I recommend WordPress. Go to the getting started page and it will walk you through the process of setting up an account.

2. Sign-up for a Twitter account and “tweet” to me @justinholman with a link to your blog. Use the hashtag #PuebloStats265.

Click below to watch a video that walks you through the blog setup assignment. Note this video is from last year but should still be useful.

[youtube id=”http://www.youtube.com/watch?v=cjZumZKrE_w” width=”600″ height=”350″]