Question;QSO 510Final ExamDirections: 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.Problem 1Suppose 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.Problem 2The 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.85Test the hypothesis that the average price is higher than $2.87. Use level of significancea = 0.05.Problem 3A store wishes to predict net profit as a function of sales for the next year. The following table gives the years 1998 to 2005.YearSales(thousands of dollars)Net Profit199851519995510.22000659.6200182-32002752.82003713.2200482-2.3200581-2.6(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?Problem 4Last week?s sales of iMac computers at an Apple Store in Oklahoma City, OK, are shown in the following table:DaySales (Dollars)1180215032104225519561907230Use 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).Problem 5The following table shows six years of average annual cost-of-living index data:YearAnnual Cost of Living Index200598.22006101.32007103.72008105.82009111.42010121.92011134.32012128.62013125.2Forecast 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).
Paper#60302 | Written in 18-Jul-2015Price : $29