QNT 275 STUDY Experience Tradition--qnt275study.com

1
QNT 275 STUDY Experience Tradition--qnt275study.co
m
2
QNT 275 STUDY Experience Tradition--qnt275study.co
m
QNT 275 Week 2 Apply Connect Week 2 Case FOR
MORE CLASSES VISIT www.qnt275study.com QNT 275
Week 2 Apply Connect Week 2 Case Part 1 You
manage the inventory for a car dealership. Your
management would like you to review current
inventory on the dealership lot. Review the Week
2 Data Set. Create and calculate the following in
Excel Create a Pie Chart which summarizes
colors of the cars in the sample. Create a Bar
Chart which summarizes the frequency of the
models of the cars in the sample.
3
QNT 275 STUDY Experience Tradition--qnt275study.co
m
QNT 275 Week 2 Homework Problem Set Excel File
FOR MORE CLASSES VISIT www.qnt275study.com 1. In
a hearing test, subjects estimate the loudness
(in decibels) of a sound, and the results are
69, 67, 71, 72, 65, 75, 68, 68, 83, 73,
68. Calculate the measures of central tendency
(Mean, median, mode) and the measures of
dispersion (range, standard deviation, variance).
4
QNT 275 STUDY Experience Tradition--qnt275study.co
m
QNT 275 Week 3 Homework Problem Set Excel
File FOR MORE CLASSES VISIT www.qnt275study.com 1
. A survey is made in a neighborhood of 90
voters. 75 are Democrats and 15 are Republicans.
Of the Democrats, 30 are women, while 7 of the
Republicans are women. If one subject from the
group is randomly selected, find the probability
the individual is a male Republican. 2.  Container
1 has 8 items, 3 of which are defective.
Container 2 has 5 items, 3 of which are
defective. If one item is drawn from each
container, what is the probability that only one
of the items is defective?
5
QNT 275 STUDY Experience Tradition--qnt275study.co
m
QNT 275 Week 4 Homework Problem Set Excel
File FOR MORE CLASSES VISIT www.qnt275study.com 1
. A sample of 100 items has a population standard
deviation of 5.9 and a mean of 32. Construct a 95
percent confidence interval for µ. 2. At the end
of 1990, 1991, and 1992, the average prices of a
share of stock in a portfolio were 34.75,
34.65, and 31.25 respectively. To investigate
the average share price at the end of 1993, a
random sample of 75 stocks was drawn and their
closing prices on the last trading day of 1993
were observed with a mean of 33.78 and a standard
deviation of 14.25.
6
QNT 275 STUDY Experience Tradition--qnt275study.co
m