SECTION 6: Exercises
6.1
A population has a distribution that is skewed to the left. Indicate in which of the following cases
the central limit theorem will apply to describe the sampling distribution of the sample mean.
a. n = 100
b. n = 25
c. n = 36
A &
2)
20 =COMBIN(6,3)
3)
120 =PERMUT(6,3)
5)
The probabilities for each can be written as 0P(Ei)1 for all i. This is the classic method
of assigning probabilities when all experimental outcomes are likely equal.
6)
Using the relative frequency method I attai
Chapter 13 1,9,10,11, Case Problem 1
1a
A
B
C
162
142
165
145
148
174
156
Mean:
142
156
124
142
136
152
142
126
122
138
140
150
128
134
432
248
124
144
Anova: Two-Factor Without Replication
Anova: Single Factor
SUMMARY
Groups
Count
Sum
A
B
C
6
6
6
Average
Chapter 9 Homework
1)
a) Ho: u <= 600
Ha: u > 600
b) That the bills are not increasing
c) The bills are increasing
2)
a) Ho: u = > 14
Ha: u = < 14
b) Ho cannot be rejected if sales increase
c) Ho can be rejected if sales dont increase
3)
a) Ho: u = 32oz
H
Greg Spoleti
Business Statistics
21-Oct-14
Chapter 8 3,7,10,16,18,20,21
3a
3.795524
83.79552
76.20448
3b
2.683841
82.68384
77.31616
3c
Larger sample size is a lower confidence level so it's more likely to fall between those numbers
7a
166.3115
1765.312
14
Supercrunchers QuestionsChapter 2
1. What does the Author mean that you can create your own data with the flip of a coin?
The idea of flipping the coin refers to creating a randomized sample which you can feel confident that
will represent the larger popu
INSTRUCTIONS
1
2
3
4
5
INSTRUCTIONS
See the data set on the next tab noted by the name "Data" and complete the steps below
Place the answers in the "answer" sheet
Variable names are noted at the top of each column. For each variable provide the type of
va
Supercrunchers Assignment
Questions Chapter 5
1. In Chapter 5, of Supercrunchers, "Experts versus Equations", the author makes a great case for the
fact that equations predict better than humans. What reasons does the author give that illustrate why a
hum
5.3
Find the following areas under a normal distribution curve with = 12 and = 2.
a. Area between x = 7.76 and x = 12 =.4830
b. Area between x = 14.48 and x = 16.34 =.0925
c. Area from x = 8.22 to x = 11.06 =.2898
5.4*
Let x be a continuous random variabl
SECTION 1: Exercises
1.1
Explain whether each of the following constitutes a population or a sample.
a.
Ages of all members of a family - population
b.
Number of days missed by all employees of Acme Direct during the month of July - population
c.
Marital
Supercrunchers Chapter 6
Questions
1. Be prepared to discuss the process that Acxiom and ChoicePoint use to build their databases.
The author provides a good starting point, if necessary conduct further research on data
compilers via the Internet.
They ob
SECTION 8: Exercises
8.1*
According to the Southern California Real Estate Association, the average sale price of homes in Los
Angeles was $208,922 in 2009 and $206,490 in 2008. Suppose that these means were based on random
samples of 420 Los Angeles home
SECTION 5: Exercises
5.1*
5.2
Find the area under the standard normal curve.
a. between z = 0 and z = 1.90 .4713
c. between z = 1.25 and z = 2.37 .0967
e. from z = -1.67 to z = 2.34 .9429
b. between z = 0 and z = -1.75 .4599
d. between z = -1.53 and z = -
Row Labels
0-49
50-99
100-149
200-249
250-299
400-449
Grand Total
Count of Revenue Relative Frequency
6
0.12
29
0.58
11
0.22
1
0.02
1
0.02
2
0.04
50
Count of Revenue
Histogram for Top 50 Largest
Corporations' Annual Revenue
Number of Corporations
Corporat
20) a)
Payment ($) Probability
0
0.85
500
0.04
1000
0.04
3000
0.03
5000
0.02
8000
0.01
10000
0.01
Expected payment is the average
mean
430 =SUMPRODUCT($A$3:$A$9,$B$3:$B$9)
b)
90 =520-430
The policyholder pays $90 because the breakeven point for the compan
Names Frequency Relative Frequency
DH
13
26%
Trace
9
18%
CSI
18
36%
L&O
10
20%
Total
50
100%
Bar Chart of Television Shows
20
18
16
14
12
10
Frequency
8
6
4
2
0
DH
Trace
CSI
L&O
Pie Chart of Television Shows
DH
Trace
CSI
L&O
Chapter 2 #10
Frequency Percent Frequency
0.16
16
107
0.29
29
187
0.10
10
62
0.06
6
41
0.39
39
252
1.00
100
649
Rating
Average
Excellent
Poor
Terrible
Very Good
Total Result
10d)
10e)
Percent Frequency
Very good and excellent more than any other
both hote
Chapter 2: 4, 10, 23, 33, 34
Professor Bobillot
BE 251-52
Problem Set Chapter 2
Due 1/28
4a) categorial
4b) Frequency & % Frequency TV Show
Jep
JJ
OWS
THM
WoF
Total Result
4c) Bar Chart & Pie Chart
Relative Frequency ercent Frequency
P
0.2
20
0.16
16
0.14
Fund Name
Chapter 4 #34
Fund
Type
5 Year
Average
Net Asset Return
Value ($)
(%)
Amer Cent Inc & Growth DE
Inv
American Century Intl. Disc
IE
American Century Tax-Free Bond
FI
American Century Ultra DE
Ariel
DE
Artisan Intl Val
IE
Artisan Small Cap
DE
Baro
Chapter 1: 3, 4
Matthew Sheehan
Professor Bobillot
BE 251-52
Problem Set #1
Due 1/28
3a)
3b)
Windows
Android
Compare
3c)
% w/ TI OMAP
3d)
% w/ Android
582.9
average(f2:f11)
723.2
averageif(g2:g11,g2,f2:f11)
428.5
averageif(g2:g11,g3,f2:f11)
Windows averag
City
Albuquerque
Atlanta
Austin
Baltimore
Boston
Charlotte
Chicago
Cincinnati
Cleveland
Columbus
Dallas
Denver
Detroit
El Paso
Fresno
Indianapolis
Jacksonville
Kansas City
Las Vegas
Little Rock
Los Angeles
Louisville
Memphis
Miami
Milwaukee
Minneapolis
Na
Tablet
Acer Iconia W510
Amazon Kindle Fire HD
Apple iPad 4
HP Envy X2
Lenovo ThinkPad Tablet
Microsoft Surface Pro
Motorola Droid Xyboard
Samsung Ativ Smart PC
Samsung Galaxy Tab
Sony Tablet S
Cost ($)
Operating System
599 Windows
299 Android
499 iOS
860
For its Music 360 survey, Nielsen Co. asked teenagers and adults how each group has listened to music in the past 12 months.
Google Inc.s video-sharing site to listen to music and 35% of the teenagers said they use Pandora Media Inc.s custom online ra
Sup
The 2012 American League consists of 14 baseball teams. Suppose a samp
the 14 teams and the random numbers assigned by Excels RAND function
Anaheim, Toronto, Texas, Tampa Bay, Seattle
Team
Random Number
Anaheim
0.70100801
Ascending values
Toronto
0.226274
Go to Yahoo! Finance ( HYPERLINK "http:/finance.yahoo.com" http:/finance.yahoo.com) (or HYPERLINK "http:/
name (e.g., I would have S, so I pick Sprint). In the top left menu click on Historical Prices. Set the date range
(in Google Finance ts on the right
The manager of the Danvers-Hilton Resort Hotel stated that the mean gue
that the total charges for guest bills have been increasing in recent month
managers claim.
Which form of the hypotheses should be used to test the managers claim
Ho
Ha
600
<600
Ho
Ha
A simple random sample of 60 items resulted in a sample mean of 80. T
Compute the 95% confidence interval for the population mean.
Assume that the same sample mean was obtained from a sample of 120
What is the effect of a larger sample size on the interva
Take one clean US penny and spin it on a smooth table 100 times by holding it on its edge and flicking it with a f
spin again; or, if it comes into contact with an object other than the table, spin again). After each spin, record wh
1. What year is your p