Chapter 3 Study Guide Solutions
Selected Solutions to Problems in Chapter 3
Problem 1
n
Using the formula for simple mean ( X ):
1a)
Xi
i
1
n
The simple mean ( X ) is:
21 45 34 25 61 45 6 12 49 58 38 41 9
13
444
=
= 34.15
13
=
n
Using the formula for sta
Chapter 2 Intro to Spreadsheet Modeling
Selected Solutions to Problems in Chapter 2
Problem 1
Create a simple spreadsheet to calculate break-even points. Create a key that includes
fixed costs, variable costs, and price. Create and label a cell that conta
Chapter 7 Study Guide Solutions
Selected Solutions to Problems in Chapter 7
Problem 1
The number of cans of soft drinks sold in a machine each week is recorded below.
Develop forecasts for periods 1-11 using a three period moving average using
thefollowin
Chapter 3 Study Guide Problems
Selected Problems in Chapter 3
1.
Given the following data set: 21, 45, 34, 25, 61, 45, 6, 12, 49, 58, 38, 41, 9
a.
b.
c.
d.
2.
Calculate the simple mean.
Calculate the standard deviation.
Calculate the median?
Is the median
Chapter 6 Study Guide Solutions
Selected Solutions to Problems in Chapter 6
Problem 1
Jeannie and her brother wish to use a test of two means to determine if both of them
take the same amount of time to get to work. To test the hypothesis of no difference
Chapter 6 Study Guide Problems
Selected Problems in Chapter 6
1. Jeannie's brother tells her that it takes him the same time to get to work as it does
her. Jeannie doesn't believe him and wants to test her brother's hypothesis. The data
on the average tim