Lab 5: Two-variable statistics in Excel
Fall 2013
We will use Excel to do some of the statistics calculations that we discussed in
c lass.
You will turn in your work from this lab to be graded as a homework assignment. Your
submission should be a single E
Melissa Pierson
Julia Torano
Dr. Meadows
Math 111A
August 24, 2013
Buying A House Project Essay
Dear Family,
We have started organizing information for our future and we have put a lot of time and
thought into the kind of job we want to have and where we
Homework 12
Fall 2013 - be sure to support all answers.
1. What is the probability of choosing a king from a standard deck of playing cards?
2. What is the probability of choosing a green marble from a jar containing 5 red, 6 green and 4
blue marbles?
3.
Homework 10
Fall 2013
Assignment
This assignment has three parts. Be sure to complete all three.
First part
Some practice with lines and their equations:
1. Graph the line corresponding to the equation
2. Determine the equation of the line shown in the gr
Melissa Pierson
Exam 11/14/13
Percentage of Adults (Age 18 and Older) who Smoked in 2004 by State
Mean
Median
21.566
20.95
Min
Q1
Median
Q3
Max
10.5
20
21.15
23.975
27.6
0 to 3
3 to 6
6 to 9
9 to 12
12 to 15
15 to 18
18 to 21
21 to 24
24 to 27
27 to 30
To
Homework 4
Fall 2013
Assignment
Use Excel to work the following problems following what you learned in the lab activities. For
problem 1, which does not require Excel, type your answer in a Word file. Submit your files
(one Word file and one Excel file) v
Homework 5
F all 2013
Assignment
Use Excel to work the following problems following what you learned in the lab activities.
Submit your Excel work via Blackboard. Before you start on the problems, read the following
guidelines for Excel work.
Guidelines
T
Melissa Pierson
Julia Torano
Dr. Meadows
Math 111A
August 24, 2013
Buying House Project
Dear Family,
We have started organizing information for our future and we have put a lot of time and
thought into the kind of job we want to have and where we want to
Project: Buying a House
Fall 2013
Main Goal and Purpose
The purpose of this project is to explore a realistic (hence, more complicated) financial situation.
You will combine several of the Excel techniques that you have been practicing over the past two
w
Melissa Pierson
Alex Rodriguez
Seasons
1994 season
1995 season
1996 season
1997 season
1998 season
1999 season
2000 season
2001 season
2002 season
2003 season
2004 season
2005 season
2006 season
2007 season
2008 season
2009 season
2010 season
2011 season