Copyright © 2019, Udaptive.All Rights Reserved.
How to enable Macros
FaQ
What will be considered for grading?
Only “Answer” Sheets will be considered for grading.
Can I add additional worksheets?
Yes.
What is the best way to present my solution?
Complete your work in your worksheet and reference or “hardcode” your answer in the yellow
cells provided in the “Answer” sheet.
Why is my formula not working in Excel?
Check for Automatic Calculation. On the Formulas ribbon [Excel Opions], look to the far right
and click Calculation Options. When this option is set to automatic, Excel recalculates the
spreadsheet’s formulas whenever you change a cell value.
Terms of Use
This template is considered a copyrighted work under the Unites States and other copyright laws and is
the
property of Udaptive. The items listed below are additional points to help clarify how you may use this template.
Not for Resale or Public Sharing
You may make archival copies and customize this template only for your personal use and not for
resale sharing.
or
public
You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use,
attribution, or other proprietary notices or marks within this template.
This template and any customized or modified version of this template may NOT be sold, distributed,
published to an online gallery, hosted on a website, or placed on a public server.
Disclaimer
This template is provided for informational or educational use only and is not intended to be relied on as medical,
financial, legal, or other professional advice.
Udaptive makes no guarantee or representations about this template, or the accuracy or completeness of the
content contained within this template.
Location (saved)
User_ID
AnswerSheets
Course
2
Please answer all questions based on the data provided below and ‘Dataset1’. If you cannot answer the question due to
‘NA’. Do not change the formatting of the yellow cells. Round to four digits after decimal.
Sophie Johnson, CFO of Neonte, suspects irregularities in the payroll system, and orders an inspection of a random sa
year. A sample of ten vouchers is randomly selected, without replacement, from the population of 1800 vouchers. Ea
1)
examined for errors and the number of vouchers in the sample with errors is denoted by x. If 17% of the population o
= 0) is:
answer
2)
During a recent sporting event, a quarter is tossed to determine which team picks the starting side. Suppose the refer
tossed 5 times and the best 3 out of five wins. If team A calls ‘heads’, what is the probability that exactly 3 heads are
answer
3) If x is a binomial random variable with n=11 and p=0.7, what is the probability that x is equal to 4?
answer
4)
Suppose that the number of calls coming per minute into an hotel reservation center follows a Poisson distribution. A
calls per minute. Determine the probability that at least two calls are received in a given two-minute period.
answer
5)
If x, the time (in minutes) to complete an change job at certain auto service station, is uniformly distributed over the
probability that an oil change job is completed in 33 to 35 minutes is:
answer
6) Let z be a normal random variable with mean 0 and standard deviation 1. What is P(z < -1.5)?
answer
A carload of steel rods has arrived at BlueCon LLC. The car contains 50,000 rods. Ruby Brown, manager of Quality Ass
7) measure the lengths of 98 randomly selected rods. If the population of rods have a mean length of 120 inches and a s
inch, the probability that the sample has a mean less than 119.985 inches is:
answer
you cannot answer the question due to insufficient data, enter
decimal.
and orders an inspection of a random sample of vouchers issued last
rom the population of 1800 vouchers. Each voucher in the sample is
denoted by x. If 17% of the population of vouchers contain errors, P(x
picks the starting side. Suppose the referee says the coin will be
the probability that exactly 3 heads are observed in five tosses?
y that x is equal to 4?
n center follows a Poisson distribution. Assume that the mean is 1.7
d in a given two-minute period.
tation, is uniformly distributed over the interval 20 to 55, then the
hat is P(z < -1.5)?
ds. Ruby Brown, manager of Quality Assurance, directs her crew
have a mean length of 120 inches and a standard deviation of 0.12
Dataset1
No additional data
Please answer all questions based on the data provided below and 'Dataset2'. If you cannot answer the question due to
formatting of the yellow cells. Round to four digits after decimal.
1)
A large industrial firm allows a discount on any invoice that is paid within 30 days. Of all invoices, 29% receive the dis
mean (average) value of the number of the 15 sampled invoices that receive discount is:
answer
2)
Sunday evening, customers arrive at the fast food drive thru at the rate of 6 cars per fifteen minute interval. Determi
minute interval. Assume a Poisson distribution.
answer
Suppose that during a given week, 20 new customers have signed up for a specialized service your company provides
3) and the remaining twelve are automotive firms. If a random sample of 6 of these new customers will be selected for
probability that 4 of the selected customers are financial services firms?
answer
4)
Canterbury Tire LLC has established that the useful life of a particular brand of its automobile tires is normally distrib
miles. What is the probability that a randomly selected tire of this brand has a life of at least 50,000 miles?
answer
5)
At a certain workstation in an assembly line, the time required to assemble a component is exponentially distributed
component is assembled in 7 minutes or less.
answer
6)
Suppose the population of college dataset shows the annual parking fee per student is $111 with a standard deviation
population, the probability of drawing a sample with a sample mean between $100 and $115 is:
answer
7)
Suppose the salaries of Starbucks employees are normally distributed with a mean of $32,000 standard deviation of $
probability that the sample mean salary will exceed $35,000.
answer
you cannot answer the question due to insufficient data, enter 'NA'. Do not change the
days. Of all invoices, 29% receive the discount. In a company audit, 15 invoices are sampled at random. The
discount is:
cars per fifteen minute interval. Determine the probability that five cars will arrive during the next five
ecialized service your company provides. Eight of these new customers are financial services companies,
hese new customers will be selected for a study of customer satisfaction in one month, what is the
of its automobile tires is normally distributed with a mean of 44000 miles and a standard deviation of 7800
a life of at least 50,000 miles?
component is exponentially distributed with a mean time of 10 minutes. Find the probability that a
student is $111 with a standard deviation of $19. If a random sample of size 49 is drawn from the
n $100 and $115 is:
mean of $32,000 standard deviation of $9400. Suppose we take samples of size 19 employees. Find the
Dataset2
No additional data
