Teaching Notes
Excel: Part 1
Videos 1.0 1.6
These teaching notes (Parts 1, 2, 3 and 4) should be used in the following manner:
On Video
Show you the wording of a homework problem.
Give you step by step instructions in Excel to obtain your graphs and table
BIOS 500 LAB DAT ANALYSIS PROJECT: Burnout in ENT Residents Source: This dataset comes from a larger study looking at burnout in medical residents in otolaryngology. Background: Resident work schedule and burnout has gained much attention lately, particul
Quiz 1 Study Guide
Basic Concepts Manual
Supplemental Text: Parts 2 & 4
1. The mean is appropriate when the data are quantitative or categorical?
2. How would we know if a dataset is symmetric while viewing a boxplot?
3. What does the IQR represent?
4. Ty
College of Science and Mathematics
Department of Mathematics & Statistics
The STAT 3010
Supplemental Text
By D. Yanosky
Kennesaw State University
2nd Edition.
College of Science and Mathematics
Department of Mathematics & Statistics
The correct bibliograp
JOBSA
EmpID Plant
100
D
061
N
089
D
024
D
016
D
075
N
017
D
077
N
014
D
004
N
011
N
005
N
091
D
007
D
006
N
019
D
082
N
063
N
078
N
023
D
071
N
027
D
013
N
065
N
086
D
062
N
069
N
083
D
029
D
094
D
088
D
090
D
095
D
097
D
012
D
022
D
028
D
058
N
010
D
009
tatistics t KU
Reference Manual for Statistical Software:
A gentle overview of Excel, SPSS, Minitab, SAS, & R
Table of Contents
1. Introduction to Statistical Computing
2. Data Analysis and Statistical Concepts
Concept 1 Measurements of Central Tendency
C
an A in STAT
3010!
Putting the Pieces
together.
11:39 PM
Attend Class Everyday
Start Homework Early
Turn Homework in on time
Pay attention to the mistakes you make and dont make
them twice.
Keys to Success
11:39 PM
Doing the same thing over and over
agai
Class notes 9 17 2013
First. We are preparing for R on HW2
We have to save everything in R.
We have to save our code.
It will be a big script.
HW2 sample paper has incomplete code at the end of it. So, I have to catch all the code as we
go along.
We are g
#Week 3 of R
#14. Get the summary statistics for penn2 in a column format
attach(penn2)
summary(penn2[,c(3:5)])
#15. Create a new categorical variable from Fastest called Speed. Classify <80 mph as Slow, between 80 and 110 as Medium and >=110 as Fast
penn
Class notes 09 05 13
For question #5 of HW to do sheet.
AT&T, Cingular and Verizon each need to be broken down by Monthly Revenue and
Income.
I need Mean and Median and other descriptive statistics.
Sorting in Excel. Sort by Provider in Customer Survey Da
8/22/13
Stats 3010
Measurements of central tendency
Measures of center
mean, median or mode
type of data
Mn.quantitative
(outliers)
Md.*
Mo.* or qual
Drawback
affected by extreme values
there can be more than one
N=size of the population (there exists cop
Class notes 9 17 2013
First. We are preparing for R on HW2
We have to save everything in R.
We have to save our code.
It will be a big script.
HW2 sample paper has incomplete code at the end of it. So, I have to catch all the code as we
go along.
We are g
Class notes 9 19 2013
Save the excel workbook as a CSV
Only the excel datasheet im currently on will be saved, so if I want to save more than one sheet,
I need to be on each sheet and save each one individually.
Code to import R data from CSV file excel w
Andrew Edwards
STAT 3010
December 12th, 2013
Professor Bell
This is a dataset of all of the songs sampled by a DJ to create an album. So, there are many
variables such as Track name which is the name of each track and Sample start which is
when each sampl
Class notes: Frequency table 9/3/13
Insert a Pivot Table.
Notes for Pivot Table are in Excel notes 2.
Copy and Paste Special the pivot table as Values so that it is no longer alive.
ClassDatamake new column called Commute. If Commute is Miles < 10 then it
Stats notes
27/08/2013
Excel
Course notes at bottom of content section for screen shots of how to do excel work.
My first homework assignment is in the dropbox on D2L.
Bivariate
Two categorical/ qual. Then use:
Contingency table
Stacked bar chart
100% sta
# Week 2 of R
#1. Import pennstate1.csv into R and name the new R data penn1.
penn1<-read.csv("E:\Stats 3010\HW2\Pennstate1.csv")
#2. Print the data in penn1
penn1
#3. Attach the columns in penn1. I will explain this.
attach(penn1)
#attaching the data
Overview
34 SAS Certication Prep Guide
Have you reviewed the appropriate tutorial for your programing environment on the
companion CDROM? If you have not, please review the appropriate tutorial before
beginning this chapter.
Int
SAS Reference Manual:
A gentle overview
Table of Contents
1. Introduction to SAS
4
What is SAS
4
Getting data into SAS
9
SAS Libraries
22
2. Data Analysis and Statistical Concepts
31
Concept 1 Measurements of Central Tendency
31
Concept 2 Measurement
strength to overcome fear strength to obey strength to resist temptation strength to believe the impossible strength to love the unlovable strength to pursue when weary strength to stand firm strength to forgive Are you feeling a little weak today? Dont h
Age Boar Valentin Crstea Carmen Diaconescu Mdlina Diaconu Marius Dobriceanu Maria Enache Nicoleta Epuran Maria Goace Eugenia Guag Marius Iana Mihai Lazr Constantin Mihai Lucia Negoi Mihia Ptru Gelu Radu Sorin Rodeanu Cristian Svulescu Cristina Stancof Iri
Brittney Brown July 7, 2010 Stat 4210 Homework 3 1.
The model y = 6.14 + 0.0194 x6 could be used to estimate values ranging from 250 to 2250. The slope is 0.01939. For every one unit increase in x6, y is estimated to increase
by 0.0194. We are 95% confide
E M O T I O N A L E X H A U S T I O N
50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1
Figure 14. Scatterplot of Emotional Exhausation by age A A A
A A A A A A A