Directions: This exam consists of 5 problems and is an open-book exam with no time limit. All work should be done individually.Word-process your solutions within this template and show all steps used in arriving at the final answers. Incomplete solutions will receive partial credit. Copy and paste all necessary data from Excel into this document and create tables as needed.
Suppose a manufacturing company makes a certain item. The time to produce each item is normally distributed around a mean of 27 minutes with a standard deviation of 2.5 minutes. Thus, the population of production times is normal in shape. Find the mean and standard deviation of the sample. Sample size is 100.
The average prices for a product in 12 stores in a city are shown below.
$2.99, $2.85, $3.25, $3.55, $3.00, $2.99, $2.76, $3.50, $3.20, $2.85, $3.75, $3.85
Test the hypothesis that the average price is higher than $2.87. Use level of significancea = 0.05.
(thousands of dollars)
(a) Graph the points from 1998 through 2005 on a scatter diagram using Sales as the independent variable and Net Profit as the dependent variable.
(b) Draw the regression line on the graph you constructed in Part (a).
(c) What is the value of the coefficient of determination for this regression model? Comment on the strength of the regression line for this model.
(d) What is the predicted net profit for 2006 if sales are expected to be 125?
Last week’s sales of iMac computers at an Apple Store in Oklahoma City, OK, are shown in the following table:
- Use the 3-day moving average method for forecasting days 4–7.
- Use the 3-day weighted moving average method for forecasting days 4–7. Use Weight 1 day ago = 2, Weight 2 days ago = 4, and Weight 3 days ago = 3.
- Compare the techniques using the mean absolute deviation (MAD).
The following table shows six years of average annual cost-of-living index data:
|Year||Annual Cost of Living Index|
- Forecast the average annual cost of living index for all years from 2008 to 2013. Use a 3-year weighted moving average with weights of 0.5, 0.3, and 0.2. Use the largest weight with the most recent data.
- Forecast the average annual cost of living index using exponential smoothing with ? = 0.7 for all years from 2008 to 2014. Use the rate for 2008 as the starting forecast for 2008.
- Which of the methods in parts (a) and (b) produces better forecasts for the 3 years from 2011 to 2013? Answer on the basis of mean square error (MAD).