BUSU 610 Data Driven Decision Making Problems Solution done june 2015

1 Compute the Average of the following numbers 1 567 3874 2081 74 -88

2 Name the following numbers as a range "Test1" 84 88 188 881 38 60 12 -38 659

3 Place the Square Root of each of these numbers below it 12 89 36 89 10 38

User the SQRT() function Answer

4 Insert a line Graph in the indicated location

X Axis (horizontal) Jan Feb Mar Apr Jun Jul Aug Sept Oct Nov Dec

Y Axis (Vertical) 600 650 675 790 821 888 901 1028 1150 1200 1333

5 Create and display the Data Analysis Descriptive Statisics for the following numbers:

What is the difference in the Standard Deviation of the two columns?

Col 1 Col 2

78 750

79 788

82 901

86 1600

88 1700

89 1800

90 1900

94 2560

98 2800

103 2900

111 3000

128 3050

139 3051

160 3052

190 3053

6 In the Answer cell, calculate the value "True" if column 1 has a higher standard deviation, and "False" if column 2 has higher standard deviation. Use the IF function.

7 Create a Pie chart for the following data with the segments labelled correctly

Red 40

Blue 21

Green 12

Yellow 9

White 9

Orange 9

****************************************************************************

Ten percent of the meals served in Brent's Deli are incorrectly priced.

What is the probability (using the Binomial calcuations) that out of a sample of 10 meals

a. Exactly one is priced wrong?

b. Exactly 5 are priced wrong?

Mortorcycle pass an intersection at a rate of one every ten minutes

According to Poisson calculations, what is the probability I see

a. Exactly 8 motorcycles in one hour

b. At least 6 motorcycles in one hour

********************************************************************************

1 According to the IRS the mean tax refund for the year 2009 was $3333

The standard deviation of the population of returns is $551, and the amounts follow the normal distribution

Using Norm.Dist

a What percent of the returns are more than $2000?

b What percent of the returns are more than $5000?

c. What percent of the returns are between $3000 and $5000?

2 Create an approximate line graph of this normal distribution with $3333 as the mean

You can make a table of values from which to create the graph

***************************************************************************************

The daily sales of Burger Baby restaurants follow the normal distribution with a standard deviation of $4000.

a. A sample is taken of 50 restaurants and the average sales were $40,000/day.

What is the 99% confidence interval for the average restaurant sales?

b What is the probability that the average sales are really $36,000 or less per day?

Assume the actual population average is $40,000 per day

A sample of the sales at 50 Haute Dog restaurants is taken and the sample mean is $30,000 per day

with a sample standard deviation of $2000. The population standard deviation is not known.

a What is the 90% confidence interval for the daily sales at all restaurants.

b What is the probability that the average sales are really $32,000 or more per day?

Assume that the population average is $30,000 per day and the std. Deviation is $2k.

**********************************************************************************************

1 List the 5 steps in Hypothesis testing

2 A tire company makes 5000 tires an hour on average with a known standard deviation of 50

A sample is taken last hour and 5100 tires were made

Spell out the null and alternate hypotheses that the mean is different than 5000

Evaluate the hypothesis (Accept or Reject) at the following significance levels:

a. 0.01

b. 0.05

3 Samples of a car company's output is taken and 490 cars are made in a day with a known standard deviation of 16 cars

Spell out the null and alternate hypotheses that the average production of the car company is less than 475 cars

Evaluate the hypothesis (Accept or Reject) at the following significance levels

a. 0.001

b. 0.1