CQS111 Team Project, Part 1
Due Dates for HardCopy Deliverables:
MW Sections: Dec. 7, 2013, 5PM
Fri Section:
Dec. 11, 2013, 5PM
Your task:
You are a team of external consultants hired by Talwar Motor
CQS111 Team Project 2013
CQS111 Team Project, Part II
Due Dates for HardCopy Deliverables:
MW Sections:
Dec. 7, 2013, 5PM
Fri Section:
Dec. 11, 2013, 5PM
Part II Tasks:
I.
Further understand trends i
June Park Expenses
8 0,000
70,000
6 0,000
5 0,000
4 0,000
30,000
20,000
10,000

June
Lsatname_Firstname_7K_Park_Expenses
Total Result
Park
Expense Item Equipment
Grounds & Maintenance
Sum  Amount
Mo
Water and Electric
Total Result
Jun
2,148,940
8 39,654
5 60,317
225,632
May
6 57,556
178,516
Apr
6 51,730
156,169

5 00,000
Lastname_Firstname_7I_City_Services
1,000,000
1,500,000
Source Electric
Wat
CQS111 Lab Syllabus: An Experience in Independent Learning
Fall Semester 2013
Professor U. H. St.Clair
WHAT WILL HAPPEN IN THE CQS111 LAB?
If you need Excel skills to do well in many of your SOM cours
CQS111 Team Project, Part 3
Due Dates for Entire Project:
Sections
MW
Deliverable
Excel & Word Printouts
PPT & Excel Files
Due Date
Mon, Dec. 9, 2013, 4:30 PM
AA 225
Sun, Dec. 8, 2012, 10 PM
Upload to
Your Name _
Your Section No. _
CQS111 Practice Exam II
In this lab exam, you will be able to use your book, any of your notes, scratch paper, and any other prepared aids. You
must keep your cell phone
Loan Options for New Home in Binghamton  Rates versus Months
$400,000.00
Selling price
Down payment
Amount of loan
Life of loan (years)
Interest rate (per year)
Monthly payment
30
4.50%
Payment Optio
Loan Options for New Home in Binghamton  Rates versus Months
$400,000.00
$80,000.00
$320,000.00
Selling price
Down payment
Amount of loan
Life of loan (years)
Interest rate (per year)
Monthly payment
City of Orange Blossom Beach
Schedule of Changes in General Fixed Assets
Last Year
Properties
Land
Buildings
Subtotal
Additions Dispositions
Current
Balance
$3,775,800
2,080,700
$5,856,500
$350,000
1,
City of Orange Blossom Beach
Last Year: All Parks Snacks Revenue
Product
Cotton candy
Chips
Cookies
Ice cream
Candy
Total
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Total
1,720
1,210
1,950
2,150
1,500
1,820
1,14
TwoSample Tests of Hypothesis (Key)
Questions 1, 2, and 3 refer to the following problem:
A recent study focused on the amount of money single men and women save monthly. The
information is summarize
Analysis of Variance
1. Analysis of variance is used to
A. compare nominal data
B. compute t test
C. compare population proportions
D. simultaneously compare several population means
2. In ANOVA, an F
OneSample Tests of Hypothesis
1. A null hypothesis makes a claim about a
A. Population parameter
B. Sample statistic
C. Sample mean
D. Type II error
2. What is the level of significance?
A. Probabili
Sampling Methods and the Central Limit Theorem
1. When all the items in a population have an equal chance of being selected for a sample, the
process is called _.
A. Simple random sampling
B. zscore
Numerical Measures
1. The sum of the deviations of each data value from this measure of central location will always
be zero.
A. Mode
B. Mean
C. Median
D. Standard deviation
2. Which measures of centr
Frequency Tables, Frequency Distributions, and Graph
1. A small sample of computer operators shows monthly incomes of $1,950, $1,775, $2,060,
$1,840, $1,795, $1,890, $1,925 and $1,810. What are these
Continuous Probability Distributions (Key)
1. The shape of any uniform probability distribution is
A. Negatively skewed
B. Positively skewed
C. Rectangular
D. Bell shaped
2. The upper and lower limits
Correlation and Linear Regression
1. What is the chart called when the paired data (the dependent and independent variables) are
plotted?
A. Scatter diagram
B. Bar chart
C. Pie chart
D. Histogram
2. W
Estimation and Confidence Intervals
1. The proportion of junior executives leaving large manufacturing companies within three years
is to be estimated within 3 percent. The 0.95 degree of confidence i
TwoSample Tests of Hypothesis
Questions 1, 2, and 3 refer to the following problem:
A recent study focused on the amount of money single men and women save monthly. The
information is summarized belo
Analysis of Variance (Key)
1. Analysis of variance is used to
A. compare nominal data
B. compute t test
C. compare population proportions
D. simultaneously compare several population means
2. In ANOVA
Estimation and Confidence Intervals (Key)
1. The proportion of junior executives leaving large manufacturing companies within three years
is to be estimated within 3 percent. The 0.95 degree of confid
Correlation and Linear Regression (Key)
1. What is the chart called when the paired data (the dependent and independent variables) are
plotted?
A. Scatter diagram
B. Bar chart
C. Pie chart
D. Histogra
Continuous Probability Distributions (Key)
1. The shape of any uniform probability distribution is
A. Negatively skewed
B. Positively skewed
C. Rectangular
D. Bell shaped
2. The upper and lower limits
Sampling Methods and the Central Limit Theorem (Key)
1. When all the items in a population have an equal chance of being selected for a sample, the
process is called _.
A. Simple random sampling
B. z
Numerical Measures (Key)
1. The sum of the deviations of each data value from this measure of central location will always
be zero.
A. Mode
B. Mean
C. Median
D. Standard deviation
2. Which measures of
OneSample Tests of Hypothesis (Key)
1. A null hypothesis makes a claim about a
A. Population parameter
B. Sample statistic
C. Sample mean
D. Type II error
2. What is the level of significance?
A. Pro