Jessica Stephan
BQA 2113
2/12/16
6 elements of statistics:
1. Experimental Unit: Starkville people
2. Population: All Starkville people
3. Variable: gift price, role, gender, appreciation level, grate
BQA 3123-201
Lab Assignment 6
Use Excel for the following Problems.
1. (4 pts) An agent for a residential real estate company in a city wants to study the relationship between
apartment size and month
BQA 3123-201
Lab Assignment 7
1. (3 pts) The following shows the size and market value of houses in a county.
Size (Square feet)
x
1812
1914
1842
1812
1836
2028
1732
1791
(a) Draw the scatterplot.
Mar
BQA 3123-201
Lab Assignment 5
Use Excel program to do the following problems.
1. (3 pts) A sporting goods manufacturing company wanted to compare the distance traveled by golf
balls produced using eac
Revision Class 1: In Class Examples
Example 1: EPA ratings (this example is associated with slides 3 to 8).
The EPA calculate car mileage for all cars currently in the US market. You wish to analyze t
Revision Class 2: In Class Examples
All of the hand calculations that are included as part of this course can be implemented in
Microsoft Excel. In fact, Excel is much more accurate than using a combi
Revision Class 3: In Class Examples
Board Example 1: Black Friday shopping
Fill in the remaining steps
95% Confidence Interval
x z / 2 x
x + z / 2 x
In Microsoft Excel
Ill demonstrate two ways of do
D. BRIAN BLANK, PH.D.
FINANCE 4223
VISITING ASSISTANT PROFESSOR OF FINANCE
SECTION 01
FINANCIAL MANAGEMENT,
SPRING SEMESTER 2017
Review Quiz
1. Which of the following is the difference between a firm
BQA 3123-201
Lab Assignment 3
Due: 2/15, Wednesday
Use SPSS program to do the following problems
1. (2.5 pts) A person wanted to compare the battery life of subcompact cameras and compact cameras.
The
7. 3 Exercise 1 A survey wants to compare male and female shoppers in a
metropolitan area. Among the questions asked was, Do you enjoy shopping for
clothing? Of 260 females, 224 answered yes. Of 240 m
7.2 Exercise 1 A person wants to compare the prices of two rental companies
Thrifty and Hertz. The following data represent the rental price on a day for a
compact automobile charged by the two compan
BQA 3123-201
Lab Assignment 1
Due: 2/1, Wednesday
Use SPSS to do the following problems.
For each problem: (i) Provide output (ii) Draw conclusion based on the output.
1. (2.5 pts) A person wants to e
BQA 3123-201
Lab Assignment 2
Due: 2/8, Wednesday
Do problems 1 5 using Excel program.
1. (1.5 pts) A person wants to estimate the mean customer waiting time of a bank. A sample 15
customers is random
Project 1 Assignment
Due: 3/1, Wednesday
The statistical method can be one of the following:
Confidence intervals (Chapter 5)
Hypothesis tests for one population (Chapter 6)
Comparing two populatio
7.2 Comparing the Means of Two Related Populations
Paired t-Test
Example 1 There are two supermarkets in a county. A resident wants determine which supermarket is
cheaper in the food products. She col
7.1 Exercise 1 A person wants to compare the heights (in meters) of a certain
type of trees in two county A and county B. He selected one sample from each
county and the results are as follows:
Sample
7.1 Comparing the Means of Two Independent Populations
7.1.1 Separate-Variance t-Test (assume that the variances are not equal)
Suppose that we have two independent populations which are normally dist
6.4 Hypothesis Test for Population Proportion
A sample proportion is defined as:
Sample
Part of sample
^p=
The z-statistic for a population proportion is:
z=
^p p
where
p(1 p)
n
p is the assumed popu
7.3 Comparing Two Population Proportions
Notation:
: Proportion of items of interest in population 1.
p1
p2
: Proportion of items of interest in sample 1.
p 1
p 2
p
x1
x2
n1
n2
: Proportion of items o
6.6 Level of Significance and Type I Error
Sample Size and Type II Error
Level of Significance
We have used the level of significance in every hypothesis tests. Here we want to use some examples
to ex
5.2 Confidence Interval for Population Mean ( Known)
In some situations, the population standard deviation is known. Then we can use to
construct confidence intervals which are better (more accurate)
6.6 Exercise 1 The following are p-values of a hypothesis test:
Items
P-value
A
0.005
B
0.06
C
0.002
D
0.04
(a) Which of the items are significant?
(b) Which item is the most significant?
6.6 Exercise
6.1 Elements of Hypothesis Tests
In Chapter 5, we construct a confidence interval to estimate a population mean (or proportion). However
in many situations, we want to determine whether a population m
6.5 Exercise 1 A major car manufacturer wants to test a new engine to determine
whether it meets new air pollution standards. The mean emission level must be less than
20 parts per million of carbon.
5.1 Confidence Interval for Population Mean
Confidence level
For a t-distribution, the 95% confidence level corresponds the middle 95% area as follows:
95%
The total area is 100% or 1. Then the sum of
5.1 Exercise 1 A person wants to know how many times people visited a
nearby Walmart store last month in his neighborhood. A sample of four
people is surveyed and the result is as follows:
2
3
7
8
(a)
6.4 Exercise 1 Last year, an insurance company paid 85.1% of the claims.
Suppose that the insurance company developed a new payment system in an
effort to increase this percentage this year. A sample
5.4 Exercise 1 The following is an Excel output:
Column1
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level(95.0%)
4.
6.2 Hypothesis Test for Population Mean
6.2.1 Left-Tailed Tests
Test Statistic
The t-statistic is defined as
t=
x
s / n
Critical Value Approach
If the t-statistic is in the rejection region, then we