BQA 3123-201
Lab Assignment 1
Due: 9/19, Monday
Use Excel program to do the following problems.
1. (2 pts) The following are the waiting times in a bank for a sample 15 customers:
4.21
5.55
3.02
5.13
4.77
3.23
3.45
3.20
4.50
5.90
0.38
5.21
6.46
5.19
3.79
BQA 3123-201
Homework 12
Due: 4/30, Wednesday
Use SPSS for Problems 1-3
1. (1 pt) The following table is a set of data points.
x
1
2
3
5
6
7
y
12
9
8
5
7
2
Use SPSS to construct a scatterplot.
2. (2 pts) A company wants to determine how the sales (
newspa
BQA 3123-201
Homework 9
Due: 4/2, Wednesday
The following problems provide you cases and data. You need to choose a statistical method, generate
Excel or SPSS output, identify p-value and then draw conclusion. You may use the level of significance
0.05.
1
BQA 3123-201
Homework 11
Due: 4/23, Wednesday
Brandon Coleman
1. (0.5 pt) When do we use ANOVA?
To compare the means of two of more populations
2. (0.5 pt) When do we use paired t-test?
To compare the means of two related populations
3. (0.5 pt) When do w
BQA 3123-201
1. (1 pt)
Homework 10
Due: 4/16, Wednesday
y=6+3 x
(a) Find the value of
y when
x = 0 and 1.
(b) Graph the linear equation.
2. (1 pt)
y=102 x
(a) Find the value of
y when
x = 0 and 1.
(b) Graph the linear equation.
3. (1 pt) The following tab
BQA 3123-201
Homework 11
Due: 4/23, Wednesday
1. (0.5 pt) When do we use ANOVA?
2. (0.5 pt) When do we use paired t-test?
3. (0.5 pt) When do we use
2
test?
4. (0.5 pt) When do we use goodness of fit test?
5. (1 pt) When do we use regression? When do we
BQA 3123-201
Homework 8
Due: 3/26, Wednesday
1. (2.5 pts) The following contingency table shows the perception of unfairness in the U.S. tax code for
two different income groups.
Perception of
U.S. Tax Code
Fair
Unfair
Income Level
Less Than $50,000
More
1.
Perception of U.S. Tax Code
Income Level
Less Than
$50,000
Fair
Unfair
More Than
$50,000
225
280
505
180
320
500
405
600
1005
2.
Object to Sharing Information
Yes
No
Total
Organizational Grouping
Insurance
Pharmacies
Research
40
80
90
160
120
110
200
2
BQA 3123-201
Homework 6
Due: 3/5, Wednesday
Use SPSS program to do the following problems.
1. (2 pts) A person wants to determine whether the mean weekly sales of BLK Cola are the same when
using a normal shelf location and when using an end-aisle display
BQA 3123-201
Homework 5
Due: 2/26, Wednesday
1. (2.5 pts) The Computer Anxiety Rating Scale (CARS) measures an individuals level of computer
anxiety, on a scale from 20 (no anxiety) to 100 (highest level of anxiety). Researchers at Miami University
admini
BQA 3123-201
Homework 4
Due: 2/19, Wednesday
1. (2 pts) Late payment of medical claims can add to the cost of health care. An article reported that the
mean time from the date of service to the date of payment for one insurance company was 41.4 days
last
BQA 3123-201
Homework 2
Due: 2/10, Monday
1. (1 pt) The following is a SPSS output. Determine the 95% confidence interval.
Descriptives
Statistic
Expense
Mean
1935.7600
95% Confidence Interval for
Lower Bound
Upper Bound
70.17982
1790.9160
Mean
Std. Error
BQA 3123-201
Homework 3
Due: 2/12, Wednesday
For problems 1-4: (i) Provide output (ii) Draw conclusion based on the output.
1. (2 pts) The following is the annual expenditure on apparel and services for a sample of consumers in
the Northeast:
1292
2701
20
BQA 3123-201
Homework 1
Due: 1/29, Wednesday
1. (1 pts) Find the mean and sample standard deviation of the following set of data:
6.1
7.6
10.9
15.0
11.5
9.8
12.6
15.4
16.6
8.6
10.0
9.9
2. (2 pts) A person wants to estimate the mean commuting time of local
11.1 Exercise 1 A mail-order catalog business wants to estimate how the cost (y) is
related to sales (x1 ) and number of orders (x2 ). The following tables show the data
for the past 24 months, and the SPSS output.
Cost
52.95
71.66
85.58
63.69
72.81
68.44
11.3 Exercise 1 A hotel has designed a new system for room service delivery of
breakfast that allows the customer to select a specified delivery time. The difference
between the actual and requested delivery times was recorded.
The hotel wants to build a
10.4 Exercise 1 Compute the linear correlation coefficient of the following set of
data points:
x
6
y
14
5
6
10
7
10.4 Exercise 1 Solution
x
6
10
21
-5
1
25
-3
6
4
9
3
-2
-6
9
4
-5
7
5
-2
6
y y
-1
y
14
5
14
38
27
x
21
7
3
( y y) 2
x x
y
27
9
3
r
( x x )(
10.3 Exercise 1
x
2
6
7
y
6
9
15
The regression equation for the above set of data points is y 2.5 1.5 x.
Compute the coefficient of determination.
10.3 Exercise 1 Solution
y
y y
( y y) 2
y y
( y y) 2
x
y
2
6
5.5
-4.5
20.25
-4
16
6
9
11.5
1.5
2.25
-1
1
7
9.3 Exercise 1 A school social worker wants to determine if the grade
distribution of home-schooled children is different in her district than nationally.
The U.S. National Center for Education Statistics provided he with the following
data, which represe
10.1 Exercise 1
(a) Find the value of when = 0, and 1.
(b) Graph the linear equation.
10.1 Exercise 1 Solution
(a)
When = 0,
When = 1, 7
(b)
y
8
7
6
5
4
x
3
2
1
0
0
1
2
3
4
10.1 Exercise 2
(a) Find the value of when = 2, and 6.
(b) Graph the linear equat
10.2 Exercise 1
x
1
2
3
5
6
8
y
12
10
7
8
3
3
(a) Draw a scatterplot for the above data points.
(b) Draw a straight line in the middle of the points to represent the trend of the
data points.
10.2 Exercise 1 Solution
14
12
10
8
6
4
2
0
0
1
2
3
4
5
6
7
8
9
8.2 Exercise 1 Suppose three samples are selected from three populations as
follows. (The three populations satisfy the assumptions for ANOVA.)
Sample 1: 6 10
Sample 2: 1 2
6
Sample 3: 6 9 12
At the = 0.05 level of significance, determine whether there is
9.2 Exercise 1 Where people turn to for news is different form various age groups. A
study indicated where different age groups primarily get their news:
Media
TV
Radio or Newspaper
Internet
Under 36
180
127
95
Age Group
36-50
221
176
83
50+
260
216
76
At
9.1 Exercise 1 More shoppers do the majority of their grocery shopping on
Saturday than any other day of the week. However, is there a difference in the
various age groups? A study showed the results for different age groups in the
following contingency t
6.2 Exercise 1 Last month the average price of a certain type of laptop is $465. A
person wants to know whether the average price is decreased this month. He finds
the following prices in four different stores:
450 400 460 410
At = 0.05 level of significa
7.1 Exercise 1 Independent random samples selected from two normally
distributed populations give the following results:
Sample Size n
Sample Mean x
Sample Standard Deviation s
Sample 1
17
3.1
3.4
Sample 2
12
7.9
4.8
At the = 0.01 level of significance, d
7.2 Exercise 1 The following data represent the daily rental for a compact
automobile charged by two car rental companies, Thrifty and Hertz, in 3
locations.
City
Thrifty
Hertz
Chicago
21.81
18.99
Orlando
27.98
35.99
Houston
17.90
19.99
At = 0.1 level of
7.4 Exercise 1 The operations manager at a lightbulb factory wants to determine
whether there is any difference in the mean life expectancy of bulbs
manufactured on two different types of machines. Two samples are selected
from the two machines and the li